Details
-
Bug
-
Status: In Progress
-
Medium
-
Resolution: Unresolved
-
8.0.x, Not 5.7.x
-
None
-
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
- mentioned in
-
Page Loading...