Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
545 questions
0
votes
0
answers
14
views
Catalog_Search Index
What does Catalog_Search index index? It takes over 40min to do and I need to extend the memory to 4gb to make it work. I thought it was because we had 62k products, but I just removed almost 40k ...
0
votes
2
answers
121
views
On reindexing, catalogsearch_fulltext, stack on status processing
I am working on a magento 2.4.2 store with about 5000 products on a Plesk (Obsidian 18.0.52 + AlmaLinux 8.8) dedicate server.
The customer complain' s than new products not appear on frontend.
On SSH ...
0
votes
1
answer
46
views
Magento 2.4.6-p6 | Indexer killed
So after setting up a new Magento Installation and adding all the products, catalogrules and everything needed the indexer doesnt run like expected.
When doing ìndexer:reset && indexer:reindex ...
- 157
0
votes
1
answer
73
views
Store Speed issue with Reindex. Magento 2
I have a Magento2.3.5 Version but that store is causing a strange issue Store is really fast when just Reindex is runned but after 2 or maybe 3 hrs it became really slow and I have to run Reindex ...
- 1,486
0
votes
1
answer
22
views
Reindex problem catalog_category_product_index_store10_replica
Recently I've been facing issues with reindex process, some indexes are shown with status Reindex Required and even if I achieve to reindex them they continue with the same status.
After some days ...
- 11
0
votes
0
answers
85
views
Magento 2.4.5-p5: Issue with Indexers Causing Prices to Drop to 0 on 800k SKUs
Hello Magento Community,
We're encountering a challenging issue with our Magento 2.4.5-p5 project, where product prices for approximately 7,000 out of our 800,000 SKUs (all configurable products) ...
- 3,018
1
vote
0
answers
104
views
Invalid column data type "" when reindexing catalog_product_flat
I'm using Magento 2.3.3 and when I try to reindex, the category flat was not reindexed and shows an error like this: Invalid column data type ""
Every Answer in here sends me to this
...
- 13
0
votes
0
answers
18
views
Executing indexes concurrently. Any negatives?
Because reindexing takes so long, I am contemplating running several reindex commands concurrently, via the CLI, see below:
php bin/magento indexer:reindex catalog_category_product & php bin/...
- 91
0
votes
1
answer
132
views
Catalog Search index process error during indexation process: Could not ping search engine: No alive nodes found in your cluster
I installed Magento 2.4.6-p3 by 1-click installation under Hostmonster webhosting c-panel. I didn't touch any thing. It went through well and gave me Admin Access of Magento 2.4.6-p3.
I searched whole ...
0
votes
0
answers
53
views
How to fix this indexing error?
When I am running indexer:reindex command, I am getting this error.
Integrity constraint violation: 1062 Duplicate entry '1448-0-1' for key 'PRIMARY', query was: INSERT INTO ...
- 2,823
0
votes
1
answer
55
views
Error on indexer
Currently using Magento Open Source ver 2.4.6-p2
with php 8.1, running on a shared hosting
I had uploaded a list of products (around 250 SKU) on the site and set up the index management "Update ...
- 11
0
votes
1
answer
108
views
Reindex catalog_product_attribute Deadlock found when trying to get lock
For some reason we fetch the following deadlock, when we run php bin/magento indexer:reindex catalog_product_attribute
Already tried reindex:reset and also performing a full reindex, but that does not ...
- 1,422
1
vote
2
answers
43
views
Attempts to reindex catalog_product_price throws SQLSTATE[42000]: Syntax error or access violation: 1064 on Magento 2
Recently I've been unable to reindex Product Price (catalog_product_price) on Magento 2.4.6. When I run 'php bin/magento indexer:reindex catalog_product_price' from the CLI, I get the following output:...
- 41
1
vote
1
answer
438
views
Products regularly not showing up but reindex
I'm new on setting up Magento.
I'm currently on 2.4.6-p2, which I had imported a list of products by csv.
Previously on the Index Management I was using "Update on Save" which the product ...
- 11
0
votes
1
answer
1k
views
Catalog search index process error indexation process
I did a new installation of Magento (2.4.6-p2) and did the data migration from Magento 1.
Everything seems to work, except the catalog pages, which give the following error on the frontend:
Error: ...
- 1
0
votes
1
answer
318
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
1
answer
164
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
56
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
- 161
0
votes
0
answers
235
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 ...
2
votes
0
answers
510
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
504
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
36
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?
- 11
3
votes
1
answer
600
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 ...
- 13.7k
1
vote
3
answers
563
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\...
- 569
0
votes
2
answers
57
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
1
vote
1
answer
450
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. ...
- 280
0
votes
1
answer
521
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, ...
- 781
1
vote
2
answers
157
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.
...
user111334
0
votes
2
answers
661
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 ...
- 13.7k
1
vote
1
answer
807
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 ...
- 165
0
votes
1
answer
392
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 ...
- 128
2
votes
2
answers
6k
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
...
- 105
1
vote
0
answers
321
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
291
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
99
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 ...
- 113
0
votes
1
answer
101
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 ...
- 81
1
vote
1
answer
122
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, ...
- 81
1
vote
0
answers
320
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":{"...
- 128
1
vote
3
answers
33
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
106
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
933
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 ...
- 81
3
votes
1
answer
4k
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 ...
- 166
0
votes
2
answers
1k
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
539
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,347
0
votes
1
answer
716
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
- 732
0
votes
1
answer
187
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
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
0
votes
1
answer
551
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
1
answer
881
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. ...
- 279
0
votes
1
answer
431
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 ...
