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

Edge case - regression in cf_options='cf0={target_file_size_base=0m};' in optimized 8.0 builds

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: 8.0, Not 5.7
    • Fix Version/s: None
    • Component/s: MyRocks

      Description

       

      # mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so
      INSTALL PLUGIN rocksdb_global_info SONAME 'ha_rocksdb.so';
      SET @@GLOBAL.rocksdb_update_cf_options='cf0={target_file_size_base=0m};';
      SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO; 

      Leads to;

      2019-02-09T00:43:52.633490Z 9 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Failed to get column family flags from CF with id = 2. MyRocks data dictionary may be corrupted.' 
      Core was generated by `/sda/PS080219-percona-server-8.0.13-4-linux-x86_64-opt/bin/mysqld --no-defaults'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      [Current thread is 1 (Thread 0x7f1387f61700 (LWP 5107))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055ac911f3ed7 in my_write_core (sig=sig@entry=6) at stacktrace.cc:278
      #2  0x000055ac9051c5c5 in handle_fatal_signal (sig=6) at signal_handler.cc:254
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #5  0x00007f1387fa2801 in __GI_abort () at abort.c:79
      #6  0x00007f133f939295 in myrocks::rdb_i_s_global_info_fill_table (thd=0x7f1304817000, tables=0x7f13049d6df0, cond=<optimized out>)
          at rdb_i_s.cc:806
      #7  0x000055ac9044ed5a in do_fill_table (thd=thd@entry=0x7f1304817000, table_list=table_list@entry=0x7f13049d6df0, 
          qep_tab=qep_tab@entry=0x7f1304886918) at sql_show.cc:5260
      #8  0x000055ac9045852e in get_schema_tables_result (join=join@entry=0x7f1304886028, 
          executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:5374
      #9  0x000055ac9043e39f in JOIN::prepare_result (this=this@entry=0x7f1304886028) at sql_select.cc:1437
      #10 0x000055ac903b83c9 in JOIN::exec (this=0x7f1304886028) at sql_executor.cc:202
      #11 0x000055ac9043ef74 in Sql_cmd_dml::execute_inner (this=0x7f13049d7398, thd=0x7f1304817000) at sql_select.cc:698
      #12 0x000055ac90446bd0 in Sql_cmd_dml::execute (this=0x7f13049d7398, thd=0x7f1304817000) at sql_select.cc:596
      #13 0x000055ac903f3303 in mysql_execute_command (thd=thd@entry=0x7f1304817000, first_level=first_level@entry=true) at sql_parse.cc:4530
      #14 0x000055ac903f664b in mysql_parse (thd=thd@entry=0x7f1304817000, parser_state=parser_state@entry=0x7f1387f5fd30, 
          update_userstat=update_userstat@entry=false, force_primary_storage_engine=force_primary_storage_engine@entry=false)
          at sql_parse.cc:5271
      #15 0x000055ac903f9a09 in dispatch_command (thd=thd@entry=0x7f1304817000, com_data=com_data@entry=0x7f1387f60c60, command=COM_QUERY)
          at sql_parse.cc:1734
      #16 0x000055ac903fa579 in do_command (thd=thd@entry=0x7f1304817000) at sql_parse.cc:1290
      #17 0x000055ac9050dc60 in handle_connection (arg=arg@entry=0x7f133d3ca160) at conn_handler/connection_handler_per_thread.cc:317
      #18 0x000055ac9129fb2f in pfs_spawn_thread (arg=0x7f133d3fa820) at pfs.cc:2836
      #19 0x00007f1389db16db in start_thread (arg=0x7f1387f61700) at pthread_create.c:463
      #20 0x00007f138808388f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      On PS 8.0.13-4, but not on 8.0.12 where it gives;

      8.0.12>SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
      +----------+------+----------------+
      | TYPE     | NAME | VALUE          |
      +----------+------+----------------+
      | CF_FLAGS | 0    | default [0]    |
      | CF_FLAGS | 1    | __system__ [0] |
      +----------+------+----------------+
      2 rows in set (0.00 sec)
      

      And on PS 5.7.24 it produces this same output. So it seems to be a recent regression.

      I tried building upstream to test there, but the FB 5.6 build fails with a compression library issue. Feel free to give it a quick spin there if you have a working FB build.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                roel.vandepaar Roel Van de Paar (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 30 minutes
                  30m