Questions tagged [reindex]

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

Filter by
Sorted by
Tagged with
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 ...
blueionRich's user avatar
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:...
Robinio's user avatar
  • 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)...
Sundar's user avatar
  • 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
Harish kuril's user avatar
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 ...
Jan-petter Havna's user avatar
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 ...
maldini3's user avatar
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 ...
Jitendra Mandloi's user avatar
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?
sarmad95's user avatar
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 ...
Rafael Corrêa Gomes's user avatar
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 ...
Joachim Cecilio's user avatar
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\...
user4095519's user avatar
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 ...
Sơn Tùng's user avatar
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.
Black's user avatar
  • 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. ...
Allysin's user avatar
  • 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`, `...
Robinio's user avatar
  • 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, ...
Robinio's user avatar
  • 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. ...
Sutariya Parth's user avatar
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. ...
Rohit Gohel's user avatar
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 ...
Rafael Corrêa Gomes's user avatar
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....
Kushal Dani's user avatar
  • 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 ...
David Young's user avatar
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 ...
lazy_coder's user avatar
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 ...
Michiel's user avatar
  • 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. ...
Mr Pablo's user avatar
  • 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: ...
glitchwizard's user avatar
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 ...
Jonathan's user avatar
  • 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 ...
Sandeep Nair's user avatar
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, ...
Sandeep Nair's user avatar
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":{"...
lazy_coder's user avatar
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
hardik malkani's user avatar
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 ...
Sri's user avatar
  • 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 ...
Pkrishna's user avatar
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 ...
Aditya Yadav's user avatar
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 ...
MADT's user avatar
  • 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 ...
Arun Sharma's user avatar
  • 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
PauGNU's user avatar
  • 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 ...
Kshitij Shah's user avatar
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 ...
Siva's user avatar
  • 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 ...
Vincent AZ's user avatar
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. ...
OBAID's user avatar
  • 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 ...
Tom Greaves's user avatar
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 ...
mechanic's user avatar
  • 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 ...
Jayendhar P's user avatar
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 ...
Rafael Corrêa Gomes's user avatar
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 ?
devhs's user avatar
  • 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 ...
Art Siv's user avatar
  • 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 ...
Unknown's user avatar
  • 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.
Sabareesh's user avatar
  • 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->...
Hieu Duong's user avatar
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 ...
Art Siv's user avatar
  • 89

1
2 3 4 5
11