Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged with
2
votes
2answers
851 views

Catalog Search reindex not completing

I have imported ~17k products, and when reindexing the catalogsearch_fulltext index does not complete. I have tried resetting and reindexing with php bin/magento indexer:reset catalogsearch_fulltext ...
4
votes
2answers
973 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 ...
5
votes
3answers
5k views

Can I completely disable an indexer?

I have a situation where I'd like to completely disable one of Magento's core indexers (cataloginventory_stock). I don't want this index to ever be rebuilt, maintained or altered in any way. Is it ...
1
vote
0answers
20 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 (...
0
votes
2answers
100 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 ...
0
votes
2answers
1k views

How to Trigger Stock Status Index?

We're using Mass Product Update in the admin, however, this doesn't trigger stock status. I can use observer once catalog_product_attribute_update_before is called, and manually trigger indexer there....
0
votes
0answers
17 views

What indexer_update_all_views cron job doing?

What is the difference between indexer_update_all_views cron job and executing php bin/magento indexer:reindex by myself? I dont't know why the indexer_update_all_views cron job give me this error: ...
0
votes
0answers
19 views

Catalog Product Price indexing issue

I am trying to run the catalog product price indexer which is failing with this error. Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '725074-0-...
1
vote
1answer
888 views

Unable to set up cron job on GoDaddy hosting

I am trying to set up my indexer using GoDaddy hosting with cPanel. The indexer is not refreshed and asks me to check that the cron job is running. How do I set up the cron job?
0
votes
0answers
5 views

How to monitor something(e.go customer points) by using a custom indexer

I've created a custom module (magento 2 commerce version) which is going to index all customer points into a custom flat table, but i don't know to implement the the followings: 1) when customer's ...
0
votes
1answer
12 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 ...
1
vote
1answer
302 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 ...
0
votes
0answers
11 views

Indexer with custom cron_group

We have created a new custom indexer as per requirement. And now we need to schedule that indexer with custom cron_group which can be scheduled according to business. We don't want to schedule with ...
8
votes
2answers
1k views

enterprise_refresh_index Sleeping MySQL Connection

There are times that the indexer that is ran by cron seems to get stuck at the MySQL as Sleeping connections can be seen. Indexer runs for several hours and this actually not running at all. I've ...
7
votes
2answers
2k views

Custom indexer on Magento2

I'm trying to create a custom indexer on Magento2. I defined a mview.xml and one indexer.xml as follows: indexer.xml: <?xml version="1.0" encoding="UTF-8"?> <config xmlns:xsi="http://www....
0
votes
1answer
35 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 ...
1
vote
2answers
1k views

Couldn't reindex stock of one item programmatically

I'm trying to reindex one product only programmatically: $product = Mage::getModel('catalog/product')->load($_productId); $product->setForceReindexRequired(true); Mage::getSingleton('index/...
0
votes
0answers
22 views

How to relate an entity type to an entity_id within an indexer's mview changelog?

I am trying to contribute to some performance enhancements on the indexing of my website. I'm having an issue knowing which entity types are being referred to in the changelog (*_cl) tables. As a ...
0
votes
0answers
9 views

Update on Schedule execute indexer multiple time

I have created a custom indexer in my project and configured it to work on 'Update on Schedule'. It is working fine but I have observed, it is executed multiple times even if there is no change in the ...
0
votes
1answer
73 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/...
1
vote
1answer
3k views

Magento 2 Reindex failed on customer grid

Magento 2 (Version 2.1.6) shows allways 2 or 3 Indexes with the processing state - and it never ends. It stays for days under processing. After a php bin/magento indexer:reset all the indexes are out ...
0
votes
2answers
48 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.
0
votes
0answers
134 views

Magento 2.3.3 - scconnector_google_remove_cl and scconnector_google_feed_cl error occur while indexing

I ran indexer:reindex command and got these errors Table status for scconnector_google_remove_cl is incorrect. Can`t fetch version id. And Table status for scconnector_google_feed_cl is incorrect. ...
1
vote
0answers
23 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 ...
0
votes
1answer
170 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 /...
0
votes
1answer
79 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 ...
5
votes
2answers
530 views

Multi select attribute not indexing CE 2.6.1

I migrated my site from 1.9x to 2.6.1. I have at least 2 multi select attributes that are not being indexed to catalog_product_index_eav. In researching this issue, I found that if the eav_attribute....
0
votes
0answers
28 views

Stop Magento Indexer while product Import running

My magento version is 2.3.2 We are using Firegento/FastSimpleImport 2 extension for product Import. It is working fine.We have around 9,000 Products and 8 country stores. Our process is we need to ...
0
votes
1answer
230 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 ...
1
vote
1answer
26 views

Do indexes work in developer mode?

Are index tables relevant when developer mode is on? If so which ones?
0
votes
1answer
21 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 ...
0
votes
2answers
473 views

Magento2: Asymmetric transaction rollback

Sometimes I found in log file issue: Ran jobs by schedule. string(32) "Asymmetric transaction rollback." Ran jobs by schedule. Ran jobs by schedule. Ran jobs by schedule. Anyone know how it is and ...
4
votes
2answers
310 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
55 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 ...
0
votes
1answer
32 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"?> &...
0
votes
1answer
94 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 ...
1
vote
1answer
49 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 ...
0
votes
2answers
910 views

Index Management - Process taking a long time

I have an issue with my Index Management job stuck in "Processing". I have read about it and found out that I can check if the reindex process is running by checking in MySQL, which I did. It is ...
0
votes
0answers
35 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 ...
8
votes
6answers
8k views

cronjob: How to reindex only what is needed

We got a server which has 5 separately shops on it. Some are practically inactive. Some are daily active. To decrease the server load. We changed the index from automatic to manual. Then we set a ...
2
votes
0answers
78 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 ...
1
vote
1answer
529 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 ...
1
vote
0answers
63 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, ...
2
votes
1answer
55 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 ...
0
votes
2answers
36 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?
1
vote
1answer
89 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 ...
1
vote
1answer
585 views

Catalog Search indexer process unknown error: SQLSTATE[HY000]: General error: 1813

**Catalog** **Search indexer** process unknown error: SQLSTATE[HY000]: General error: 1813 Tablespace for table '`mydb`.`catalogsearch_fulltext_scope1_tmp`' exists. Please DISCARD the tablespace ...
7
votes
2answers
9k views

Magento CE 2.0 Index Management Always Processing

How to fix Magento 2.0 Index Management stuck at processing state? There's no var/lock to delete inside Magento 2 root directory, so old ways to fix this are obsolete. Forcing with these new CLI ...
2
votes
0answers
143 views

Magento Indexer Bug in 1.9.4.0

currently i have a bug(?) in Magento CE1.9.4.0 - where i just upgraded from 1.9.3.4. My problem is that the indexer is not able to lock files. I created a simple php file to reproduce the error: ...