Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
mysqld: 10.4/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
|
180814 12:53:38 [ERROR] mysqld got signal 6 ;
|
Server version: 10.4.0-MariaDB-debug-log
|
|
stdlib/abort.c:91(__GI_abort)[0x7fb7bf7ce02a]
|
assert/assert.c:92(__assert_fail_base)[0x7fb7bf7c4bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb7bf7c4c82]
|
myisam/mi_open.c:68(test_if_reopen)[0x558c80bbe37b]
|
myisam/mi_open.c:122(mi_open)[0x558c80bbe74a]
|
myisam/ha_myisam.cc:782(ha_myisam::open(char const*, int, unsigned int))[0x558c80b4c7b3]
|
sql/handler.cc:2684(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x558c80476cdb]
|
sql/ha_partition.cc:8422(ha_partition::open_read_partitions(char*, unsigned long))[0x558c8148da22]
|
sql/ha_partition.cc:3588(ha_partition::open(char const*, int, unsigned int))[0x558c8146877d]
|
sql/handler.cc:2684(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x558c80476cdb]
|
sql/table.cc:3499(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x558c8002f7c1]
|
sql/sql_base.cc:1953(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x558c7fc466c8]
|
sql/sql_base.cc:3554(open_and_process_table(THD*, LEX*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x558c7fc4d668]
|
sql/sql_base.cc:4074(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x558c7fc4ff84]
|
sql/sql_base.h:248(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x558c7fc3e20d]
|
sql/sql_base.cc:5012(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x558c7fc54a84]
|
sql/sql_base.cc:5062(open_tables_only_view_structure(THD*, TABLE_LIST*, bool))[0x558c7fc54ee8]
|
sql/sql_show.cc:4573(fill_schema_table_by_open(THD*, st_mem_root*, bool, TABLE*, st_schema_table*, st_mysql_const_lex_string*, st_mysql_const_lex_string*, Open_tables_backup*, bool))[0x558c7ff1ebd8]
|
sql/sql_show.cc:5099(get_all_tables(THD*, TABLE_LIST*, Item*))[0x558c7ff2118f]
|
sql/sql_show.cc:8775(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x558c7ff50dd0]
|
sql/sql_select.cc:4038(JOIN::exec_inner())[0x558c7fe4ce05]
|
sql/sql_select.cc:3871(JOIN::exec())[0x558c7fe4b180]
|
sql/sql_select.cc:4277(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x558c7fe4e50b]
|
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558c7fe28c37]
|
sql/sql_parse.cc:6546(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558c7fdae861]
|
sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x558c7fd9d074]
|
sql/sql_parse.cc:8064(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558c7fdb6ca5]
|
sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558c7fd91dcb]
|
sql/sql_parse.cc:1392(do_command(THD*))[0x558c7fd8ef63]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x558c800df768]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x558c800df145]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb7c04096ba]
|
x86_64/clone.S:111(clone)[0x7fb7bf89e41d]
|
See comments for further details.
Attachments
Issue Links
- relates to
-
MDEV-11539 test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S
- Closed
-
MDEV-21746 Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed in test_if_reopen upon SELECT from temporary table
- Closed
Activity
Here is another test case, which doesn't involve triggers or views:
CREATE TABLE t1 (a INT) ENGINE=MyISAM; |
LOCK TABLE t1 WRITE; |
--error ER_BAD_FIELD_ERROR
|
ALTER TABLE t1 ADD b INT, LOCK=EXCLUSIVE, ORDER BY x; |
SHOW TABLE STATUS; |
|
# Cleanup
|
UNLOCK TABLES;
|
DROP TABLE t1; |
10.1 15f06559 |
mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
190505 1:06:22 [ERROR] mysqld got signal 6 ;
|
|
#6 0x00007fd2d3447e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:92
|
#7 0x00007fd2d3447f12 in __GI___assert_fail (assertion=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=67, function=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:101
|
#8 0x00005620de09d9c7 in test_if_reopen (filename=0x7fd2d4e6c2a0 "/data/bld/10.1-debug/mysql-test/var/mysqld.1/data/test/t1.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
|
#9 0x00005620de09dbe0 in mi_open (name=0x7fd2ca865d60 "./test/t1", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122
|
#10 0x00005620de0717f7 in ha_myisam::open (this=0x7fd2ca8ae888, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
|
#11 0x00005620dddeb874 in handler::ha_open (this=0x7fd2ca8ae888, table_arg=0x7fd2ca880a70, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2535
|
#12 0x00005620ddc99146 in open_table_from_share (thd=0x7fd2cc7cd070, share=0x7fd2ca865888, alias=0x7fd2ca8fff60 "t1", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fd2ca880a70, is_create_table=false) at /data/src/10.1/sql/table.cc:2975
|
#13 0x00005620ddb3c580 in open_table (thd=0x7fd2cc7cd070, table_list=0x7fd2ca9de270, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:2585
|
#14 0x00005620ddb3efab in open_and_process_table (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058, has_prelocking_list=false, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:4162
|
#15 0x00005620ddb3ffb9 in open_tables (thd=0x7fd2cc7cd070, options=..., start=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, sroutine_to_open_list=0x7fd2d4e6e288, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.cc:4648
|
#16 0x00005620ddb376f2 in open_tables (thd=0x7fd2cc7cd070, options=..., tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:264
|
#17 0x00005620ddb37743 in open_tables (thd=0x7fd2cc7cd070, tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:272
|
#18 0x00005620ddb4187d in open_normal_and_derived_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5459
|
#19 0x00005620ddc379d2 in fill_schema_table_by_open (thd=0x7fd2cc7cd070, is_show_fields_or_keys=false, table=0x7fd2ca9dc088, schema_table=0x5620ded019a0 <schema_tables+1920>, orig_db_name=0x7fd2ca8ff8d8, orig_table_name=0x7fd2ca8fff00, open_tables_state_backup=0x7fd2d4e6f800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4278
|
#20 0x00005620ddc3915e in get_all_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca8fb880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4924
|
#21 0x00005620ddc47efb in get_schema_tables_result (join=0x7fd2ca8fd900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8280
|
#22 0x00005620ddbe7600 in JOIN::exec_inner (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2714
|
#23 0x00005620ddbe6cab in JOIN::exec (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2562
|
#24 0x00005620ddbea239 in mysql_select (thd=0x7fd2cc7cd070, rref_pointer_array=0x7fd2cc7d1560, tables=0x7fd2ca8fb880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fd2ca8fd8e0, unit=0x7fd2cc7d0bb8, select_lex=0x7fd2cc7d12b8) at /data/src/10.1/sql/sql_select.cc:3499
|
#25 0x00005620ddbdf923 in handle_select (thd=0x7fd2cc7cd070, lex=0x7fd2cc7d0af0, result=0x7fd2ca8fd8e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:376
|
#26 0x00005620ddbaf0f2 in execute_sqlcom_select (thd=0x7fd2cc7cd070, all_tables=0x7fd2ca8fb880) at /data/src/10.1/sql/sql_parse.cc:5951
|
#27 0x00005620ddba5453 in mysql_execute_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:3038
|
#28 0x00005620ddbb2d6b in mysql_parse (thd=0x7fd2cc7cd070, rawbuf=0x7fd2ca8fa088 "SHOW TABLE STATUS", length=17, parser_state=0x7fd2d4e711e0) at /data/src/10.1/sql/sql_parse.cc:7469
|
#29 0x00005620ddba1465 in dispatch_command (command=COM_QUERY, thd=0x7fd2cc7cd070, packet=0x7fd2ce7f0071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499
|
#30 0x00005620ddba0223 in do_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:1131
|
#31 0x00005620ddcdb745 in do_handle_one_connection (thd_arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1330
|
#32 0x00005620ddcdb48b in handle_one_connection (arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1242
|
#33 0x00005620de10ea8c in pfs_spawn_thread (arg=0x7fd2d2c39c70) at /data/src/10.1/storage/perfschema/pfs.cc:1861
|
#34 0x00007fd2d4aee4a4 in start_thread (arg=0x7fd2d4e72700) at pthread_create.c:456
|
#35 0x00007fd2d3504d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
I am getting the same assertion with BACKUP STAGE BLOCK_COMMIT on 10.5:
10.5 05fa4558e0e82302ece981dea |
mysqld: /10.5/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
200731 16:10:30 [ERROR] mysqld got signal 6 ;
|
|
myisam/mi_open.c:68(test_if_reopen)[0x55750d023bd8]
|
myisam/mi_open.c:122(mi_open)[0x55750cfa325d]
|
myisam/ha_myisam.cc:807(ha_myisam::open(char const*, int, unsigned int))[0x55750bc0557c]
|
sql/handler.cc:2977(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x55750b7682f0]
|
sql/table.cc:4196(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x55750b286728]
|
sql/sql_base.cc:607(flush_tables(THD*, flush_tables_type))[0x55750ba615f0]
|
sql/backup.cc:257(backup_block_ddl(THD*))[0x55750ba609f3]
|
sql/backup.cc:113(run_backup_stage(THD*, backup_stages))[0x55750b431c1c]
|
sql/sql_parse.cc:5109(mysql_execute_command(THD*))[0x55750b4453af]
|
sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55750b41be4a]
|
sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55750b4186c8]
|
sql/sql_parse.cc:1347(do_command(THD*))[0x55750b846aba]
|
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55750b846413]
|
sql/sql_connect.cc:1314(handle_one_connection)[0x55750c50aee7]
|
nptl/pthread_create.c:463(start_thread)[0x7f811ae6a6db]
|
x86_64/clone.S:97(clone)[0x7f811a050a3f]
|
|
Query (0x62b0000e72a8): BACKUP STAGE BLOCK_COMMIT
|
USE test;
|
SET SQL_MODE='';
|
CREATE TABLE t (a INT PRIMARY KEY) ENGINE=MyISAM;
|
LOCK TABLE t WRITE;
|
CREATE TRIGGER t AFTER DELETE ON t FOR EACH ROW SET @log:= concat(@log, "(AFTER_DELETE: old=(id=", old.id, ", data=", old.data,"))");
|
SHOW TABLE STATUS LIKE 't';
|
Leads to:
10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug) |
mysqld: /test/10.4_dbg/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug) |
Core was generated by `/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
[Current thread is 1 (Thread 0x14866ece1700 (LWP 1231945))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x00005625e4a3c8a6 in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:482
|
#2 0x00005625e41b8cdc in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:343
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x000014866cf788b1 in __GI_abort () at abort.c:79
|
#6 0x000014866cf6842a in __assert_fail_base (fmt=0x14866d0efa38 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:92
|
#7 0x000014866cf684a2 in __GI___assert_fail (assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:101
|
#8 0x00005625e48f7de0 in test_if_reopen (filename=filename@entry=0x14866ecd7a80 "/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/data/test/t.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66
|
#9 0x00005625e48fa614 in mi_open (name=0x148647cbbc18 "./test/t", mode=2, open_flags=open_flags@entry=82) at /test/10.4_dbg/storage/myisam/mi_open.c:122
|
#10 0x00005625e48d6847 in ha_myisam::open (this=0x148647c7a888, name=<optimized out>, mode=<optimized out>, test_if_locked=18) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:807
|
#11 0x00005625e41c0104 in handler::ha_open (this=0x148647c7a888, table_arg=table_arg@entry=0x148647d2f070, name=0x148647cbbc18 "./test/t", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.4_dbg/sql/handler.cc:2782
|
#12 0x00005625e4004d39 in open_table_from_share (thd=thd@entry=0x148647c15070, share=share@entry=0x148647cbb688, alias=alias@entry=0x148647d26110, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=<optimized out>, is_create_table=<optimized out>, partitions_to_open=<optimized out>) at /test/10.4_dbg/sql/table.cc:3981
|
#13 0x00005625e3e84a04 in open_table (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, ot_ctx=ot_ctx@entry=0x14866ecd9bf0) at /test/10.4_dbg/sql/sql_base.cc:2083
|
#14 0x00005625e3e89070 in open_and_process_table (ot_ctx=0x14866ecd9bf0, has_prelocking_list=false, prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x148647d260c8, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.cc:3893
|
#15 open_tables (thd=thd@entry=0x148647c15070, options=@0x14866ecdb3c8: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x14866ecd9c78, counter=counter@entry=0x14866ecd9c84, flags=flags@entry=1346, prelocking_strategy=prelocking_strategy@entry=0x14866ecd9c88) at /test/10.4_dbg/sql/sql_base.cc:4365
|
#16 0x00005625e3e8a54a in open_tables (prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x14866ecd9c78, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.h:258
|
#17 open_normal_and_derived_tables (thd=thd@entry=0x148647c15070, tables=<optimized out>, tables@entry=0x148647d260c8, flags=1346, dt_phases=dt_phases@entry=35) at /test/10.4_dbg/sql/sql_base.cc:5332
|
#18 0x00005625e3e8a702 in open_tables_only_view_structure (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, can_deadlock=can_deadlock@entry=true) at /test/10.4_dbg/sql/sql_base.cc:5383
|
#19 0x00005625e3f8b30a in fill_schema_table_by_open (thd=thd@entry=0x148647c15070, mem_root=mem_root@entry=0x14866ecdbb00, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x148647cf9088, schema_table=schema_table@entry=0x5625e55d3e20 <schema_tables+2048>, orig_db_name=orig_db_name@entry=0x148647c73000, orig_table_name=0x148647d21fc8, open_tables_state_backup=0x14866ecdbb50, can_deadlock=true) at /test/10.4_dbg/sql/sql_show.cc:4669
|
#20 0x00005625e3fa0eec in get_all_tables (thd=0x148647c15070, tables=0x148647c6edb0, cond=<optimized out>) at /test/10.4_dbg/sql/sql_show.cc:5307
|
#21 0x00005625e3fa2d63 in get_schema_tables_result (join=join@entry=0x148647c711e8, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.4_dbg/sql/sql_show.cc:8949
|
#22 0x00005625e3f826dd in JOIN::exec_inner (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4430
|
#23 0x00005625e3f8304d in JOIN::exec (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4255
|
#24 0x00005625e3f813f3 in mysql_select (thd=thd@entry=0x148647c15070, tables=<optimized out>, wild_num=0, fields=@0x148647c198d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x148647c6d6f8, last = 0x148647c6ed70, elements = 20}, <No data fields>}, conds=0x0, og_num=<optimized out>, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x148647c711c0, unit=0x148647c18f98, select_lex=0x148647c19790) at /test/10.4_dbg/sql/sql_select.cc:4687
|
#25 0x00005625e3f8171e in handle_select (thd=thd@entry=0x148647c15070, lex=lex@entry=0x148647c18ed8, result=result@entry=0x148647c711c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_dbg/sql/sql_select.cc:410
|
#26 0x00005625e3efa3c6 in execute_sqlcom_select (thd=thd@entry=0x148647c15070, all_tables=0x148647c6edb0) at /test/10.4_dbg/sql/sql_parse.cc:6355
|
#27 0x00005625e3f0579a in mysql_execute_command (thd=thd@entry=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:3889
|
#28 0x00005625e3f10090 in mysql_parse (thd=thd@entry=0x148647c15070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14866ece0460, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7896
|
#29 0x00005625e3f12920 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148647c15070, packet=packet@entry=0x148647c57071 "SHOW TABLE STATUS LIKE 't'", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:1834
|
#30 0x00005625e3f1635b in do_command (thd=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:1352
|
#31 0x00005625e40428b6 in do_handle_one_connection (connect=connect@entry=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1412
|
#32 0x00005625e40429d6 in handle_one_connection (arg=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1316
|
#33 0x000014866dedf6db in start_thread (arg=0x14866ece1700) at pthread_create.c:463
|
#34 0x000014866d059a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.1.47 (dbg), 10.2.34 (dbg), 10.3.25 (dbg), 10.4.15 (dbg)
Bug confirmed not present in:
MariaDB: 10.1.47 (opt), 10.2.34 (opt), 10.3.25 (opt), 10.4.15 (opt), 10.5.6 (dbg), 10.5.6 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)
Another testcase leads to a slightly different stack on latest 10.4 debug build.
Unique id
strcmp(share->unique_file_name,filename) || share->last_version|SIGABRT|test_if_reopen|mi_create|ha_myisam::create|handler::ha_create
|
SET SQL_MODE=''; |
SET SESSION storage_engine='MyISAM'; |
CREATE TABLE t (a INT,b INT,KEY(a)); |
INSERT INTO t VALUES (0,0); |
INSERT DELAYED INTO t VALUES (mod (0,0),'test0'); |
CREATE TABLE t0 (a INT,b BLOB,UNIQUE (b)) IGNORE AS SELECT * FROM t; |
CREATE TABLE t0 (a INT); |
Leads to:
10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug) |
mariadbd: /test/10.4_dbg/storage/myisam/mi_open.c:66: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug) |
Core was generated by `/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14cb9018c700 (LWP 873459))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014cb92651859 in __GI_abort () at abort.c:79
|
#2 0x000014cb92651729 in __assert_fail_base (fmt=0x14cb927e7588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=66, function=<optimized out>) at assert.c:92
|
#3 0x000014cb92662fd6 in __GI___assert_fail (assertion=assertion@entry=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=66, function=function@entry=0x55c3a69520a8 <__PRETTY_FUNCTION__.18678> "test_if_reopen") at assert.c:101
|
#4 0x000055c3a65143b4 in test_if_reopen (filename=filename@entry=0x14cb901864c0 "/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/data/test/t0.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66
|
#5 0x000055c3a65090fc in mi_create (name=0x14cb90187390 "./test/t0", keys=keys@entry=0, keydefs=keydefs@entry=0x14cb28080358, columns=columns@entry=2, recinfo=recinfo@entry=0x14cb28080298, uniques=uniques@entry=0, uniquedefs=0x0, ci=0x14cb90187350, flags=0) at /test/10.4_dbg/storage/myisam/mi_create.c:639
|
#6 0x000055c3a64f90a7 in ha_myisam::create (this=<optimized out>, name=0x14cb90189480 "./test/t0", table_arg=<optimized out>, ha_create_info=<optimized out>) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:2319
|
#7 0x000055c3a5d65c79 in handler::ha_create (this=0x14cb2807fb30, name=0x14cb90189480 "./test/t0", form=form@entry=0x14cb901876c0, info_arg=info_arg@entry=0x14cb90189850) at /test/10.4_dbg/sql/handler.cc:4837
|
#8 0x000055c3a5d6683f in ha_create_table (thd=thd@entry=0x14cb28000d28, path=path@entry=0x14cb90189480 "./test/t0", db=0x14cb28012c98 "test", table_name=0x14cb28012570 "t0", create_info=create_info@entry=0x14cb90189850, frm=frm@entry=0x14cb90189470) at /test/10.4_dbg/sql/handler.cc:5305
|
#9 0x000055c3a5b9aa15 in create_table_impl (thd=thd@entry=0x14cb28000d28, orig_db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, orig_table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, path=path@entry=0x14cb90189480 "./test/t0", options={m_options = DDL_options_st::OPT_NONE}, create_info=0x14cb90189850, alter_info=0x14cb90189790, create_table_mode=0, is_trans=0x14cb90189707, key_info=0x14cb90189468, key_count=0x14cb90189464, frm=0x14cb90189470) at /test/10.4_dbg/sql/sql_table.cc:5183
|
#10 0x000055c3a5b9ada3 in mysql_create_table_no_lock (thd=thd@entry=0x14cb28000d28, db=db@entry=0x14cb280125c0, table_name=table_name@entry=0x14cb280125d0, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790, is_trans=is_trans@entry=0x14cb90189707, create_table_mode=0, table_list=0x14cb280125a8) at /test/10.4_dbg/sql/sql_table.cc:5267
|
#11 0x000055c3a5b9b0d5 in mysql_create_table (thd=thd@entry=0x14cb28000d28, create_table=create_table@entry=0x14cb280125a8, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790) at /test/10.4_dbg/sql/sql_table.cc:5416
|
#12 0x000055c3a5b9ca6e in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_table.cc:11823
|
#13 0x000055c3a5ae3ec3 in mysql_execute_command (thd=thd@entry=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:6216
|
#14 0x000055c3a5ae6247 in mysql_parse (thd=thd@entry=0x14cb28000d28, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14cb9018b3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:8008
|
#15 0x000055c3a5ae8d62 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14cb28000d28, packet=packet@entry=0x14cb28019509 "CREATE TABLE t0 (a INT)", packet_length=packet_length@entry=23, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1231
|
#16 0x000055c3a5aeb58d in do_command (thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:1378
|
#17 0x000055c3a5c083d7 in do_handle_one_connection (connect=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1420
|
#18 0x000055c3a5c08493 in handle_one_connection (arg=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1324
|
#19 0x000014cb92b62609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#20 0x000014cb9274e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.4.30 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.30 (opt), 10.5.21 (dbg), 10.5.21 (opt), 10.6.14 (dbg), 10.6.14 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.7 (dbg), 10.9.7 (opt), 10.10.5 (dbg), 10.10.5 (opt), 10.11.4 (dbg), 10.11.4 (opt), 11.0.2 (dbg), 11.0.2 (opt), 11.1.0 (dbg), 11.1.0 (opt)
Please note that in the test case below the error upon trigger re-creation is already questionable. I just let it happen so that the test could hit further assertion failure which is unquestionable.
--error ER_TRG_DOES_NOT_EXIST
# Cleanup
UNLOCK TABLES;
10.1 d0116e10
mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
190403 16:53:09 [ERROR] mysqld got signal 6 ;
#7 0x00007fbb713bdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x0000556e75564505 in test_if_reopen (filename=0x7fbb736542e0 "/dev/shm/var_auto_GdBe/mysqld.1/data/test/t2.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
#9 0x0000556e7556471e in mi_open (name=0x7fbb68468360 "./test/t2", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122
#10 0x0000556e755384cd in ha_myisam::open (this=0x7fbb684b2088, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
#11 0x0000556e75270cb8 in handler::ha_open (this=0x7fbb684b2088, table_arg=0x7fbb68483870, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2534
#12 0x0000556e7511eadc in open_table_from_share (thd=0x7fbb6a0d5070, share=0x7fbb68467e88, alias=0x7fbb6855ee68 "t2", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fbb68483870, is_create_table=false) at /data/src/10.1/sql/table.cc:2975
#13 0x0000556e74fc2373 in open_table (thd=0x7fbb6a0d5070, table_list=0x7fbb6855ee70, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:2585
#14 0x0000556e74fc4c6f in open_and_process_table (thd=0x7fbb6a0d5070, lex=0x7fbb736561f0, tables=0x7fbb6855ee70, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050, has_prelocking_list=false, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:4124
#15 0x0000556e74fc5d0f in open_tables (thd=0x7fbb6a0d5070, options=..., start=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.cc:4639
#16 0x0000556e74fbd52a in open_tables (thd=0x7fbb6a0d5070, tables=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.h:261
#17 0x0000556e74fc760c in open_normal_and_derived_tables (thd=0x7fbb6a0d5070, tables=0x7fbb6855ee70, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5448
#18 0x0000556e750bd74d in fill_schema_table_by_open (thd=0x7fbb6a0d5070, is_show_fields_or_keys=false, table=0x7fbb68501088, schema_table=0x556e7612f040 <schema_tables+1920>, orig_db_name=0x7fbb684487b8, orig_table_name=0x7fbb68448fe0, open_tables_state_backup=0x7fbb73657800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4282
#19 0x0000556e750bee89 in get_all_tables (thd=0x7fbb6a0d5070, tables=0x7fbb68444880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4920
#20 0x0000556e750cddc4 in get_schema_tables_result (join=0x7fbb68446900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8278
#21 0x0000556e7506d002 in JOIN::exec_inner (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2714
#22 0x0000556e7506c6a9 in JOIN::exec (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2562
#23 0x0000556e7506fc3f in mysql_select (thd=0x7fbb6a0d5070, rref_pointer_array=0x7fbb6a0d9560, tables=0x7fbb68444880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fbb684468e0, unit=0x7fbb6a0d8bb8, select_lex=0x7fbb6a0d92b8) at /data/src/10.1/sql/sql_select.cc:3499
#24 0x0000556e750652f8 in handle_select (thd=0x7fbb6a0d5070, lex=0x7fbb6a0d8af0, result=0x7fbb684468e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:388
#25 0x0000556e75034cf3 in execute_sqlcom_select (thd=0x7fbb6a0d5070, all_tables=0x7fbb68444880) at /data/src/10.1/sql/sql_parse.cc:5945
#26 0x0000556e7502b375 in mysql_execute_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:3042
#27 0x0000556e75038937 in mysql_parse (thd=0x7fbb6a0d5070, rawbuf=0x7fbb68443088 "SHOW TABLE STATUS", length=17, parser_state=0x7fbb736591e0) at /data/src/10.1/sql/sql_parse.cc:7463
#28 0x0000556e75027305 in dispatch_command (command=COM_QUERY, thd=0x7fbb6a0d5070, packet=0x7fbb6cbf9071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499
#29 0x0000556e75026090 in do_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:1131
#30 0x0000556e75161301 in do_handle_one_connection (thd_arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1330
#31 0x0000556e75161065 in handle_one_connection (arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1242
#32 0x0000556e7551fb14 in pfs_spawn_thread (arg=0x7fbb70839ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1861
#33 0x00007fbb732d9494 in start_thread (arg=0x7fbb7365a700) at pthread_create.c:333
#34 0x00007fbb7147a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6