Magento 2.2 : MySQL General error 1787 when reindexing The Next CEO of Stack OverflowMySQL...
Is there a difference between "Fahrstuhl" and "Aufzug"
Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?
Reference request: Grassmannian and Plucker coordinates in type B, C, D
Should I tutor a student who I know has cheated on their homework?
What happened in Rome, when the western empire "fell"?
How to count occurrences of text in a file?
Chain wire methods together in Lightning Web Components
Is the D&D universe the same as the Forgotten Realms universe?
Why did CATV standarize in 75 ohms and everyone else in 50?
Why isn't the Mueller report being released completely and unredacted?
How to write a definition with variants?
What does "Its cash flow is deeply negative" mean?
What steps are necessary to read a Modern SSD in Medieval Europe?
Proper way to express "He disappeared them"
Rotate a column
Why does standard notation not preserve intervals (visually)
Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?
Why the difference in type-inference over the as-pattern in two similar function definitions?
Won the lottery - how do I keep the money?
Why is information "lost" when it got into a black hole?
Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
Unclear about dynamic binding
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
Magento 2.2 : MySQL General error 1787 when reindexing
The Next CEO of Stack OverflowMySQL “SELECT would examine more than MAX_JOIN_SIZE rows” error when reindexing catalog_product_priceError when creating new theme for magento 2.2Magento 2.2 : Cannot Add SubcategoryReindexing catalog_product_flat causes Mysql error 1117 Too many columsdesign_config_grid_flat' doesn't existMagento ver. 1.9.3.9 After update catalog url rewrite stuck on processing2.2 B2B - Error when editing companyMagento 2 Down: replica Tales not found when reindexing!error after moving magento mysql
How to fix the two errors 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.
database magento2.2
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
How to fix the two errors 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.
database magento2.2
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25
add a comment |
How to fix the two errors 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.
database magento2.2
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
How to fix the two errors 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.
database magento2.2
database magento2.2
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
edited Oct 26 '17 at 15:51
maxagaz
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
asked Oct 24 '17 at 7:52
maxagazmaxagaz
421425
421425
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25
add a comment |
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25
add a comment |
2 Answers
2
active
oldest
votes
Magento try to create a temporary table, but like you have ENFORCE_GTID_CONSISTENCY enable that failed.
Only statements that can be logged using GTID safe statements can be logged when enforce-gtid-consistency is set to ON, so the operations listed here cannot be used with this option:
- CREATE TABLE ... SELECT statements
- CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions
- Transactions or statements that update both transactional and nontransactional tables. There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are temporary.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
I don't know if Magento 2 is able to work with GTID Consistency enable (seems not). If it's not a strong need, you can deactivate it.
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
add a comment |
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f198330%2fmagento-2-2-mysql-general-error-1787-when-reindexing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Magento try to create a temporary table, but like you have ENFORCE_GTID_CONSISTENCY enable that failed.
Only statements that can be logged using GTID safe statements can be logged when enforce-gtid-consistency is set to ON, so the operations listed here cannot be used with this option:
- CREATE TABLE ... SELECT statements
- CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions
- Transactions or statements that update both transactional and nontransactional tables. There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are temporary.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
I don't know if Magento 2 is able to work with GTID Consistency enable (seems not). If it's not a strong need, you can deactivate it.
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
add a comment |
Magento try to create a temporary table, but like you have ENFORCE_GTID_CONSISTENCY enable that failed.
Only statements that can be logged using GTID safe statements can be logged when enforce-gtid-consistency is set to ON, so the operations listed here cannot be used with this option:
- CREATE TABLE ... SELECT statements
- CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions
- Transactions or statements that update both transactional and nontransactional tables. There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are temporary.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
I don't know if Magento 2 is able to work with GTID Consistency enable (seems not). If it's not a strong need, you can deactivate it.
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
add a comment |
Magento try to create a temporary table, but like you have ENFORCE_GTID_CONSISTENCY enable that failed.
Only statements that can be logged using GTID safe statements can be logged when enforce-gtid-consistency is set to ON, so the operations listed here cannot be used with this option:
- CREATE TABLE ... SELECT statements
- CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions
- Transactions or statements that update both transactional and nontransactional tables. There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are temporary.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
I don't know if Magento 2 is able to work with GTID Consistency enable (seems not). If it's not a strong need, you can deactivate it.
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
Magento try to create a temporary table, but like you have ENFORCE_GTID_CONSISTENCY enable that failed.
Only statements that can be logged using GTID safe statements can be logged when enforce-gtid-consistency is set to ON, so the operations listed here cannot be used with this option:
- CREATE TABLE ... SELECT statements
- CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions
- Transactions or statements that update both transactional and nontransactional tables. There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are temporary.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
I don't know if Magento 2 is able to work with GTID Consistency enable (seems not). If it's not a strong need, you can deactivate it.
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
answered Oct 24 '17 at 8:44
Nicolas PERNOTNicolas PERNOT
392212
392212
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
add a comment |
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
How to disable it ?
– maxagaz
Oct 26 '17 at 15:22
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
Depends... Try to look for it in your my.cnf. You can have something like "enforce_gtid_consistency=true". Switch it to false and restart MySQL. Check if the modification is effective thanks to the query following: "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;"
– Nicolas PERNOT
Oct 27 '17 at 9:47
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
It is possible there are other configuration lines in you my.cnf about gtid, like gtid_mode (if it is, switch it to OFF). Don't forget to restart MySQL after a modification of my.cnf.
– Nicolas PERNOT
Oct 27 '17 at 9:48
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
Actually, I can't switch off GTID on the RDS server I'm using, is there another way to clean the database from GTID stuffs ?
– maxagaz
Oct 27 '17 at 10:51
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
You can set values through MySQL. But if configurations are in my.cnf, these values will be reinitialized each time MySQL will restart. So its not a good way to do, but that let you test if the solution works. "SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1000;". Maybe a dump of the database before could be a good idea ;)
– Nicolas PERNOT
Oct 27 '17 at 13:20
add a comment |
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
add a comment |
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
add a comment |
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
Problem fixed by this module:
https://github.com/bangerkuwranger/Magento-2-GTID-Safe-URL-Rewrite-Tables
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
answered Nov 13 '17 at 15:13
maxagazmaxagaz
421425
421425
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f198330%2fmagento-2-2-mysql-general-error-1787-when-reindexing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What is your MySQL version ? What returns the mysql query : "SELECT @@GLOBAL.ENFORCE_GTID_CONSISTENCY;" ?
– Nicolas PERNOT
Oct 24 '17 at 8:06
I'm using "mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper". The query returns "1".
– maxagaz
Oct 24 '17 at 8:25