Details
- 
    Bug 
- 
    Status: Open (View Workflow)
- 
    Major 
- 
    Resolution: Unresolved
- 
    10.4(EOL)
- 
    None
Description
Note: The test case currently fails for me every time, but it's still a race condition, so it can vary on different machines and builds. Run with --repeat=N if it doesn't fail right away. We can also convert it into a concurrent test if necessary.
| CREATE TABLE t1 (a INT) ENGINE=MyISAM; | 
|  | 
| --connect (con1,localhost,root,,test) | 
| BACKUP STAGE START; | 
| --send | 
|   BACKUP STAGE BLOCK_COMMIT; | 
|  | 
| --connection default | 
| SET lock_wait_timeout= 1; | 
| --error ER_LOCK_WAIT_TIMEOUT | 
| ALTER TABLE t1 ADD INDEX (a); | 
|  | 
| --connection con1 | 
| --reap | 
|  | 
| # Cleanup | 
| --disconnect con1 | 
| --connection default | 
| DROP TABLE t1; | 
| 10.4 301bd62b253 | 
| mysqltest: At line 14: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 | 
The most important effect is that MariaBackup backup might fail with the deadlock error.
Attachments
Issue Links
- is blocked by
- 
                    MDEV-18643 'BACKUP STAGE BLOCK_DDL ' failed: 1213: Deadlock found -         
- Open
 
-         
- is caused by
- 
                    MDEV-5336 Implement BACKUP STAGE for safe external backups -         
- Closed
 
-