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

MyRocks: To set rocksdb_update_cf_options with a non-existant column family created a partially-defined column family which could cause a server exit.

    Details

      Description

      gdb:

      Core was generated by `/sdc/PS031219-percona-server-8.0.18-9-linux-x86_64-debug/bin/mysqld --no-defaul'.
      Program terminated with signal 6, Aborted.
      #0  0x00007fbda45b2a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      59        val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
      (gdb) bt
      +bt
      #0  0x00007fbda45b2a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      #1  0x00000000049e6f27 in my_write_core (sig=6) at /home/hrvoje/sdc/release-8.0.18-9_dbg/mysys/stacktrace.cc:305
      #2  0x0000000003924059 in handle_fatal_signal (sig=6) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/signal_handler.cc:172
      #3  <signal handler called>
      #4  0x00007fbda23f9337 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:55
      #5  0x00007fbda23faa28 in __GI_abort () at abort.c:90
      #6  0x00007fbd5070eb3d in myrocks::rdb_i_s_global_info_fill_table (thd=0x7fbd38420000, tables=0x7fbd38473e28, cond=0x0) at /home/hrvoje/sdc/release-8.0.18-9_dbg/storage/rocksdb/rdb_i_s.cc:807
      #7  0x00000000037c9bbf in do_fill_information_schema_table (thd=0x7fbd38420000, table_list=0x7fbd38473e28, qep_tab=0x7fbd3857a938) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_show.cc:4295
      #8  0x0000000003a4f2a5 in MaterializeInformationSchemaTableIterator::Init (this=0x7fbd3857ab50) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/composite_iterators.cc:1978
      #9  0x000000000384ace7 in SELECT_LEX_UNIT::ExecuteIteratorQuery (this=0x7fbd38473378, thd=0x7fbd38420000) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_union.cc:1488
      #10 0x000000000384b1cc in SELECT_LEX_UNIT::execute (this=0x7fbd38473378, thd=0x7fbd38420000) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_union.cc:1578
      #11 0x00000000037a57e4 in Sql_cmd_dml::execute_inner (this=0x7fbd384743d8, thd=0x7fbd38420000) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_select.cc:900
      #12 0x00000000037a4f09 in Sql_cmd_dml::execute (this=0x7fbd384743d8, thd=0x7fbd38420000) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_select.cc:705
      #13 0x000000000373fefa in mysql_execute_command (thd=0x7fbd38420000, first_level=true) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_parse.cc:4670
      #14 0x00000000037428d7 in mysql_parse (thd=0x7fbd38420000, parser_state=0x7fbda0d9a9f0, update_userstat=false) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_parse.cc:5481
      #15 0x0000000003737316 in dispatch_command (thd=0x7fbd38420000, com_data=0x7fbda0d9bb80, command=COM_QUERY) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_parse.cc:1815
      #16 0x000000000373576f in do_command (thd=0x7fbd38420000) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/sql_parse.cc:1302
      #17 0x000000000390d6df in handle_connection (arg=0x7fbd4fa365c0) at /home/hrvoje/sdc/release-8.0.18-9_dbg/sql/conn_handler/connection_handler_per_thread.cc:308
      #18 0x000000000514fa1a in pfs_spawn_thread (arg=0x7fbda048b1e0) at /home/hrvoje/sdc/release-8.0.18-9_dbg/storage/perfschema/pfs.cc:2855
      #19 0x00007fbda45ade65 in start_thread (arg=0x7fbda0d9c700) at pthread_create.c:307
      #20 0x00007fbda24c188d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      sql:

      # mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so --init-file=/home/hrvoje/percona-qa/plugins_80-dbg-hack.sql
      SET @@global.rocksdb_update_cf_options='cf1={write_buffer_size=8m;target_file_size_base=2m};cf2={write_buffer_size=16m;max_bytes_for_level_multiplier=8};cf3={target_file_size_base=4m};';
      select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
      

      I'm able to reproduce it on both release and debug builds for 8.0.18-9.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kamil.holubicki Kamil Holubicki
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 4 hours, 55 minutes
                  2d 4h 55m