Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2, 11.3(EOL), 11.4
-
None
Description
The test atomic.alter_table is seldomly hanging on our CI systems. Here is an example from the oldest affected major version:
|
10.6 80ae69c8bc948382920b083ba203369e |
atomic.alter_table 'innodb' w3 [ fail ] timeout after 900 seconds
|
Test ended at 2023-02-06 20:57:42
|
|
|
Test case timeout after 900 seconds
|
|
|
== /dev/shm/var/3/log/alter_table.log ==
|
`c` int(11) DEFAULT NULL,
|
KEY `a` (`a`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
|
count(*)
|
2
|
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
|
crash point: ddl_log_alter_after_rename_triggers
|
t2.frm
|
t2.ibd
|
"Table is in test2"
|
Table Create Table
|
t2 CREATE TABLE `t2` (
|
`a` int(11) DEFAULT NULL,
|
`b` int(11) DEFAULT NULL,
|
`c` int(11) DEFAULT NULL,
|
KEY `a` (`a`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='new'
|
count(*)
|
2
|
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
|
|
|
== /dev/shm/var/3/tmp/analyze-timeout-mysqld.1.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local server through socket '/dev/shm/var/tmp/3/mysqld.1.sock' (111)
|
Stack traces of the apparently hung server process are available. As far as I can tell, all threads are idle in all the stack traces that I have checked; at least InnoDB should not be to blame for the hangs. This could be a bug in mtr itself.
Attachments
Issue Links
- is part of
-
MDEV-33073 always green buildbot
-
- Stalled
-
- relates to
-
-
- Closed
-