All Questions
74 questions
0
votes
1
answer
319
views
Magento keeps creating multiple indexes in Elasticsearch
I have a couple Magento stores, and have them hooked up to an Elasticsearch server. On just one of the stores, it seems to regularly create new index names every day, which leads to overage issues ...
- 41
1
vote
0
answers
323
views
mui/index/render loading slow, index reindex when I navigate pages in admin
A store we look after is experiencing odd behaviour recently.
The admin dashboard is very slow and from what I can figure out, the indexes seem to reindex whenever you navigate to a different page. ...
- 131
0
votes
1
answer
292
views
How do I check the progress of a reindex with status 'processing'?
I am running the following command
php -d memory_limit=-1 bin/magento indexer:reindex foo
When running it on my table, my terminal goes haywire showing the following:
Memory used: 706M
Memory used: ...
- 101
0
votes
2
answers
539
views
After upgrading to magento 2.4.3-p1 catalog search not working
Elasticsearch 7 is used and all the configuration setting are as same
as given on devdoc.
Elasticsearch connection is also returning Succesfull
When searching any of the product it does not display ...
- 1,347
0
votes
1
answer
187
views
What are recommended Re-index settings?
What are the recommended re-index settings? We run a store that has around 8,000 SKUs and is connected to a Warehouse Management System which processes our Amazon orders as well.
Currently we have ...
0
votes
2
answers
769
views
Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2
Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2. How it works and what are files called to index the products.
- 358
0
votes
4
answers
4k
views
How to re-index only one product in Magento 2?
I have added the product using REST API in Magento 2 I want to re-index only one inserted product not fully reindex just one that inserted product.
How to do that ?
Any help is appriciated.
- 623
0
votes
1
answer
955
views
Getting error on re indexing in Magento 2.4 after change batch size
I have change the Batch size for Magento 2.4
var/www/html/Mag/app/code/Reg/Indexer/etc/adminhtml/di.xml
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/...
- 623
1
vote
1
answer
1k
views
Table in MySQL to show product data in Magento 2 after reindexing process
I want to know about those MYSQL tables which is used to fetch data for Front-end Products in Magento 2 after re-indexing process.
Like which table will be used after re-indexing process to show ...
- 623
2
votes
1
answer
5k
views
How to check indexer reindex progress in Magento 2?
I have 60 million products in my Magento 2 Store and i have run php bin/magento indexer:reindex query using terminal.
Now the issue is that the indexer running from around 100 hours but it will show ...
- 623
0
votes
1
answer
2k
views
Indexer Re-index goes to suspend in Magento 2?
I have 60 million products in my magento 2 store.
I have started indexer:reindex so it will struck on catalog_category_product it shows processing in this and on schedule status it shows suspended in ...
- 623
0
votes
2
answers
758
views
indexer:reindex not running in Magento 2
I have 60 million product in my Magento 2 Store.
On running sudo php bin/magento indexer:reindex it will run successfull for only 2 the don't know why it doesn't show any error.
Any it will not ...
- 623
0
votes
1
answer
703
views
I have 60 Million product in my Magento 2 but indexer:redindex not working
I have 60 Millions products in my Magento 2 Store.
But when i run bin/magento indexer:reindex command.
It is struck on Category Product Index.
When i check on backend it is stuck here.
[
3
votes
4
answers
5k
views
Magento 2 Setup:Upgrade giving error of Cannot add foreign key constraint
I have moved my website files and DB from one server to another.
Now, When I am running setup:upgrade command. I am getting below error:
Updating modules:
Schema creation/updates:
SQLSTATE[HY000]: ...
- 749
2
votes
1
answer
3k
views
Notice: Undefined index: default in vendor/magento/module-catalog/......BatchSizeCalculator.php
I got this error when try to reindex catalog_product_price
php bin/magento indexer:reindex catalog_product_price
Notice: Undefined index: default in
/public_html/vendor/magento/module-catalog/...
- 990
2
votes
1
answer
924
views
Magento 2 Reindex error: snapshot in progress
I'm using Magento 2.3 with cloud ElasticSearch and sometimes reindex cron gives the following error
[2019-09-18 19:24:13] main.ERROR: Cron Job indexer_reindex_all_invalid has an error: {"error":{"...
- 399
0
votes
1
answer
597
views
Advice about index stuck
I have not seen this case in the other topics: magento 1.9.2CE that has a reindex working for way too many hours seems stuck ; generally it takes few minutes to 1 hour.
Context
everyday at 02h10 a ...
- 357
0
votes
1
answer
276
views
How to configure the indexer to run over the night?
I would like to run my indexer to run over the night since I'm already using the reindex by schedule, how could I do that?
- 13.7k
3
votes
0
answers
132
views
Order of indexers
On a Magento 2.2.8 store, we have a Catalog Price Rule for customer-group offers.
The indexers involved are set to update on schedule which is running successfully and not producing any errors. Most ...
- 300
1
vote
1
answer
452
views
Catalog URL Rewrites - Index Management and rebuild required indexes in Magento 1.9
I am seeing this message in the Magento admin-area:
One or more of the Indexes are not up to date: Catalog URL Rewrites.
Click here to go to Index Management and rebuild required indexes.
I ...
- 411
4
votes
2
answers
2k
views
Understanding the Magento 2 index
Generally Magento's index can be updated in 3 ways (depending on usage and configuration):
"On Save"
"By Schedule"
Using indexer:reindex command
This is what I can gather from the description in the ...
- 757
1
vote
2
answers
55
views
Reindex from different computer
Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
- 85
1
vote
1
answer
278
views
”Undefined offset: 4” when reindexing “Search indexer”
After module update I've got such error for indexing via SSH
Catalog Search indexer process unknown error:
Notice: Undefined offset: 4 in /home/sellastu/public_html/vendor/magento/module-catalog-...
- 185
6
votes
1
answer
2k
views
Magento 2 Is it possible to run reindexing per storeview?
My site has more than 100.000 products and almost 20 storeviews. Each time I run a full reindexing, it takes about 10 hours for reindexing to be finished.
I wonder if it's possible to just run ...
- 2,074
1
vote
1
answer
132
views
Magento1.9 Indexing fast
My catalog_product_flat indexing take too long time.
How to make this indexing faster in Magento 1.9
- 25
1
vote
1
answer
1k
views
Error Elasticsearch on reindexing - No handler for type [text] declared on field [search]
When I launch a full reindex (php bin/magento indexer:reindex), I have two errors for these indexes : "Catalog Search" , "ElasticSuite Category"
I have the Smile/Elasticsuite module installed on my ...
- 23
0
votes
2
answers
50
views
Can't reindex from web admin
I can't reindex catalog_category_flat index from web admin, I see an error message. But I can reindex it from the console by running
php shell/indexer.php --reindex catalog_category_flat
without ...
- 101
3
votes
3
answers
3k
views
Magento 2 Down: replica Tales not found when reindexing!
My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back:
(Magento 2.2.4, PHP 7.0.30)
When re-indexing, i get the following error:
...
- 333
0
votes
2
answers
4k
views
Magento 2 : Schedule Status : suspended
I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day.
I usually also reindex manually and when i see a suspended index I reset it.
But, when I do reindex:...
- 333
0
votes
0
answers
443
views
DROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?
We have had an issue with Magento 2.2.5 on an AWS RDS instance (MySQL 5.7):
Every then and when, essential Magento Admin functionality is blocked. It is possible to login, but order and customer list ...
- 1,137
1
vote
1
answer
2k
views
Magento 2 how to run reindex for single product or some cart line products
Is there any way in magento to achieve to reindex only single product or some items.
I have a inventory existing /update call on product page load and cart page load.
Right now doing indexing for ...
- 4,054
0
votes
1
answer
1k
views
Magento 2: How to reindex specific ids and in specific indexer using an observer
I know I can programatically trigger the indexer to index a list of product ids with the following:
/**
* @var \Magento\Framework\Indexer\IndexerInterfaceFactory
*/
protected $indexerFactory;
...
- 2,470
0
votes
1
answer
503
views
Indexer always getting stuck processing when using the admin GUI
When completing a reindex via the admin GUI it always gets stuck and never completes. If I reindex via the command line it completes rather 3 minutes. Could anyone advise the best way to make the GUI ...
- 2,641
2
votes
1
answer
13k
views
Magento2 reindex via cron job
I have a store with 300k products, I set up the reindex to be "Update by Schedule",
But I don't know what is the best way for reindexing, Should I do this manually by SSH command every 24 hours by ...
- 2,155
1
vote
0
answers
909
views
ReIndex after updating the Product name via API's in Magento 2?
Am re-indexing the Product programmatically every time its name is updated via API. But still, it shows old data. The code which I use to reindex a product,
$indexers = array('...
- 355
1
vote
0
answers
685
views
Magento1 reindexing: running indexer from command is queuing instead of reindexing
I am trying to run Magento indexer with:
php shell/indexer.php --reindex catalog_url
But I am getting:
Catalog URL Rewrites index was rebuilt successfully in 00:00:00
Which first made no sense to ...
- 111
3
votes
1
answer
667
views
Rogue "enterprise_refresh_index" causing excessive Merchandising failures
Thanks in advance for reading, and for any help you can hopefully offer.
My company uses Magento for our marketplace, and while we've always had occasional issues with AOE Scheduler unable to kick ...
- 41
3
votes
1
answer
5k
views
Magento 2 - How to reindex one product
I have issue with missing some products on frontend.
I noticed that reindexig catalog_product_category is fixing this issue.
In observer triggered after import I just add reindexing script:
public ...
- 1,467
1
vote
1
answer
925
views
Is it safe to delete my index lock files?
I am trying to reindex but I get an error "Stock Status Index process is working now. Please try run this process later.". When I look at MAGENTO_ROOT/var/locks I see a ton of lock files. Some are ...
- 37
1
vote
1
answer
116
views
Reindexing - browser window during re-indexing
Does the browser window need to remain open when re-indexing from the admin panel? i.e. once I start the re-index process, what happens if the browser window is closed. I am guessing re-indexing would ...
- 11
1
vote
0
answers
456
views
New products not showing until manually reindexing although cron is running
I am running Magento 2.1.2 and when creating new products they don't show up on the website until I manually run bin/magento indexer:reindex and flush the cache.
This sounds like a cron problem as ...
- 540
0
votes
2
answers
2k
views
Magento2 multi-store price-per-website: Wrong price indexed for configurable products
I have a multi-website Magento 2.1.0 CE installation, with 2 websites and different prices per-website. Prices are note related to each other, for the same product across the two websites.
In product ...
2
votes
1
answer
2k
views
Magento 2: Error while reindexing Catalog Search
I am getting error while trying to reindex catalog search with the following command:
php bin/magento indexer:reindex catalogsearch_fulltext
Here is the error that I am getting while running the ...
- 5,493
7
votes
4
answers
25k
views
Indexer stuck in processing
Magento ver. 2.0.7
Hello, I'm trying to reindex my store so that products I added from the backend will show up on the frontend.
As shown below, after running bin/magento indexer:reindex, every ...
- 191
1
vote
1
answer
1k
views
What triggers the partial re-index on attribute mass update?
I'm having a hard time figuring out what fires off the flat table update (partial re-indexing) when a attribute mass update is done from the Manage Catalog page in the admin.
When you mass-update ...
- 6,850
3
votes
1
answer
2k
views
Magento2 prevent reindex after adding product programmatically
I have made a module that adds a grouped product to the catalog. After adding some products I always have to reindex to see the changes. If I add a product via the Admin, this does not seem to be ...
1
vote
1
answer
864
views
var/locks is always empty
I do see the var/locks folder in my Magento installation. But it is always empty - even while the indexer is running.
I assume it will cause an issue if the indexer gets triggered more than once, is ...
- 1,507
5
votes
1
answer
1k
views
Reindex doesn't work (but shows success message)
I have a local environment and an online environment. Reindexing works locally but not online.
In the backend I'm getting the message:
One or more of the Indexes are not up to date: Product ...
- 153
0
votes
1
answer
410
views
Indexing issue - keep reverting to manual
With our Magento version 1.9.1.0 we are having an issue where indexing reverts back to manual as can be seen here
We set the mode to 'Update on Save' and do indexing via command line and it all shows ...
- 209