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

innodb_zip.wl6501_1 fails in buildbot with Unknown storage engine 'InnoDB'

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL)
    • 10.2.6
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/759/steps/test_1/logs/stdio

      innodb_zip.wl6501_1 'innodb'             w2 [ fail ]
              Test ended at 2017-05-08 19:08:36
       
      CURRENT_TEST: innodb_zip.wl6501_1
      mysqltest: At line 228: query 'select count(*) from t1' failed: 1286: Unknown storage engine 'InnoDB'
       
      The result from queries just before the failure was:
      < snip >
      3
      select count(*) from t4;
      count(*)
      3
      select count(*) from t5;
      count(*)
      3
      select count(*) from t6;
      count(*)
      3
      set session debug="+d,ib_trunc_crash_during_drop_index_temp_table";
      Warnings:
      Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
      "---debug ib_trunc_crash_during_drop_index_temp_table point---"
      # Write file to make mysql-test-run.pl expect crash and restart
      # Run the crashing query
      truncate table t5;
      ERROR HY000: Lost connection to MySQL server during query
      # Restart the MySQL server
      select count(*) from t1;
      

      Attachments

        Activity

          If this repeats after MDEV-12720 recovery fails with "Generic error" for ROW_FORMAT=compressed i.e. commit b3939a35aa5e67d6204810e3e8c150772e60c422 please get back.

          jplindst Jan Lindström (Inactive) added a comment - If this repeats after MDEV-12720 recovery fails with "Generic error" for ROW_FORMAT=compressed i.e. commit b3939a35aa5e67d6204810e3e8c150772e60c422 please get back.

          With latest version can't repeat:

          jan@jan-laptop-asus:~/mysql/10.2-orig/mysql-test$ ./mtr --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20
          Logging: ./mtr  --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20
          vardir: /dev/shm
          Checking leftover processes...
          Removing old var directory...
          couldn't chmod(0777, /dev/shm): Operation not permitted at /usr/share/perl/5.24/File/Find.pm line 511.
          Couldn't remove directory '/dev/shm': Permission denied at /usr/share/perl/5.24/File/Find.pm line 511.
          Creating var directory '/dev/shm'...
          Checking supported features...
          MariaDB Version 10.2.6-MariaDB-debug
           - SSL connections supported
           - binaries are debug compiled
          Collecting tests...
          Installing system database...
           
          ==============================================================================
           
          TEST                                      RESULT   TIME (ms) or COMMENT
          --------------------------------------------------------------------------
           
          worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
          innodb_zip.wl6501_1 'innodb'             [ pass ]  76866
          innodb_zip.wl6501_1 'innodb'             [ pass ]  79404
          innodb_zip.wl6501_1 'innodb'             [ pass ]  78946
          innodb_zip.wl6501_1 'innodb'             [ pass ]  78544
          innodb_zip.wl6501_1 'innodb'             [ pass ]  83392
          innodb_zip.wl6501_1 'innodb'             [ pass ]  85788
          innodb_zip.wl6501_1 'innodb'             [ pass ]  84697
          innodb_zip.wl6501_1 'innodb'             [ pass ]  81712
          innodb_zip.wl6501_1 'innodb'             [ pass ]  79476
          innodb_zip.wl6501_1 'innodb'             [ pass ]  81910
          innodb_zip.wl6501_1 'innodb'             [ pass ]  80776
          innodb_zip.wl6501_1 'innodb'             [ pass ]  81565
          innodb_zip.wl6501_1 'innodb'             [ pass ]  80546
          innodb_zip.wl6501_1 'innodb'             [ pass ]  80882
          innodb_zip.wl6501_1 'innodb'             [ pass ]  80519
          innodb_zip.wl6501_1 'innodb'             [ pass ]  81370
          innodb_zip.wl6501_1 'innodb'             [ pass ]  81789
          innodb_zip.wl6501_1 'innodb'             [ pass ]  82283
          innodb_zip.wl6501_1 'innodb'             [ pass ]  86641
          innodb_zip.wl6501_1 'innodb'             [ pass ]  84401
          --------------------------------------------------------------------------
          The servers were restarted 0 times
          Spent 1631.507 of 1645 seconds executing testcases
           
          Completed: All 20 tests were successful.
          

          jplindst Jan Lindström (Inactive) added a comment - With latest version can't repeat: jan@jan-laptop-asus:~/mysql/10.2-orig/mysql-test$ ./mtr --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20 Logging: ./mtr --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20 vardir: /dev/shm Checking leftover processes... Removing old var directory... couldn't chmod(0777, /dev/shm): Operation not permitted at /usr/share/perl/5.24/File/Find.pm line 511. Couldn't remove directory '/dev/shm': Permission denied at /usr/share/perl/5.24/File/Find.pm line 511. Creating var directory '/dev/shm'... Checking supported features... MariaDB Version 10.2.6-MariaDB-debug - SSL connections supported - binaries are debug compiled Collecting tests... Installing system database...   ==============================================================================   TEST RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------   worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 innodb_zip.wl6501_1 'innodb' [ pass ] 76866 innodb_zip.wl6501_1 'innodb' [ pass ] 79404 innodb_zip.wl6501_1 'innodb' [ pass ] 78946 innodb_zip.wl6501_1 'innodb' [ pass ] 78544 innodb_zip.wl6501_1 'innodb' [ pass ] 83392 innodb_zip.wl6501_1 'innodb' [ pass ] 85788 innodb_zip.wl6501_1 'innodb' [ pass ] 84697 innodb_zip.wl6501_1 'innodb' [ pass ] 81712 innodb_zip.wl6501_1 'innodb' [ pass ] 79476 innodb_zip.wl6501_1 'innodb' [ pass ] 81910 innodb_zip.wl6501_1 'innodb' [ pass ] 80776 innodb_zip.wl6501_1 'innodb' [ pass ] 81565 innodb_zip.wl6501_1 'innodb' [ pass ] 80546 innodb_zip.wl6501_1 'innodb' [ pass ] 80882 innodb_zip.wl6501_1 'innodb' [ pass ] 80519 innodb_zip.wl6501_1 'innodb' [ pass ] 81370 innodb_zip.wl6501_1 'innodb' [ pass ] 81789 innodb_zip.wl6501_1 'innodb' [ pass ] 82283 innodb_zip.wl6501_1 'innodb' [ pass ] 86641 innodb_zip.wl6501_1 'innodb' [ pass ] 84401 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 1631.507 of 1645 seconds executing testcases   Completed: All 20 tests were successful.

          It didn't happen after MDEV-12720.

          elenst Elena Stepanova added a comment - It didn't happen after MDEV-12720 .

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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