Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
545 questions
89
votes
12
answers
201k
views
Magento 2 Reindexing - One or more indexers are invalid. Make sure your Magento cron job is running
I couldn't find the way to do reindexing in mass actions on magento 2.
Seems like you need to run it from cronjob. Is there an alternative way to reindex data in magento 2 from backend or command ...
- 1,293
74
votes
9
answers
69k
views
Magento 2 How to unlock reindex process
I'm making some tests in Magento reindex process and I locked the stock index process.
How can I unlock this process?
Design Config Grid index has been rebuilt successfully in 00:00:02
Customer ...
- 1,038
22
votes
4
answers
61k
views
How to reindex Magento 1.x by using command line
How can I reindex magento using by command line.
Kindly provide steps for the same.
user51199
17
votes
6
answers
22k
views
Magento 2 reindex returns No such entity
I have successfully migrated the catalog from Magento 1.9.2.3 to Magento 2.0.2.
After the migration, I did reindex using the command php bin/magento indexer:reindex.
All is reindexed successfully, ...
- 945
9
votes
3
answers
18k
views
Magento 2: Not showing customers in backend grid
There are customers imported from Magento 1.9.1.0 which are in customer eav customer_entity and related tables. But admin customer grid shows no records. I have also tested adding new customer from ...
- 529
9
votes
4
answers
6k
views
Magento 2 reindex gives error Duplicate entry
I am experiencing an issue which not sure why when I try to reindex it gives the error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'4458-142-1-1293-4458' for key 'PRIMARY',...
- 2,651
8
votes
3
answers
4k
views
Product Attributes could not be reindexed
I am recieving this error while trying to reindex "Product Attributes". Can anyone suggest, what might be the issue and possible solution
Fatal error: Uncaught exception 'PDOException' with message ...
- 454
8
votes
4
answers
28k
views
Magento 2 - Moving site - 'No such entity'
After I moved a site from staging.site.nl to site.nl I received a weird error. If I try to reindex the site I get this error: No such entity.
If I try to login I get this message:
a:4:{i:0;s:15:"No ...
- 1,357
8
votes
6
answers
17k
views
Magento 2: Run reindexer programmatically
I am having a problem that I have costumer groups in our shop. When new customer is created and customer discount group is changed form BE. The customer cannot see their new prices. New customer sees ...
- 499
8
votes
3
answers
6k
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,651
8
votes
1
answer
9k
views
What indexes need to be reindexed for products to display correctly after stock is changed via script?
I have written a cron that updates the inventory of my products every night. What indexes need to be reindexed for products to display correctly after stock is changed via script? Does cache need to ...
- 779
8
votes
4
answers
6k
views
Magento 2.1.5: Products Missing in Categories after Reindex
I am running Magento 2.1.5 and facing a really strange issue. I have over 6,500 products uploaded to the store but some items are not showing up after performing a complete reindex. Of course, some ...
- 101
8
votes
2
answers
2k
views
enterprise_refresh_index Sleeping MySQL Connection
There are times that the indexer that is ran by cron seems to get stuck at the MySQL as Sleeping connections can be seen. Indexer runs for several hours and this actually not running at all. I've ...
- 1,339
7
votes
4
answers
25k
views
Indexer stuck in processing
Magento ver. 2.0.7
Hello, I'm trying to reindex my store so that products I added from the backend will show up on the frontend.
As shown below, after running bin/magento indexer:reindex, every ...
- 191
7
votes
5
answers
3k
views
Which server settings can cause Magento reindex to run really slow?
Shop facts:
around 100 categories
but in the main category, there are ~ 70.000 products (because filtering is heavily used)
After moving a shop developed by us to a production server of an external ...
- 14k
7
votes
2
answers
5k
views
Magento 2: How to set cron for reindex in SSH in magento 2?
I want to know how to set cron for reindexing a particular indexer method in Magento 2. I have used below code to reindex all but not working:
* * * * * php –f /shell/indexer.php reindexall
Can ...
- 906
7
votes
1
answer
4k
views
Indexing and lock files
This is more of a research question - we have a site which is having some real problems with reindexing (30,000 products). It's now at the point where we're experiencing a lot of timeouts and SQLSTATE ...
- 870
6
votes
4
answers
5k
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,130
6
votes
2
answers
5k
views
Magento Category URL Key Removed after Reindexing
Problem
I'm having a strange issue with my url_key field reverting to NULL on my catalog_category_flat_store_1 table following a reindex, but only on categories that I have created since enabling the ...
- 1,000
6
votes
1
answer
6k
views
Lock wait timeout exceeded
Quite often we get the following error in Magento when we try to make a change to one of our Categories.
SQLSTATE[HY000] [1205] Lock wait timeout exceeded; try restarting
transaction, query was: ...
- 4,923
6
votes
2
answers
8k
views
Magento 2: database error customer_grid_flat doesn't exist
We could not reindex customer_grid_flat nor we can open Customer menu at the left side in Magento 2 admin. It gives an error. Looking around i found this similar issue Then we tried to open DB table ...
- 93
6
votes
1
answer
2k
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 ...
- 2,074
6
votes
1
answer
4k
views
Magento 2: How to display error message in CLI
I have an indexer, which needs to be configured first - requires API credentials.
When I run in a reindex command in CLI: $ bin/magento indexer:reindex my_reindexer_name and the API credentials are ...
- 339
6
votes
2
answers
12k
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 ...
- 61
6
votes
5
answers
4k
views
Magento 2 - indexer:reindex throws error "Unknown TokenFilter type [phonetic] for [phonetic]"
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 ...
- 311
6
votes
2
answers
4k
views
Reindex a single product [duplicate]
My magento store has products around 30000.
Everytime When i upload/update new product, i have to reindex the whole store which takes very huge time.
So basically i would like to have a php script ...
- 332
6
votes
3
answers
1k
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,142
6
votes
0
answers
695
views
Magento 2 what is the use of indexer backlogs?
When we run the php bin/magento index:status command it throws the complete view of the indexer.
In Below screenshot you can see the backlogs are way higher. I am trying to understand what is the use ...
- 426
6
votes
0
answers
368
views
what populates data in cataloginventory_stock_status table and from which table
In magento2 - I would like to understand what populates data in cataloginventory_stock_status table and from which table the data is transferred in this table. I tried searching in ...
- 1,546
5
votes
6
answers
20k
views
Re-index error: Cannot initialize the indexer process
I have a problem re-indexing my Magento website. Sometimes I get the error "There was a problem with reindexing process", but sometimes it's "Cannot initialize the indexer process".
I read a lot of ...
- 51
5
votes
1
answer
3k
views
catalog_product index does not exist yet. Make sure everything is reindexed
In our production site using Magento 2.3.4 and Smile-SA elasticsuite extension with elasticsuite 6.x. After manual reindex site working well. But some time shows an error.
main.CRITICAL: ...
- 323
5
votes
2
answers
228
views
Magerun vs Command line indexer
Is it preferable to run a nightly re-index via the command line or would it be better to run it with Magerun?
(Or doesn't it really make a difference)
- 6,104
5
votes
2
answers
15k
views
Understanding Catalog URL Rewrite Indexer [duplicate]
I've truncated the core_url_rewrite table with about 5000000 records. After that I run the Catalog URL Rewrite Indexer which created 1782612 records. Then I run it again and the table had 2251930 ...
- 310
5
votes
3
answers
14k
views
Why all the products are not displayed on the category?
I came across a weird issue. There are around 400 products assigned to a category but it is only displaying around 150 products.
I verified the products enabled and all, actually those products show ...
- 1,103
5
votes
2
answers
2k
views
How To Resolve Magento ReIndexing Errors In Magento 1.9.1 Store
How To Resolve Magento ReIndexing Errors In Magento 1.9.1 Store please find the below image
When I reindex product prices it is showing below error
There was a problem with reindexing process.
...
- 173
5
votes
2
answers
2k
views
Temporarily disable reindexing
Scenario:
I'm running some script that changed some attribute values for some products.
Because of performance reasons, I split this into batches.
Problem:
But each time I'm done with a batch the ...
- 199k
5
votes
1
answer
1k
views
Magento 2: Is there a way to lock indexer programmatically?
When I run my custom import script, and during it's execution starts reindex, it causes the error :
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when
trying to get lock; try ...
- 865
5
votes
1
answer
2k
views
Magento 2: How to reindex specific indexer method in Magento 2 programatically
I can reindex a specific indexer method by following way in Magento 1.x
$process = Mage::getModel('index/indexer')->getProcessByCode('catalog_product_price');
$process->reindexAll();
How to ...
- 906
5
votes
3
answers
1k
views
Magento dataflow import (stop indexing on the fly)
There are, basically, two ways when importing product via csv file in Magento.
a) import
b) dataflow import
a) option, works faster, I assume that is because this option want index all the data on ...
- 581
5
votes
2
answers
311
views
Index management - most crucial factors of indexing time
What are the most important factors which affects the time of indexing ...
product attributes
product prices
catalog url rewrites
and also the indexes for flat tables.
I know that the number of ...
- 243
5
votes
2
answers
4k
views
Magento Enterprise: catalog_product_attribute not reindexed on product save
I'm using Magento ee 1.13.0.2 and discovering the next problem:
I have some of the attributes used in layered navigation - color and size. When I add a new product (simple one) and save it - product ...
- 71
5
votes
3
answers
901
views
How to manage Magento store with 60 Million Products
I have completed the product import process of 60 Million products in Magento 2. But products are not visible on the front-end, while debugging this I found that re-indexing of products is still in ...
- 623
5
votes
1
answer
1k
views
Reindex doesn't work (but shows success message)
I have a local environment and an online environment. Reindexing works locally but not online.
In the backend I'm getting the message:
One or more of the Indexes are not up to date: Product ...
- 153
5
votes
1
answer
648
views
Error while reindexing product attribute
On re-indexing product attribute I have found below error :
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (xxxxxxx....
- 1,040
5
votes
0
answers
755
views
Magento with ElasticSearch index
I'm trying to understand the "We can't find products matching the selection" issue that happens a few times a week with the Magento.
Most of the time(80%), this is resolved automatically in ...
- 71
4
votes
5
answers
3k
views
Magento 2 while reindex INSERT INTO 'catalog_category_product_index_store1' stuck the query
I am working on Magento 2.3.2. When I run re-index command php bin/magento i:rei Design Config Grid and Customer Config Grid is completed. But it is taking too much time to re-index Category Products ...
- 308
4
votes
3
answers
7k
views
Magento2 reindex from backend
I don't see any options to reindex from backend.
Will it always have to be done via ssh? This is a big pain because our store owners should have the option to reindex from backend, we don't want to ...
- 6,287
4
votes
1
answer
2k
views
Reindexing in Magento with AOE Scheduler
I installed the rather nifty looking AOE Scheduler extension. It's all working good and I can see a task called;
catalog_product_index_price_reindex_all
but from what I can gather this only ...
- 149
4
votes
2
answers
3k
views
Magento indexing is failing, SQLSTATE[23000]: Integrity constraint violation
For some reason Magento indexing is failing, we haven't changed anything in the website.... And that is the weird thing! The error in shell using indexer.php:
$ php indexer.php --reindex ...
- 201
4
votes
1
answer
301
views
Where is the "CREATE TABLE" definition for catalog_product_flat* tables?
I'm looking to add indexes the table to it to make lookups faster. If you manually add an index in MySQL, it will disappear at the next Magento "reindexing" event.
- 1,318