- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2017
08:34 AM
10-26-2017
08:34 AM
How to fix the error below ?
$ php bin/magento indexer:reindex Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index is locked by another reindex process. Skipping. Category Products index has been rebuilt successfully in 00:00:00 Product Categories index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:00 SQLSTATE[HY000]: General error: 1787 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_eav_temp` LIKE `catalog_product_index_eav_tmp` Stock index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:04
My server in on Ubuntu 16.04 with Mysql 5.7.19 and php 7.0.24.
Solved! Go to Solution.
Labels:
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017
07:09 AM
11-13-2017
07:09 AM
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
6 REPLIES 6
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2017
10:59 PM
10-26-2017
10:59 PM
Re: MySQL General error 1787 when reindexing
please check
Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2017
11:15 PM
10-26-2017
11:15 PM
Re: MySQL General error 1787 when reindexing
This is my same question on stackexchange, but there's not yet any reply there either.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2017
11:19 PM
10-26-2017
11:19 PM
Re: MySQL General error 1787 when reindexing
cab you please check GTID Consistency disabledor not?
https://avdeo.com/2014/03/27/enabling-gtid-in-mysql/
If enable then disable it.
Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2017
03:54 AM
10-27-2017
03:54 AM
Re: MySQL General error 1787 when reindexing
It is enabled but I can't disable it, it's on a shared database server. Is
there a way to clean the database manually from GTID stuffs ?
there a way to clean the database manually from GTID stuffs ?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2017
04:04 AM
10-27-2017
04:04 AM
Re: MySQL General error 1787 when reindexing
i don't think possible per db wise.
https://github.com/magento/magento2/issues/9455
Magento does not support enforce_gtid_consistency
Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2017
07:09 AM
11-13-2017
07:09 AM
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables