Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged 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 ...
0
votes
1answer
20 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
591 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
25 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 ...
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/...
6
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....
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 ...
2
votes
2answers
659 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 ...
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 ...
4
votes
1answer
72 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 ...
2
votes
0answers
33 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
94 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 Display ...
0
votes
0answers
24 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, ...
1
vote
1answer
823 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?
2
votes
1answer
32 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
30 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
37 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
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
1answer
343 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
8k 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
131 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: ...
0
votes
0answers
35 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
56 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
1answer
280 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....
0
votes
0answers
22 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 ...
2
votes
2answers
257 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
37 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
51 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 ...
3
votes
1answer
109 views

Magento2 Indexer ATTRIBUTES_CHUNK_SIZE

In Magento\Catalog\Model\Indexer\Product\Flat\Action\Indexer there is one constant: /** * Maximum size of attributes chunk */ const ATTRIBUTES_CHUNK_SIZE = 59; reference: https://github.com/...
3
votes
3answers
427 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
2answers
226 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
131 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
1answer
126 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
97 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
48 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
154 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: ...
1
vote
0answers
135 views

Magento 2 mview_state mode disabled?

When I check indexer status with php bin/magento indexer:status, I got following result, +--------------------------------------+--------+-----------+-----------------+------------------+ | Title ...
4
votes
0answers
300 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,...
0
votes
1answer
225 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 ...
7
votes
7answers
24k views

How to make sure your Magento 2.0 cron job is running

How do I make sure my Magento cron job is running? I setup cron per the Magento 2 installation instructions for the log files. See screen shot (click to enlarge): I am running Magento CE 2.0.2 ...
0
votes
1answer
121 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 ...
0
votes
1answer
18 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 ...
1
vote
1answer
155 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 ...
4
votes
2answers
396 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 ...
7
votes
2answers
4k views

Magento 2: How to set cron for reindex in SSH in magento 2?

I want to know how to set cron for reindexing a particular indexer method in Magento 2. I have used below code to reindex all but not working: * * * * * php –f /shell/indexer.php reindexall Can ...
1
vote
1answer
70 views

Use of Indexer.xml in Magento

What is the use of indexer.xml ? I mean what it does? Please help.
3
votes
3answers
2k views

Magento 2 Indexer Allowed memory size of xxxx bytes exhousted

When running the Magento 2 indexer process from the CLI with command: ./magento indexer:reindex customer_grid I get the following error: PHP Fatal error: Allowed memory size of 1073741824 bytes ...
3
votes
1answer
813 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? ...
2
votes
3answers
404 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 ...
1
vote
1answer
50 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 ...