Web lists-archives.com

Error 1837




Hi, 

On a fresh new master-slave very simple setup with just a Magento 1.5 DB
under MySQL 5.6.35, I'm getting this error with a memory table: 

2017-05-03 07:08:37 1109 [Note] Slave I/O thread: connected to master
'replica@10.0.15.183:3306',replication started in log 'FIRST' at
position 4
2017-05-03 11:38:18 1109 [ERROR] Slave SQL: Error 'When
@@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a
different value after a COMMIT or ROLLBACK. Please check GTID_NEXT
variable manual page for detailed explanation. Current
@@SESSION.GTID_NEXT is '76a1eb3e-1ecc-11e7-a106-027ba847acd7:121'.' on
query. Default database: 'xxxxx_web'. Query: 'DELETE FROM
`xxxxx_web`.`catalog_product_index_price_bundle_tmp`', Error_code: 1837
2017-05-03 11:38:18 1109 [Warning] Slave: When @@SESSION.GTID_NEXT is
set to a GTID, you must explicitly set it to a different value after a
COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for
detailed explanation. Current @@SESSION.GTID_NEXT is
'76a1eb3e-1ecc-11e7-a106-027ba847acd7:121'. Error_code: 1837
2017-05-03 11:38:18 1109 [ERROR] Error running query, slave SQL thread
aborted. Fix the problem, and restart the slave SQL thread with "SLAVE
START". We stopped at log 'xxxxx-pre-master-mysql-bin.000001' position
68789 

and replication stops util I stop/start slave. 

That looks it was fixed in https://bugs.mysql.com/bug.php?id=68525 but
it's happening to me at least. 

Any help? 

Thanks, 

Rubén.