-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: 5.7.22-22, 8.0.12-2rc1
-
Component/s: MyRocks
-
Labels:
Startup option
--plugin-load-add=RocksDB=ha_rocksdb.so --sql_mode=ONLY_FULL_GROUP_BY
Testcase
# mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so --sql_mode=ONLY_FULL_GROUP_BY CREATE DATABASE test; USE test; CREATE TABLE t1(c1 VARCHAR(1)CHARACTER SET 'utf8' COLLATE 'utf8_bin',c2 YEAR,c3 REAL(1,0) UNSIGNED,PRIMARY KEY(c1)) ENGINE=RocksDB; INSERT INTO t1 VALUES(0,'<foo val=”bar“ />','/dev/null;touch /tmp/blns.fail;echo'); INSERT INTO t1 VALUES('{0}','▒','<img src=x_x13onerror="javascript:alert(1)">'); ALTER TABLE t1 ADD INDEX(c3),ADD UNIQUE (c3);
GDB info
#0 0x00007ffa3458a9b1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000186bb3d in my_write_core (sig=11) at /sda/qa/PS-5.7-trunk_dbg/mysys/stacktrace.c:249 #2 0x0000000000e8eb59 in handle_fatal_signal (sig=11) at /sda/qa/PS-5.7-trunk_dbg/sql/signal_handler.cc:223 #3 <signal handler called> #4 0x00007ffa05c8982a in myrocks::Rdb_string_reader::read (this=0x0, size=@0x7ffa34b77a24: 1) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/././rdb_buff.h:253 #5 0x00007ffa05cd3cd6 in myrocks::Rdb_string_reader::read_uint8 (this=0x0, res=0x7ffa34b77a78) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/./././rdb_buff.h:265 #6 0x00007ffa05cca33a in myrocks::Rdb_key_def::unpack_binary_or_utf8_varchar_space_pad (this=0x7ff9ffc7e498, fpi=0x7ff9ffcf7830, field=0x7ff9ffc17460, dst=0x7ff9ffc17432 "", reader=0x7ffa34b77bb0, unp_reader=0x0) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/rdb_datadic.cc:2442 #7 0x00007ffa05cc82f3 in myrocks::Rdb_key_def::unpack_field (this=0x7ff9ffc7e498, fpi=0x7ff9ffcf7830, field=0x7ff9ffc17460, reader=0x7ffa34b77bb0, default_value=0x7ff9ffc16ec1 "", unp_reader=0x0) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/rdb_datadic.cc:1379 #8 0x00007ffa05cc883d in myrocks::Rdb_key_def::unpack_record (this=0x7ff9ffc7e498, table=0x7ff9ffe5d220, buf=0x7ff9ffc17430 <incomplete sequence \375>, packed_key=0x7ffa34b77e30, unpack_info=0x0, verify_row_debug_checksums=@0x7ff9ffc297a1: false) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/rdb_datadic.cc:1484 #9 0x00007ffa05c7b396 in myrocks::ha_rocksdb::inplace_populate_sk (this=0x7ff9ffc29030, new_table_arg=0x7ff9ffe5d220, indexes=std::unordered_set with 2 elements = {...}) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc:10595 #10 0x00007ffa05c7aadf in myrocks::ha_rocksdb::inplace_alter_table (this=0x7ff9ffc29030, altered_table=0x7ff9ffe5d220, ha_alter_info=0x7ffa34b78890) at /sda/qa/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc:10419 #11 0x00000000015d114d in handler::ha_inplace_alter_table (this=0x7ff9ffc29030, altered_table=0x7ff9ffe5d220, ha_alter_info=0x7ffa34b78890) at /sda/qa/PS-5.7-trunk_dbg/sql/handler.h:3623 #12 0x00000000015c7df7 in mysql_inplace_alter_table (thd=0x7ff9ffc12000, table_list=0x7ffa0008b9f0, table=0x7ff9ffd04a20, altered_table=0x7ff9ffe5d220, ha_alter_info=0x7ffa34b78890, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7ffa34b782d0, alter_ctx=0x7ffa34b78e20) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_table.cc:7784 #13 0x00000000015cdaa0 in mysql_alter_table (thd=0x7ff9ffc12000, new_db=0x7ffa0008bf78 "test", new_name=0x0, create_info=0x7ffa34b79ae0, table_list=0x7ffa0008b9f0, alter_info=0x7ffa34b79a10) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_table.cc:10198 #14 0x000000000173c7dc in Sql_cmd_alter_table::execute (this=0x7ffa0008c0f0, thd=0x7ff9ffc12000) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_alter.cc:338 #15 0x000000000153504a in mysql_execute_command (thd=0x7ff9ffc12000, first_level=true) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_parse.cc:5121 #16 0x000000000153708c in mysql_parse (thd=0x7ff9ffc12000, parser_state=0x7ffa34b7b470) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_parse.cc:5897 #17 0x000000000152bc13 in dispatch_command (thd=0x7ff9ffc12000, com_data=0x7ffa34b7bc50, command=COM_QUERY) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_parse.cc:1493 #18 0x000000000152aa59 in do_command (thd=0x7ff9ffc12000) at /sda/qa/PS-5.7-trunk_dbg/sql/sql_parse.cc:1021 #19 0x000000000166a650 in handle_connection (arg=0x7ff9ffc11040) at /sda/qa/PS-5.7-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:312 #20 0x0000000001d03283 in pfs_spawn_thread (arg=0x7ffa30819e20) at /sda/qa/PS-5.7-trunk_dbg/storage/perfschema/pfs.cc:2190 #21 0x00007ffa34585e25 in start_thread () from /lib64/libpthread.so.0 #22 0x00007ffa3275934d in clone () from /lib64/libc.so.6
- relates to
-
PS-5217 Merge fb-prod201803
-
- Done
-
- links to