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 ...
