Questions tagged [reindex]

Denotes Question about reindex data in index management in Magento 1 and 2.

Filter by
Sorted by
Tagged with
1
vote
0answers
9 views

Product's Tax Class change to “None” on Reindex. Any ideas?

We've just migrated from Magento 1.9.2.2 to Magento 2.2.8. We noticed in the last couple days some orders are created without billing any tax. When We go check the product We notice the tax class is ...
0
votes
0answers
26 views

Magento 2: Category page empty after re-index (E.E 2.2.9)

I am working on Magento E.E 2.2.9 Category page is not able to display product once I ran re-index. I ran re-index using crontab. Category pages are empty until I flush cache manually. Any idea ...
0
votes
1answer
33 views

how to schedule reindex of catalog_category_product only

I need to run separately with its own schedule the reindexing of: catalog_category_product catalog_product_category catalog_category_flat I dont find the in any crontab.xml How can we do ...
2
votes
0answers
26 views

Reindex a single category in magento 1

I want to re-index a single category in Magento 1. The method given in this post is not working for reindexing categories Is there a way to do it through code?
0
votes
0answers
15 views

Catalog Rule Product and Catalog Product Rule reindex not working in magento2

When I run following commands php bin/magento indexer:reindex catalogrule_rule php bin/magento indexer:reindex catalogrule_product error: [2019-07-24 12:48:35] main.CRITICAL: SQLSTATE[42S01]: ...
0
votes
1answer
12 views

How to configure the indexer to run over the night?

I would like to run my indexer to run over the night since I'm already using the reindex by schedule, how could I do that?
0
votes
1answer
24 views

Algolia extension error in Magento 2

I have installed the Algolia search extension on the Magento2 website. Upon reindexing, I am getting below error. "upgrade your plan or delete existing records". My question is an upgraded plan ...
2
votes
4answers
149 views

Magento 2 programatically reindex using custom extention controller file

How to set the re-index process automatically in Magento 2 site. We have one custom extension. We want to set cone in controller files. So when we run this controller URL; re-index function work. ...
2
votes
0answers
14 views

Order of indexers

On a Magento 2.2.8 store, we have a Catalog Price Rule for customer-group offers. The indexers involved are set to update on schedule which is running successfully and not producing any errors. Most ...
1
vote
1answer
31 views

Catalog URL Rewrites - Index Management and rebuild required indexes in Magento 1.9

I am seeing this message in the Magento admin-area: One or more of the Indexes are not up to date: Catalog URL Rewrites. Click here to go to Index Management and rebuild required indexes. I ...
1
vote
0answers
17 views

cat_index_position defaults to 10001. Magento 2.1.9

Magento 2.1.9 right now. We have a fec categories and set the position according to our liking. However this isnt reflected in the frontend for every product. Some work, some dont. Screenshot of the ...
0
votes
2answers
38 views

Magento 2 Catalog Product Flat Data not reindexing

the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like: truncate catalog_product_flat_1, ...
0
votes
0answers
75 views

SQLSTATE[42000]: Syntax error or access violation: 3057 Incorrect user-level lock name on re indexing

When I run php indexer.php --reindexall command I get following error. PDOException: SQLSTATE[42000]: Syntax error or access violation: 3057 Incorrect user-level lock name 'magento_prod....
1
vote
0answers
83 views

catalog_product_price reindex stuck

Using Magento 2.3.1 EE, 50k products and 14 store views. The catalog_product_price reindex gets stuck with this query listed in SHOW FULL PROCESSLIST DELETE `price_index` FROM `...
0
votes
0answers
49 views

products disappear from category page or search result, index error cluster_block_exception

Products sometimes disappear from the category pages in the frontend. It might be after reindex, or clear cache. If i go to magento admin panel->catalog-> and highlight the category, make some changes,...
2
votes
0answers
69 views

Magento2: During reindex Serialization failure: 1213 Deadlock found when trying to get lock

During php bin/magento indexer:reindex SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `...
0
votes
1answer
19 views

