[MDEV-21746] Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed in test_if_reopen upon SELECT from temporary table Created: 2020-02-17  Updated: 2023-07-28  Resolved: 2023-07-28

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Temporary, Storage Engine - MyISAM
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Won't Fix Votes: 0
Labels: not-10.2, not-10.3, not-10.4

Issue Links:
Relates
relates to MDEV-16985 Assertion `strcmp(share->unique_file_... Stalled

 Description   

Note: The assertion failure is the same as in MDEV-16985, but there is no SHOW TABLE STATUS, no previously failed ALTER, the stack trace is different, and affected versions aren't the same; so I'm filing it separately.

CREATE TEMPORARY TABLE t1 (a INT, b VARBINARY(8), c INT, KEY(a)) ENGINE=MyISAM;
 
INSERT INTO t1 VALUES (1,'a',1),(2,'b',2),(3,'c',3),(4,'d',4),(5,'e',5),(6,'f',6);
 
ALTER TABLE t1 ADD KEY (c);
 
SELECT * FROM t1 WHERE a IS NULL OR c IS NULL;

10.1 716161ea

 
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.
 
200217 14:28:19 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f817967df12 in __GI___assert_fail (assertion=0x55c923852098 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x55c923852070 "/data/src/10.1/storage/myisam/mi_open.c", line=67, function=0x55c9238522f8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:101
 
#8  0x000055c92329166b in test_if_reopen (filename=0x7f817b2a7550 "/dev/shm/var_auto_lG40/tmp/mysqld.1/#sql173b_3_1.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
 
#9  0x000055c923291884 in mi_open (name=0x7f8170a850e8 "/data/bld/10.1-debug-nightly/mysql-test/var/tmp/mysqld.1/#sql173b_3_1", mode=7, open_flags=66) at /data/src/10.1/storage/myisam/mi_open.c:122
 
#10 0x000055c92326547f in ha_myisam::open (this=0x7f8170a90278, name=0x7f8170a850e8 "/data/bld/10.1-debug-nightly/mysql-test/var/tmp/mysqld.1/#sql173b_3_1", mode=7, test_if_locked=2) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
 
#11 0x000055c922fee68e in handler::ha_open (this=0x7f8170a90278, table_arg=0x7f8170a84070, name=0x7f8170a850e8 "/data/bld/10.1-debug-nightly/mysql-test/var/tmp/mysqld.1/#sql173b_3_1", mode=7, test_if_locked=2) at /data/src/10.1/sql/handler.cc:2569
 
#12 0x000055c922fee170 in handler::clone (this=0x7f81708ac888, name=0x7f8170a850e8 "/data/bld/10.1-debug-nightly/mysql-test/var/tmp/mysqld.1/#sql173b_3_1", mem_root=0x7f81709a5188) at /data/src/10.1/sql/handler.cc:2480
 
#13 0x000055c923265221 in ha_myisam::clone (this=0x7f81708ac888, name=0x7f8170a850e8 "/data/bld/10.1-debug-nightly/mysql-test/var/tmp/mysqld.1/#sql173b_3_1", mem_root=0x7f81709a5188) at /data/src/10.1/storage/myisam/ha_myisam.cc:680
 
#14 0x000055c923107915 in QUICK_RANGE_SELECT::init_ror_merged_scan (this=0x7f8170a8b140, reuse_handler=false, local_alloc=0x7f81709a5188) at /data/src/10.1/sql/opt_range.cc:1500
 
#15 0x000055c923108532 in QUICK_ROR_UNION_SELECT::reset (this=0x7f81709a5100) at /data/src/10.1/sql/opt_range.cc:1789
 
#16 0x000055c922e10e71 in join_init_read_record (tab=0x7f81708f8d08) at /data/src/10.1/sql/sql_select.cc:19500
 
#17 0x000055c922e0ede4 in sub_select (join=0x7f81708f6e00, join_tab=0x7f81708f8d08, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18590
 
#18 0x000055c922e0e69b in do_select (join=0x7f81708f6e00, fields=0x7f81727cf3d8, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18248
 
#19 0x000055c922de82a0 in JOIN::exec_inner (this=0x7f81708f6e00) at /data/src/10.1/sql/sql_select.cc:3277
 
#20 0x000055c922de55cb in JOIN::exec (this=0x7f81708f6e00) at /data/src/10.1/sql/sql_select.cc:2564
 
#21 0x000055c922de8ac1 in mysql_select (thd=0x7f81727cb070, rref_pointer_array=0x7f81727cf568, tables=0x7f81708f6298, wild_num=1, fields=..., conds=0x7f81708f6c28, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f81708f6de0, unit=0x7f81727cebb8, select_lex=0x7f81727cf2c0) at /data/src/10.1/sql/sql_select.cc:3501
 
#22 0x000055c922dde230 in handle_select (thd=0x7f81727cb070, lex=0x7f81727ceaf8, result=0x7f81708f6de0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:377
 
#23 0x000055c922dadae9 in execute_sqlcom_select (thd=0x7f81727cb070, all_tables=0x7f81708f6298) at /data/src/10.1/sql/sql_parse.cc:5691
 
#24 0x000055c922da4929 in mysql_execute_command (thd=0x7f81727cb070) at /data/src/10.1/sql/sql_parse.cc:3038
 
#25 0x000055c922db1761 in mysql_parse (thd=0x7f81727cb070, rawbuf=0x7f81708f6088 "SELECT * FROM t1 WHERE a IS NULL OR c IS NULL", length=45, parser_state=0x7f817b2aa1e0) at /data/src/10.1/sql/sql_parse.cc:7209
 
#26 0x000055c922da093b in dispatch_command (command=COM_QUERY, thd=0x7f81727cb070, packet=0x7f81747ee071 "", packet_length=45) at /data/src/10.1/sql/sql_parse.cc:1499
 
#27 0x000055c922d9f6f9 in do_command (thd=0x7f81727cb070) at /data/src/10.1/sql/sql_parse.cc:1131
 
#28 0x000055c922edcae3 in do_handle_one_connection (thd_arg=0x7f81727cb070) at /data/src/10.1/sql/sql_connect.cc:1331
 
#29 0x000055c922edc814 in handle_one_connection (arg=0x7f81727cb070) at /data/src/10.1/sql/sql_connect.cc:1242
 
#30 0x000055c92330276e in pfs_spawn_thread (arg=0x7f8178c39c70) at /data/src/10.1/storage/perfschema/pfs.cc:1868
 
#31 0x00007f817af2c4a4 in start_thread (arg=0x7f817b2ab700) at pthread_create.c:456
 
#32 0x00007f817973ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Not reproducible with the provided test case on 10.2+.
No obvious problem on a non-debug build.

 Comments   
Comment by Elena Stepanova [ 2020-04-07 ]

Same test case, ASAN build (it is worth saving for the history):

10.1 241ac3f4

 
mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `__extension__ ({ size_t __s1_len, __s2_len; (__builtin_constant_p (share->unique_file_name) && __builtin_constant_p (filename) && (__s1_len = __builtin_strlen (share->unique_file_name), __s2_len = __builtin_strlen (filename), (!((size_t)(const void *)((share->unique_file_name) + 1) - (size_t)(const void *)(share->unique_file_name) == 1) || __s1_len >= 4) && (!((size_t)(const void *)((filename) + 1) - (size_t)(const void *)(filename) == 1) || __s2_len >= 4)) ? __builtin_strcmp (share->unique_file_name, filename) : (__builtin_constant_p (share->unique_file_name) && ((size_t)(const void *)((share->unique_file_name) + 1) - (size_t)(const void *)(share->unique_file_name) == 1) && (__s1_len = __builtin_strlen (share->unique_file_name), __s1_len < 4) ? (__builtin_constant_p (filename) && ((size_t)(const void *)((filename) + 1) - (size_t)(const void *)(filename) == 1) ? __builtin_strcmp (share->unique_file_name, filename) : (__extension__ ({ const unsigned char *__s2 = (const unsigned char *) (const char *) (filename); int __result = (((const unsigned char *) (const char *) (share->unique_file_name))[0] - __s2[0]); if (__s1_len > 0 && __result == 0) { __result = (((const unsigned char *) (const char *) (share->unique_file_name))[1] - __s2[1]); if (__s1_len > 1 && __result == 0) { __result = (((const unsigned char *) (const char *) (share->unique_file_name))[2] - __s2[2]); if (__s1_len > 2 && __result == 0) __result = (((const unsigned char *) (const char *) (share->unique_file_name))[3] - __s2[3]); } } __result; }))) : (__builtin_constant_p (filename) && ((size_t)(const void *)((filename) + 1) - (size_t)(const void *)(filename) == 1) && (__s2_len = __builtin_strlen (filename), __s2_len < 4) ? (__builtin_constant_p (share->unique_file_name) && ((size_t)(const void *)((share->unique_file_name) + 1) - (size_t)(const void *)(share->unique_file_name) == 1) ? __builtin_strcmp (share->unique_file_name, filename) : -(__extension__ ({ const unsigned char *__s2 = (const unsigned char *) (const char *) (share->unique_file_name); int __result = (((const unsigned char *) (const char *) (filename))[0] - __s2[0]); if (__s2_len > 0 && __result == 0) { __result = (((const unsigned char *) (const char *) (filename))[1] - __s2[1]); if (__s2_len > 1 && __result == 0) { __result = (((const unsigned char *) (const char *) (filename))[2] - __s2[2]); if (__s2_len > 2 && __result == 0) __result = (((const unsigned char *) (const char *) (filename))[3] - __s2[3]); } } __result; }))) : __builtin_strcmp (share->unique_file_name, filename)))); }) || share->last_version' failed.
 
