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

handle_fatal_signal (sig=11) in myrocks::Rdb_dict_manager::get_value when querying I_S when MyRocks is not loaded, but rocksdb_global_info is

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 5.7.20-18
    • Fix Version/s: 5.7.21-20
    • Component/s: MyRocks
    • Labels:
      None

      Description

      INSTALL PLUGIN rocksdb_global_info SONAME 'ha_rocksdb.so';
      select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;

      Will crash PS if MyRocks is otherwise not loaded. 

      2017-12-29T22:44:23.540838Z 0 [Note] /sda/PS281217-percona-server-5.7.20-18-linux-x86_64-debug/bin/mysqld: ready for connections.
      Version: '5.7.20-18-debug' socket: '/sda/PS281217-percona-server-5.7.20-18-linux-x86_64-debug/socket.sock' port: 10695 MySQL Community Server (GPL)
      2017-12-29T22:44:23.540854Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
      2017-12-29T22:44:23.540861Z 0 [Note] Beginning of list of non-natively partitioned tables
      2017-12-29T22:44:23.571528Z 0 [Note] End of list of non-natively partitioned tables
      22:44:30 UTC - mysqld got signal 11 ;
      
      Core was generated by `/sda/PS281217-percona-server-5.7.20-18-linux-x86_64-debug/bin/mysqld --no-defau'.
      Program terminated with signal 11, Segmentation fault.
      #0 0x00007fa82c8f19b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      61	val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
      (gdb) bt
      #0 0x00007fa82c8f19b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1 0x000000000186b89d in my_write_core (sig=11) at /git/PS-5.7-new/PS-5.7-trunk_dbg/mysys/stacktrace.c:249
      #2 0x0000000000e8e8b9 in handle_fatal_signal (sig=11) at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/signal_handler.cc:223
      #3 <signal handler called>
      #4 0x00007fa7eb8cdaca in myrocks::Rdb_dict_manager::get_value (this=0x7fa7ec3d9740 <myrocks::dict_manager>, key=..., 
      value=0x7fa82cedd800) at /git/PS-5.7-new/PS-5.7-trunk_dbg/storage/rocksdb/rdb_datadic.cc:4266
      #5 0x00007fa7eb8cf398 in myrocks::Rdb_dict_manager::get_max_index_id (this=0x7fa7ec3d9740 <myrocks::dict_manager>, 
      index_id=0x7fa82ceddb9c) at /git/PS-5.7-new/PS-5.7-trunk_dbg/storage/rocksdb/rdb_datadic.cc:4781
      #6 0x00007fa7eb8ffa78 in myrocks::rdb_i_s_global_info_fill_table (thd=0x7fa7ba812000, tables=0x7fa7bab3ed00, cond=0x0)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/storage/rocksdb/rdb_i_s.cc:744
      #7 0x00000000015ad8df in do_fill_table (thd=0x7fa7ba812000, table_list=0x7fa7bab3ed00, qep_tab=0x7fa7bad68408)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_show.cc:8770
      #8 0x00000000015addd7 in get_schema_tables_result (join=0x7fa7bad68030, executed_place=PROCESSED_BY_JOIN_EXEC)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_show.cc:8900
      #9 0x0000000001583863 in JOIN::prepare_result (this=0x7fa7bad68030) at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_select.cc:910
      #10 0x00000000014e4e6c in JOIN::exec (this=0x7fa7bad68030) at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_executor.cc:124
      #11 0x0000000001582439 in handle_query (thd=0x7fa7ba812000, lex=0x7fa7ba814620, result=0x7fa7bab3f790, added_options=0, 
      removed_options=0) at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_select.cc:185
      #12 0x0000000001535dd4 in execute_sqlcom_select (thd=0x7fa7ba812000, all_tables=0x7fa7bab3ed00)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_parse.cc:5449
      #13 0x000000000152eef2 in mysql_execute_command (thd=0x7fa7ba812000, first_level=true)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_parse.cc:2943
      #14 0x0000000001536dec in mysql_parse (thd=0x7fa7ba812000, parser_state=0x7fa82cedf4b0)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_parse.cc:5897
      #15 0x000000000152b973 in dispatch_command (thd=0x7fa7ba812000, com_data=0x7fa82cedfc90, command=COM_QUERY)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_parse.cc:1493
      #16 0x000000000152a7b9 in do_command (thd=0x7fa7ba812000) at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/sql_parse.cc:1021
      #17 0x000000000166a3b0 in handle_connection (arg=0x7fa7ba811040)
      at /git/PS-5.7-new/PS-5.7-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #18 0x000000000189aee7 in pfs_spawn_thread (arg=0x7fa81efebd20) at /git/PS-5.7-new/PS-5.7-trunk_dbg/storage/perfschema/pfs.cc:2190
      #19 0x00007fa82c8ece25 in start_thread (arg=0x7fa82cee0700) at pthread_create.c:308
      #20 0x00007fa82accc34d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

        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:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: