Questions tagged [indexer]

Denotes questions related to the magento's indexer process.

49 questions with no upvoted or accepted answers
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 ...
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....
4
votes
0answers
363 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
457 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 ...
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
0answers
43 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
94 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
136 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
196 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
735 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
765 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
1answer
32 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 ...
1
vote
0answers
73 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 ...
1
vote
0answers
171 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/...
1
vote
1answer
431 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 ...
1
vote
1answer
129 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....
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 ...
1
vote
0answers
20 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 ...
1
vote
1answer
294 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. ...
1
vote
1answer
853 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?
1
vote
0answers
78 views

Undefined property: Mage_Shell_Compiler::$_factory in indexer.php

Since SUPEE on Magento 1.9.0.1 we see the following error: Notice: Undefined property: Mage_Shell_Compiler::$_factory in /shell/indexer.php on line 45 Question: Did someone come across this error ...
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/...
1
vote
1answer
56 views

How can I require reindexing in magento backend

I made a custom module and I want the user to be prompted to reindex a certain index table. How can I show this prompt progmatically?
1
vote
0answers
2k views

Fix error “There was a problem with reindexing process.” or “Cannot initialize the indexer process.”

I am having an issue reindexing my content in Magento. Both Product Flat Data and Product Category Data need to be re-indexed and it won't index for me. I have tried deleting all content in /var/...
0
votes
0answers
23 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
1answer
15 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
1answer
23 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
19 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
25 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 ...
0
votes
0answers
31 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 ...
0
votes
0answers
33 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, ...
0
votes
0answers
36 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 ...
0
votes
1answer
67 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
26 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
321 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
166 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
146 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
158 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
31 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 ...
0
votes
1answer
56 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 ...
0
votes
0answers
216 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
211 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: ...
0
votes
1answer
69 views

Product attributes not loading in home page. Maybe Permissions? I really don't know

I was trying to reboot the index with the shell/indexer.php script (because my new categories are not displaying on my megamenu) and after using this script my products are not showing some custom ...
0
votes
0answers
29 views

Accessing index from extension

I've made an extension with a single adminhtml page, added an index table for it in the installer and added an indexing model to the extension's configuration. How do I implement this model and ...
0
votes
1answer
175 views

Problem with reindex catalog_product_prices

Having a problem with reindexing catalog_product_prices. I get the following error message: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an ...
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....