mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
80da35a326
CREATE-OR-REPLACE SEQUENCE is not logged with Gtid event DDL flag which affects its slave parallel execution. Unlike other DDL:s it can occur in concurrent execution with following transactions which can lead to various errors, including asserts like (mdl_request->type != MDL_INTENTION_EXCLUSIVE && mdl_request->type != MDL_EXCLUSIVE) || !(get_thd()->rgi_slave && get_thd()->rgi_slave->is_parallel_exec && lock->check_if_conflicting_replication_locks(this) in MDL_context::acquire_lock. Fixed to wrap internal statement level commit with save- and-restore of TRANS_THD::m_unsafe_rollback_flags.
8 lines
257 B
Text
8 lines
257 B
Text
RESET MASTER;
|
|
CREATE OR REPLACE SEQUENCE s1;
|
|
DROP SEQUENCE s1;
|
|
FLUSH LOGS;
|
|
FOUND 2 /GTID [0-9]+-[0-9]+-[0-9]+/ in mysqlbinlog.sql
|
|
The same as above number of samples must be found:
|
|
FOUND 2 /GTID [0-9]+-[0-9]+-[0-9]+ ddl/ in mysqlbinlog.sql
|
|
End of the tests
|