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

partition table created with RocksDB engine crashes on a select query

Details

    Description

      While testing RocksDB storage engine, a crash is seen with a simple select query. (refer attached MTR testcase)

      Stacktrace:

      #0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055bd8c8d6765 in my_write_core (sig=11) at /home/mohit.joshi/mysql-8.0/mysys/stacktrace.cc:409
      #2  0x000055bd8b5bd893 in handle_fatal_signal (sig=11) at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:194
      #3  <signal handler called>
      #4  __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:328
      #5  0x00007f8f77992932 in myrocks::Rdb_key_def::unpack_binary_varlength (fpi=0x7f8f7e358900, ctx=0x7f902859fd70, dst=0x7f8f7e219c01 "\n", 
          reader=0x7f902859fea0, unp_reader=0x7f902859feb0) at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rdb_datadic.cc:3243
      #6  0x00007f8f77989efb in myrocks::Rdb_convert_to_record_key_decoder::decode_field (fpi=0x7f8f7e358900, table=0x7f8f7e21a550, 
          buf=0x7f8f7e219b48 "\300 ", reader=0x7f902859fea0, unpack_reader=0x7f902859feb0)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rdb_datadic.cc:105
      #7  0x00007f8f77989fb3 in myrocks::Rdb_convert_to_record_key_decoder::decode (buf=0x7f8f7e219b48 "\300 ", fpi=0x7f8f7e358900, 
          table=0x7f8f7e21a550, has_unpack_info=true, reader=0x7f902859fea0, unpack_reader=0x7f902859feb0)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rdb_datadic.cc:135
      #8  0x00007f8f7798a3ba in myrocks::Rdb_key_field_iterator::next (this=0x7f902859fee0)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rdb_datadic.cc:246
      #9  0x00007f8f779908f7 in myrocks::Rdb_key_def::unpack_record (this=0x7f8f7e358380, table=0x7f8f7e21a550, buf=0x7f8f7e219b48 "\300 ", 
          packed_key=0x7f902859ffd0, unpack_info=0x7f902859ffe0, verify_row_debug_checksums=false)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rdb_datadic.cc:2119
      #10 0x00007f8f77919319 in myrocks::ha_rocksdb::index_next_with_direction_intern (this=0x7f8f7e34c698, buf=0x7f8f7e219b48 "\300 ", 
          move_forward=true, skip_next=false) at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:9190
      #11 0x00007f8f77918d35 in myrocks::ha_rocksdb::index_next (this=0x7f8f7e34c698, buf=0x7f8f7e219b48 "\300 ")
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:9080
      #12 0x000055bd8aeea8b4 in handler::ha_index_next (this=0x7f8f7e34c698, buf=0x7f8f7e219b48 "\300 ")
          at /home/mohit.joshi/mysql-8.0/sql/handler.cc:3556
      #13 0x000055bd8aef653c in handler::read_range_next (this=0x7f8f7e34c698) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:7649
      #14 0x000055bd8aec67df in native_part::Partition_base::read_range_next_in_part (this=0x7f8f7e1d9cd8, part=1, buf=0x0)
          at /home/mohit.joshi/mysql-8.0/sql/partitioning/partition_base.cc:2741
      #15 0x000055bd8b1fab30 in Partition_helper::handle_unordered_next (this=0x7f8f7e1db500, buf=0x7f8f7e219b48 "\300 ", is_next_same=false)
          at /home/mohit.joshi/mysql-8.0/sql/partitioning/partition_handler.cc:2343
      #16 0x000055bd8b1fa739 in Partition_helper::ph_read_range_next (this=0x7f8f7e1db500)
          at /home/mohit.joshi/mysql-8.0/sql/partitioning/partition_handler.cc:2229
      #17 0x000055bd8aecf9ee in native_part::Partition_base::read_range_next (this=0x7f8f7e1d9cd8)
          at /home/mohit.joshi/mysql-8.0/sql/partitioning/partition_base.h:436
      #18 0x000055bd8aef3dc9 in handler::multi_range_read_next (this=0x7f8f7e1d9cd8, range_info=0x7f90285a03f8)
          at /home/mohit.joshi/mysql-8.0/sql/handler.cc:6718
      #19 0x000055bd8aef3bcf in handler::ha_multi_range_read_next (this=0x7f8f7e1d9cd8, range_info=0x7f90285a03f8)
          at /home/mohit.joshi/mysql-8.0/sql/handler.cc:6672#20 0x000055bd8b19cc5d in QUICK_RANGE_SELECT::get_next (this=0x7f8f7ed77ee0) at /home/mohit.joshi/mysql-8.0/sql/opt_range.cc:10110
      #21 0x000055bd8b216bf7 in IndexRangeScanIterator::Read (this=0x7f8f7f2ddc98) at /home/mohit.joshi/mysql-8.0/sql/records.cc:311
      #22 0x000055bd8b4d9667 in Query_expression::ExecuteIteratorQuery (this=0x7f8f7f289c98, thd=0x7f8f7c015080)
          at /home/mohit.joshi/mysql-8.0/sql/sql_union.cc:1231
      #23 0x000055bd8b4d99f0 in Query_expression::execute (this=0x7f8f7f289c98, thd=0x7f8f7c015080)
          at /home/mohit.joshi/mysql-8.0/sql/sql_union.cc:1284
      #24 0x000055bd8b41a936 in Sql_cmd_dml::execute_inner (this=0x7f8f7f2dc2d0, thd=0x7f8f7c015080)
          at /home/mohit.joshi/mysql-8.0/sql/sql_select.cc:791
      #25 0x000055bd8b419df4 in Sql_cmd_dml::execute (this=0x7f8f7f2dc2d0, thd=0x7f8f7c015080) at /home/mohit.joshi/mysql-8.0/sql/sql_select.cc:575
      #26 0x000055bd8b393dea in mysql_execute_command (thd=0x7f8f7c015080, first_level=true) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:4677
      #27 0x000055bd8b395f0c in dispatch_sql_command (thd=0x7f8f7c015080, parser_state=0x7f90285a1aa0, update_userstat=false)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:5273
      #28 0x000055bd8b38b4db in dispatch_command (thd=0x7f8f7c015080, com_data=0x7f90285a2b70, command=COM_QUERY)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1938
      #29 0x000055bd8b38984b in do_command (thd=0x7f8f7c015080) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1386
      #30 0x000055bd8b5a4c0a in handle_connection (arg=0x55bd933fb300)
          at /home/mohit.joshi/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:307
      #31 0x000055bd8d16399a in pfs_spawn_thread (arg=0x55bd935501d0) at /home/mohit.joshi/mysql-8.0/storage/perfschema/pfs.cc:2899
      #32 0x00007f903d765609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #33 0x00007f903d68c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Steps to repeat:

      Step 1: Copy the testcase in rocksdb test suite
      Step 2: ./mtr rocksdb.bug7827

       

      Attachments

        Issue Links

          Activity

            People

              marcelo.altmann Marcelo Altmann
              mohit.joshi Mohit Joshi
              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:
                  Time Spent - 1 day, 32 minutes Remaining Estimate - 48 minutes
                  48m
                  Logged:
                  Time Spent - 1 day, 32 minutes Remaining Estimate - 48 minutes
                  1d 32m

                  Smart Checklist