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

RocksDB table crashes with a simple update/check table query

Details

    • Bug
    • Status: In Progress
    • Medium
    • Resolution: Unresolved
    • 8.0.x, Not 5.7.x
    • None
    • MyRocks
    • Yes

    Description

      Server started with RocksDB crashes on an update / check table query. Please find attached MTR testcase to repeat the issue. Also refer to comment section for multiple other testcases that lead to same crash

      5.7 version is not affected.

      Stacktrace:

      #0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x00005611f06cddad in my_write_core (sig=11) at /home/mohit.joshi/mysql-8.0/mysys/stacktrace.cc:409
      #2  0x00005611ef2133bd in handle_fatal_signal (sig=11) at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:194
      #3  <signal handler called>
      #4  0x00005611eeb4d63e in Field::is_virtual_gcol (this=0x5838656c67735732) at /home/mohit.joshi/mysql-8.0/sql/field.h:833
      #5  0x00007f687210a21a in myrocks::ha_rocksdb::fill_virtual_columns (this=0x7f684031d1a8)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:12950
      #6  0x00007f68720fca42 in myrocks::ha_rocksdb::get_row_by_rowid (this=0x7f684031d1a8, buf=0x7f684035e728 "\340\330\002#o\[email protected]\177", 
          rowid=0x7f68403251e0 "", rowid_size=12, skip_lookup=false, skip_ttl_check=true)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:9031
      #7  0x00007f68720fa12f in myrocks::ha_rocksdb::secondary_index_read (this=0x7f684031d1a8, keyno=3, 
          buf=0x7f684035e728 "\340\330\002#o\[email protected]\177") at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:8488
      #8  0x00007f68720fd469 in myrocks::ha_rocksdb::index_next_with_direction_intern (this=0x7f684031d1a8, 
          buf=0x7f684035e728 "\340\330\002#o\[email protected]\177", move_forward=true, skip_next=false)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:9218
      #9  0x00007f68720fcd15 in myrocks::ha_rocksdb::index_next (this=0x7f684031d1a8, buf=0x7f684035e728 "\340\330\002#o\[email protected]\177")
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:9080
      #10 0x00005611eeb3c13f in handler::index_next_same (this=0x7f684031d1a8, buf=0x7f684035e728 "\340\330\002#o\[email protected]\177", 
          key=0x7f6840327c70 "", keylen=5) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:5344
      #11 0x00005611eeb37e20 in handler::ha_index_next_same (this=0x7f684031d1a8, buf=0x7f684035e728 "\340\330\002#o\[email protected]\177", 
          key=0x7f6840327c70 "", keylen=5) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:3728
      #12 0x00005611eeb425e2 in handler::read_range_next (this=0x7f684031d1a8) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:7643
      #13 0x00005611eeb3ff0b in handler::multi_range_read_next (this=0x7f684031d1a8, range_info=0x7f68fc557b98)
          at /home/mohit.joshi/mysql-8.0/sql/handler.cc:6719
      #14 0x00005611eeb3fd11 in handler::ha_multi_range_read_next (this=0x7f684031d1a8, range_info=0x7f68fc557b98)
          at /home/mohit.joshi/mysql-8.0/sql/handler.cc:6673
      #15 0x00005611eede9bbb in QUICK_RANGE_SELECT::get_next (this=0x7f6840380fa0) at /home/mohit.joshi/mysql-8.0/sql/opt_range.cc:10110
      #16 0x00005611eee65b7d in IndexRangeScanIterator::Read (this=0x7f684030fc00) at /home/mohit.joshi/mysql-8.0/sql/records.cc:311
      #17 0x00005611ef12bcb2 in Sql_cmd_update::update_single_table (this=0x7f684030f3b0, thd=0x7f6840010ff0)
          at /home/mohit.joshi/mysql-8.0/sql/sql_update.cc:714
      #18 0x00005611ef12f85f in Sql_cmd_update::execute_inner (this=0x7f684030f3b0, thd=0x7f6840010ff0)
          at /home/mohit.joshi/mysql-8.0/sql/sql_update.cc:1736
      #19 0x00005611ef065cc0 in Sql_cmd_dml::execute (this=0x7f684030f3b0, thd=0x7f6840010ff0) at /home/mohit.joshi/mysql-8.0/sql/sql_select.cc:574
      #20 0x00005611eefdaba1 in mysql_execute_command (thd=0x7f6840010ff0, first_level=true) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:3641
      #21 0x00005611eefe052a in dispatch_sql_command (thd=0x7f6840010ff0, parser_state=0x7f68fc559aa0, update_userstat=false)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:5302
      #22 0x00005611eefd5a86 in dispatch_command (thd=0x7f6840010ff0, com_data=0x7f68fc55ab70, command=COM_QUERY)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1956
      #23 0x00005611eefd3df8 in do_command (thd=0x7f6840010ff0) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1404
      #24 0x00005611ef1fa654 in handle_connection (arg=0x5611f8740d90)
          at /home/mohit.joshi/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:307
      #25 0x00005611f0f6061e in pfs_spawn_thread (arg=0x5611f8735730) at /home/mohit.joshi/mysql-8.0/storage/perfschema/pfs.cc:2899
      #26 0x00007f690bf6f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #27 0x00007f690be96293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              df@tempesta-tech.com Daniel Fiala
              mohit.joshi Mohit Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Time Spent - 3 hours, 14 minutes Remaining Estimate - 1 hour, 4 minutes
                  1h 4m
                  Logged:
                  Time Spent - 3 hours, 14 minutes Remaining Estimate - 1 hour, 4 minutes
                  3h 14m

                  Smart Checklist