Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
536
questions
0
votes
0
answers
19
views
Magento keeps creating multiple indexes in Elasticsearch
I have a couple Magento stores, and have them hooked up to an Elasticsearch server. On just one of the stores, it seems to regularly create new index names every day, which leads to overage issues ...
- 41
0
votes
0
answers
10
views
How can I catch more detailed information about a reindexing error or when reindexing is stuck?
The size of the catalog is about 70k products.
When reindexing sometimes it turns out Could not acquire lock for index:catalog_category_product and Could not acquire lock for index:...
- 749
0
votes
1
answer
27
views
Magento 2 - Invalid Samesite attribute error on reindex command
I am getting "Invalid Samesite attribute." error while run the reindex command from CLI
"php bin/magento indexer:reindex" in the magento 2 setup (version 2.4.4, PHP 8.1, and Apache)...
- 1
0
votes
1
answer
26
views
Getting incorrect date in "updated" column in indexer grid
Getting incorrect date in "updated" column in indexer grid after upgrading magento 246p1
And in the indexer_state table updated column shows 0000-00-00
- 106
0
votes
0
answers
63
views
Magento 2.4.3 index issue - Deadlock
We are experiencing some major issues with reindex lately. We think it has something to do with the 3rd party module (we can't turn it off) We get deadlock during re-indexing every day.
And ofc that ...
- 149
2
votes
0
answers
72
views
Catalog Search index process always fail
Catalog Search indexation never end succefully.
I am using Opensearch with elasticsuite. I have 3 Vms
VM1 : Magento
VM2 : Mysql
VM3: Opensearch
Magento : I have Magento with 7 stores and more than ...
- 21
1
vote
2
answers
35
views
Magento 2 : Products not showing on front store due to re-index issue
There are no products showing on store front. After routine health checkup of the store, below error found during the reindex:
php bin/magento indexer:reindex catalogsearch_fulltext
...
- 892
1
vote
1
answer
19
views
Why new products take so long to show on frontend
The products we add in Magento 2 take too long to show on frontend, specifically 24 hours give or take before they start to show. Is this a php or index issue?
- 7
2
votes
0
answers
55
views
PhpAmqpLib Broken pipe or closed connection during index reindex
I ran this command below in my Adobe Commerce Cloud 2.4.6 to reindex it.
MAGE_INDEXER_THREADS_COUNT=$(nproc) php -d memory_limit=-1 bin/magento i:reindex
Then I got these error messages that suddenly ...
- 12.9k
0
votes
0
answers
22
views
Adding new store, Indexer issue on Magento 2.4
By adding a new store in my Magento 2.4.5-p1 EE, the indexers change to invalid status. This seems normal. If I execute a manual indexing via the CLI (bin/magento indexer:reindex), everything goes ...
0
votes
1
answer
100
views
Cannot instantiate interface Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface on reindex?
I copied a Magento 2.4.6 to the live server and suddenly I am getting this error when the search index is being reindexed:
Cannot instantiate interface Magento\InventoryIndexer\Model\...
- 409
0
votes
2
answers
44
views
My site show "We can't find products matching the selection" in category page
I used the command
bin/magento indexer:reindex
and the product appeared. But then it disappeared again and showed the words We can't find products matching the selection on the category page.
Why is ...
- 1
0
votes
0
answers
15
views
Can't reindex with LiteMage disabled
I disabled the extension Litespeed_Litemage because I don't need it on my dev environment, but now I get...
Category Products index Abort: LiteMage is not enabled
...when trying to reindex.
- 3,100
0
votes
1
answer
48
views
Is this the right command to have a cron job reindex my Magento 2 site automatically 4 times an hour?
Magento 2.4.5-p1
I have a problem which I'm guessing stems from some illegal characters in some of my product fields which results in the products in categories NOT loading every once in a while. ...
- 128
0
votes
0
answers
22
views
I get an error while re-indexing catalog_category_product M2
During the reindexing catalog_category_product index gives an error
query_timeout exceeded
INSERT INTO `catalog_category_product_index_store2_tmp` (`category_id`, `product_id`, `position`, `...
- 749
0
votes
1
answer
186
views
Magento 2.4 , Query execution was interrupted, query_timeout exceeded
its given when indexing Category Products index
Category Products index process error during indexation process: SQLSTATE[70100]: <<Unknown error>>: 1907 Query execution was interrupted, ...
- 749
0
votes
0
answers
34
views
Magento2 Some product not showing in frontend
I have the problem that no products are listed in the categories in the frontend, although they are available and the index status in the backend is indicated as "Ready" for all indexers. ...
1
vote
2
answers
37
views
Error while run reindex "405 Method Not Allowed"
I have one major error in reindex magento 2, i have try all things about Elasticsearch and I have find solution for that last one week but I didn't get any solution for that anyone help me into that.
...
- 21
0
votes
2
answers
301
views
Share catalog is taking too much time to reindex
We have almost 900+ shared catalogs across multiple stores in one setup, the pricing is assigned to each product.
When we are doing reindexing. It is taking 3-4 hours to complete Catalog Product ...
- 12.9k
0
votes
0
answers
79
views
Custom indexer for modified product in magento 2
I am try to create custom indexer in Magento 2.4. Which we will execute when any product is modified like catalog_product_category. Because i want to update the product attribute at that time.
indexer....
- 2,074
0
votes
1
answer
303
views
After Upgrade PHP to 8.1 version - flock(): supplied resource is not a valid stream resource
I have Magento v2.4.5-p1 and after php version upgrade to 8.1 when running the command: index:reindex i get this error for each index: flock(): supplied resource is not a valid stream resource.
Has ...
- 125
0
votes
1
answer
175
views
Elasticsearch indexing problem after upgrading to 2.4.4-p1
after upgrading Magento C.E to version 2.4.4-P1
I found out that I keep getting this error message when I reindex catalog search:
Catalog Search index process error during indexation process:
429 Too ...
- 118
1
vote
2
answers
2k
views
2 errors Could not acquire lock for index: when reindexing
When I reindex a Magento 2.4.4-p2 webshop, I'm getting the following errors:
Category Products index process error during indexation process:
Could not acquire lock for index: catalog_category_product
...
- 85
1
vote
0
answers
168
views
mui/index/render loading slow, index reindex when I navigate pages in admin
A store we look after is experiencing odd behaviour recently.
The admin dashboard is very slow and from what I can figure out, the indexes seem to reindex whenever you navigate to a different page. ...
- 131
0
votes
1
answer
78
views
How do I check the progress of a reindex with status 'processing'?
I am running the following command
php -d memory_limit=-1 bin/magento indexer:reindex foo
When running it on my table, my terminal goes haywire showing the following:
Memory used: 706M
Memory used: ...
- 101
1
vote
0
answers
72
views
ERROR Illegal offset type on reindexing catalog_product_attribute. Cant reindex product attributes
Upgraded from Magento2.4.2pt1 to Magento2.4.4-pt1. Now reindexing from SSH I am getting error with reindexing catalog_product_attribute.
php -d memory_limit=2G bin/magento indexer:reindex ...
- 103
0
votes
1
answer
69
views
Issue with Advanced MSI and products listing Magento 2.4.3
I'm facing an issue with Magento 2.4.x, the website is hosted on managed magento server.
We have 2 inventory sources (default & abc) and we have assigned products to the source abc. If we enable ...
- 41
1
vote
1
answer
45
views
Issue with category and brand listing
I'm facing an issue with Magento 2.4.x, the website is hosted on managed magento server. I'm facing issues with reindex even after reindexing all of the manufacturers are not listing on the front-end, ...
- 41
1
vote
0
answers
157
views
Magento 2.4 cant delete old indices from elastic search AWS server
I am having a problem in elasticsearch it doesnt delete old indices when reindexing I am getting this message in var/log/exception.log
[2022-08-10 08:05:36] main.CRITICAL: {"error":{"...
- 118
1
vote
3
answers
29
views
Magento2 reindexing
I want to know how reindexing works in Magento2. I am wondering what affects in my database when we do reindexing in Magento2.
Can anyone help me in this please
Thank you
1
vote
0
answers
71
views
You cannot define a correlation name 'stock_status' more than once while running reindex after upgrade to 2.4.3
We are getting this error during the reindex process only of catalog_category_product and catalog_product_category. This issue popped up after the upgrade of Magento to 2.4.3 from 2.1.5. Please help ...
- 11
0
votes
2
answers
454
views
Magento 2 Reindex by Website or Store id
Is there any possibility to run Magento 2 indexer based on Website id. I have tried identifying events for indexer but couldn't find one.
Is there any option to validate website id or run indexer for ...
- 71
3
votes
1
answer
3k
views
Magento 2 Elastic.co reindexing issue
I have connected my magento 2 instance with elastic.co for elasticsearch service, the connection is successfull but upon reindexing I get the following error
{"error":"no handler found ...
- 164
0
votes
2
answers
867
views
Products on category pages keep disappearing until reindex
The products on my website in the category achieves pages keep disappearing and I have to run indexer reindex every 24 hours or so. I tried both Reindex by schedule and Update on save but the problem ...
- 21
0
votes
2
answers
446
views
After upgrading to magento 2.4.3-p1 catalog search not working
Elasticsearch 7 is used and all the configuration setting are as same
as given on devdoc.
Elasticsearch connection is also returning Succesfull
When searching any of the product it does not display ...
- 1,205
0
votes
1
answer
428
views
Reindex single category programmatically
I would like to know if there is a way to reindex one single category programmatically in Magento 2.
Thanks
- 692
0
votes
1
answer
85
views
What are recommended Re-index settings?
What are the recommended re-index settings? We run a store that has around 8,000 SKUs and is connected to a Warehouse Management System which processes our Amazon orders as well.
Currently we have ...
5
votes
0
answers
546
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 ...
- 61
0
votes
1
answer
353
views
Catalog Search Index failed and products list doesn't work
Last Friday, I installed a new module (ERP embedded). Since this installation, the products list is empty on frontend. I'm using Magento 2.4.2 on apache2/php 7.4.24.
I try to reindex but I have an ...
0
votes
0
answers
730
views
Magento 2.4.2-p1 Indexing issue
Hi We have migrated our store from Magento 2.2.5 to Magento 2.4.1-p1. We are facing issues with Indexing its taking too long to complete Category Products index is taking 2 to 3 hours to complete. ...
- 269
0
votes
1
answer
387
views
Reindex - 401 Authorization Required - nginx
I have set up a local version of our Magento 2 store on my local machine running on Valet+ with Docker serving Elastic Search.
Everything is working great, except I am running into a few errors when i ...
0
votes
1
answer
387
views
Magento 2: Error on reindex
I have recently upgrade my instance from Magento 2.3.0 to 2.4.3 and products are not showing on the frontend. When I run php bin/magento indexer:reindex command I get this error:
Any help will be ...
- 350
0
votes
4
answers
2k
views
ElasticSearch connection to Magento 2.4.2
I'm new to Magento2.4 and Elasticsearch. I'm having an issue in connecting them in server setup. This works fine in my local(Windows) setup. When I try to setup in the server, it is not working as ...
0
votes
1
answer
982
views
Magento 2.4.3 not showing products and error to reindex Catalog Search
I just installed an Adobe Commerce 2.4.3 B2B + SampleData, but when I open my catalogue of products in the frontend I don't see products in the list, even seeing products in the backend, I thought it ...
- 12.9k
2
votes
0
answers
90
views
Magento 2 : Price mismatch
In magento 2.4.2,
the admin catalog product has price 40 & in frontend also 40
but in 'catalog_product_entity_decimal' the same product's price is 50.
Why so ?
What can be done to fix this ?
- 230
0
votes
1
answer
2k
views
Magento2: How can you check/set which Elasticsearch index is currently being used
We have a large catalog (400k products) that takes a day or two to reindex.
Occasionally I've had something go wrong with the indexing process and then nothing is searchable (code errors). I don't ...
- 89
0
votes
0
answers
46
views
Unable to display products in flat table even after reindexing
I imported few products in magento2.4 and also enable Flat tables through configuration.
After that I tried to run php bin/magento indexer:reindex but didn't display that product in ...
- 581
0
votes
1
answer
540
views
Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2
Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2. How it works and what are files called to index the products.
- 328
0
votes
2
answers
288
views
Schedule indexer programmatically
I have a custom index my_index that observe the change in a custom table entity_data. When changes happen in entity_data, my index's execute function is called by Magento like this $indexer->...
- 184
1
vote
1
answer
1k
views
Magento 2: What is causing slow reindexing of catalogsearch_fulltext with large catalog?
We have 400k line items, so I expect things to take a little while, but reindexing has started taking days, and often errors out in the middle. Checking in the database processlist, it looks to be ...
- 89