Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged with
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 ...
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
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 ...
7
votes
1answer
6k views

How to create a Custom Indexer?

I'm trying to create a custom indexer for a particular product attribute. I need to: read the product attribute value process it in some way ( not relevant ) save it in a index table The above ...
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 ...
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 ...
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....
5
votes
3answers
12k views

How to stop index process in running

We have currently some process indexing in running. How I can stop this? We tried already some things like: mysql restart, didn't worked as we could not do it mysql kill -9, didn't worked, but we ...
5
votes
3answers
4k 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 ...
5
votes
2answers
219 views

Magerun vs Command line indexer

Is it preferable to run a nightly re-index via the command line or would it be better to run it with Magerun? (Or doesn't it really make a difference)
5
votes
1answer
1k views

Magento 2: How to display error message in CLI

I have an indexer, which needs to be configured first - requires API credentials. When I run in a reindex command in CLI: $ bin/magento indexer:reindex my_reindexer_name and the API credentials are ...
5
votes
1answer
685 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 ...
4
votes
3answers
5k views

MySQL server has gone away when maual reindex catalog_product_flat

In my Magento EE 14.0.1, when I try to reindex catalog_product_flat like this: php indexer.php --reinex catalog_product_flat After serveral minutes, it throws me this error: Product Flat Data index ...
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 ...
4
votes
1answer
849 views

Implementing a custom Magento indexer in an extension

I'm working on adding an additional column to a grid in an existing backend extension. I need to add an indexer to to this extension indexing the health (the amount of sells) of (roughly) the last 3 ...
4
votes
2answers
388 views

Indexer mode Unknown

I am running Magento EE 1.13.1.0 I set all the index options in System=>Configuration=>Advanced=>Index Management to "Update when scheduled". When I run $ php -f indexer.php mode Product Flat Data: ...
4
votes
1answer
962 views

The “Product Prices” and “Product Attributes” index depended on stock index?

I found that on a client server, the stock index run cause a heavy load and slow down the site, so I changed the stock index to manually. After I changed "stock status" index to manually mode, every ...
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 ...
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,...
3
votes
2answers
3k views

Full reindex process is already running

If Magento Enterprise's indexers have crashed or your database has crashed or was dumped during a re-index, you might get stuck with an indexer lock. This lock can only be removed by the MySQL thread ...
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? ...
3
votes
3answers
424 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 ...
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
1answer
126 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 ...
3
votes
1answer
318 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....
3
votes
1answer
275 views

Changing backend_type on attribute leads to indexing problems

I am working with a client that has some very large multi-select lists, large enough that they exceeded the 255 character limit of varchar. After some investigation I found a number of people that ...
3
votes
1answer
51 views

Custom Enumerated Product Attribute Doesn't Get Indexed

I want to create a product attribute where the values are enumerated string codes like "value_1", "value_2", "value_2" so that I can match them cleanly without having to rely on an ID or a user facing ...
2
votes
3answers
748 views

Indexer won't work with SSH

I try to view or reindex the indexer by SSH. I get always the same response: xxxx:/home/www/xxxx/html/shell > php -f indexer.php -- status all X-Powered-By: PHP/5.6.5 Content-type: text/html; ...
2
votes
3answers
2k views

Magento 2 : Impossible to retreive the customer id of the session in an external script

I created an external script test.php inside Magento 2 at the root. But, I don't succeed to retrieve the customer ID of the session in this external script. The script is as follows: <?php ...
2
votes
3answers
2k views

Magento 2.0 with upgraded to php 7.0 Indexer Stuck at processing

With Apache2.4 mariaDB php7.0.2 everything working correctly with php7 extensions except for my products dont display when searched in magento2 Front-end. After checking for anything that could have ...
2
votes
2answers
720 views

indexer from shell not working

i'm working on a magento CE 1.7.0.2 and I have to update indexes from shell. However I'm trying the commands: php -f indexer.php info and also php -f indexer.php -- -reindex catalog_url but they ...
2
votes
1answer
113 views

Custom Indexer, TYPE_MASS_ACTION and TYPE_DELETE

I am building a custom indexer and quick search based on a mysql table with fulltext indices and having some difficulties in understanding the Mage_Index_Model_Event::TYPE_DELETE in conjunction with ...
2
votes
1answer
5k views

Rebuilding catalogsearch_fulltext index stucked [duplicate]

I am trying to rebuild catalogsearch_fulltext index but the process always get stucked in the middle. Normally it was running 3-4 hours but now it did not finish after 19 hours. I already killed the ...
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 ...
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 ...
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 ...
2
votes
1answer
676 views

Trouble reindexing - forgein key constrain fails

I deleted all products by truncating tables. Now, after uploading all products again I get this: Product Attributes index process unknown error: exception 'PDOException' with message '...
2
votes
1answer
145 views

Multiple Server Indexing - Isolate Indexing Process

We run a multi-server magento install. 2 webservers, 1 MySQL server and 1 server for the magento admin. When I am running an indexing process via the command line using the admin server I am noticing ...
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 ...
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 ...
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 ...
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: ...
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 ...
2
votes
0answers
77 views

Prices Index Exception and Currency Multiplied by 10.000 in Adminhtml

I had no problems with the price index of the site, it was always possible reindexes it normally. But now whenever I try to reindex prices, I got this exception: 2015-12-05T18:49:17+00:00 DEBUG (7): ...
2
votes
0answers
100 views

Flag a product to be updated in next scheduled run. Change index status manually

We have some scripts which updates few product attributes directly, I want to set the product to be picked up in the next schedular cron and push it in to solr. Currently the only possible way seems ...
2
votes
0answers
754 views

Product Prices index process unknown error

I am trying to run the indexer for product prices but it keeps erroring out (See Below). My catalog has approx 25,000 simple products and no attributes assigned to them. There are custom attributes ...
2
votes
0answers
2k views

Index Management - Catalog Category Flat Data - Stuck on processing

The Catalog Category Flat Data has been now stuck for weeks and i can't seem to fix it. I tried to change the corresponding table in the database: TRUNCAT catalog_product_flat_1, ...
1
vote
2answers
10k views

Index Management in Magento 2 [duplicate]

Can anyone tell me how does re indexing work in Magento 2. Right now there are two options - Update on save and Update by schedule. But like in Magento 1 there is no option for manual re index. It ...
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 ...