200408  0:19:41 [ERROR] mysqld got signal 6 ;
 
 
 
#6  0x00007fe3bde19e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55767761dc80 "__extension__ ({ size_t __s1_len, __s2_len; (__builtin_constant_p (share->unique_file_name) && __builtin_constant_p (filename) && (__s1_len = __builtin_strlen (share->unique_file_name), __s2_len = __b"..., file=file@entry=0x55767761dc20 "/data/src/10.1/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x55767761ecc0 <__PRETTY_FUNCTION__.14432> "test_if_reopen") at assert.c:92
 
#7  0x00007fe3bde19f12 in __GI___assert_fail (assertion=assertion@entry=0x55767761dc80 "__extension__ ({ size_t __s1_len, __s2_len; (__builtin_constant_p (share->unique_file_name) && __builtin_constant_p (filename) && (__s1_len = __builtin_strlen (share->unique_file_name), __s2_len = __b"..., file=file@entry=0x55767761dc20 "/data/src/10.1/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x55767761ecc0 <__PRETTY_FUNCTION__.14432> "test_if_reopen") at assert.c:101
 
#8  0x0000557676a8841a in test_if_reopen (filename=filename@entry=0x7fe3b3e26f00 "/dev/shm/var_auto_Wgvh/tmp/mysqld.1/#sql1dd1_3_1.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
 
