Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [reindex]

Denotes Question about reindex data in index management in Magento 1 and 2.

Filter by
Sorted by
Tagged with
0 votes
1 answer
17 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 ...
ernestoslo's user avatar
0 votes
0 answers
72 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) ...
Navin Bhudiya's user avatar
1 vote
0 answers
50 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 ...
JadoBulku's user avatar
0 votes
0 answers
13 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/...
A. Andersen's user avatar
0 votes
1 answer
42 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 ...
user114880's user avatar
0 votes
0 answers
38 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 ...
Mujahidh's user avatar
  • 2,793
0 votes
1 answer
44 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 ...
Vulcan's user avatar
  • 11
0 votes
1 answer
47 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 ...
JGeer's user avatar
  • 1,418
0 votes
0 answers
34 views

Magento 2.4.0 Sorting by custom eav attribute

I have a index that adds eav values ​​to products and it adds the correct values, these eav attributes are used to sort the product catalog, but this sorting is not correct, it started with a value of ...
RatajX's user avatar
  • 11
1 vote
2 answers
31 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:...
mcpacific's user avatar
1 vote
1 answer
197 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 ...
Vulcan's user avatar
  • 11
0 votes
1 answer
371 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: ...
PinoL's user avatar
  • 1
0 votes
1 answer
107 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 ...
blueionRich's user avatar
0 votes
0 answers
36 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:...
Robinio's user avatar
  • 771
0 votes
1 answer
110 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)...
Sundar's user avatar
  • 1
0 votes
1 answer
45 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
Harish kuril's user avatar
0 votes
0 answers
161 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 ...
Jan-petter Havna's user avatar
2 votes
0 answers
292 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 ...
maldini3's user avatar
1 vote
2 answers
202 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 ...
Jitendra Mandloi's user avatar
1 vote
1 answer
28 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?
sarmad95's user avatar
3 votes
1 answer
392 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 ...
Rafael Corrêa Gomes's user avatar
0 votes
0 answers
36 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 ...
Joachim Cecilio's user avatar
0 votes
3 answers
359 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\...
user4095519's user avatar
0 votes
2 answers
52 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 ...
Simon098's user avatar
0 votes
1 answer
217 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. ...
Allysin's user avatar
  • 260
0 votes
1 answer
371 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, ...
Robinio's user avatar
  • 771
1 vote
2 answers
85 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. ...
user avatar
0 votes
2 answers
542 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 ...
Rafael Corrêa Gomes's user avatar
1 vote
1 answer
613 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 ...
David Young's user avatar
0 votes
1 answer
324 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 ...
lazy_coder's user avatar
2 votes
3 answers
4k 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 ...
Michiel's user avatar
  • 105
1 vote
0 answers
259 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. ...
Mr Pablo's user avatar
  • 131
0 votes
1 answer
176 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: ...
glitchwizard's user avatar
1 vote
0 answers
88 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 ...
Jonathan's user avatar
  • 113
0 votes
1 answer
94 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 ...
Sandeep Nair's user avatar
1 vote
1 answer
75 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, ...
Sandeep Nair's user avatar
1 vote
0 answers
247 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":{"...
lazy_coder's user avatar
1 vote
3 answers
31 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
hardik malkani's user avatar
1 vote
0 answers
79 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 ...
Sri's user avatar
  • 11
0 votes
2 answers
752 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 ...
Pkrishna's user avatar
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 ...
Aditya Yadav's user avatar
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 ...
MADT's user avatar
  • 21
0 votes
2 answers
503 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 ...
Arun Sharma's user avatar
  • 1,315
0 votes
1 answer
597 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
PauGNU's user avatar
  • 722
0 votes
1 answer
139 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 ...
Kshitij Shah's user avatar
5 votes
0 answers
687 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 ...
Siva's user avatar
  • 61
0 votes
1 answer
490 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 ...
Vincent AZ's user avatar
0 votes
1 answer
834 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. ...
OBAID's user avatar
  • 279
0 votes
1 answer
413 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 ...
Tom Greaves's user avatar
0 votes
1 answer
524 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 ...
mechanic's user avatar
  • 440

1
2 3 4 5
11