Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [reindex]

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

2
votes
1answer
36 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
34 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
1answer
42 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
24 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
15 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
19 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
24 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
33 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
30 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
33 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 ...
1
vote
0answers
21 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
34 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
108 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
47 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
43 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
34 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 ...
0
votes
1answer
58 views

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

After created a shopping cart rule for grouped product I got that catalog_product_attribute indexer needs reindex. When I tried to reindex from console I got: Product Attributes index process ...
0
votes
1answer
48 views

How to confirm that the reindex is working or not?

We have added a new product in one of the categories on our site using the Magento admin panel. But the added product is not visible in the frontend. We have set the reindex mode to Update on save ...
0
votes
0answers
24 views

M2: Impossible finish reindex

Now all products are were gone on all store view. I checked and product and category index is proccessed. I try reset indexes and reindex again but now I wait about 50 minutes and no result. Any ...
0
votes
1answer
36 views

Magento 2 localhost wamp cron jobs

I'm still getting the error on my admin page "One or more indexers are invalid. Make sure your Magento cron job is running" All field indexes rebuild successfully apart from Catalog Search. I'm using ...
0
votes
0answers
32 views

Magento 2.1 - Reindex failing on product eav and catalog search index

We moved magento code setup from one server to another. Initially all the indexes are in ready status. But if we run the reindex command: php bin/magento indexer:reindex the reindex fails for ...
0
votes
0answers
10 views

Content not appearing after adding two text content types

I've gone through the Magento admin control panel to Content > Content Types > Select Section (For us it is called "0-Home") > Manage Fields and added two text fields, not required, no max ...
0
votes
0answers
88 views

Getting “DDL statements are not allowed in transactions ” error when re-index programmatically in magento 2.2.X

I am working on Magento 2.2.6. As per requirement I need to do re-index on sales_order_save_after event. It is working well in Magento 2.1.X but I am getting following error on Magento 2.2.X. ...
0
votes
0answers
29 views

Magento 2 Visual Swatches isn't appear for some products

i have set the color attribute to show as "Visual Swatch" and for some reason the swatches isn't showing up at all for most of the products. All the swatches has values and the simple products has ...
0
votes
0answers
39 views

Magento homepage redirects to 404 page not found

After reindexing, when entering the homepage url, I'm redirected to 404 page not found. I have checked configuration/general/web and everything seems to be working there.
2
votes
1answer
27 views

Does indexer:reindex need “var”, “generated” and “pub/static” to be writable?

I would like to know if, when doing "php bin/magento indexer:reindex" the folders "var", "generated" and "pub/static" have to be writable ? Alternatively, does reindexing only work at database level? ...
6
votes
2answers
166 views

Indexing Not working after installed Smile Elastic search extension Magento 2

I have installed Smile Elasticsearch extension successfully.But i am not able to reindex catalogsearch_fulltext indexer. I have installed elasticsearch successfully on my local server. Please check ...
3
votes
0answers
60 views

Indexer stuck at processing Design Config Grid, Customer Grid, and Catalog Search

My indexer always stuck at processing for Design Config Grid, Customer Grid, and Catalog Search i already ran php bin/magento indexer:reset , but when the cron indexer run the result still the same, ...
0
votes
1answer
30 views

Magento 2 - Clear cache in 3 Servers programatically?

I am in a project which uses 3 servers to serve a Magento 2 site. I have written a code to clear cache and re-indexing. But for certain reasons the cache flush has to happen in all the three servers. ...
0
votes
2answers
83 views

Error when reindexing

when I use php bin/magento indexer:reindex or php bin/magento cron:run I keep getting this error. Parse error: syntax error, unexpected '?', expecting variable (T_VARIABLE) in /home/[NAME]/...
0
votes
2answers
80 views

Magento 2 error : Command “indexer:reindex” is not defined

System : Ubuntu 18 Application : Magento2.3 PHP : 7.1 I have two indexer need to be reindex. I have update the indexer on the admin page but it is not work. I also use the following command on the ...
0
votes
0answers
25 views

Catalog Rule Product indexer process unknown error

