[MDEV-23390] Server crash in myrocks::ha_rocksdb::update_stats or internal error after failed TRUNCATE Created: 2020-08-03  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 1
Labels: None


 Description    

--source include/have_partition.inc
 
 
 
INSTALL SONAME 'ha_rocksdb';
 
 
 
CREATE TABLE t1 (
 
    pk INT PRIMARY KEY,
 
    a VARCHAR(1),
 
    KEY(a)
 
) ENGINE=RocksDB PARTITION BY HASH (pk);
 
 
 
ALTER TABLE t1 MODIFY a VARCHAR (2) COLLATE utf8mb4_general_nopad_ci;
 
--error ER_MYROCKS_CANT_NOPAD_COLLATION
 
TRUNCATE t1;
 
SELECT * FROM t1;

10.2 6e09e7c1

 
#3  <signal handler called>
 
#4  0x00007fa4275851d3 in myrocks::ha_rocksdb::update_stats (this=0x7fa42c0994c8) at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:10838
 
#5  0x00007fa42758539f in myrocks::ha_rocksdb::info (this=0x7fa42c0994c8, flag=18) at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:10870
 
#6  0x000055bd9c44f34e in ha_partition::info (this=0x7fa42c0940f8, flag=18) at /data/src/10.2/sql/ha_partition.cc:6650
 
#7  0x000055bd9bbd9329 in TABLE_LIST::fetch_number_of_rows (this=0x7fa42c012638) at /data/src/10.2/sql/table.cc:8298
 
#8  0x000055bd9bb0dfbc in make_join_statistics (join=0x7fa42c012d50, tables_list=..., keyuse_array=0x7fa42c013040) at /data/src/10.2/sql/sql_select.cc:3969
 
#9  0x000055bd9bb05e32 in JOIN::optimize_inner (this=0x7fa42c012d50) at /data/src/10.2/sql/sql_select.cc:1584
 
#10 0x000055bd9bb04324 in JOIN::optimize (this=0x7fa42c012d50) at /data/src/10.2/sql/sql_select.cc:1114
 
#11 0x000055bd9bb0d852 in mysql_select (thd=0x7fa42c000af0, tables=0x7fa42c012638, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa42c012d30, unit=0x7fa42c0046e8, select_lex=0x7fa42c004e28) at /data/src/10.2/sql/sql_select.cc:3819
 
#12 0x000055bd9bb01aa0 in handle_select (thd=0x7fa42c000af0, lex=0x7fa42c004628, result=0x7fa42c012d30, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
 
#13 0x000055bd9bacd4ec in execute_sqlcom_select (thd=0x7fa42c000af0, all_tables=0x7fa42c012638) at /data/src/10.2/sql/sql_parse.cc:6218
 
#14 0x000055bd9bac3d6d in mysql_execute_command (thd=0x7fa42c000af0) at /data/src/10.2/sql/sql_parse.cc:3524
 
#15 0x000055bd9bad1223 in mysql_parse (thd=0x7fa42c000af0, rawbuf=0x7fa42c012458 "SELECT * FROM t1", length=16, parser_state=0x7fa43c6c3610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733
 
#16 0x000055bd9babf54f in dispatch_command (command=COM_QUERY, thd=0x7fa42c000af0, packet=0x7fa42c08cdb1 "SELECT * FROM t1", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
 
#17 0x000055bd9babdfca in do_command (thd=0x7fa42c000af0) at /data/src/10.2/sql/sql_parse.cc:1377
 
#18 0x000055bd9bc14099 in do_handle_one_connection (connect=0x55bd9ee423b0) at /data/src/10.2/sql/sql_connect.cc:1336
 
#19 0x000055bd9bc13e04 in handle_one_connection (arg=0x55bd9ee423b0) at /data/src/10.2/sql/sql_connect.cc:1241
 
#20 0x000055bd9c42aaa8 in pfs_spawn_thread (arg=0x55bd9ed8f0c0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
 
#21 0x00007fa4443184a4 in start_thread (arg=0x7fa43c6c4700) at pthread_create.c:456
 
#22 0x00007fa44244cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Without partitioning server doesn't crash, but SELECT produces an error:

INSTALL SONAME 'ha_rocksdb';
 
 
 
