Questions tagged [indexer]
Denotes questions related to the magento's indexer process.
171
questions
0
votes
0
answers
66
views
Magento 2.4.5-p5: Issue with Indexers Causing Prices to Drop to 0 on 800k SKUs
Hello Magento Community,
We're encountering a challenging issue with our Magento 2.4.5-p5 project, where product prices for approximately 7,000 out of our 800,000 SKUs (all configurable products) ...
0
votes
0
answers
11
views
Executing indexes concurrently. Any negatives?
Because reindexing takes so long, I am contemplating running several reindex commands concurrently, via the CLI, see below:
php bin/magento indexer:reindex catalog_category_product & php bin/...
0
votes
0
answers
14
views
Why I am getting error while using n98-magrun2 command "PHP Fatal error: Uncaught TypeError: Magento\ApplicationPerformanceMonitor\Plugin\Applicatio"
I am getting the below error while running the command n98-magerun2 list:
PHP Fatal error: Uncaught TypeError: Magento\ApplicationPerformanceMonitor\Plugin\ApplicationPerformanceMonitor::aroundLaunch(...
0
votes
0
answers
63
views
Catalog Rule Product index in parallel mode
In the Magento 2.4.6 Community Edition project there is an issue. An implementation of the Catalog Price parallel index has almost been done in the issue.
The size of the ...
0
votes
1
answer
43
views
One or more indexers are invalid. Make sure your Magento cron job is running. Can it be fixed from admin panel?
I have a magento 2.4.3 running on a production server. I have the following error message in the admin panel.
Also some of the indexers shows "reindex required". I do not have the SSH ...
0
votes
0
answers
32
views
How can I catch more detailed information about a reindexing error or when reindexing is stuck?
The size of the catalog is about 70k products.
When reindexing sometimes it turns out Could not acquire lock for index:catalog_category_product and Could not acquire lock for index:...
0
votes
1
answer
577
views
How to optimize Magento 2 indexer
I'm having one magento 2 website which contains 1 million products. The website is based on MSI and there are multiple CRON jobs running on hourly basis to do the inventory and price updates. So the ...
0
votes
2
answers
51
views
My site show "We can't find products matching the selection" in category page
I used the command
bin/magento indexer:reindex
and the product appeared. But then it disappeared again and showed the words We can't find products matching the selection on the category page.
Why is ...
0
votes
0
answers
30
views
Can't reindex with LiteMage disabled
I disabled the extension Litespeed_Litemage because I don't need it on my dev environment, but now I get...
Category Products index Abort: LiteMage is not enabled
...when trying to reindex.
0
votes
4
answers
2k
views
Products are not visible at frontend Magento 2
There's two created product each of them is set:
Product Type : Simple
Website : Main Websites
Status : Enabled
Visibility: Catalog, Search
Salable Quantity: >50
I use Magento 2.4.4 Open source ...
0
votes
0
answers
73
views
Get list of product ids which are being indexed when catalog_product_price indexer is executed in 2.4?
Want to get the list of products/SKUs which are being indexed when the following index command is executed?
php bin/magento indexer:reindex catalog_product_price
Looking for any public method or ...
0
votes
1
answer
664
views
Inventory management not automatically changing to 'out of stock' (is there Patches List for Magento 2)
I have faced issue after issue with the Magento 2 software that entails me having to do patch after patch.
My most recent issue is with the inventory feature. I have turned on inventory management, ...
0
votes
1
answer
214
views
Explain meaning of column Schedule Status on the Index Management admin page
There are 2 columns on the Index Management page: Status and Schedule status.
Could you please provide detailed explanation what does each combination of values mean?
For example:
Status
Schedule ...
0
votes
1
answer
485
views
How to set the MAGE_INDEXER_THREADS_COUNT variable in Magento cloud?
In the docs, Magento advises us that we can set the MAGE_INDEXER_THREADS_COUNT environment variable:
run the reindex command using the environment variable MAGE_INDEXER_THREADS_COUNT, or add an ...
0
votes
2
answers
466
views
How Magento validate products in cart for carts price rule and how to extract product from conditions_serialized column of the sale rules table?
I need to create an indexer for cart price rules.
I decided to iterate the values from sales_rules table and extract the products from conditions_serialized coloumn.
My indexer file is like below.i ...
2
votes
1
answer
815
views
Indexer hangs unexpected
problem description
i have a problem on a magento 2.4.5-p1 project.
the problem: sometimes, the indexer has a problem and is hanging. i can run "php bin/mangeto indexer:reindex". then, ...
1
vote
1
answer
443
views
How to create indexer for custom table
I want to create an indexer for my custom EAV entity (for learning purposes only).
I have the following tables:
custom_employee_entity
custom_employee_entity_datetime
custom_employee_entity_decimal
...
0
votes
0
answers
96
views
Magento 2.4.3 Configurable Disappears From Catalog when simple count exceeds 325
One for the Gurus!
I have a configurable with 3 Attributes: Product type, Colour and Height.
When I exceed 325 simple products within the configurable the product will disappear from the category it ...
0
votes
1
answer
191
views
New products not showing in category frontend Magento 2.3.7-p3
Before you dismiss this kindly read the details. I have come across several issues but none provide a solution to my question.
My products do not show in the frontend of the store.
They are visible ...
0
votes
2
answers
651
views
Magento 2 Reindex by Website or Store id
Is there any possibility to run Magento 2 indexer based on Website id. I have tried identifying events for indexer but couldn't find one.
Is there any option to validate website id or run indexer for ...
2
votes
0
answers
444
views
Very slow async bulk import via RabbitMQ
I'm importing products using bulk Magento APIs and RabbitMQ. The problem is that the process is too slow and sometimes it seems that completely stucks.
Magento version is 2.4.2 and RabbitMQ version is ...
0
votes
2
answers
1k
views
How can I remove backlog from indexer programmatically?
I want to remove backlogs from the indexer when I check the indexer:status there I found many backlogs in the indexer.
I need to remove this problematically using corn job at every 2 minutes my cron ...
1
vote
1
answer
369
views
Catalog Search index error After updating Magento 2.4.0 to 2.4.2
When I run php bin/magento indexer:reindex I get the following error message from the Catalog Search indexer:
{"error":{"root_cause":[{"type":"...
0
votes
1
answer
503
views
Magento 2: Error on reindex
I have recently upgrade my instance from Magento 2.3.0 to 2.4.3 and products are not showing on the frontend. When I run php bin/magento indexer:reindex command I get this error:
Any help will be ...
0
votes
0
answers
232
views
Magento 2 - Why do I always have to manually reindex?
I have setup my cronjob and it runs fine. But sometimes we have to manually execute php bin/magento indexer:reindex to manually reindex everything, otherwise new customers are not showing in the ...
0
votes
2
answers
338
views
Schedule indexer programmatically
I have a custom index my_index that observe the change in a custom table entity_data. When changes happen in entity_data, my index's execute function is called by Magento like this $indexer->...
1
vote
0
answers
293
views
Index catalogrule_rule still invalid after reindex by cron
I have an issue with indexes becoming invalid once a day even though nothing has changed (neither in front end or back end). When this happens all other indexes but catalogrule_rule and ...
1
vote
1
answer
117
views
updateAttributes cannot be used to enable a product? (price index not updated)
We are enabling a disabled product with \Magento\Catalog\Model\Product\Action::updateAttributes
$this->productAction->updateAttributes([$magentoProductId], [
'status' => \Magento\Catalog\...
0
votes
0
answers
86
views
Magento 2.4.1: We can't find products matching this selection indexer issue
This error message keeps displaying across the category pages of our Magento 2.4.1 site. Indexer status is below. Not sure what is the cause of this recurrent issue.
1
vote
0
answers
524
views
Magento 2. Indexers sometimes switch(on their own) to Update On Save when configured on Update On Schedule
My issue is simple enough. It reproduced on 2 separated projects.
I have all indexers set on Update on Schedule. Without anyone changing them, I just wake up with them configured with Update On Save.
...
0
votes
0
answers
74
views
Indexing problem 2 different sites on same server. One site breaks other
We are facing a problem with indexing.
There are two magento 2 installations, (diferent hosting, different domains, running different fpm pools with different users , different and independant ...
0
votes
2
answers
1k
views
Error reindexing fulltext search after elasticsearch had been enabled on Nexcess cloud hosting (Magento 2)
I get this error when trying to run the indexer for the search:
php bin/magento indexer:reindex catalogsearch_fulltext
Catalog Search indexer process unknown error:
{"error":{"...
2
votes
1
answer
111
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
1
answer
2k
views
URI is not valid and cannot be converted into a string
I'm struggling with an error that is thrown in the debug.log. The problem is that multiple indexers are not updated allthough the cronjobs are running.
Re-indexing by CLI is working properly on all ...
1
vote
3
answers
5k
views
Getting error on indexing magento2.4
I have just installed magento2.4 with sample data. Setup looks fine from frontend and backend also, but facing 2 issues -
1 - when I run 'indexer:reindex' command, it giving me below issue -
Catalog ...
0
votes
1
answer
500
views
Magento 2 - How to regenerate url_rewrite table?
I truncated the whole url_rewrite table from phpMyAdmin.
I thought that it will regenerate if I execute php bin/magento indexer:reindex but it doesn't.
How can I fix it?
2
votes
0
answers
230
views
Cron 'catalogrule_apply_all' locks cron 'indexer_all_invalid' and catalogsearch_fulltext keeps processing Magento 2.3.5
Took me quite some time to debug this. Every night (default) at 0:00 catalogrule_apply_all is run by cron, and resets all indexes for all store.
As a consequence catalogserach_fulltext is launched (...
2
votes
3
answers
12k
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
1
answer
28
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
2
answers
580
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
1
answer
512
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/...
1
vote
2
answers
1k
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.
1
vote
0
answers
31
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
1
answer
1k
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
1
answer
265
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 ...
4
votes
1
answer
4k
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
1
answer
71
views
Do indexes work in developer mode?
Are index tables relevant when developer mode is on? If so which ones?
0
votes
1
answer
59
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
1
answer
53
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
0
answers
261
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 ...