[MDEV-30987] main.alter_table_online times out with view-protocol Created: 2023-04-02  Updated: 2023-08-16  Resolved: 2023-08-16

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Tests
Affects Version/s: N/A
Fix Version/s: 11.2.1

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16329 Engine-independent online ALTER TABLE Closed
Relates
relates to MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) ... Stalled

 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.



 Comments   
Comment by Sergei Golubchik [ 2023-05-23 ]

a6b49437424 is ok to push

Generated at Thu Feb 08 10:20:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.