Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
446
questions
1
vote
0answers
20 views
Magento2.3.4 - Switching Catalog Price Scope causes SQL error
After switching the Catalog Price Scope from Global to Website and trying to reindex I get the following SQL error. How do I fix it?
Design Config Grid index has been rebuilt successfully in 00:00:00
...
0
votes
0answers
24 views
Could not open input file: bin/magneto error after every command in magent2.3.3
I have freshly installed magento 2.3.3 but when i am trying to run indexer or any other command i am getting following errors.
Could not open input file: bin/magneto
I have tried so many commands ...
2
votes
4answers
44 views
Magento 2 while reindex INSERT INTO 'catalog_category_product_index_store1' stuck the query
I am working on Magento 2.3.2. When I run re-index command php bin/magento i:rei Design Config Grid and Customer Config Grid is completed. But it is taking too much time to re-index Category Products ...
0
votes
0answers
23 views
Magento 2 reindex process stuck on Category Products and Product Categories
I am working on Magento 2.3.2. I am doing reindex but the process is never ends for Product Categories and Category Products for total of 60K Prducts
I tried to reset these both and tried to reindex ...
0
votes
0answers
18 views
Catalog product index website is empty
From time to time the record of this table is deleted.
Catalog product index website is empty
Tech details:
PHP 7.0.33
Magento v2.1.18
Apache/2.4.25 (Debian)
10.1.41-MariaDB-0+deb9u1 Debian 9.9
...
1
vote
0answers
25 views
Problems re-indexing Category Products and Products Categories in Magento 2.3
We are facing the Reindex for the Category Products and Product Categories and we are getting the following error while reindexing through SSH (php bin/magento indexer:reindex)
Category Products ...
0
votes
1answer
35 views
SQLSTATE[42000]: 1142 TRIGGER command denied for table 'catalog_product_index_price_replica',
Good Day
I am very much a novice when it comes to this. I upgraded my store from Magento 2.2.8 to 2.3.3.
All seemed initially to go without issues.
However on reindexing i get the below error.
...
1
vote
0answers
31 views
Magento 1.9 menu and products stock problem
I have a problem with a Magento 1.9.1.1 store: categories menu in header disappears and in the meantime all the product stock seems to be unavailable. The strange thing is that the two problems occur ...
1
vote
0answers
14 views
magento 2.2.0 reindex through command is not working
I have setup magento 2.2.0 version and set index to update on scheduel. When I remove category from product and run php bin/magento indexer:reindex command it's reindex successfully but when I check ...
1
vote
0answers
94 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
146 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/...
1
vote
3answers
41 views
How Reindex and Reset programmatically in magento 2?
I Need to reindex and reset the indexer programmatically using external script from magento root.
How can i achieve this.Is there a Way to do this.?
I am new in magento. Please help me.
Thanks in ...
0
votes
0answers
32 views
Magento 2 - Catalog Search Indexer DB problem
I have a problem with my Catalog Search Indexer. I reindex all indexes by using php bin/magento indexer:reindex command but when indexer starts reindex catalog search process then I have an error that ...
1
vote
0answers
75 views
Magento 2 what is the use of indexer backlogs?
When we run the php bin/magento index:status command it throws the complete view of the indexer.
In Below screenshot you can see the backlogs are way higher. I am trying to understand what is the use ...
0
votes
0answers
26 views
reindexing error while trying to refresh magento 2.3 indexes via ssh with godaddy hosting
I am a noob user and am setting up magento 2.3 with godaddy hosting for development and testing my store.
I receved the error message within magento: One or more indexers are invalid. Make sure your ...
0
votes
1answer
79 views
Syntax error or access violation: 1118 Row size too large Reindexing
I am facing : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, ...
5
votes
5answers
323 views
Which server settings can cause Magento reindex to run really slow?
Shop facts:
around 100 categories
but in the main category, there are ~ 70.000 products (because filtering is heavily used)
After moving a shop developed by us to a production server of an external ...
2
votes
0answers
26 views
Magento 2 reindex cronjob frequency
Magento 2.3.0
It's more like an open question than a problem.
By default reindex by schedule is fired every minute. Why is that so often?
By your experience, can default cronjob be set less often ...
0
votes
2answers
56 views
How to programmatically reindex product after update ex. price/stock quantity
how to programmatically reindex product after update ex. price/stock quantity using Magento ver. 2.3.2 API via Swagger? I do application in C# which sync my system with Magento. I have a lot of ...
1
vote
1answer
30 views
Magento 2: custom action di compile issue
I have created below code for the reindexing programmatically from a custom url, bit i got the below error while running below code, please help me to solve out this issue.
<?php
namespace ...
2
votes
1answer
152 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":{"...
3
votes
0answers
67 views
Catalog product flat reindex issue: errno: 121 Duplicate key on write or update (Magento 1.9.3.8)
When I try to reindex catalog_product_flat from command line I get following error.
Reindex finished with error message "SQLSTATE[HY000]: General error: 1005 Can't create tablemagento_db.#sql-...
0
votes
1answer
84 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 ...
0
votes
1answer
153 views
Magento 2.3.1 Product EAV index throws error with GTID consistency
when I run reindex Command After Below type error showing
SQLSTATE[HY000]: General error: 1787 Statement violates GTID
consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only
be ...
0
votes
2answers
315 views
CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.,
My Magento 2 site can't be indexed anymore.
not sure what created the problem, when I run php bin/magento indexer:reindex, It shows following error
userxx@host [~/public_html/magento2]# php bin/...
1
vote
0answers
67 views
Product's Tax Class change to “None” on Reindex. Any ideas?
We've just migrated from Magento 1.9.2.2 to Magento 2.2.8. We noticed in the last couple of days some orders are created without billing any tax. When We go check the product We notice the tax class ...
0
votes
0answers
96 views
Magento 2: Category page empty after re-index (E.E 2.2.9)
I am working on Magento E.E 2.2.9
Category page is not able to display product once I ran re-index. I ran re-index using crontab. Category pages are empty until I flush cache manually.
Any idea ...
0
votes
1answer
46 views
how to schedule reindex of catalog_category_product only
I need to run separately with its own schedule the reindexing of:
catalog_category_product
catalog_product_category
catalog_category_flat
I dont find the in any crontab.xml
How can we do ...
3
votes
0answers
45 views
Reindex a single category in magento 1
I want to re-index a single category in Magento 1.
The method given in this post is not working for reindexing categories
Is there a way to do it through code?
0
votes
0answers
62 views
Catalog Rule Product and Catalog Product Rule reindex not working in magento2
When I run following commands
php bin/magento indexer:reindex catalogrule_rule
php bin/magento indexer:reindex catalogrule_product
error:
[2019-07-24 12:48:35] main.CRITICAL: SQLSTATE[42S01]: ...
0
votes
1answer
24 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?
0
votes
1answer
66 views
Algolia extension error in Magento 2
I have installed the Algolia search extension on the Magento2 website.
Upon reindexing, I am getting below error.
"upgrade your plan or delete existing records".
My question is an upgraded plan ...
2
votes
4answers
404 views
Magento 2 programatically reindex using custom extention controller file
How to set the re-index process automatically in Magento 2 site.
We have one custom extension.
We want to set cone in controller files.
So when we run this controller URL; re-index function work.
...
2
votes
0answers
22 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 ...
1
vote
1answer
56 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 ...
1
vote
0answers
39 views
cat_index_position defaults to 10001. Magento 2.1.9
Magento 2.1.9 right now. We have a fec categories and set the position according to our liking. However this isnt reflected in the frontend for every product. Some work, some dont.
Screenshot of the ...
0
votes
2answers
345 views
Magento 2 Catalog Product Flat Data not reindexing
the indexing of magento product Flat data is staying on "index required".The mode is on "Scheme" and the cron is running. I tried several things like:
truncate catalog_product_flat_1, ...
0
votes
0answers
143 views
SQLSTATE[42000]: Syntax error or access violation: 3057 Incorrect user-level lock name on re indexing
When I run php indexer.php --reindexall command I get following error.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 3057 Incorrect user-level lock name 'magento_prod....
1
vote
0answers
357 views
catalog_product_price reindex stuck
Using Magento 2.3.1 EE, 50k products and 14 store views. The catalog_product_price reindex gets stuck with this query listed in SHOW FULL PROCESSLIST
DELETE `price_index` FROM `...
1
vote
1answer
314 views
products disappear from category page or search result, index error cluster_block_exception
Products sometimes disappear from the category pages in the frontend. It might be after reindex, or clear cache. If i go to magento admin panel->catalog-> and highlight the category, make some changes,...
2
votes
1answer
349 views
Magento2: During reindex Serialization failure: 1213 Deadlock found when trying to get lock
During php bin/magento indexer:reindex
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `...
0
votes
1answer
23 views
MAgento2.3.0 how to Update automatic indexing - cron job to set up to re-index automaticaly/periodically [duplicate]
I am using MAgento2.3.0 website i need to Update automatic indexing - cron job to set up to re-index automaticaly/periodically
if any one idea how to setup please reply me
0
votes
1answer
187 views
M2: Impossible reindex
Impossible reindex magento 2.1.11
In terminal I run:
php bin/magento indexer:reindex
The first 3 indexes reindex in a few seconds. Reindex stops on the 4th index and this is the end. I waited all ...
1
vote
2answers
120 views
Inventory reindex runs catalog price reindex also
Magento version: 2.3.1
When I run inventory reindex from command line it first runs inventory reindex and then price reindex after that.
Here is the command I executed:
bin/magento indexer:reindex ...
1
vote
3answers
56 views
How do I reindex catalogue on Magento 2? 'reindex' dropdown not available
New products are not appearing on the live page. I understand I have to reindex the catalogue and clear cache for them to appear.
Selecting: system > Index Management
When setting all to '...
0
votes
1answer
52 views
Index sql error
When I run indexer:reindex I get the following SQL error
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;
check the manual that corresponds to your ...
0
votes
0answers
46 views
Reindexing issue after upgrading to magento 2.3
Preconditions (*)
Install Magento 2.2.x
Make custom multi-select product attribute with the source model
Steps to reproduce (*)
Upgrade above magento2.2.x to magento2.3.1
Reindex Data
Expected ...
0
votes
1answer
59 views
Need to run Reindex command in Controller (programmatically) in Magento 2 [duplicate]
I need to run command php bin/magento indexer:reindex in Controller.
1
vote
0answers
31 views
Magento2 Catalog Price Rule
Magento2 Catalog Price Rule Not Working when i create rule and click on save and apply rule not applied on Category without re-indexing my indexing is on update on save mode.
2
votes
2answers
35 views
While trying to Reindexing through the command prompt generate error
Command I used :
php bin/magento indexer:reindex
