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

Assertion "myrocks..ha_rocksdb..info" with innodb_trx_rseg_n_slots_debug

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: 8.0.x
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:
      None

      Description

      sql:

      CREATE DATABASE transforms;
      CREATE DATABASE test;
      USE test;
      create TABLE t1(a int key)engine=RocksDB;
      CREATE TABLE tab1(c1 int,c2 CHAR (1),c3 BLOB) ENGINE=RocksDB;
      set global innodb_trx_rseg_n_slots_debug=1;
      CREATE INDEX idx1 ON tab1(c2(1));
      CREATE TABLE tab1(c1 INT KEY,c2 CHAR (1)) ENGINE=InnoDB;
      

      gdb:

      Core was generated by `/sdc/PS300819-percona-server-8.0.16-7-linux-x86_64-debug/bin/mysqld --no-defaul'.
      Program terminated with signal 11, Segmentation fault.
      #0  0x00007f05ea73d9d1 in __pthread_kill (threadid=<optimized out>, signo=11) 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  0x00007f05ea73d9d1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      #1  0x000000000458b977 in my_write_core (sig=11) at /sdc/ps-8.0-0830_dbg/mysys/stacktrace.cc:284
      #2  0x00000000034ee891 in handle_fatal_signal (sig=11) at /sdc/ps-8.0-0830_dbg/sql/signal_handler.cc:171
      #3  <signal handler called>
      #4  0x00007f0597a42557 in myrocks::ha_rocksdb::info (this=0x7f05831eb028, flag=26) at /sdc/ps-8.0-0830_dbg/storage/rocksdb/ha_rocksdb.cc:10013
      #5  0x00007f0597a35b6a in myrocks::ha_rocksdb::open (this=0x7f05831eb028, name=0x7f0583052c98 "./test/tab1", mode=2, test_if_locked=2, table_def=0x7f05830847d0) at /sdc/ps-8.0-0830_dbg/storage/rocksdb/ha_rocksdb.cc:6274
      #6  0x0000000002f7cfb3 in handler::ha_open (this=0x7f05831eb028, table_arg=0x7f05830aa420, name=0x7f0583052c98 "./test/tab1", mode=2, test_if_locked=2, table_def=0x7f05830847d0) at /sdc/ps-8.0-0830_dbg/sql/handler.cc:2832
      #7  0x00000000034653c0 in open_table_from_share (thd=0x7f0583021000, share=0x7f0583052928, alias=0x7f05831f11e8 "tab1", db_stat=39, prgflag=8, ha_open_flags=0, outparam=0x7f05830aa420, is_create_table=false, table_def_param=0x7f05830847d0) at /sdc/ps-8.0-0830_dbg/sql/table.cc:3285
      #8  0x0000000003242c84 in open_table (thd=0x7f0583021000, table_list=0x7f05831f11f0, ot_ctx=0x7f05e71dfd50) at /sdc/ps-8.0-0830_dbg/sql/sql_base.cc:3378
      #9  0x000000000324685c in open_and_process_table (thd=0x7f0583021000, lex=0x7f0583027800, tables=0x7f05831f11f0, counter=0x7f05e71dff88, prelocking_strategy=0x7f05e71dfe20, has_prelocking_list=false, ot_ctx=0x7f05e71dfd50) at /sdc/ps-8.0-0830_dbg/sql/sql_base.cc:5057
      #10 0x0000000003247cf5 in open_tables (thd=0x7f0583021000, start=0x7f0583027810, counter=0x7f05e71dff88, flags=0, prelocking_strategy=0x7f05e71dfe20) at /sdc/ps-8.0-0830_dbg/sql/sql_base.cc:5706
      #11 0x00000000032543fb in open_tables (thd=0x7f0583021000, tables=0x7f0583027810, counter=0x7f05e71dff88, flags=0) at /sdc/ps-8.0-0830_dbg/sql/sql_base.h:446
      #12 0x00000000033c541f in mysql_create_table (thd=0x7f0583021000, create_table=0x7f05831f11f0, create_info=0x7f05e71e0270, alter_info=0x7f05e71e00f0) at /sdc/ps-8.0-0830_dbg/sql/sql_table.cc:9342
      #13 0x0000000003276dc5 in Sql_cmd_create_table::execute (this=0x7f05831f1b08, thd=0x7f0583021000) at /sdc/ps-8.0-0830_dbg/sql/sql_cmd_ddl_table.cc:319
      #14 0x0000000003316705 in mysql_execute_command (thd=0x7f0583021000, first_level=true) at /sdc/ps-8.0-0830_dbg/sql/sql_parse.cc:3575
      #15 0x000000000331c7d2 in mysql_parse (thd=0x7f0583021000, parser_state=0x7f05e71e1a10, update_userstat=false) at /sdc/ps-8.0-0830_dbg/sql/sql_parse.cc:5427
      #16 0x0000000003311398 in dispatch_command (thd=0x7f0583021000, com_data=0x7f05e71e2b80, command=COM_QUERY) at /sdc/ps-8.0-0830_dbg/sql/sql_parse.cc:1796
      #17 0x000000000330f839 in do_command (thd=0x7f0583021000) at /sdc/ps-8.0-0830_dbg/sql/sql_parse.cc:1293
      #18 0x00000000034d911d in handle_connection (arg=0x7f05d237e560) at /sdc/ps-8.0-0830_dbg/sql/conn_handler/connection_handler_per_thread.cc:308
      #19 0x0000000004677884 in pfs_spawn_thread (arg=0x7f059655fc20) at /sdc/ps-8.0-0830_dbg/storage/perfschema/pfs.cc:2836
      #20 0x00007f05ea738dd5 in start_thread (arg=0x7f05e71e3700) at pthread_create.c:307
      #21 0x00007f05e890802d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      (gdb) quit
      

      I'm able to reproduce this on debug builds only, as it requires innodb_trx_rseg_n_slots_debug.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              hrvoje.matijakovic Hrvoje Matijakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 40 minutes
                  40m