Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
466
questions
0
votes
1answer
9 views
Magento : Assigning products to (new) websites programmatically do I need to run an index and which one?
In Magento When assigning products to (new) websites programmatically do I need to run an index and which one?
When using
Mage::getModel('catalog/product_website')->addProducts(array($...
0
votes
1answer
95 views
+100
Elasticsearch Limit of total fields [9165] in index [product_1_v2] has been exceeded
When we enable ElasticSearch 7+ in our Magento 2.3.5 install and try to reindex the search index, we get the following error:
Catalog Search indexer process unknown error:
{"error":{"...
0
votes
2answers
54 views
Magento 2 Aftet Migration Error - Reindex No Such Entity Error
[root@test]# php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:00
Product Flat Data index ...
2
votes
0answers
11 views
Basic clarity on some magento default function
I had gone through a interview process. They fired some questions below which I don't know answers and couldn't find in google. The questions are below.
How to create a object and why we need to ...
1
vote
0answers
28 views
Urgent - Magento 2.3.4 - “One or more indexers are invalid. Make sure your Magento cron job is running.”
I am creating a store with Magento, but the products are not appearing, I believe it is due to the error "One or more indexers are invalid. Make sure your Magento cron job is running.".
I've ...
1
vote
0answers
21 views
Reindex programmatically in magento
I am new to magento. i have to indexer:reindex pragmatically and i looking for this solution. i found few source but there is no guide how and where i can use this code.
https://magecomp.com/blog/how-...
0
votes
1answer
22 views
how often that magento 2 reindex cron job run?
Anyone know how often that Magento 2 Reindex Cron job run daily?
thanks
0
votes
0answers
59 views
Getting error while reindexing in magento2
While re indexing in magento2 getting below error
Fatal error: Uncaught TypeError: Return value of Magento\PageBuilder\Model\Stage\Preview::isPreviewMode() must be of the type boolean, null returned ...
0
votes
0answers
11 views
Indexer with custom cron_group
We have created a new custom indexer as per requirement. And now we need to schedule that indexer with custom cron_group which can be scheduled according to business. We don't want to schedule with ...
0
votes
2answers
47 views
Magento Cloud reindex fail elasticsuite
I try to reindex my Magento Cloud and caught below error. Anyone whats wrong with the ElasticSuite
web@mymagento.0:~$ php bin/magento indexer:reindex
Design Config Grid index has been rebuilt ...
0
votes
0answers
36 views
Magento 2.3.2 - Issue with catalog_product_price reindex (Product Price)
I was getting below error while doing reindex for catalog_product_price (Product Price).
SQLSTATE[HY000]: General error: 1137 Can't reopen table: 'catalog_product_index_price_temp', query was: INSERT ...
0
votes
0answers
15 views
Re-indexing not happening for the catalog_product_flat - got the error Syntax error or access violation: 1118 Row size too large
Re-indexing not happening for the catalog_product_flat getting the below error.
Syntax error or access violation: 1118 Row size too large. The ...
0
votes
0answers
14 views
Failed to reindex “Product Flat Data” and “Product Price” getting error like illegal offset on DataObject.php
Failed to reindex "Product Flat Data" - Reorganize EAV product structure to flat structure and "Product Price"
I have got the below error while indexing from the backend.
"Warning: Illegal ...
0
votes
0answers
13 views
Magento 2.3.3 reindex error
i have this error and i don't understand to solve it
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '26974-207-1-0-26974' for key 'PRIMARY', query was: INSERT INTO ...
0
votes
0answers
11 views
Magento 2 Catalog rule Reindex Fail `Unknown column 'at_sku.store_id'` in 'on clause'
I am having this error when running php bin/magento indexer:reindex
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sku.store_id' in 'on clause', query was: SELECT e.*, at_sku.sku FROM ...
0
votes
1answer
13 views
An error occurred while saving the URL rewrite in both System --> Index Management and through SSH
Magento 1.9.x
The Error from the Error log is as follows:
2020-04-20T23:17:52+00:00 ERR (3):
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'category/112-1-1' ...
0
votes
0answers
26 views
Catalog rule indexing issue after data migration in magento 2.3.4
main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sku.store_id' in 'on clause', query was: SELECT `e`.*, `at_sku`.`sku` FROM `mee_catalog_product_entity` AS `e`
INNER JOIN `...
0
votes
1answer
36 views
Magento 2.3 reindex design_config_grid stucks on processing
design_config_grid and customer_grid stuck on processing when I use bin/magento indexer:reindex. Even after bin/magento indexer:reset and changing status to Invalid, when I reindex again, they stuck ...
0
votes
0answers
14 views
4472 Segmentation fault searchd --config fake.conf 2>&1
I have a problem with my Sphinx Search Engine. I'm running store on Magento 2.2 platform and durring reindex I getting an error like in topic.
After some debuging i found that the external module try ...
0
votes
0answers
153 views
Error “DDL statements are not allowed in transactions” while Reindexing programmatically using Event Observer Magento 2.3.0
Actually i am trying to reindex category data while saving category
from backend but i am getting an error DDL statements are not
allowed in transactions in log file while reindexing ...
3
votes
2answers
268 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]: ...
0
votes
1answer
36 views
Magento 2 is not showing product in categroy pages
I use Magento 2.2.2 and since yesterday I can't see any products in category pages. products are available individually but not available in any category pages
I've done these solutions but still, it'...
0
votes
0answers
24 views
Why products disappeared on the frontend after import?
I'm running my store in the Magento 2.3.1 + ElasticSearch 6 + PHP 7.2
With 12k products and 228 attributes, and PHP memory_limit = -1.
I have an integration that syncs the products through Magento's ...
1
vote
0answers
33 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
26 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
156 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
31 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
30 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
66 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
149 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
34 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
1answer
308 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
430 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
65 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
45 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
196 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
35 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
279 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
530 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
29 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
65 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
34 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
256 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":{"...
4
votes
0answers
87 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
145 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
210 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
530 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
95 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
131 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 ...
