2022 Developer Survey is open! Take survey.

Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged with
0 votes
2 answers
42 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 ...
user avatar
0 votes
0 answers
10 views

Magento 2.3.x Indexer | x in backlog

Good day, today i discovered that my indexers are going into backlog. After a quick google search an noumerous questions regarding this i tried basically all of them with no luck. My indexers are ...
user avatar
0 votes
0 answers
26 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 ...
user avatar
  • 1
0 votes
0 answers
61 views

Magento 2.4: Custom indexer not working

On running sudo php bin/magento indexer:reindex vsbridge_banners_promotion_indexer it show's error configuration was not found. Elastic search version 7.16.2 and vue store configuration are done from ...
user avatar
0 votes
0 answers
12 views

Magento 2.4 sorting issue due to pricing by some additional attributes

We have a site where we have to sort products by price to display in collection. But there are few attributes that too are considered while calculation final price and even on listing we want to show ...
user avatar
0 votes
0 answers
13 views

Why aren't Magento sale grids using Mview (and indexer)?

By default Magento implement Mview/indexer for some grids for example customer grid. But for sale grids (sale, invoice, credit memo, shipment) Magento use a cron job to insert/update new data (if ...
user avatar
0 votes
2 answers
136 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 ...
user avatar
1 vote
1 answer
101 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":"...
user avatar
0 votes
1 answer
43 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 ...
user avatar
0 votes
0 answers
58 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 ...
user avatar
  • 2,402
0 votes
2 answers
100 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->...
user avatar
1 vote
0 answers
111 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 ...
user avatar
1 vote
1 answer
96 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\...
user avatar
  • 14.6k
0 votes
0 answers
67 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.
user avatar
1 vote
0 answers
154 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. ...
user avatar
0 votes
0 answers
38 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 ...
user avatar
0 votes
2 answers
643 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":{"...
user avatar
  • 325
2 votes
1 answer
47 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 ...
user avatar
2 votes
1 answer
1k 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 ...
user avatar
1 vote
3 answers
2k 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 ...
user avatar
  • 885
0 votes
1 answer
194 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?
user avatar
  • 2,402
2 votes
0 answers
159 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 (...
user avatar
  • 36
2 votes
3 answers
6k 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 ...
user avatar
0 votes
1 answer
22 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 ...
user avatar
  • 1,175
0 votes
2 answers
178 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 ...
user avatar
0 votes
1 answer
309 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/...
user avatar
  • 322
0 votes
2 answers
490 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.
user avatar
  • 29
1 vote
0 answers
30 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 ...
user avatar
  • 1,280
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 /...
user avatar
0 votes
1 answer
225 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 ...
user avatar
4 votes
1 answer
2k 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 ...
user avatar
1 vote
1 answer
39 views

Do indexes work in developer mode?

Are index tables relevant when developer mode is on? If so which ones?
user avatar
  • 158
0 votes
1 answer
49 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
37 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 ...
user avatar
  • 43
0 votes
0 answers
181 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 ...
user avatar
0 votes
1 answer
82 views

Data from the default shipping address in customer grid

Magento OOTB is displaying data from default billing address in customer grid. I need data from default shipping address instead of billing. I made changes in indexer.xml <?xml version="1.0"?> &...
user avatar
0 votes
1 answer
271 views

Found a potential bottle neck when reindexing prices in 2.3.2

I have a total of 7193 products in the catalog. 6704 simple and 489 configurable. When reindexing, Magento iterates trough all price indexers and process them. I added some debug messages and found ...
user avatar
  • 1
0 votes
1 answer
689 views

New products don't get Salable Quantity update until reindexed manually

I have an issue with my Magento 2.3.2 store where a new product, after it is created, never gets Salable Quantity updated until we manually go in and reindex at the command line. It stays at Default ...
user avatar
  • 669
1 vote
1 answer
81 views

Magento 2 - indexer error after data migration magento 1.9.1.1 to 2.3.2

I'm trying to migrate data to magento 2 using the data migration tool, the migration goes fine but the indexor crash during catalog_product_price index with the error : SQLSTATE[42000]: Syntax ...
user avatar
0 votes
0 answers
86 views

How to change indexer mode from "update on save "to "update by schedule" from database or script Magento 2?

In Magento 2 admin panel I want to change indexer mode from update on save to update by schedule but I can not change it from the admin because it continues to loading nothing changes on any product ...
user avatar
3 votes
1 answer
339 views

How do I decide a value for MAGE_INDEXER_THREADS_COUNT?

Can anyone suggest to me how to decide a value for MAGE_INDEXER_THREADS_COUNT? I am managing a website that has 5 websites, 10 stores, 6 customer groups. I know adding this environment variable can ...
user avatar
2 votes
1 answer
2k views

There are no commands defined in the "indexer" namespace. php 7.2 (ubuntu)

When i want to re Index in Magento2 in php version of 7.3, this display me this error An exception was raised while creating "Request"; no instance returned And when i change to version 7.2 ...
user avatar
4 votes
2 answers
820 views

Magento 2.3 - Category Products indexer takes so much time although I have little products

I have just installed Magento 2 a few days ago. And suddenly when I try to reindex manually I noticed that the Category Products indexer takes much time. more than 8 mins And I've got this exception ...
user avatar
  • 129
1 vote
1 answer
202 views

How to call Magento2 mview reindexer programmatically

I have line of code which schedule full or partial reindex cron job. using Trigger::REINDEX_SCOPE_PARTIAL and Trigger::REINDEX_SCOPE_FULL parameter. public function restoreIndexers($reindex = false, ...
user avatar
  • 3,036
2 votes
1 answer
160 views

How to trigger an index for a configurable if the simple price index was changed

I made a pull request enter link description here for an the ElasticSuite module to make a discount of configurables flag dependent on simples. Now of course the configurable has to be reindexed if ...
user avatar
  • 14.6k
0 votes
2 answers
38 views

Is going to reindex automatically?

If I build a module with a indexer, is Magento going to run the reindex automatically each night or do I need to create a cronjob for it?
user avatar
  • 322
1 vote
1 answer
179 views

Calculate attribute value in indexer or cron?

This is my observer and its updating my custom attribute every time when I save attributes on catalog_product_attribute_update_before event. namespace MyVendor\MyModule\Observer; class ...
user avatar
  • 1,638
0 votes
0 answers
124 views

magento 2 not reindexing two indexers - Catalog Product Rule and Product Categories

i try to Reindexing Using this command :bin/magento indexer:reindex It says it's updated all the indexers but when i return to index management in the admin these two indexers (Catalog Product Rule ...
user avatar
  • 3
2 votes
0 answers
201 views

Magento2 - Indexing / Full page cache problems

We are having long-term problems with indexer and cache settings. After reading great guide by @johnhughes1984 about caching and indexing we thought that everything will be alright with settings ...
user avatar
  • 21
4 votes
2 answers
2k views

Reindex stuck at processing even after resetting in Magento 2

My indexer:reindex process for Design config grid, Customer Grid, and Catalog Search always stuck at processing: i already reset the indexer, but when i run indexer:reindex again, it stucks at ...
user avatar
  • 1,474