Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
0
votes
1answer
14 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
23 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
28 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
24 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
31 views
While trying to Reindexing through the command prompt generate error
Command I used :
php bin/magento indexer:reindex
0
votes
1answer
24 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
24 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
39 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
23 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
54 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
36 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 ...
3
votes
4answers
411 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
18 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
98 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
53 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
45 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
120 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
25 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
34 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
32 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
34 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
40 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
45 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
59 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 ...
1
vote
0answers
40 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
40 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
320 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
102 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
92 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
49 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 ...
0
votes
1answer
173 views
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row
After created a shopping cart rule for grouped product I got that
catalog_product_attribute indexer
needs reindex.
When I tried to reindex from console I got:
Product Attributes index process ...
0
votes
1answer
56 views
How to confirm that the reindex is working or not?
We have added a new product in one of the categories on our site using the Magento admin panel. But the added product is not visible in the frontend.
We have set the reindex mode to Update on save ...
0
votes
0answers
25 views
M2: Impossible finish reindex
Now all products are were gone on all store view. I checked and product and category index is proccessed.
I try reset indexes and reindex again but now I wait about 50 minutes and no result.
Any ...
0
votes
1answer
42 views
Magento 2 localhost wamp cron jobs
I'm still getting the error on my admin page "One or more indexers are invalid. Make sure your Magento cron job is running"
All field indexes rebuild successfully apart from Catalog Search.
I'm using ...
0
votes
0answers
41 views
Magento 2.1 - Reindex failing on product eav and catalog search index
We moved magento code setup from one server to another. Initially all the indexes are in ready status. But if we run the reindex command:
php bin/magento indexer:reindex
the reindex fails for ...
0
votes
0answers
10 views
Content not appearing after adding two text content types
I've gone through the Magento admin control panel to
Content > Content Types > Select Section (For us it is called "0-Home") > Manage Fields
and added two text fields, not required, no max ...
0
votes
0answers
209 views
Getting “DDL statements are not allowed in transactions ” error when re-index programmatically in magento 2.2.X
I am working on Magento 2.2.6. As per requirement I need to do re-index on sales_order_save_after event.
It is working well in Magento 2.1.X but I am getting following error on Magento 2.2.X.
...
0
votes
0answers
45 views
Magento 2 Visual Swatches isn't appear for some products
i have set the color attribute to show as "Visual Swatch" and for some reason the swatches isn't showing up at all for most of the products.
All the swatches has values and the simple products has ...
0
votes
0answers
51 views
Magento homepage redirects to 404 page not found
After reindexing, when entering the homepage url, I'm redirected to 404 page not found.
I have checked configuration/general/web and everything seems to be working there.
2
votes
1answer
30 views
Does indexer:reindex need “var”, “generated” and “pub/static” to be writable?
I would like to know if, when doing "php bin/magento indexer:reindex" the folders "var", "generated" and "pub/static" have to be writable ?
Alternatively, does reindexing only work at database level?
...
6
votes
2answers
257 views
Indexing Not working after installed Smile Elastic search extension Magento 2
I have installed Smile Elasticsearch extension successfully.But i am not able to reindex catalogsearch_fulltext indexer.
I have installed elasticsearch successfully on my local server.
Please check ...
3
votes
0answers
112 views
Indexer stuck at processing Design Config Grid, Customer Grid, and Catalog Search
My indexer always stuck at processing for Design Config Grid, Customer Grid, and Catalog Search
i already ran php bin/magento indexer:reset , but when the cron indexer run the result still the same, ...
0
votes
1answer
34 views
Magento 2 - Clear cache in 3 Servers programatically?
I am in a project which uses 3 servers to serve a Magento 2 site. I have written a code to clear cache and re-indexing. But for certain reasons the cache flush has to happen in all the three servers.
...
0
votes
2answers
107 views
Error when reindexing
when I use php bin/magento indexer:reindex or php bin/magento cron:run I keep getting this error.
Parse error: syntax error, unexpected '?', expecting variable (T_VARIABLE) in /home/[NAME]/...
0
votes
2answers
132 views
Magento 2 error : Command “indexer:reindex” is not defined
System : Ubuntu 18
Application : Magento2.3
PHP : 7.1
I have two indexer need to be reindex. I have update the indexer on the admin page but it is not work. I also use the following command on the ...
0
votes
0answers
33 views
Catalog Rule Product indexer process unknown error
I am getting the following error : while running : bin/magento indexer:reindex
Catalog Rule Product indexer process unknown error:
Table status for `catalogrule_rule_cl` is incorrect. Can`t fetch ...
2
votes
3answers
102 views
Reindex is in processing since 10 days why it is not going to complete in magento2
See the date of reindex in processing since 10 days why it is not going to finish
Cron jobs running in every 21 hours for reindex
I try also manually reindex but taking too long time in days
...
0
votes
0answers
240 views
Catalog Search indexer process unknown error
I'm getting a 'One or more indexers are invalid. Make sure your Magento cron job is running.' and it seems I need to run php bin/magento indexer:reindex from the CLI.
I get the index rebuilt ...
3
votes
0answers
177 views
Magento2 catalog_product_category / catalog_category_product - Serialization failure Deadlock
Lately I'm experiencing some issues when trying to reindex catalog_product_category and/or catalog_category_product (most of the issues seem to be on this last one). The reindex process fails to ...
0
votes
0answers
16 views
Search on front end not working = Cannot initialize the indexer process FOR Rebuild Catalog product fulltext search index (Catalog Search Index)
Magento 1.9.1
Porto theme
We had some server performance problems. I did a re-index couple of times and broke one of the indexes (I guess). Now - when anyone tries to search on the front end - they ...