CREATE TABLE t1 (
 
    pk INT PRIMARY KEY,
 
    a VARCHAR(1),
 
    KEY(a)
 
) ENGINE=RocksDB;
 
 
 
ALTER TABLE t1 MODIFY a VARCHAR (2) COLLATE utf8mb4_general_nopad_ci;
 
--error ER_MYROCKS_CANT_NOPAD_COLLATION
 
TRUNCATE t1;
 
SELECT * FROM t1;


mysqltest: At line 12: query 'SELECT * FROM t1' failed: 1815: Internal error: Attempt to open a table that is not present in RocksDB-SE data dictionary

Reproducible on 10.2-10.5, release, debug and ASAN builds alike.

 Comments   
Comment by Elena Stepanova [ 2022-10-01 ]

Same test case, only INSERT instead of SELECT, different stack trace:

--source include/have_partition.inc
 
 
 
INSTALL SONAME 'ha_rocksdb';
 
CREATE TABLE t1 (
 
    pk INT PRIMARY KEY,
 
    a VARCHAR(1),
 
    KEY(a)
 
) ENGINE=RocksDB PARTITION BY HASH (pk);
 
ALTER TABLE t1 MODIFY a VARCHAR (2) COLLATE utf8mb4_general_nopad_ci;
 
--error ER_MYROCKS_CANT_NOPAD_COLLATION
 
TRUNCATE t1;
 
 
 
INSERT INTO t1 VALUES (1,'f');

10.3 2b89598f

 
#3  <signal handler called>
 
#4  0x00007fa288a941c5 in myrocks::ha_rocksdb::check_uniqueness_and_lock (this=0x61c0000488a8, row_info=..., pk_changed=false) at /data/src/10.3/storage/rocksdb/ha_rocksdb.cc:9926
 
#5  0x00007fa288a97d1f in myrocks::ha_rocksdb::update_write_row (this=0x61c0000488a8, old_data=0x0, new_data=0x6190000b4fd0 "\376\001", skip_unique_check=false) at /data/src/10.3/storage/rocksdb/ha_rocksdb.cc:10379
 
#6  0x00007fa288a922fe in myrocks::ha_rocksdb::write_row (this=0x61c0000488a8, buf=0x6190000b4fd0 "\376\001") at /data/src/10.3/storage/rocksdb/ha_rocksdb.cc:9602
 
#7  0x000055837d95a0c3 in handler::ha_write_row (this=0x61c0000488a8, buf=0x6190000b4fd0 "\376\001") at /data/src/10.3/sql/handler.cc:6495
 
#8  0x000055837eb88719 in ha_partition::write_row (this=0x61d0001ffea8, buf=0x6190000b4fd0 "\376\001") at /data/src/10.3/sql/ha_partition.cc:4404
 
#9  0x000055837d959fc4 in handler::ha_write_row (this=0x61d0001ffea8, buf=0x6190000b4fd0 "\376\001") at /data/src/10.3/sql/handler.cc:6495
 
#10 0x000055837d13be19 in write_record (thd=0x62a000060208, table=0x61f00004b488, info=0x7fa289fd9d60) at /data/src/10.3/sql/sql_insert.cc:2054
 
#11 0x000055837d13431e in mysql_insert (thd=0x62a000060208, table_list=0x62b000000338, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.3/sql/sql_insert.cc:1077
 
#12 0x000055837d1d97bb in mysql_execute_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:4505
 
#13 0x000055837d1f14dc in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "INSERT INTO t1 VALUES (1,'f')", length=29, parser_state=0x7fa289fdba00, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7871
 
#14 0x000055837d1c8a82 in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000eb209 "INSERT INTO t1 VALUES (1,'f')", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
 
#15 0x000055837d1c565e in do_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:1398
 
#16 0x000055837d587068 in do_handle_one_connection (connect=0x608000000ca8) at /data/src/10.3/sql/sql_connect.cc:1403
 
#17 0x000055837d586964 in handle_one_connection (arg=0x608000000ca8) at /data/src/10.3/sql/sql_connect.cc:1308
 
#18 0x000055837eb31a67 in pfs_spawn_thread (arg=0x615000004408) at /data/src/10.3/storage/perfschema/pfs.cc:1869
 
#19 0x00007fa294b1dea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
 
#20 0x00007fa294a3daef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Generated at Thu Feb 08 09:22:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.