Stack Exchange Network

Stack Exchange network consists of 174 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.

0
votes
0answers
18 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
33 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
23 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
23 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
17 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
14 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. ...
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
64 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
31 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
26 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
48 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
32 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
16 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
58 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
58 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 ...
2
votes
0answers
48 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
8 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
92 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
15 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
27 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
24 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
27 views

main.ERROR: Cron Job indexer_reindex_all_invalid has an error

Since two days ago magento 2.2.6 don't work properly. catalog search don't reindex. Backend catalog don't find any product. Backend contains config don't work. frontend product page 404 error. the ...
0
votes
0answers
14 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
151 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
35 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
40 views

Magento2: Reindex command issue

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

Magento 2 index management page not working

My English not perfect sorry. When I click System > index management , page is looks like this. I add a picture. https://prnt.sc/leejne What can I do? Thanks for reply..
0
votes
1answer
78 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
68 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
123 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
31 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
66 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
63 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 ...
1
vote
1answer
26 views

Magento1.9 Indexing fast

My catalog_product_flat indexing take too long time. How to make this indexing faster in Magento 1.9
0
votes
1answer
95 views

Error Elasticsearch on reindexing - No handler for type [text] declared on field [search]

When I launch a full reindex (php bin/magento indexer:reindex), I have two errors for these indexes : "Catalog Search" , "ElasticSuite Category" I have the Smile/Elasticsuite module installed on my ...
0
votes
1answer
36 views

Re index For specific product in magento1.9

i want reindex for some products by id i tried following code but it take all indexing to reindex required i am using magento 1.9.2. $product = Mage::getModel('catalog/product')->load('84494'); // ...
0
votes
0answers
31 views

Disable Magento 2 reindex update by schedule

I changed my Magento 2 reindex from "Update on Save" to "Update on Schedule". I did this because I wanted reindex to run just when I need it. I saw by the php bin/magento indexer:status command that ...
1
vote
0answers
56 views

Magento 2.2.5 - Table catalogsearch_fulltext_scope1 not being automatically generated

Summary The exception log becomes bloated with "main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalogsearch_fulltext_scope1' doesn't exist". sometimes reindexing cycle is ...
0
votes
2answers
33 views

Can't reindex from web admin

I can't reindex catalog_category_flat index from web admin, I see an error message. But I can reindex it from the console by running php shell/indexer.php --reindex catalog_category_flat without ...
2
votes
1answer
159 views

Magento 2 Big numbers in backlog for indexer [duplicate]

When I run php bin/magento indexer:status I got the following result. Title | Status | Update On | Schedule Status | Schedule Updated | +-------...
1
vote
1answer
127 views

Magento 2 Down: replica Tales not found when reindexing!

My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back: (Magento 2.2.4, PHP 7.0.30) When re-indexing, i get the following error: ...
0
votes
0answers
27 views

Cannot initialize the indexer process in magento1

I have tried in so many ways to solve it, but still i did not reach at my goal. In magento admin the reindex is not working and showing the error like Cannot initialize the indexer process . Please ...
0
votes
1answer
141 views

Problem with reindex terminal

I have an issue with the reindex of Magento. I have try to do this with the terminal and this is the response error [Exception] ...
0
votes
1answer
117 views

Magento 2 : Schedule Status : suspended

I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day. I usually also reindex manually and when i see a suspended index I reset it. But, when I do reindex:...
0
votes
0answers
31 views

Re indexing not working properly. Magento 2

I am getting issue with some of the products in flat table are getting current date/time in created_at, whenever re-index command has been executed. I have also checked with changing that products ...
1
vote
0answers
88 views

Magento 2.2.2:Customer Grid Indexer not working

While re indexing got an error PHP Fatal error: Uncaught Error: Call to undefined method Magento\Customer\Model\Indexer\Source::addAttributeToSelect() in /var/www/html/ncsmokehouse/vendor/magento/...
1
vote
1answer
365 views

Magento 2 Reindex Fail `Unknown column 'entity_value.value'` in 'field list'

I am having this error when running php bin/magento indexer:reindex also failing when loading the product: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_value.value' in 'field list',...
2
votes
2answers
41 views

Reindexing issue in Magento 2

I added a column in customer_grid_flat table using UpgradeSchema.php . But each time I run the command php bin/magento indexer:reindex this column gets deleted. I cannot figure out why this happen....
0
votes
2answers
272 views

Error in reindex process in Magento 2

Due to error in reindex, Reindex process for 'design_config_grid ' is Skipping Design Config Grid index is locked by another reindex process. Skipping. Customer Grid index has been rebuilt ...
0
votes
0answers
26 views

Search is not working for some products with magento 1.9.3.7

I know there is already asked this type of question but it does not work for me. I am using magento 1.9.3.7 version when I am going to search products, for some products it is working and for some ...