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

innodb_zip.recover, innodb_gis.types failed in buildbot with server failing to restart

Details

    Description

      Note: Possibly it has already been fixed, but I don't see a clear indication of it.

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio

      bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28

      innodb_zip.recover 'innodb'              w1 [ fail ]
              Test ended at 2020-05-06 14:52:03
       
      CURRENT_TEST: innodb_zip.recover
      mysqltest: In included file "./include/wait_until_connected_again.inc": 
      included from ./include/start_mysqld.inc at line 18:
      included from ./include/restart_mysqld.inc at line 11:
      included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29:
      At line 23: Server failed to restart
       
      The result from queries just before the failure was:
      #
      # MDEV-12720 recovery fails with "Generic error"
      # for ROW_FORMAT=compressed
      #
      CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
      ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
      BEGIN;
      insert into a(i) select null;
      insert into a select null, uuid() from a a, a b, a c;
      insert into a select null, uuid() from a a, a b, a c;
      insert into a select null, uuid() from a a, a b, a c;
      SET GLOBAL innodb_flush_log_at_trx_commit=1;
      COMMIT;
      

      Last words in the log:

      2020-05-07  9:42:08 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 17, since the redo log references ./test/t1.ibd with space ID 16.
      2020-05-07  9:42:08 0 [Note] InnoDB: Starting a batch to recover 332 pages from redo log.
      2020-05-07  9:42:09 0 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 21 failed attempts to flush a page! Consider increasing innodb_buffer_pool_size. Pending flushes (fsync) log: 0; buffer pool: 0. 381 OS file reads, 78 OS file writes, 78 OS fsyncs.
      

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description _Note: Possibly it has already been fixed, but I don't see a clear indication of it._

            http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio

            {noformat:title=bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28}
            innodb_zip.recover 'innodb' w1 [ fail ]
                    Test ended at 2020-05-06 14:52:03

            CURRENT_TEST: innodb_zip.recover
            mysqltest: In included file "./include/wait_until_connected_again.inc":
            included from ./include/start_mysqld.inc at line 18:
            included from ./include/restart_mysqld.inc at line 11:
            included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29:
            At line 23: Server failed to restart

            The result from queries just before the failure was:
            #
            # MDEV-12720 recovery fails with "Generic error"
            # for ROW_FORMAT=compressed
            #
            CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
            ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
            BEGIN;
            insert into a(i) select null;
            insert into a select null, uuid() from a a, a b, a c;
            insert into a select null, uuid() from a a, a b, a c;
            insert into a select null, uuid() from a a, a b, a c;
            SET GLOBAL innodb_flush_log_at_trx_commit=1;
            COMMIT;
            {noformat}
            _Note: Possibly it has already been fixed, but I don't see a clear indication of it._

            http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio

            {noformat:title=bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28}
            innodb_zip.recover 'innodb' w1 [ fail ]
                    Test ended at 2020-05-06 14:52:03

            CURRENT_TEST: innodb_zip.recover
            mysqltest: In included file "./include/wait_until_connected_again.inc":
            included from ./include/start_mysqld.inc at line 18:
            included from ./include/restart_mysqld.inc at line 11:
            included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29:
            At line 23: Server failed to restart

            The result from queries just before the failure was:
            #
            # MDEV-12720 recovery fails with "Generic error"
            # for ROW_FORMAT=compressed
            #
            CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
            ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
            BEGIN;
            insert into a(i) select null;
            insert into a select null, uuid() from a a, a b, a c;
            insert into a select null, uuid() from a a, a b, a c;
            insert into a select null, uuid() from a a, a b, a c;
            SET GLOBAL innodb_flush_log_at_trx_commit=1;
            COMMIT;
            {noformat}

            Last words in the log:
            {noformat}
            2020-05-07 9:42:08 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 17, since the redo log references ./test/t1.ibd with space ID 16.
            2020-05-07 9:42:08 0 [Note] InnoDB: Starting a batch to recover 332 pages from redo log.
            2020-05-07 9:42:09 0 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 21 failed attempts to flush a page! Consider increasing innodb_buffer_pool_size. Pending flushes (fsync) log: 0; buffer pool: 0. 381 OS file reads, 78 OS file writes, 78 OS fsyncs.
            {noformat}
            elenst Elena Stepanova made changes -
            Fix Version/s 10.3 [ 22126 ]
            Affects Version/s 10.3 [ 22126 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.4 [ 22408 ]
            Affects Version/s 10.4 [ 22408 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Thirunarayanan Balathandayuthapani [ thiru ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Labels need_rr
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.1 [ 24029 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
            Labels need_rr not-10.5
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2020-10-19 08:50:19.0 2020-10-19 08:50:19.732
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            midenok Aleksey Midenkov made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            midenok Aleksey Midenkov made changes -
            Summary innodb_zip.recover failed in buildbot with server failing to restart innodb_zip.recover, innodb_gis.types failed in buildbot with server failing to restart
            midenok Aleksey Midenkov made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5.1 [ 24029 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 108452 ] MariaDB v4 [ 143641 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.2 [ 14601 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2022-11-08 16:42:22.0 2022-11-08 16:42:22.747
            marko Marko Mäkelä made changes -
            Fix Version/s 10.3.38 [ 28507 ]
            Fix Version/s 10.4.28 [ 28509 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.