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

rocksdb.optimize_table fails: sst file reduction was not enough

    Details

      Description

      The failure looks like this:

      https://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/19325/steps/mtr_ps/logs/stdio/text

      rocksdb.optimize_table 'write_prepared'  w1 [ fail ]
              Test ended at 2019-07-26 04:08:03
       
      CURRENT_TEST: rocksdb.optimize_table
      --- /mnt/buildbot/build/mariadb-10.3.17/storage/rocksdb/mysql-test/rocksdb/r/optimize_table.result	2019-07-26 01:32:33.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.3.17/storage/rocksdb/mysql-test/rocksdb/r/optimize_table.reject	2019-07-26 04:08:03.241689846 -0400
      @@ -40,7 +40,7 @@
       optimize table t4;
       Table	Op	Msg_type	Msg_text
       test.t4	optimize	status	OK
      -sst file reduction ok
      +sst file reduction was not enough 8596599 -> 8245954 (minimum 1000kb)
       optimize table t6;
       Table	Op	Msg_type	Msg_text
       test.t6	optimize	status	OK
       
      mysqltest: Result length mismatch
       
       - saving '/mnt/buildbot/build/mariadb-10.3.17/mysql-test/var/1/log/rocksdb.optimize_table-write_prepared/' to '/mnt/buildbot/build/mariadb-10.3.17/mysql-test/var/log/rocksdb.optimize_table-write_prepared/'
       
      Retrying test rocksdb.optimize_table, attempt(2/3)...
      

      The testcase has:

      source optimize_table.inc;
      optimize table t1;
      source optimize_table.inc;
      optimize table t3;
      source optimize_table.inc;
      optimize table t4;
      source optimize_table.inc;
      optimize table t6;
      source optimize_table.inc;
      

      The failure always happens after table t4:

       Table	Op	Msg_type	Msg_text
       test.t4	optimize	status	OK
      -sst file reduction ok
      +sst file reduction was not enough 8596599 -> 8245954 (minimum 1000kb)
       optimize table t6;
       Table	Op	Msg_type	Msg_text
       test.t6	optimize	status	OK
      

        Attachments

          Activity

            People

            • Assignee:
              psergey Sergei Petrunia
              Reporter:
              psergey Sergei Petrunia
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: