Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33489

The test atomic.alter_table occasionally hangs

    XMLWordPrintable

Details

    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

          Activity

            People

              monty Michael Widenius
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.