#9  0x0000557676a93862 in mi_open (name=name@entry=0x6210000561e8 "/data/bld/10.1-asan-nightly/mysql-test/var/tmp/mysqld.1/#sql1dd1_3_1", mode=mode@entry=7, open_flags=open_flags@entry=66) at /data/src/10.1/storage/myisam/mi_open.c:122
 
#10 0x0000557676a375d9 in ha_myisam::open (this=0x621000052bf8, name=0x6210000561e8 "/data/bld/10.1-asan-nightly/mysql-test/var/tmp/mysqld.1/#sql1dd1_3_1", mode=7, test_if_locked=2) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
 
#11 0x000055767645732f in handler::ha_open (this=this@entry=0x621000052bf8, table_arg=<optimized out>, name=name@entry=0x6210000561e8 "/data/bld/10.1-asan-nightly/mysql-test/var/tmp/mysqld.1/#sql1dd1_3_1", mode=<optimized out>, test_if_locked=test_if_locked@entry=2) at /data/src/10.1/sql/handler.cc:2569
 
#12 0x0000557676457c08 in handler::clone (this=this@entry=0x61c00004d910, name=0x6210000561e8 "/data/bld/10.1-asan-nightly/mysql-test/var/tmp/mysqld.1/#sql1dd1_3_1", mem_root=0x61100000c3c8) at /data/src/10.1/sql/handler.cc:2480
 
