Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Critical 
- 
    Resolution: Fixed
- 
    N/A
- 
    None
Description
https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/40471
| bb-11.0-oalter e599b8b45 | 
| main.alter_table_online 'innodb,nobinlog' w1 [ fail ] timeout after 900 seconds | 
| Test ended at 2023-03-26 15:16:56 | 
|  | 
| Test case timeout after 900 seconds | 
|  | 
| == /mnt/buildbot/build/mariadb-11.0.1/mysql-test/var/1/log/alter_table_online.log ==  | 
| ERROR 21000: Operand should contain 1 column(s) | 
| alter table t modify c date; | 
| ERROR 23000: Duplicate entry '0000-00-00' for key 'c' | 
| select * from t; | 
| c	c2	stamp | 
| 1	1	0000-00-00 00:00:00 | 
| 2	2	0000-00-00 00:00:00 | 
| 3	3	0000-00-00 00:00:00 | 
| 4	4	0000-00-00 00:00:00 | 
| 5	5	0000-00-00 00:00:00 | 
| drop table t; | 
| set sql_mode=default; | 
| # | 
| # MDEV-28944 XA assertions failing in binlog_rollback and binlog_commit | 
| # | 
| CREATE TABLE t (a INT) ENGINE=MyISAM; | 
| INSERT INTO t VALUES (1); | 
| connect con1,localhost,root,,test; | 
| XA START 'xid'; | 
| SELECT * FROM t; | 
Same for main.alter_table_online_debug.
The failure appears to be deterministic when the test is run with --view-protocol. Not reproducible on the baseline.
Attachments
Issue Links
- is caused by
- 
                    MDEV-16329 Engine-independent online ALTER TABLE -         
- Closed
 
-         
- relates to
- 
                     MDEV-28808
        Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part MDEV-28808
        Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part-         
- Closed
 
-