Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

Filter by
Sorted by
Tagged with
9
votes
1answer
7k 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 ...
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
27k 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
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
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 ...
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....
5
votes
3answers
6k 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
3answers
16k 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
2answers
221 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
2answers
902 views

How to 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 ...
5
votes
2answers
572 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....
5
votes
1answer
2k 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
860 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
6k 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
1answer
973 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
459 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
1k 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
2answers
376 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
2answers
1k 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 ...
4
votes
0answers
504 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
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
2answers
4k 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
1answer
2k 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
1k 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
137 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
897 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 ...
3
votes
1answer
136 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
326 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
758 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
5k views

Magento in Xampp server ( localhost ) indexer:reindex

I'm running Magento latest version in my localhost with xampp, it's great. but in admin panel, I see an error One or more indexers are invalid. Make sure your Magento cron job is running. I ...
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
765 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
117 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
61 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
421 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
1answer
746 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
166 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
1answer
17 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 ...
2
votes
1answer
540 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 ...
2
votes
1answer
95 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
144 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
0answers
146 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
0answers
358 views

Magento 2 mview_state mode disabled?

When I check indexer status with php bin/magento indexer:status, I got following result, +--------------------------------------+--------+-----------+-----------------+------------------+ | Title ...
2
votes
2answers
894 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
1answer
359 views

magento2 bin/magento indexer:reindex this command delete the data from catalog_product_index_price

I am uploading products via xls and this is working fine.I am uploading bundle/simple products After that when all process complete. then I run bin/magento indexer:reindex by script for reindexing. ...
2
votes
0answers
78 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): ...