Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
433
questions
1
vote
0answers
9 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 days some orders are created without billing any tax. When We go check the product We notice the tax class is ...
0
votes
0answers
26 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
33 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 ...
2
votes
0answers
26 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
15 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
12 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
24 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
149 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
14 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
31 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
17 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
38 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
75 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
83 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 `...
0
votes
0answers
49 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
0answers
69 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
19 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
54 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
51 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
27 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
32 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
36 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
42 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
26 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
33 views
While trying to Reindexing through the command prompt generate error
Command I used :
php bin/magento indexer:reindex
0
votes
1answer
42 views
Magento Cron reindexing issue
We are facing an strange issue that products in listing pages are not showing in frontend. we are importing products from zoho and we have setup crons as update by schedule. Suddenly products got ...
1
vote
0answers
51 views
Facing issue with elastic search in magento 2.3 cloud
I am facing an issue with elastic search. I can not able to reindex catalosearch_fulltext.
[2019-05-06 11:54:08] report.CRITICAL: Notice: Undefined index: magento2_stg_product_1_v32 in /app/Staging/...
1
vote
2answers
62 views
Reindex Not Happening Automatically Magento 2.3
Every time I update a product stock in magento it updates perfectly in the backend but only when I manually run a reindex via SSH does it update on the front end.
Very annoying when I am sometimes ...
0
votes
0answers
48 views
Magento2 Product price data not save in catalog_product_index_price table
When I get product collection using \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory
some of products are not get. After debug query and found missing products are not add in ...
3
votes
1answer
98 views
Magento 2: Run reindexer using REST API
Is any one having tried to create REST API so using custom API one can trigger re-indexing?
which method do i have to mention in webapi.xml file as this is purely AREA::ADMIN activitiy. currently ...
4
votes
2answers
57 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 ...
4
votes
4answers
612 views
How to check whether the reindex working or not in Magento?
I have seen the Index Management of our site via admin panel System->Index Management. While checking, some of the indexes haven't updated. In this case, I'm not sure whether the index is working or ...
1
vote
0answers
28 views
catalog_category_product_index_store1 has stopped updating on reindex
I am currently having issues with making products display when adding them to new categories.
The table catalog_category_product_index_store1 is no longer adding new records when reindexing
Has ...
0
votes
0answers
175 views
URL rewrites not working Magento 2.3.0
I am having an issue with URL rewrites in Magento 2.3.0.
URL rewrites are of course turned on and most URLs have been rewritten but there are some which have not been. They are included in the ...
2
votes
2answers
68 views
SQL Error when I try to reindex Magento 2
I have an issue in Magento 2.2.7 where my site has the message
"One or more indexers are invalid." and looking at the indexers I see the following:
However when I try to run php bin/magento indexer:...
1
vote
1answer
46 views
Magento 2 : Problem in reindexing site
I have created two users with certains access in BO and I found that when adding category or product even an article ( via an extension that I have already installed) I can't find the new rows added ...
0
votes
2answers
245 views
Error While Saving Product and doing reindex in Magento2.3
When I run the reindexing command got this error:
Fatal error: Uncaught Error: Cannot instantiate interface Magento\InventoryIndexer\Model\StockIndexTableNameResolverInterface in /home/public_html/...
2
votes
0answers
26 views
Magento 2 : Product list only shows one product in one of the category, the rest works fine
Product list only shows one product in one of the category, the rest works fine. That category has more products, if you search for a product, you can access its product view and in related products ...
0
votes
0answers
68 views
Indexer status and backlog
When I run indexer:status from command line to look at the status of my indexes i notice some are like this:
| Catalog Product Rule | Ready | Schedule | working (7414 in backlog) | 2019-02-19 01:37:...
0
votes
0answers
71 views
Magento2 Getting issue on Reindex SQLSTATE[42000]: Syntax error or access violation: 1070
Getting issue on Reindex, I was about to create a new customer attribute,
How can i fix this, I also need is_used_in_grid = true
Customer Grid indexer process unknown error: SQLSTATE[42000]: Syntax
...
2
votes
0answers
54 views
You need to choose options for your item in Magento2 after running command indexer:reindex
I Moved database and webserver files from one server to another. After moving everything works fine. But when i run php bin/magento indexer:reindex on new server then while adding products ...
2
votes
1answer
59 views
When should i reindex Design Config Grid?
There are different types of magento indexers as mentioned in
https://devdocs.magento.com/guides/v2.3/extension-dev-guide/indexing.html
Whats is use of Design Config Grid Indexer? and when does it ...
2
votes
2answers
73 views
Getting error in catalog product price indexing
I am facing below error while running indexing for catalog product price.
Command:
php bin/magento indexer:reindex catalog_product_price
Error:
SQLSTATE[23000]: Integrity constraint violation: ...
1
vote
0answers
109 views
reindex does not works on magento 2
Have tried below commands provided for similar queries to resolve reindex issue but failed.
php bin/magento indexer:info
php bin/magento indexer:status
php bin/magento indexer:reset
php bin/magento ...
2
votes
0answers
62 views
Magento 2 - re-indexing creates multiple catalogrule_product tables
Currently i am facing an issue with re-indexing, It creates a temporary copy of catalogrule_product table. I have shared an image of the tables.
And because of this the db size is growing larger. Did ...
1
vote
2answers
43 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 ...
1
vote
1answer
503 views
Magento 2 MySQL server has gone away
I managed to migrate magento 1 to new magento 2.2.5
When I reindex for the first time I get in indexer
Category Products
[2019-02-07 21:58:57] main.CRITICAL: Warning: PDOStatement::execute(): ...
0
votes
1answer
172 views
Magento 2 Customer Grid index is locked by another reindex process. Skipping
I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue.
On the first reindexing I got the following error:
PHP Fatal error: ...
0
votes
1answer
131 views
Magento 2 Reindex overwriting database Tier_Price changes
Could someone explain to me why whenever I perform a reindex on my magento website any changes I have made within the catalog_product_index_price table get overwritten.
I have created a module that ...
0
votes
0answers
73 views
Error on reindex Magento 2
I recently made a massive load of products. After this, it's happening the following error:
bitnami@ip-172-31-24-128:~/apps/magento/htdocs$ php bin/magento indexer:reindex
Customer Grid index has ...
