Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Duplicate
- 
    10.6, 10.11, 11.4, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 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
 
-