Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
10.0.34
Description
CREATE TABLE t1 (i INT) ENGINE=MyISAM; |
LOCK TABLE t1 WRITE; |
OPTIMIZE TABLE t1; |
SELECT * FROM INFORMATION_SCHEMA.TABLES; |
|
# Cleanup
|
DROP TABLE t1; |
10.0 4496fd71f47e |
mysqld: /data/src/10.0/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
|
180110 20:12:22 [ERROR] mysqld got signal 6 ;
|
|
Query (0x7f7b60cfa088): SELECT * FROM INFORMATION_SCHEMA.TABLES
|
Connection ID (thread ID): 3
|
Status: NOT_KILLED
|
#7 0x00007fbb782f9ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000557ed9b0b679 in test_if_reopen (filename=0x7fbb72562ef0 "/data/bld/10.3/mysql-test/var/mysqld.1/data/test/t1.MYI") at /data/src/10.3/storage/myisam/mi_open.c:66
|
#9 0x0000557ed9b0b892 in mi_open (name=0x7fbb60035898 "./test/t1", mode=2, open_flags=82) at /data/src/10.3/storage/myisam/mi_open.c:122
|
#10 0x0000557ed9adeb91 in ha_myisam::open (this=0x7fbb60051098, name=0x7fbb60035898 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.3/storage/myisam/ha_myisam.cc:782
|
#11 0x0000557ed93c889e in handler::ha_open (this=0x7fbb60051098, table_arg=0x7fbb60050470, name=0x7fbb60035898 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0) at /data/src/10.3/sql/handler.cc:2645
|
#12 0x0000557ed91fce98 in open_table_from_share (thd=0x7fbb60000b00, share=0x7fbb60035378, alias=0x7fbb60048340 "t1", db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7fbb60050470, is_create_table=false) at /data/src/10.3/sql/table.cc:3365
|
#14 0x0000557ed9073063 in open_and_process_table (thd=0x7fbb60000b00, lex=0x7fbb72564ee0, tables=0x7fbb60048348, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0, has_prelocking_list=false, ot_ctx=0x7fbb72564c00) at /data/src/10.3/sql/sql_base.cc:3467
|
#15 0x0000557ed907422e in open_tables (thd=0x7fbb60000b00, options=..., start=0x7fbb72564cb0, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0) at /data/src/10.3/sql/sql_base.cc:3987
|
#16 0x0000557ed906c8be in open_tables (thd=0x7fbb60000b00, tables=0x7fbb72564cb0, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0) at /data/src/10.3/sql/sql_base.h:238
|
#17 0x0000557ed9076211 in open_normal_and_derived_tables (thd=0x7fbb60000b00, tables=0x7fbb60048348, flags=1346, dt_phases=35) at /data/src/10.3/sql/sql_base.cc:4930
|
#18 0x0000557ed90763ea in open_tables_only_view_structure (thd=0x7fbb60000b00, table_list=0x7fbb60048348, can_deadlock=true) at /data/src/10.3/sql/sql_base.cc:4987
|
#19 0x0000557ed918fb8b in fill_schema_table_by_open (thd=0x7fbb60000b00, mem_root=0x7fbb725666c0, is_show_fields_or_keys=false, table=0x7fbb60084168, schema_table=0x557eda63f800 <schema_tables+1920>, orig_db_name=0x7fbb6001ab10, orig_table_name=0x7fbb60044480, open_tables_state_backup=0x7fbb72566700, can_deadlock=true) at /data/src/10.3/sql/sql_show.cc:4502
|
#20 0x0000557ed91914e2 in get_all_tables (thd=0x7fbb60000b00, tables=0x7fbb60014d80, cond=0x0) at /data/src/10.3/sql/sql_show.cc:5151
|
#21 0x0000557ed91a1342 in get_schema_tables_result (join=0x7fbb60016ce8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8519
|
#22 0x0000557ed913cf4c in JOIN::exec_inner (this=0x7fbb60016ce8) at /data/src/10.3/sql/sql_select.cc:3600
|
#23 0x0000557ed913c5f0 in JOIN::exec (this=0x7fbb60016ce8) at /data/src/10.3/sql/sql_select.cc:3431
|
#24 0x0000557ed913d831 in mysql_select (thd=0x7fbb60000b00, tables=0x7fbb60014d80, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fbb60016cc8, unit=0x7fbb60004838, select_lex=0x7fbb60004f70) at /data/src/10.3/sql/sql_select.cc:3835
|
#25 0x0000557ed9131824 in handle_select (thd=0x7fbb60000b00, lex=0x7fbb60004770, result=0x7fbb60016cc8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:375
|
#26 0x0000557ed90fcfc5 in execute_sqlcom_select (thd=0x7fbb60000b00, all_tables=0x7fbb60014d80) at /data/src/10.3/sql/sql_parse.cc:6511
|
#27 0x0000557ed90f3759 in mysql_execute_command (thd=0x7fbb60000b00) at /data/src/10.3/sql/sql_parse.cc:3744
|
#28 0x0000557ed91008f8 in mysql_parse (thd=0x7fbb60000b00, rawbuf=0x7fbb60014b58 "SELECT * FROM INFORMATION_SCHEMA.TABLES", length=39, parser_state=0x7fbb72568610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7968
|
#29 0x0000557ed90ee26d in dispatch_command (command=COM_QUERY, thd=0x7fbb60000b00, packet=0x7fbb6011ecd1 "SELECT * FROM INFORMATION_SCHEMA.TABLES", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
|
#30 0x0000557ed90ecca1 in do_command (thd=0x7fbb60000b00) at /data/src/10.3/sql/sql_parse.cc:1369
|
#31 0x0000557ed9245cf4 in do_handle_one_connection (connect=0x557edcd30100) at /data/src/10.3/sql/sql_connect.cc:1401
|
#32 0x0000557ed9245a81 in handle_one_connection (arg=0x557edcd30100) at /data/src/10.3/sql/sql_connect.cc:1307
|
#33 0x0000557ed96d5cda in pfs_spawn_thread (arg=0x557edcd4c930) at /data/src/10.3/storage/perfschema/pfs.cc:1863
|
#34 0x00007fbb79fd0494 in start_thread (arg=0x7fbb72569700) at pthread_create.c:333
|
#35 0x00007fbb783b693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible with 10.0 - 10.3.
Not reproducible with 5.5.
No obvious effect on a non-debug build.
Attachments
Issue Links
- relates to
-
MDEV-16985 Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon SHOW TABLE STATUS after failed DDL
- Stalled