I am getting the following error : while running : bin/magento indexer:reindex Catalog Rule Product indexer process unknown error: Table status for `catalogrule_rule_cl` is incorrect. Can`t fetch ...
2
votes
3answers
84 views

Reindex is in processing since 10 days why it is not going to complete in magento2

See the date of reindex in processing since 10 days why it is not going to finish Cron jobs running in every 21 hours for reindex I try also manually reindex but taking too long time in days ...
0
votes
0answers
155 views

Catalog Search indexer process unknown error

I'm getting a 'One or more indexers are invalid. Make sure your Magento cron job is running.' and it seems I need to run php bin/magento indexer:reindex from the CLI. I get the index rebuilt ...
3
votes
0answers
87 views

Magento2 catalog_product_category / catalog_category_product - Serialization failure Deadlock

Lately I'm experiencing some issues when trying to reindex catalog_product_category and/or catalog_category_product (most of the issues seem to be on this last one). The reindex process fails to ...
0
votes
0answers
12 views

Search on front end not working = Cannot initialize the indexer process FOR Rebuild Catalog product fulltext search index (Catalog Search Index)

Magento 1.9.1 Porto theme We had some server performance problems. I did a re-index couple of times and broke one of the indexes (I guess). Now - when anyone tries to search on the front end - they ...
0
votes
1answer
294 views

Magento 2.3 - php 7.2.10 - Reindex error - bin/magento is not opening -

MacOS High Sierra MAMP php webserver - 7.2.10 /Applications/MAMP/bin/php/php7.2.10/bin//php- 7.2.10 -- usr/bin/php - 7.1.16 Nittns-MacBook-Air:~ baanallc$ cd /applications/MAMP/htdocs/23/ Nittns-...
0
votes
0answers
19 views

Why “catalog_product_price” indexing is required while importing new products with tags Magento 1.9

I have to reindex catalog_product_price when I import products which have new tags. We have managed to create the tags if they are not in the system. We have created an observer which fires after ...
1
vote
0answers
29 views

Reindex price only for specific store

When I import special_price on a specific store, I would like reindex price only for this store. I found this : Mage::getSingleton('catalogindex/indexer')->plainReindex(null, null, $store); But ...
0
votes
0answers
29 views

Table customer_grid_flat delted after reindex magento

I have my project in amazon server. when I run indexer_reindex the table customer_grid_flat is deleted and I get an error as below Exception #0 (Magento\Framework\Exception\LocalizedException): ...
0
votes
0answers
18 views

InnoDB temporary tablespace size explodes after reindex

Within a Magento 2.2.6 installation we currently have a peculiar problem, where MySQL's Temporary Tablespace of InnoDB (ibtmp1) suddenly explodes in size, growing seemingly indefinitely until the disk ...
1
vote
0answers
162 views

”Undefined offset: 4” when reindexing “Search indexer”

After module update I've got such error for indexing via SSH Catalog Search indexer process unknown error: Notice: Undefined offset: 4 in /home/sellastu/public_html/vendor/magento/module-catalog-...
1
vote
0answers
66 views

Magento 2 mview_state mode disabled?

When I check indexer status with php bin/magento indexer:status, I got following result, +--------------------------------------+--------+-----------+-----------------+------------------+ | Title ...
0
votes
0answers
49 views

Magento2: Reindex command issue

Reindex status is processing Also index:reset command is not working Got the error message below
0
votes
1answer
164 views

catalog_category_product_index table empty (Magento 2.2.5)

Our indexer re-fills the table catalog_category_product_index_store1, but the table catalog_category_product_index remains empty. I have found this issue https://github.com/Smile-SA/elasticsuite/...
0
votes
1answer
102 views

SQLSTATE[42000] Exceptions on reindex

I updated my MAMP site from EE 1.14.1.0 to EE 1.14.2.0. After updating, I also applied the new patch for PHP 7. The site also has all of the required SUPEES. When I try and do a reindexall command ...
3
votes
1answer
199 views

Magento 2 Is it possible to run reindexing per storeview?

My site has more than 100.000 products and almost 20 storeviews. Each time I run a full reindexing, it takes about 10 hours for reindexing to be finished. I wonder if it's possible to just run ...
0
votes
0answers
56 views

Magento 2: Asymmetric transaction rollback

Impossible save product / assign to categories. Asymmetric transaction rollback. I try rm -rf var/di/* rm -rf var/cache/* rm -rf var/page_cache/* rm -rf var/generation/* and php bin/magento ...
0
votes
2answers
135 views

Is it possible to reindex without CLI?

I am getting the error: One or more indexers are invalid. Make sure your Magento cron job is running. I know that I could fix this using the command php bin/magento indexer:reindex using the ...
0
votes
0answers
114 views

Magento 2 Reindexing Product EAV takes long time to run

I have about 114000 products in catalog_product_entity table, I wonder how long time it will normally take for run indexer:reindex? In my case all indexer can be finished with in an hour, but Product ...