Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged with
0 votes
0 answers
59 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
0 votes
0 answers
9 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
0 answers
13 views

Why I am getting error while using n98-magrun2 command "PHP Fatal error: Uncaught TypeError: Magento\ApplicationPerformanceMonitor\Plugin\Applicatio"

I am getting the below error while running the command n98-magerun2 list: PHP Fatal error: Uncaught TypeError: Magento\ApplicationPerformanceMonitor\Plugin\ApplicationPerformanceMonitor::aroundLaunch(...
Abhinav's user avatar
  • 33
0 votes
0 answers
60 views

Catalog Rule Product index in parallel mode

In the Magento 2.4.6 Community Edition project there is an issue. An implementation of the Catalog Price parallel index has almost been done in the issue. The size of the ...
OleKh's user avatar
  • 1
0 votes
1 answer
43 views

One or more indexers are invalid. Make sure your Magento cron job is running. Can it be fixed from admin panel?

I have a magento 2.4.3 running on a production server. I have the following error message in the admin panel. Also some of the indexers shows "reindex required". I do not have the SSH ...
Ye Myat Aung's user avatar
0 votes
0 answers
30 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
537 views

How to optimize Magento 2 indexer

I'm having one magento 2 website which contains 1 million products. The website is based on MSI and there are multiple CRON jobs running on hourly basis to do the inventory and price updates. So the ...
Sandeep Nair's user avatar
0 votes
2 answers
51 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
0 answers
29 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,280
0 votes
4 answers
2k views

Products are not visible at frontend Magento 2

There's two created product each of them is set: Product Type : Simple Website : Main Websites Status : Enabled Visibility: Catalog, Search Salable Quantity: >50 I use Magento 2.4.4 Open source ...
rt89's user avatar
  • 11
0 votes
0 answers
71 views

Get list of product ids which are being indexed when catalog_product_price indexer is executed in 2.4?

Want to get the list of products/SKUs which are being indexed when the following index command is executed? php bin/magento indexer:reindex catalog_product_price Looking for any public method or ...
sandip's user avatar
  • 3,964
0 votes
1 answer
621 views

Inventory management not automatically changing to 'out of stock' (is there Patches List for Magento 2)

I have faced issue after issue with the Magento 2 software that entails me having to do patch after patch. My most recent issue is with the inventory feature. I have turned on inventory management, ...
thinkhjj's user avatar
0 votes
1 answer
196 views

Explain meaning of column Schedule Status on the Index Management admin page

There are 2 columns on the Index Management page: Status and Schedule status. Could you please provide detailed explanation what does each combination of values mean? For example: Status Schedule ...
Ruslan Mavlyanov's user avatar
0 votes
1 answer
471 views

How to set the MAGE_INDEXER_THREADS_COUNT variable in Magento cloud?

In the docs, Magento advises us that we can set the MAGE_INDEXER_THREADS_COUNT environment variable: run the reindex command using the environment variable MAGE_INDEXER_THREADS_COUNT, or add an ...
McMunchkin's user avatar
0 votes
2 answers
450 views

How Magento validate products in cart for carts price rule and how to extract product from conditions_serialized column of the sale rules table?

I need to create an indexer for cart price rules. I decided to iterate the values from sales_rules table and extract the products from conditions_serialized coloumn. My indexer file is like below.i ...
Mujahidh's user avatar
  • 2,791
2 votes
1 answer
794 views

Indexer hangs unexpected

problem description i have a problem on a magento 2.4.5-p1 project. the problem: sometimes, the indexer has a problem and is hanging. i can run "php bin/mangeto indexer:reindex". then, ...
Philippe Aellig's user avatar
1 vote
1 answer
426 views

How to create indexer for custom table

I want to create an indexer for my custom EAV entity (for learning purposes only). I have the following tables: custom_employee_entity custom_employee_entity_datetime custom_employee_entity_decimal ...
LolKek's user avatar
  • 166
0 votes
0 answers
96 views

Magento 2.4.3 Configurable Disappears From Catalog when simple count exceeds 325

One for the Gurus! I have a configurable with 3 Attributes: Product type, Colour and Height. When I exceed 325 simple products within the configurable the product will disappear from the category it ...
UK_Rogue's user avatar
0 votes
1 answer
187 views

New products not showing in category frontend Magento 2.3.7-p3

Before you dismiss this kindly read the details. I have come across several issues but none provide a solution to my question. My products do not show in the frontend of the store. They are visible ...
thinkhjj's user avatar
0 votes
2 answers
630 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
2 votes
0 answers
438 views

Very slow async bulk import via RabbitMQ

I'm importing products using bulk Magento APIs and RabbitMQ. The problem is that the process is too slow and sometimes it seems that completely stucks. Magento version is 2.4.2 and RabbitMQ version is ...
myh34d's user avatar
  • 121
0 votes
2 answers
1k views

How can I remove backlog from indexer programmatically?

I want to remove backlogs from the indexer when I check the indexer:status there I found many backlogs in the indexer. I need to remove this problematically using corn job at every 2 minutes my cron ...
Jay Parmar's user avatar
1 vote
1 answer
365 views

Catalog Search index error After updating Magento 2.4.0 to 2.4.2

When I run php bin/magento indexer:reindex I get the following error message from the Catalog Search indexer: {"error":{"root_cause":[{"type":"...
Jared Chesebro's user avatar
0 votes
1 answer
497 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
0 votes
0 answers
232 views

Magento 2 - Why do I always have to manually reindex?

I have setup my cronjob and it runs fine. But sometimes we have to manually execute php bin/magento indexer:reindex to manually reindex everything, otherwise new customers are not showing in the ...
Black's user avatar
  • 3,280
0 votes
2 answers
332 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
0 answers
292 views

Index catalogrule_rule still invalid after reindex by cron

I have an issue with indexes becoming invalid once a day even though nothing has changed (neither in front end or back end). When this happens all other indexes but catalogrule_rule and ...
P. Kouvarakis's user avatar
1 vote
1 answer
117 views

updateAttributes cannot be used to enable a product? (price index not updated)

We are enabling a disabled product with \Magento\Catalog\Model\Product\Action::updateAttributes $this->productAction->updateAttributes([$magentoProductId], [ 'status' => \Magento\Catalog\...
Alex's user avatar
  • 13.8k
0 votes
0 answers
86 views

Magento 2.4.1: We can't find products matching this selection indexer issue

This error message keeps displaying across the category pages of our Magento 2.4.1 site. Indexer status is below. Not sure what is the cause of this recurrent issue.
CodeForGood's user avatar
1 vote
0 answers
517 views

Magento 2. Indexers sometimes switch(on their own) to Update On Save when configured on Update On Schedule

My issue is simple enough. It reproduced on 2 separated projects. I have all indexers set on Update on Schedule. Without anyone changing them, I just wake up with them configured with Update On Save. ...
vitoriodachef's user avatar
0 votes
0 answers
73 views

Indexing problem 2 different sites on same server. One site breaks other

We are facing a problem with indexing. There are two magento 2 installations, (diferent hosting, different domains, running different fpm pools with different users , different and independant ...
pablo picans's user avatar
0 votes
2 answers
1k views

Error reindexing fulltext search after elasticsearch had been enabled on Nexcess cloud hosting (Magento 2)

I get this error when trying to run the indexer for the search: php bin/magento indexer:reindex catalogsearch_fulltext Catalog Search indexer process unknown error: {"error":{"...
Sparc's user avatar
  • 327
2 votes
1 answer
109 views

How to change indexer multi-store sequence

I'm working on a Magento2 with 100's of websites in a multi-store setup. We're presently not using the asynchronous indexing feature, but rather re-index in full once per day. The whole reindexing ...
Juergen Schreck's user avatar
2 votes
1 answer
2k views

URI is not valid and cannot be converted into a string

I'm struggling with an error that is thrown in the debug.log. The problem is that multiple indexers are not updated allthough the cronjobs are running. Re-indexing by CLI is working properly on all ...
bluebyte's user avatar
1 vote
3 answers
5k views

Getting error on indexing magento2.4

I have just installed magento2.4 with sample data. Setup looks fine from frontend and backend also, but facing 2 issues - 1 - when I run 'indexer:reindex' command, it giving me below issue - Catalog ...
Atul's user avatar
  • 905
0 votes
1 answer
497 views

Magento 2 - How to regenerate url_rewrite table?

I truncated the whole url_rewrite table from phpMyAdmin. I thought that it will regenerate if I execute php bin/magento indexer:reindex but it doesn't. How can I fix it?
Black's user avatar
  • 3,280
2 votes
0 answers
229 views

Cron 'catalogrule_apply_all' locks cron 'indexer_all_invalid' and catalogsearch_fulltext keeps processing Magento 2.3.5

Took me quite some time to debug this. Every night (default) at 0:00 catalogrule_apply_all is run by cron, and resets all indexes for all store. As a consequence catalogserach_fulltext is launched (...
Matthew's user avatar
  • 56
2 votes
3 answers
12k views

How to Solve: "Could not acquire lock for cron job: X" in Magento var/log/cron.log

With my M2 instance indexers in "Update on Schedule" mode... var/log/cron.log receives this warning near constantly: Could not acquire lock for cron job: indexer_update_all_views [] [] The cron ...
Gabriel Richards's user avatar
0 votes
1 answer
27 views

Indexer catalogrule_rule is set to invalid and causes the cache to be flushed a lot

I'm having a slowness issue on my client cloud instance. Indexer catalogrule_rule is set to invalid and flush the caches a lot so the site is always slow even when we have the Miravit cache warmer ...
Toan Tam's user avatar
  • 1,308
0 votes
2 answers
572 views

Magento 2.3 reindex design_config_grid stucks on processing

design_config_grid and customer_grid stuck on processing when I use bin/magento indexer:reindex. Even after bin/magento indexer:reset and changing status to Invalid, when I reindex again, they stuck ...
samurai_code's user avatar
0 votes
1 answer
510 views

Undefined index: type_id - Catalog Search indexer

Installed Smile-sa elasticSuite for Magento 2.3.3 and when indexing it gives this error: Catalog Search indexer process unknown error: Notice: Undefined index: type_id in /srv/html/src/vendor/smile/...
Abude's user avatar
  • 322
0 votes
2 answers
1k views

Magento 2 Which Index should set "Index By Schedule" or "Update On Save" for performance purpose?

I have a site with Magento 2.3.3 version with over 10000 catalog products. For performance purposes which Indexer should set "Update on Save" or "Update On Schedule". Thank You.
Ye Yint's user avatar
  • 79
1 vote
0 answers
31 views

Flat catalog tables considered a bad practice since M2.1.x and above? [duplicate]

Magento no longer recommends the use of a flat catalog as a best practice. Continued use of this feature is known to cause performance degradation and other indexing issues. A detailed description and ...
Akif's user avatar
  • 1,532
0 votes
1 answer
1k views

Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory .Magento 1.9 indexing error

I have installed Magento 1.9 but when I am trying to run indexer command I am getting following errors. PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /...
Sayyed Hasan's user avatar
0 votes
1 answer
265 views

2.3.3 Unable to Reindex Catalog Search: 'index catalogsearch_fulltext_scope1: does not support DELETE'

I have migrated from Magento1.9 to Magento2.3.3. When running the reindexer command I got the following error: index catalogsearch_fulltext_scope1: does not support DELETE (enabled=0) [ DELETE FROM ...
eyemauler's user avatar
4 votes
1 answer
4k views

Magento 2 how to use elasticsearch for custom indexer? Custom sort stops working after enabling elasticsearch

I am a magento newbie and trying to implementing a custom sort on product listing page with the help of this: https://magento.stackexchange.com/a/230983/84727 On top of the solution i have built a ...
Vivek V. Bharos's user avatar
1 vote
1 answer
70 views

Do indexes work in developer mode?

Are index tables relevant when developer mode is on? If so which ones?
jekabs's user avatar
  • 308
0 votes
1 answer
59 views

Magento2 Indexers constant problem

We sync our products a lot with 3rd parties to update pricing and stock. We also have people editing products daily. This will trigger indexers to run. The indexers can take 5 hours to run on ...
user avatar
0 votes
1 answer
53 views

Magento2: Reset specific indexer by cronjob

Sometimes the indexer catalog_product_category doesn't automatically run when assigning new products to a category, so products aren't displayed at the shop. I've to manually reset this indexer in the ...
Joris's user avatar
  • 43
0 votes
0 answers
260 views

Catalog Inventory Stock Indexer not working

I have an issue with the cataloginventory_stock index. Base table or view already exists: 1050 Table '/cataloginventory_stock_status_outdated' already exists, query was: RENAME TABLE ...
Moin Malek's user avatar