MAgento2.3.0 how to Update automatic indexing - cron job to set up to re-index automaticaly/periodically [duplicate]

I am using MAgento2.3.0 website i need to Update automatic indexing - cron job to set up to re-index automaticaly/periodically if any one idea how to setup please reply me
0
votes
1answer
54 views

M2: Impossible reindex

Impossible reindex magento 2.1.11 In terminal I run: php bin/magento indexer:reindex The first 3 indexes reindex in a few seconds. Reindex stops on the 4th index and this is the end. I waited all ...
1
vote
2answers
51 views

Inventory reindex runs catalog price reindex also

Magento version: 2.3.1 When I run inventory reindex from command line it first runs inventory reindex and then price reindex after that. Here is the command I executed: bin/magento indexer:reindex ...
1
vote
3answers
27 views

How do I reindex catalogue on Magento 2? 'reindex' dropdown not available

New products are not appearing on the live page. I understand I have to reindex the catalogue and clear cache for them to appear. Selecting: system > Index Management When setting all to '...
0
votes
1answer
32 views

Index sql error

When I run indexer:reindex I get the following SQL error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your ...
0
votes
0answers
36 views

Reindexing issue after upgrading to magento 2.3

Preconditions (*) Install Magento 2.2.x Make custom multi-select product attribute with the source model Steps to reproduce (*) Upgrade above magento2.2.x to magento2.3.1 Reindex Data Expected ...
0
votes
1answer
42 views

Need to run Reindex command in Controller (programmatically) in Magento 2 [duplicate]

I need to run command php bin/magento indexer:reindex in Controller.
1
vote
0answers
26 views

Magento2 Catalog Price Rule

Magento2 Catalog Price Rule Not Working when i create rule and click on save and apply rule not applied on Category without re-indexing my indexing is on update on save mode.
2
votes
2answers
33 views

While trying to Reindexing through the command prompt generate error

Command I used : php bin/magento indexer:reindex
0
votes
1answer
42 views

Magento Cron reindexing issue

We are facing an strange issue that products in listing pages are not showing in frontend. we are importing products from zoho and we have setup crons as update by schedule. Suddenly products got ...
1
vote
0answers
51 views

Facing issue with elastic search in magento 2.3 cloud

I am facing an issue with elastic search. I can not able to reindex catalosearch_fulltext. [2019-05-06 11:54:08] report.CRITICAL: Notice: Undefined index: magento2_stg_product_1_v32 in /app/Staging/...
1
vote
2answers
62 views

Reindex Not Happening Automatically Magento 2.3

Every time I update a product stock in magento it updates perfectly in the backend but only when I manually run a reindex via SSH does it update on the front end. Very annoying when I am sometimes ...
0
votes
0answers
48 views

Magento2 Product price data not save in catalog_product_index_price table

When I get product collection using \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory some of products are not get. After debug query and found missing products are not add in ...
3
votes
1answer
98 views

Magento 2: Run reindexer using REST API

Is any one having tried to create REST API so using custom API one can trigger re-indexing? which method do i have to mention in webapi.xml file as this is purely AREA::ADMIN activitiy. currently ...
4
votes
2answers
57 views

Understanding the Magento 2 index

Generally Magento's index can be updated in 3 ways (depending on usage and configuration): "On Save" "By Schedule" Using indexer:reindex command This is what I can gather from the description in the ...
4
votes
4answers
612 views

How to check whether the reindex working or not in Magento?

I have seen the Index Management of our site via admin panel System->Index Management. While checking, some of the indexes haven't updated. In this case, I'm not sure whether the index is working or ...
1
vote
0answers
28 views

catalog_category_product_index_store1 has stopped updating on reindex

I am currently having issues with making products display when adding them to new categories. The table catalog_category_product_index_store1 is no longer adding new records when reindexing Has ...
0
votes
0answers
175 views

