Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

2
votes
1answer
26 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
25 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?
0
votes
1answer
29 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 ...
0
votes
0answers
33 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 ...
2
votes
0answers
38 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 ...
1
vote
2answers
95 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 ...
1
vote
0answers
18 views

Magento 2.2 any issue will arise if we truncate import export history?

If I truncate import_history table from database in Magento 2.2 version. But thing is that some of the values in execution_time column it's showing as In Progress which seems to that product import ...
0
votes
1answer
43 views

Magento 2 localhost wamp cron jobs

I'm still getting the error on my admin page "One or more indexers are invalid. Make sure your Magento cron job is running" All field indexes rebuild successfully apart from Catalog Search. I'm using ...
0
votes
0answers
19 views

Extend Catalog Search Indexer

I would like to extend catalog search indexing by adding some own values to the fulltext index. I am researching the magento catalog indexer a while now and do not find a good entry point to change ...
0
votes
2answers
133 views

Magento 2 error : Command “indexer:reindex” is not defined

System : Ubuntu 18 Application : Magento2.3 PHP : 7.1 I have two indexer need to be reindex. I have update the indexer on the admin page but it is not work. I also use the following command on the ...
0
votes
1answer
71 views

Magento 2.3 - event when catalog price rules are applied

I am working in a module which extends catalogrule feature In this module, we apply some changes to price calculation process. Right now, it is working when a product is saved in admin. We have ...
2
votes
0answers
117 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: ...
2
votes
1answer
102 views

Remove trigger creation when changing an indexer mode

I've disabled the Magento_Bundle module because I don't need it. But now when I try to set the catalogsearch_fulltext index to schedule via cli: php bin/magento indexer:set-mode schedule ...
1
vote
0answers
55 views

Magento 2 custom indexer - How to execute related indexers

i have a custom módule with his own indexer. I need that when i execute it (indexer:reindex custom_index), some indexes runs after. There is an example with the "catalogrule_rule" indexer. bin/...
0
votes
0answers
26 views

Why “catalog_product_price” indexing is required while importing new products with tags Magento 1.9

I have to reindex catalog_product_price when I import products which have new tags. We have managed to create the tags if they are not in the system. We have created an observer which fires after ...
0
votes
1answer
125 views

Catalogue Search Indexer Unknown Error

I'm having problems getting the Catalog Search indexer to complete. All other indexers are fine. Here's the exact error taking from shell Catalog Search indexer process unknown error: Notice: ...
0
votes
1answer
177 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 ...
1
vote
0answers
96 views

Magento 2 mview_state mode disabled?

When I check indexer status with php bin/magento indexer:status, I got following result, +--------------------------------------+--------+-----------+-----------------+------------------+ | Title ...
0
votes
1answer
96 views

Category Flat Data indexer process unknown error Magento 2

We are getting Integrity constraint violation: 1062 error when we are going to reindex in magento 2. Kindly see the error below and let me know if any update Category Flat Data indexer process ...
3
votes
3answers
314 views

Custom REST API endpoint - Consumer is not authorized to access %resources - Magento_Indexer::Indexer

I'm trying to expose the getLatestUpdated() method of the Indexer class through the REST API. The endpoint is getting an auth token and all that - I can use protected endpoints no problem. What ...
0
votes
1answer
16 views

Where does magento get the value of the “updated” column to display in adminhtml->system->index mgm?

The dates shown on the index management adminhtml page are not the same as what can be found in the table: indexer_state.updated. I cannot seem to track down the dates this grid is pulling. I am ...
4
votes
0answers
246 views

Magento 2.2.5 - Categories are not getting saved in the database

In my Magento 2.2.5 Store, When I try to edit the existing categories content and press the save button, the categories content stays the same, there is no change being reflected in the admin panel,...
1
vote
1answer
115 views

Product EAV Index never finishes processing

For some reason my Product EAV index never finishes... Well I have left for over two days and it still says Processing... I have 42,000 products in my catalog and 92 attributes. Is this normal? How ...
2
votes
2answers
288 views

Add the MAGE_INDEXER_THREADS_COUNT environment variable to env.php

In Magento 2.2.6 you can take advantage of Multi-threading for the indexers as stated in release notes here: https://devdocs.magento.com/guides/v2.2/release-notes/ReleaseNotes2.2.6EE.html This ...
1
vote
1answer
58 views

Use of Indexer.xml in Magento

What is the use of indexer.xml ? I mean what it does? Please help.
1
vote
1answer
233 views

I am getting error running this command php bin/magento indexer:reindex

I am getting this error while running this command.php bin/magento indexer:reindex here is the error PHP Fatal error: Uncaught Error: Class 'DOMDocument' not found in /opt/lampp/htdocs/magento2.2....
2
votes
1answer
593 views