#13 0x0000557676a2ec21 in ha_myisam::clone (this=0x61c00004d910, name=<optimized out>, mem_root=<optimized out>) at /data/src/10.1/storage/myisam/ha_myisam.cc:680
 
#14 0x000055767674ac63 in QUICK_RANGE_SELECT::init_ror_merged_scan (this=0x612000015f40, reuse_handler=<optimized out>, local_alloc=<optimized out>) at /data/src/10.1/sql/opt_range.cc:1500
 
#15 0x000055767674be09 in QUICK_ROR_UNION_SELECT::reset (this=0x61100000c340) at /data/src/10.1/sql/opt_range.cc:1789
 
#16 0x000055767600b3d0 in join_init_read_record (tab=0x62b0000260c8) at /data/src/10.1/sql/sql_select.cc:19500
 
#17 0x000055767600b983 in sub_select (join=join@entry=0x62b0000240c8, join_tab=join_tab@entry=0x62b0000260c8, end_of_records=end_of_records@entry=false) at /data/src/10.1/sql/sql_select.cc:18590
 
#18 0x0000557676044814 in do_select (join=join@entry=0x62b0000240c8, fields=fields@entry=0x62a0000645d8, table=table@entry=0x0, procedure=<optimized out>) at /data/src/10.1/sql/sql_select.cc:18248
 
#19 0x0000557676088825 in JOIN::exec_inner (this=this@entry=0x62b0000240c8) at /data/src/10.1/sql/sql_select.cc:3277
 
#20 0x000055767608986c in JOIN::exec (this=this@entry=0x62b0000240c8) at /data/src/10.1/sql/sql_select.cc:2564
 
#21 0x000055767607c617 in mysql_select (thd=thd@entry=0x62a000060270, rref_pointer_array=rref_pointer_array@entry=0x62a000064768, tables=<optimized out>, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /data/src/10.1/sql/sql_select.cc:3501
 
#22 0x000055767607ec04 in handle_select (thd=thd@entry=0x62a000060270, lex=lex@entry=0x62a000063cf8, result=result@entry=0x62b0000240a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.1/sql/sql_select.cc:377
 
#23 0x0000557675f4e518 in execute_sqlcom_select (thd=thd@entry=0x62a000060270, all_tables=<optimized out>) at /data/src/10.1/sql/sql_parse.cc:5691
 
#24 0x0000557675f69d2b in mysql_execute_command (thd=thd@entry=0x62a000060270) at /data/src/10.1/sql/sql_parse.cc:3038
 
#25 0x0000557675f8078d in mysql_parse (thd=thd@entry=0x62a000060270, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fe3b3e2c3d0) at /data/src/10.1/sql/sql_parse.cc:7209
 
#26 0x0000557675f87ac5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62a000060270, packet=packet@entry=0x6290000e1271 "", packet_length=packet_length@entry=45) at /data/src/10.1/sql/sql_parse.cc:1499
 
#27 0x0000557675f8cc6c in do_command (thd=0x62a000060270) at /data/src/10.1/sql/sql_parse.cc:1131
 
#28 0x0000557676231991 in do_handle_one_connection (thd_arg=thd_arg@entry=0x62a000060270) at /data/src/10.1/sql/sql_connect.cc:1331
 
#29 0x0000557676231f49 in handle_one_connection (arg=arg@entry=0x62a000060270) at /data/src/10.1/sql/sql_connect.cc:1242
 
#30 0x0000557676b7076f in pfs_spawn_thread (arg=0x6160000057f0) at /data/src/10.1/storage/perfschema/pfs.cc:1868
 
#31 0x00007fe3bf6c84a4 in start_thread (arg=0x7fe3b3e2e700) at pthread_create.c:456
 
#32 0x00007fe3bded6d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Comment by Elena Stepanova [ 2023-07-28 ]

10.1 is EOL

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