Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6974

Correct instability in the rocksdb.drop_cf_* tests

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.x, 8.0.x, Not 5.6.x
    • Fix Version/s: 5.7.30-33, 8.0.20-11
    • Component/s: None
    • Labels:

      Description

      rocksdb.drop_cf_during_manual_compaction is unstable. Locally works fine but fails on Jenkins at https://ps80.cd.percona.com/job/percona-server-8.0-param/558/:

      CURRENT_TEST: rocksdb.drop_cf_during_manual_compaction
      mysqltest: At line 51: Query 'create table create_cf ( id int, primary key (id) comment 'cfname=cf_primary_key' ) engine=rocksdb' failed.
      ERROR 8018 (HY000): Column family ('cf_primary_key') is being dropped.
      
      The result from queries just before the failure was:
      set @old_debug = @@global.debug;
      create table create_cf ( id int, primary key (id) comment 'cfname=cf_primary_key' ) engine=rocksdb;
      drop table create_cf;
      select * from information_schema.rocksdb_cfstats where cf_name='cf_primary_key';
      CF_NAME	STAT_TYPE	VALUE
      cf_primary_key	NUM_IMMUTABLE_MEM_TABLE	0
      cf_primary_key	MEM_TABLE_FLUSH_PENDING	0
      cf_primary_key	COMPACTION_PENDING	0
      cf_primary_key	CUR_SIZE_ACTIVE_MEM_TABLE	728
      cf_primary_key	CUR_SIZE_ALL_MEM_TABLES	728
      cf_primary_key	NUM_ENTRIES_ACTIVE_MEM_TABLE	0
      cf_primary_key	NUM_ENTRIES_IMM_MEM_TABLES	0
      cf_primary_key	NON_BLOCK_CACHE_SST_MEM_USAGE	0
      cf_primary_key	NUM_LIVE_VERSIONS	1
      set @@global.debug = '+d,rocksdb_compact_column_family';
      set @@global.debug = '+d,rocksdb_drop_cf';
      set @@global.rocksdb_compact_cf = 'cf_primary_key';
      set debug_sync = "now wait_for ready_to_mark_cf_dropped_in_compact_column_family";
      select * from information_schema.rocksdb_cfstats where cf_name='cf_primary_key';
      CF_NAME	STAT_TYPE	VALUE
      cf_primary_key	NUM_IMMUTABLE_MEM_TABLE	0
      cf_primary_key	MEM_TABLE_FLUSH_PENDING	0
      cf_primary_key	COMPACTION_PENDING	0
      cf_primary_key	CUR_SIZE_ACTIVE_MEM_TABLE	728
      cf_primary_key	CUR_SIZE_ALL_MEM_TABLES	728
      cf_primary_key	NUM_ENTRIES_ACTIVE_MEM_TABLE	0
      cf_primary_key	NUM_ENTRIES_IMM_MEM_TABLES	0
      cf_primary_key	NON_BLOCK_CACHE_SST_MEM_USAGE	0
      cf_primary_key	NUM_LIVE_VERSIONS	1
      set @@global.rocksdb_delete_cf = 'cf_primary_key';
      select * from information_schema.rocksdb_cfstats where cf_name='cf_primary_key';
      CF_NAME	STAT_TYPE	VALUE
      cf_primary_key	NUM_IMMUTABLE_MEM_TABLE	0
      cf_primary_key	MEM_TABLE_FLUSH_PENDING	0
      cf_primary_key	COMPACTION_PENDING	0
      cf_primary_key	CUR_SIZE_ACTIVE_MEM_TABLE	728
      cf_primary_key	CUR_SIZE_ALL_MEM_TABLES	728
      cf_primary_key	NUM_ENTRIES_ACTIVE_MEM_TABLE	0
      cf_primary_key	NUM_ENTRIES_IMM_MEM_TABLES	0
      cf_primary_key	NON_BLOCK_CACHE_SST_MEM_USAGE	0
      cf_primary_key	NUM_LIVE_VERSIONS	1
      set debug_sync = "now signal mark_cf_dropped_done_in_compact_column_family";
      set @@global.debug = '+d,rocksdb_drop_cf';
      select * from information_schema.rocksdb_cfstats where cf_name = 'cf_primary_key' ;
      CF_NAME	STAT_TYPE	VALUE
      cf_primary_key	NUM_IMMUTABLE_MEM_TABLE	0
      cf_primary_key	MEM_TABLE_FLUSH_PENDING	0
      cf_primary_key	COMPACTION_PENDING	0
      cf_primary_key	CUR_SIZE_ACTIVE_MEM_TABLE	728
      cf_primary_key	CUR_SIZE_ALL_MEM_TABLES	728
      cf_primary_key	NUM_ENTRIES_ACTIVE_MEM_TABLE	0
      cf_primary_key	NUM_ENTRIES_IMM_MEM_TABLES	0
      cf_primary_key	NON_BLOCK_CACHE_SST_MEM_USAGE	0
      cf_primary_key	NUM_LIVE_VERSIONS	1
      set debug_sync = "now signal ready_to_drop_cf";
      set debug_sync = "now wait_for drop_cf_done";
      Timeout in wait_condition.inc for select count(*) = 0 from information_schema.rocksdb_cfstats where cf_name = 'cf_primary_key'
      set @@global.debug = @old_debug;
      safe_process[23784]: Child process: 23785, exit: 1
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                przemyslaw.skibinski Przemyslaw Skibinski
                Reporter:
                przemyslaw.skibinski Przemyslaw Skibinski
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 2 hours
                    1d 2h