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
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Link |
This issue relates to |
| Description |
https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/40471
{code:sql|title=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; # # # CREATE TABLE t (a INT) ENGINE=MyISAM; INSERT INTO t VALUES (1); connect con1,localhost,root,,test; XA START 'xid'; SELECT * FROM t; {code} The failure appears to be deterministic when the test is run *with {{\-\-view-protocol}}*. Not reproducible on the baseline. Does not |
https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/40471
{code:sql|title=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; # # # CREATE TABLE t (a INT) ENGINE=MyISAM; INSERT INTO t VALUES (1); connect con1,localhost,root,,test; XA START 'xid'; SELECT * FROM t; {code} 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. |
| Summary | main.alter_table_online fails with view-protocol | main.alter_table_online fails with a timeout with view-protocol |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Summary | main.alter_table_online fails with a timeout with view-protocol | main.alter_table_online timeouts with view-protocol |
| Summary | main.alter_table_online timeouts with view-protocol | main.alter_table_online times out with view-protocol |
| Assignee | Nikita Malyavin [ nikitamalyavin ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Nikita Malyavin [ nikitamalyavin ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.1 [ 28549 ] |
| Fix Version/s | 11.2.1 [ 29034 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |