Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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 ...