Questions tagged [indexer]
Denotes questions related to the magento's indexer process.
168
questions
0
votes
1
answer
29
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
9
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:...
- 749
0
votes
1
answer
89
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 ...
- 41
0
votes
2
answers
43
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 ...
- 1
0
votes
0
answers
15
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.
- 3,100
0
votes
4
answers
674
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 ...
- 1
0
votes
0
answers
26
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 ...
- 3,914
0
votes
1
answer
298
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, ...
- 1
0
votes
1
answer
71
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 ...
- 370
0
votes
0
answers
122
views
Create custom indexer on custom table Magento2
I am going to have a custom table with over 1000 products, I saw that the best way (other option is to load all 1000 records on cache, no thanks) is to create a indexer for my custom table.
The issue ...
- 73
0
votes
1
answer
301
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 ...
- 43
0
votes
2
answers
254
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,671
2
votes
1
answer
544
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, ...
- 310
1
vote
1
answer
300
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
...
- 116
0
votes
0
answers
89
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 ...
- 41
0
votes
1
answer
155
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 ...
- 1
0
votes
2
answers
452
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 ...
- 71
1
vote
0
answers
342
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 ...
- 11
0
votes
2
answers
830
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 ...
- 501
1
vote
1
answer
324
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
385
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 ...
- 350
0
votes
0
answers
188
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 ...
- 3,100
0
votes
2
answers
288
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->...
- 184
1
vote
0
answers
270
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 ...
- 121
1
vote
1
answer
112
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\...
- 13.7k
0
votes
0
answers
85
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.
- 686
1
vote
1
answer
441
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.
...
- 3,460
0
votes
0
answers
59
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":{"...
- 327
2
votes
1
answer
97
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 ...
- 21
1
vote
3
answers
4k
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 ...
- 895
0
votes
1
answer
451
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?
- 3,100
2
votes
0
answers
223
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 (...
- 46
2
votes
3
answers
10k
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
27
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 ...
- 1,308
0
votes
2
answers
504
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 ...
- 49
0
votes
1
answer
474
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/...
- 322
0
votes
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.
- 79
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 ...
- 1,462
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 /...
- 85
0
votes
1
answer
262
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
3k
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
59
views
Do indexes work in developer mode?
Are index tables relevant when developer mode is on? If so which ones?
- 188
0
votes
1
answer
58
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 ...
user44406
0
votes
1
answer
52
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 ...
- 43
0
votes
0
answers
248
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 ...
- 934
0
votes
1
answer
112
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"?>
&...
- 371
0
votes
1
answer
334
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 ...
- 1
0
votes
1
answer
1k
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 ...
- 699