URL rewrites not working Magento 2.3.0

I am having an issue with URL rewrites in Magento 2.3.0. URL rewrites are of course turned on and most URLs have been rewritten but there are some which have not been. They are included in the ...
2
votes
2answers
68 views

SQL Error when I try to reindex Magento 2

I have an issue in Magento 2.2.7 where my site has the message "One or more indexers are invalid." and looking at the indexers I see the following: However when I try to run php bin/magento indexer:...
1
vote
1answer
46 views

Magento 2 : Problem in reindexing site

I have created two users with certains access in BO and I found that when adding category or product even an article ( via an extension that I have already installed) I can't find the new rows added ...
0
votes
2answers
245 views

Error While Saving Product and doing reindex in Magento2.3

When I run the reindexing command got this error: Fatal error: Uncaught Error: Cannot instantiate interface Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface in /home/public_html/...
2
votes
0answers
26 views

Magento 2 : Product list only shows one product in one of the category, the rest works fine

Product list only shows one product in one of the category, the rest works fine. That category has more products, if you search for a product, you can access its product view and in related products ...
0
votes
0answers
68 views

Indexer status and backlog

When I run indexer:status from command line to look at the status of my indexes i notice some are like this: | Catalog Product Rule | Ready | Schedule | working (7414 in backlog) | 2019-02-19 01:37:...
0
votes
0answers
71 views

Magento2 Getting issue on Reindex SQLSTATE[42000]: Syntax error or access violation: 1070

Getting issue on Reindex, I was about to create a new customer attribute, How can i fix this, I also need is_used_in_grid = true Customer Grid indexer process unknown error: SQLSTATE[42000]: Syntax ...
2
votes
0answers
54 views

You need to choose options for your item in Magento2 after running command indexer:reindex

I Moved database and webserver files from one server to another. After moving everything works fine. But when i run php bin/magento indexer:reindex on new server then while adding products ...
2
votes
1answer
59 views

When should i reindex Design Config Grid?

There are different types of magento indexers as mentioned in https://devdocs.magento.com/guides/v2.3/extension-dev-guide/indexing.html Whats is use of Design Config Grid Indexer? and when does it ...
2
votes
2answers
73 views

Getting error in catalog product price indexing

I am facing below error while running indexing for catalog product price. Command: php bin/magento indexer:reindex catalog_product_price Error: SQLSTATE[23000]: Integrity constraint violation: ...
1
vote
0answers
109 views

reindex does not works on magento 2

Have tried below commands provided for similar queries to resolve reindex issue but failed. php bin/magento indexer:info php bin/magento indexer:status php bin/magento indexer:reset php bin/magento ...
2
votes
0answers
62 views

Magento 2 - re-indexing creates multiple catalogrule_product tables

Currently i am facing an issue with re-indexing, It creates a temporary copy of catalogrule_product table. I have shared an image of the tables. And because of this the db size is growing larger. Did ...
1
vote
2answers
43 views

Reindex from different computer

Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
1
vote
1answer
503 views

Magento 2 MySQL server has gone away

I managed to migrate magento 1 to new magento 2.2.5 When I reindex for the first time I get in indexer Category Products [2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): ...
0
votes
1answer
172 views

Magento 2 Customer Grid index is locked by another reindex process. Skipping

I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue. On the first reindexing I got the following error: PHP Fatal error: ...
0
votes
1answer
131 views

Magento 2 Reindex overwriting database Tier_Price changes

Could someone explain to me why whenever I perform a reindex on my magento website any changes I have made within the catalog_product_index_price table get overwritten. I have created a module that ...
0
votes
0answers
73 views

Error on reindex Magento 2

I recently made a massive load of products. After this, it's happening the following error: bitnami@ip-172-31-24-128:~/apps/magento/htdocs$ php bin/magento indexer:reindex Customer Grid index has ...