All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
222 views

Magento2: Asymmetric transaction rollback

Sometimes I found in log file issue: Ran jobs by schedule. string(32) "Asymmetric transaction rollback." Ran jobs by schedule. Ran jobs by schedule. Ran jobs by schedule. Anyone know how it is and ...
4
votes
0answers
300 views

Magento 2.2.5 - Categories are not getting saved in the database

In my Magento 2.2.5 Store, When I try to edit the existing categories content and press the save button, the categories content stays the same, there is no change being reflected in the admin panel,...
0
votes
0answers
190 views

Indexer query error empty values

When I run the indexer I get the following error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; This is caused by the following: LEFT JOIN ...
4
votes
3answers
5k views

MySQL server has gone away when maual reindex catalog_product_flat

In my Magento EE 14.0.1, when I try to reindex catalog_product_flat like this: php indexer.php --reinex catalog_product_flat After serveral minutes, it throws me this error: Product Flat Data index ...
2
votes
1answer
676 views

Trouble reindexing - forgein key constrain fails

I deleted all products by truncating tables. Now, after uploading all products again I get this: Product Attributes index process unknown error: exception 'PDOException' with message '...
0
votes
1answer
99 views

MySQL error when targetrule indexer is executed

I'm trying to run the targetrule indexer in my terminal and it shows some syntax error Command: php indexer.php --reindex targetrule Error: exception 'PDOException' with message 'SQLSTATE[42000]: ...
8
votes
2answers
1k views

enterprise_refresh_index Sleeping MySQL Connection

There are times that the indexer that is ran by cron seems to get stuck at the MySQL as Sleeping connections can be seen. Indexer runs for several hours and this actually not running at all. I've ...
1
vote
1answer
694 views

INSERT IGNORE INTO `catalog_category_product_index_tmp` in multiple websites

one question to the community: Questions why does magento reindex each website ? in our situation all website have the same store Why does Magento only reindex 500 entitys ? SQL Statement ...
1
vote
2answers
2k views

General error: 1005 Can't create table 'db_name.catalog_category_flat_store_1'

I am trying to reindex Category Flat Data via ssh with the command php indexer.php --reindex catalog_category_flat but I am getting error as below. I have tried all the solutions posted on the forum ...
2
votes
1answer
5k views

Rebuilding catalogsearch_fulltext index stucked [duplicate]

I am trying to rebuild catalogsearch_fulltext index but the process always get stucked in the middle. Normally it was running 3-4 hours but now it did not finish after 19 hours. I already killed the ...