M2.2.5 : Can someone explain the role / functionality of the various tables used by the indexing process?

I've read the documentation about indexing in Magento 2, but it's very much on the surface. What I am wondering is how do the internals of the indexing mechanism work. Can somebody explain this to me? ...
1
vote
1answer
44 views

Cleaning Changelog tables - Cron Enterprise_Index scheduledCleanup issue

Our instance is throwing an error on this cronjob PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' The code is pulling empty table ...
2
votes
3answers
351 views

Improve performance - Catalog Search Fulltext

Do you have some suggestion how can I improve the performance of the catalogsearch_fulltext indexer for Magento 2.1.X I already set this indexer to 'Update By Schedule' so only the updated products ...
0
votes
1answer
143 views

How to remove indexer error? Requested store not found? in Magento 2.2.3

The following error comes after re-indexing in first two lines Requested store is not found How can I fix this error?
0
votes
1answer
206 views

Magento 2.1.7 Product EAV Reindexer issue

I am very new to magento and am finding it ok to use (after overcomming a lot of issues it has) however i am now at one spot cdwhere i cant seem to resolved an issue i have with the Product EAV ...
0
votes
2answers
479 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
1answer
29 views

Crons not reindexing the indexer after setting all

I checked the crontab and it is showing me the correct entries. link I checked the cron_schedule table and it is creating and scheduling indexers. link I checked the bin/magento indexer:status and it ...
1
vote
2answers
585 views

Does the magento 1.9 schedule start reindexing?

Our customer uses a tool for importing products. This tool does not trigger reindexing on save. When I look at the indexing modes of Magento 1.9 indexers I see real_time and manual. Is there a way ...
4
votes
1answer
636 views

Magento 2: Is there a way to lock indexer programmatically?

When I run my custom import script, and during it's execution starts reindex, it causes the error : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try ...
0
votes
1answer
307 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 ...
3
votes
1answer
117 views

Indexers are locked automatically: what makes indexers to be locked in Magento 2?

What makes indexers to be locked in Magento 2? What are use cases make the indexers to be locked? In some cases the indexers are locked automatically, how can we stop this indexers to be locked, what ...
1
vote
1answer
1k views

Magento 2 : Indexing for large database is taking so much time

I have imported more than 250000 of products for two stores. I am trying to indexing those products but it is taking long time through SSH.Indexing Taking so much time and then after indexer lock. If ...
0
votes
1answer
734 views

Magento 2 - Cannot reindex Catalog rule product and catalog product rule

I get the following error when I try to reindex when I check index status... Design Config Grid: Ready Customer Grid: Ready ...
1
vote
1answer
121 views

Magento 2 index management system error message

I installed magento 2.1.9 on my shared hosting account. A system error message appears within the admin panel that states: "One or more indexers are invalid. Make sure your Magento cron job is running....
0
votes
1answer
110 views

Indexer, Reindex ALL Magento2

New to Magento2, I am trying to use the Indexer to reindexAll. I tried with the objectManager, without success. Sample : $indexer = $this->objectManager->create('Magento\Indexer\Model\...
2
votes
2answers
622 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 ...
0
votes
1answer
53 views

MAGENTO 2 System error after first install

It is my first time that I tried to install magento and I followed the tutorial at the following link: https://medium.com/@purvirawal.work/magento-2-installation-on-mac-os-f78981ecea92 However, I ...
1
vote
1answer
53 views

Cron executed successfully but product is not getting updated

I setup the cronjob in Magento 2.1.7 but I got an unexpected result. All the indexer were updated except Product category an Category product when I add a new product. Check in the cron_schedule ...
1
vote
1answer
965 views

Magento 2.1.8 Reindex Timeout

We have a Magento store that we upgraded to 2.1.8 last week. Everything seemed to be working well till then. However, after the update, I am no longer able to re-index Category Products and Product ...
1
vote
1answer
2k 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 ...
3
votes
1answer
280 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....
1
vote
0answers
19 views

Magento1 change-logs cleanup

I've end up having the following query: SELECT entity_id, count(version_id) as number_of_versions, max(version_id) as max_version FROM catalog_product_flat_cl GROUP BY entity_id ORDER BY ...
0
votes
0answers
173 views

Indexer query error empty values

When I run the indexer I get the following error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; This is caused by the following: LEFT JOIN ...
0
votes
2answers
197 views

Cron job issue with indexing

I have set cron for indexing issue. but i have got error in mail. /home/ltfab/public_html/shell/indexer.php: line 1: ?php: No such file or directory /home/ltfab/public_html/shell/indexer.php: line 2: ...