Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
-
None
-
Arch Linux
Description
--source include/have_binlog_format_row.inc
|
--source include/have_innodb.inc
|
--source include/master-slave.inc
|
|
--sync_slave_with_master
|
--source include/stop_slave.inc
|
|
SET GLOBAL slave_parallel_threads=7; |
set global slave_parallel_mode=optimistic; |
set global slave_transaction_retries=1000; |
alter table mysql.gtid_slave_pos engine=myisam; |
|
# Create some conflicting events on master |
connection master; |
CREATE TABLE t1(a INT NOT NULL AUTO_INCREMENT PRIMARY KEY) engine=innodb; |
INSERT INTO t1 VALUES (1),(2),(3),(4); |
--disable_query_log
|
--let $count=5
|
while ($count) |
{
|
update t1 set a=a+5 where a=1; |
update t1 set a=a+5 where a=2; |
update t1 set a=a+5 where a=3; |
update t1 set a=a+5 where a=4; |
update t1 set a=a-5 where a=5; |
update t1 set a=a-5 where a=6; |
--dec $count
|
}
|
--enable_query_log
|
select * from t1; |
drop table t1; |
|
--connection slave
|
start slave;
|
--connection master
|
--sync_slave_with_master
|
stop slave;
|
SET GLOBAL slave_parallel_threads=0; |
set global slave_parallel_mode=conservative; |
set global slave_transaction_retries=10; |
start slave;
|
--source include/rpl_end.inc |
Fails with following error:
Last_Errno 1942
|
Last_Error Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-11' for key 'PRIMARY'
|
Attachments
Issue Links
- duplicates
-
MDEV-10242 Non-transactional mysql.gtid_slave_pos breaks --slave-parallel-mode=[optimistic|aggressive] replication
- Confirmed
- is blocked by
-
MDEV-25768 ALTER gtid_slave_pos table storage engine should not be allowed when slave is running.
- Closed