Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5, 10.6, 10.7
-
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
|
|
It 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
- is blocked by
-
MDEV-25768 ALTER gtid_slave_pos table storage engine should not be allowed when slave is running.
-
- Stalled
-