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

After the merge rocksdb.drop_table fails with warnings

    XMLWordPrintable

    Details

      Description

      After I have merged fb/mysql-5.6 -> MariaDB, rocksdb.drop_table fails with warnings like pasted below. Upstream does not have the warnings.

      ~/dev-git/10.2-mariarocks/mysql-test$ ./mysql-test-run --mem rocksdb.drop_table
      rocksdb.drop_table                       [ fail ]  Found warnings/errors in server log file!
              Test ended at 2017-07-31 10:57:11
      line
      2017-07-31 10:55:48 140556445300480 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:48 140556445300480 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:48 140556445300480 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:48 140556445300480 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:51 140556444694272 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:426] ------- DUMPING STATS -------
      2017-07-31 10:55:51 140556444694272 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:427] 
      2017-07-31 10:55:51 140556444694272 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:377] STATISTICS:
      2017-07-31 10:55:51 140556151777024 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [__system__] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:55:52 139796177463040 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:426] ------- DUMPING STATS -------
      2017-07-31 10:55:52 139796177463040 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:427] 
      2017-07-31 10:55:52 139796177463040 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:377] STATISTICS:
      2017-07-31 10:55:52 139796729816960 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [__system__] Stalling writes because we have 3 level-0 files rate 16777216
      2017-07-31 10:55:54 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [rev:cf2] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:55:54 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:15 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [rev:cf2] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:15 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:37 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [rev:cf2] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:37 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:57 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [rev:cf2] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:56:57 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:57:07 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [rev:cf2] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:57:07 139796570359552 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:232] This condition must be satisfied: level0_stop_writes_trigger(1000) >= level0_slowdown_writes_trigger(-1) >= level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:249] Adjust the value to level0_stop_writes_trigger(1000)level0_slowdown_writes_trigger(2)level0_file_num_compaction_trigger(2)
      2017-07-31 10:57:08 139853689759488 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:426] ------- DUMPING STATS -------
      2017-07-31 10:57:08 139853689759488 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:427] 
      2017-07-31 10:57:08 139853689759488 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/db_impl.cc:377] STATISTICS:
      2017-07-31 10:57:08 139854245111680 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:57:09 139854085629696 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/column_family.cc:698] [cf1] Stalling writes because we have 2 level-0 files rate 16777216
      2017-07-31 10:57:10 139853706544896 [Warning] LibRocksDB:[/home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/rocksdb/db/compaction_picker.cc:243] [rev:cf2] ExpandWhileOverlapping() failure because some of the necessary compaction input files are currently being compacted.
      ^ Found warnings in /home/psergey/dev-git/10.2-mariarocks/mysql-test/var/log/mysqld.1.err
      
      

      The exact set of warnings produced varies across executions (edge case: under gdb, I often see none!).

      Looking at the upstream, their server does produce those warnings as well (I can see them in var/log/mysqld.1.err file), but MTR does not consider them to be worth printing.

      I've looked through the global and test' supressions and was unable to see messages like the above to be suppressed.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: