[MDEV-17166] [Draft] Server crashes in in heap_check_heap Created: 2018-09-10  Updated: 2019-09-26  Resolved: 2019-09-26

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.1, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-18783 Server crash in hp_rb_make_key, ASAN ... Closed

 Description   

10.1 f1bcfbb4373e40dda2c18c137f76fc6ff32e1a45

Version: '10.1.37-MariaDB-debug'  socket: '/home/travis/logs/vardir/mysql.sock'  port: 19300  Source distribution
2018-09-08 22:38:47 7f3c7c2cdb00  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
2018-09-08 22:38:47 139897758079744 [ERROR] InnoDB: Cannot rename file './testdb_N/t1_base2_N.ibd' to './testdb_S/t1_base2_N.ibd'
2018-09-08 22:39:07 139897756261120 [ERROR] Event Scheduler: [rqg@localhost][testdb_S.e1_1_S] Table 'testdb_S.t1_part1_N' doesn't exist
180908 22:39:07 [ERROR] mysqld got signal 11 ;
 
Query (0x7f3c58004688): FLUSH TABLES /* QNO 2818 CON_ID 12 */
Connection ID (thread ID): 48
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off

#3  <signal handler called>
#4  0x000055874eb9d4c6 in heap_check_heap (info=0x7f3c580417a0, print_status=0 '\000') at /home/travis/src/storage/heap/_check.c:82
#5  0x000055874eb9c18d in hp_close (info=0x7f3c580417a0) at /home/travis/src/storage/heap/hp_close.c:39
#6  0x000055874eb9c104 in heap_close (info=0x7f3c580417a0) at /home/travis/src/storage/heap/hp_close.c:28
#7  0x000055874eb93dc7 in ha_heap::close (this=0x7f3c58040e68) at /home/travis/src/storage/heap/ha_heap.cc:141
#8  0x000055874e9e6d43 in handler::ha_close (this=0x7f3c58040e68) at /home/travis/src/sql/handler.cc:2599
#9  0x000055874e88ee89 in closefrm (table=0x7f3c58040220, free_share=true) at /home/travis/src/sql/table.cc:3063
#10 0x000055874e72dfa1 in intern_close_table (table=0x7f3c58040220) at /home/travis/src/sql/sql_base.cc:354
#11 0x000055874e9681c6 in tc_purge (mark_flushed=true) at /home/travis/src/sql/table_cache.cc:204
#12 0x000055874e72e3c4 in close_cached_tables (thd=0x5587525f49b0, tables=0x0, wait_for_refresh=true, timeout=10) at /home/travis/src/sql/sql_base.cc:485
#13 0x000055874e909d6b in reload_acl_and_cache (thd=0x5587525f49b0, options=4, tables=0x0, write_to_binlog=0x7f3c7c2cbd70) at /home/travis/src/sql/sql_reload.cc:343
#14 0x000055874e7a1cc0 in mysql_execute_command (thd=0x5587525f49b0) at /home/travis/src/sql/sql_parse.cc:4885
#15 0x000055874e7a9230 in mysql_parse (thd=0x5587525f49b0, rawbuf=0x7f3c58004688 "FLUSH TABLES /* QNO 2818 CON_ID 12 */", length=37, parser_state=0x7f3c7c2cc630) at /home/travis/src/sql/sql_parse.cc:7465
#16 0x000055874e797ab1 in dispatch_command (command=COM_QUERY, thd=0x5587525f49b0, packet=0x55875254bda1 "FLUSH TABLES /* QNO 2818 CON_ID 12 */ ", packet_length=38) at /home/travis/src/sql/sql_parse.cc:1495
#17 0x000055874e796831 in do_command (thd=0x5587525f49b0) at /home/travis/src/sql/sql_parse.cc:1124
#18 0x000055874e8d1e99 in do_handle_one_connection (thd_arg=0x5587525f49b0) at /home/travis/src/sql/sql_connect.cc:1330
#19 0x000055874e8d1bfd in handle_one_connection (arg=0x5587525f49b0) at /home/travis/src/sql/sql_connect.cc:1242
#20 0x00007f3c958f6184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#21 0x00007f3c95018ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

github.com/elenst/rqg mdev15376 aa7bc7508b939e11fc7e444384290d5950a06f4f

perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --seed=1530946075 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--default-storage-engine=MyISAM --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --mysqld=--log-bin --transformers=ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --threads=6

No information yet on whether it's reproducible


Generated at Thu Feb 08 08:34:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.