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

innodb.alter_crash failed in buildbot - The process cannot access the file

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3
    • 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
    • Tests
    • None
    • Microsoft Windows

    Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/9770

      innodb.alter_crash 'innodb'              w3 [ fail ]
              Test ended at 2018-07-26 11:17:18
       
      CURRENT_TEST: innodb.alter_crash
      The process cannot access the file because it is being used by another process.
      mysqltest: In included file "./include/start_mysqld.inc": 
      included from D:/win32-debug/build/src/mysql-test/suite/innodb/t/alter_crash.test at line 77:
      At line 10: exec of 'D:\win32-debug\build\client\Debug\echo.exe "restart" > D:/win32-debug/build/mysql-test/var/3/tmp/mysqld.1.expect' failed, error: 1, status: 1, errno: 2
      Output from before failure:
      # Restart mysqld after the crash and reconnect.
       
       
       
      The result from queries just before the failure was:
      < snip >
      ALTER TABLE t1 ADD INDEX (c2,c3);
      ERROR HY000: Index c3 is corrupted
      ALTER TABLE t1 CHANGE c3 c3 INT NOT NULL;
      CHECK TABLE t1;
      Table	Op	Msg_type	Msg_text
      test.t1	check	status	OK
      ALTER TABLE t1 ADD INDEX (c2,c3);
      DROP TABLE t1;
      #
      # Bug #14669848 CRASH DURING ALTER MAKES ORIGINAL TABLE INACCESSIBLE
      #
      # -- Scenario 1:
      # Crash the server in ha_innobase::commit_inplace_alter_table()
      # just after committing the dictionary changes.
      CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=innodb;
      INSERT INTO t1 VALUES (1,2),(3,4);
      SET DEBUG_DBUG='+d,innodb_alter_commit_crash_after_commit';
      ALTER TABLE t1 ADD PRIMARY KEY (f2, f1);
      ERROR HY000: Lost connection to MySQL server during query
      # Restart mysqld after the crash and reconnect.
       
      More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\3\log\alter_crash.log
      

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.