Questions tagged [indexer]
Denotes questions related to the magento's indexer process.
142
questions
0
votes
1answer
34 views
How to Solve: “Could not acquire lock for cron job: X” in Magento var/log/cron.log
With my M2 instance indexers in "Update on Schedule" mode... var/log/cron.log receives this warning near constantly:
Could not acquire lock for cron job: indexer_update_all_views [] []
The cron ...
0
votes
0answers
11 views
What indexer_update_all_views cron job doing?
What is the difference between indexer_update_all_views cron job and executing php bin/magento indexer:reindex by myself?
I dont't know why the indexer_update_all_views cron job give me this error:
...
0
votes
0answers
18 views
Catalog Product Price indexing issue
I am trying to run the catalog product price indexer which is failing with this error.
Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '725074-0-...
0
votes
0answers
5 views
How to monitor something(e.go customer points) by using a custom indexer
I've created a custom module (magento 2 commerce version) which is going to index all customer points into a custom flat table, but i don't know to implement the the followings:
1) when customer's ...
0
votes
1answer
10 views
Indexer catalogrule_rule is set to invalid and causes the cache to be flushed a lot
I'm having a slowness issue on my client cloud instance.
Indexer catalogrule_rule is set to invalid and flush the caches a lot so the site is always slow even when we have the Miravit cache warmer ...
0
votes
0answers
10 views
Indexer with custom cron_group
We have created a new custom indexer as per requirement. And now we need to schedule that indexer with custom cron_group which can be scheduled according to business. We don't want to schedule with ...
0
votes
0answers
18 views
How to relate an entity type to an entity_id within an indexer's mview changelog?
I am trying to contribute to some performance enhancements on the indexing of my website. I'm having an issue knowing which entity types are being referred to in the changelog (*_cl) tables.
As a ...
0
votes
0answers
9 views
Update on Schedule execute indexer multiple time
I have created a custom indexer in my project and configured it to work on 'Update on Schedule'. It is working fine but I have observed, it is executed multiple times even if there is no change in the ...
0
votes
1answer
34 views
Magento 2.3 reindex design_config_grid stucks on processing
design_config_grid and customer_grid stuck on processing when I use bin/magento indexer:reindex. Even after bin/magento indexer:reset and changing status to Invalid, when I reindex again, they stuck ...
0
votes
1answer
64 views
Undefined index: type_id - Catalog Search indexer
Installed Smile-sa elasticSuite for Magento 2.3.3 and when indexing it gives this error:
Catalog Search indexer process unknown error:
Notice: Undefined index: type_id in /srv/html/src/vendor/smile/...
0
votes
2answers
44 views
Magento 2 Which Index should set “Index By Schedule” or “Update On Save” for performance purpose?
I have a site with Magento 2.3.3 version with over 10000 catalog products.
For performance purposes which Indexer should set "Update on Save" or "Update On Schedule".
Thank You.
0
votes
0answers
103 views
Magento 2.3.3 - scconnector_google_remove_cl and scconnector_google_feed_cl error occur while indexing
I ran indexer:reindex command and got these errors
Table status for scconnector_google_remove_cl is incorrect. Can`t fetch version id.
And
Table status for scconnector_google_feed_cl is incorrect. ...
1
vote
0answers
23 views
Flat catalog tables considered a bad practice since M2.1.x and above? [duplicate]
Magento no longer recommends the use of a flat catalog as a best practice. Continued use of this feature is known to cause performance degradation and other indexing issues. A detailed description and ...
0
votes
1answer
141 views
Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory .Magento 1.9 indexing error
I have installed Magento 1.9 but when I am trying to run indexer command
I am getting following errors.
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /...
0
votes
0answers
25 views
Stop Magento Indexer while product Import running
My magento version is 2.3.2
We are using Firegento/FastSimpleImport 2 extension for product Import. It is working fine.We have around 9,000 Products and 8 country stores. Our process is we need to ...
0
votes
1answer
69 views
2.3.3 Unable to Reindex Catalog Search: 'index catalogsearch_fulltext_scope1: does not support DELETE'
I have migrated from Magento1.9 to Magento2.3.3.
When running the reindexer command I got the following error:
index catalogsearch_fulltext_scope1: does not support DELETE (enabled=0) [ DELETE FROM ...
1
vote
1answer
259 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 ...
1
vote
1answer
26 views
Do indexes work in developer mode?
Are index tables relevant when developer mode is on? If so which ones?
0
votes
1answer
21 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
26 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
49 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
29 views
Data from the default shipping address in customer grid
Magento OOTB is displaying data from default billing address in customer grid. I need data from default shipping address instead of billing. I made changes in indexer.xml
<?xml version="1.0"?>
&...
0
votes
1answer
83 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
1answer
207 views
New products don't get Salable Quantity update until reindexed manually
I have an issue with my Magento 2.3.2 store where a new product, after it is created, never gets Salable Quantity updated until we manually go in and reindex at the command line. It stays at Default ...
1
vote
1answer
49 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
0answers
34 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 ...
2
votes
0answers
69 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
496 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
...
4
votes
2answers
286 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 ...
1
vote
0answers
59 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, ...
2
votes
1answer
53 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
36 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?
1
vote
1answer
84 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
55 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
128 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 ...
4
votes
2answers
901 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
167 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
109 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
2answers
523 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
366 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
143 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
306 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
331 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
1answer
225 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
2answers
457 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 ...
2
votes
0answers
310 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
325 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
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 ...
0
votes
1answer
21 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
469 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,...
