|
# Keep repeating the following testcase in quick succession till mysqld crashes. Definitely sporadic.
|
DROP DATABASE test;
|
CREATE DATABASE test;
|
USE test;
|
CREATE TABLE t (column_name_1 INT, column_name_2 VARCHAR(52)) ENGINE=InnoDB;
|
XA START 'a';
|
SET MAX_STATEMENT_TIME = 0.001;
|
INSERT INTO t VALUES (101,NULL),(102,NULL),(103,NULL),(104,NULL),(105,NULL),(106,NULL),(107,NULL),(108,NULL),(109,NULL),(1010,NULL);
|
CHECKSUM TABLE t, INFORMATION_SCHEMA.tables;
|
SELECT SLEEP(3);
|
Leads to:
|
10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057
|
mysqld: /test/10.5_dbg/sql/handler.h:3380: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
|
...
|
Query (0x14e3ae4740a0): CHECKSUM TABLE t, INFORMATION_SCHEMA.tables
|
|
10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057
|
Core was generated by `/test/MD150620-mariadb-10.5.4-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 0x155318ca2700 (LWP 2945016))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x0000560699e2e4c6 in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
|
#2 0x00005606995d0d60 in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:330
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x0000155319b16801 in __GI_abort () at abort.c:79
|
#6 0x0000155319b0639a in __assert_fail_base (fmt=0x155319c8d7d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x56069a1c9cc8 "inited==RND", file=file@entry=0x560699f95492 "/test/10.5_dbg/sql/handler.h", line=line@entry=3380, function=function@entry=0x560699fc9210 <_ZZN7handler10ha_rnd_endEvE19__PRETTY_FUNCTION__> "int handler::ha_rnd_end()") at assert.c:92
|
#7 0x0000155319b06412 in __GI___assert_fail (assertion=assertion@entry=0x56069a1c9cc8 "inited==RND", file=file@entry=0x560699f95492 "/test/10.5_dbg/sql/handler.h", line=line@entry=3380, function=function@entry=0x560699fc9210 <_ZZN7handler10ha_rnd_endEvE19__PRETTY_FUNCTION__> "int handler::ha_rnd_end()") at assert.c:101
|
#8 0x00005606993f2087 in handler::ha_rnd_end (this=0x1552f8843ea0) at /test/10.5_dbg/sql/handler.h:3380
|
#9 mysql_checksum_table (thd=thd@entry=0x1552f8815088, tables=tables@entry=0x1552f8874198, check_opt=check_opt@entry=0x1552f881a338) at /test/10.5_dbg/sql/sql_table.cc:11624
|
#10 0x000056069932743d in mysql_execute_command (thd=thd@entry=0x1552f8815088) at /test/10.5_dbg/sql/sql_parse.cc:4376
|
#11 0x000056069933315c in mysql_parse (thd=thd@entry=0x1552f8815088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x155318ca1350, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7993
|
#12 0x000056069931fc60 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1552f8815088, packet=packet@entry=0x1552f8867089 "", packet_length=packet_length@entry=43, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1874
|
#13 0x000056069931e43a in do_command (thd=0x1552f8815088) at /test/10.5_dbg/sql/sql_parse.cc:1355
|
#14 0x0000560699479c47 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x1552fb17a808, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1411
|
#15 0x000056069947a363 in handle_one_connection (arg=arg@entry=0x1552fb17a808) at /test/10.5_dbg/sql/sql_connect.cc:1313
|
#16 0x00005606998db902 in pfs_spawn_thread (arg=0x155318446c88) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
|
#17 0x000015531a7f96db in start_thread (arg=0x155318ca2700) at pthread_create.c:463
|
#18 0x0000155319bf788f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.3.24 (dbg), 10.4.14 (dbg), 10.5.4 (dbg)
Bug confirmed not present in:
MariaDB: 10.1.46 (dbg), 10.1.46 (opt), 10.2.33 (dbg), 10.2.33 (opt), 10.3.24 (opt), 10.4.14 (opt), 10.5.4 (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)
|
|
I could not crash the server using the original testcase against 10.5.4 debug, including on repeated runs. Perhaps something MTR specific I missed?
|
|
Possibly connected with MDEV-11783
|
|
No, it still fails on 10.2-10.4, but not anymore on 10.5. Probably something got fixed in 10.5 only, it could be bisected, but I don't see much point doing it at this time, as we aren't closing it anyway.
|
|
A testcase which crashes 10.3 to 11.0. Sporadic, keep looping until it crashes, usually around 10 attempts.
DROP DATABASE test;
|
CREATE DATABASE test;
|
USE test;
|
CREATE TABLE t(c INT) ENGINE=InnoDB;
|
SELECT REVERSE(t) FROM t;
|
SET max_statement_time=0.000001;
|
EXPLAIN SELECT * FROM t;
|
PREPARE p FROM 'CHECKSUM TABLE t';
|
EXECUTE p;
|
Leads to:
|
11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)
|
mariadbd: /test/11.0_dbg/sql/handler.h:3450: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
|
|
11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)
|
Core was generated by `/test/MD180223-mariadb-11.0.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22660455855680)
|
at ./nptl/pthread_kill.c:44
|
[Current thread is 1 (Thread 0x149c0c6bf640 (LWP 3077155))]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22660455855680) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=22660455855680) at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=22660455855680, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
#3 0x0000149c25f48476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
#4 0x0000149c25f2e7f3 in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x0000149c25f2e71b in __assert_fail_base (fmt=0x149c260e3150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56312e16164b "inited==RND", file=0x56312df4a14e "/test/11.0_dbg/sql/handler.h", line=3450, function=<optimized out>) at ./assert/assert.c:92
|
#6 0x0000149c25f3fe96 in __GI___assert_fail (assertion=0x56312e16164b "inited==RND", file=0x56312df4a14e "/test/11.0_dbg/sql/handler.h", line=3450, function=0x56312df4a16b "int handler::ha_rnd_end()") at ./assert/assert.c:101
|
#7 0x000056312d532bdf in handler::ha_rnd_end (this=0x149bbc029d20) at /test/11.0_dbg/sql/handler.h:3450
|
#8 mysql_checksum_table (thd=thd@entry=0x149bbc000d58, tables=tables@entry=0x149bbc085e80, check_opt=check_opt@entry=0x149bbc085550) at /test/11.0_dbg/sql/sql_table.cc:12004
|
#9 0x000056312d4606dd in mysql_execute_command (thd=0x149bbc000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=true) at /test/11.0_dbg/sql/sql_parse.cc:4387
|
#10 0x000056312d48d0e4 in Prepared_statement::execute (this=this@entry=0x149bbc083d58, expanded_query=expanded_query@entry=0x149c0c6bdd10, open_cursor=open_cursor@entry=false) at /test/11.0_dbg/sql/sql_prepare.cc:5223
|
#11 0x000056312d48d480 in Prepared_statement::execute_loop (this=this@entry=0x149bbc083d58, expanded_query=expanded_query@entry=0x149c0c6bdd10, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/11.0_dbg/sql/sql_prepare.cc:4646
|
#12 0x000056312d48dabd in mysql_sql_stmt_execute (thd=thd@entry=0x149bbc000d58) at /test/11.0_dbg/sql/sql_prepare.cc:3690
|
#13 0x000056312d45f50c in mysql_execute_command (thd=thd@entry=0x149bbc000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.0_dbg/sql/sql_parse.cc:3965
|
#14 0x000056312d4667cf in mysql_parse (thd=thd@entry=0x149bbc000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x149c0c6be2c0) at /test/11.0_dbg/sql/sql_parse.cc:8002
|
#15 0x000056312d468963 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x149bbc000d58, packet=packet@entry=0x149bbc00ae19 "", packet_length=packet_length@entry=9, blocking=blocking@entry=true) at /test/11.0_dbg/sql/sql_class.h:242
|
#16 0x000056312d46a7bc in do_command (thd=0x149bbc000d58, blocking=blocking@entry=true) at /test/11.0_dbg/sql/sql_parse.cc:1407
|
#17 0x000056312d5bb6e2 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56312f9f1ba8, put_in_cache=put_in_cache@entry=true) at /test/11.0_dbg/sql/sql_connect.cc:1416
|
#18 0x000056312d5bb941 in handle_one_connection (arg=0x56312f9f1ba8) at /test/11.0_dbg/sql/sql_connect.cc:1318
|
#19 0x0000149c25f9ab43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#20 0x0000149c2602ca00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Bug confirmed present in:
MariaDB: 10.3.38 (dbg), 10.4.29 (dbg), 10.5.20 (dbg), 10.6.13 (dbg), 10.7.8 (dbg), 10.8.8 (dbg), 10.9.6 (dbg), 10.11.2 (dbg), 11.0.1 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.3.38 (opt), 10.4.29 (opt), 10.5.20 (opt), 10.6.13 (opt), 10.7.8 (opt), 10.8.8 (opt), 10.9.6 (opt), 10.10.4 (dbg), 10.10.4 (opt), 10.11.2 (opt), 11.0.1 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.40 (dbg), 5.7.40 (opt), 8.0.31 (dbg), 8.0.31 (opt)
|
|
Observed in 11.4 dbg
# Keep pasting into client in quick succession till mariadbd crashes. Sporadic (~1/10)
|
SET sql_mode='', @@max_statement_time=0.0001;
|
CREATE TEMPORARY TABLE t3 (c VARCHAR PRIMARY KEY,c2 INT,c3 TIME) ENGINE=Aria;
|
CREATE TABLE t1(a int) ENGINE=FEDERATED COMMENT='';
|
SET @@GLOBAL.OPTIMIZER_SWITCH="join_cache_bka=ON";
|
RENAME TABLE InnoDB.procs_priv TO procs_priv_backup;
|
INSERT INTO t1 VALUES;
|
CHECKSUM TABLE t1,t2,t3;
|
|
11.4.0 b8f9f796ff8a1b0744cafde715c370db5a07adb7 (Debug)
|
mariadbd: /test/11.4_dbg/sql/handler.h:3523: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
|
|
11.4.0 b8f9f796ff8a1b0744cafde715c370db5a07adb7 (Debug)
|
Core was generated by `/test/MD311023-mariadb-11.4.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23385628194368)
|
at ./nptl/pthread_kill.c:44
|
[Current thread is 1 (Thread 0x1544e40fb640 (LWP 4134163))]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23385628194368) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=23385628194368) at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=23385628194368, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
#3 0x00001544e6a42476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
#4 0x00001544e6a287f3 in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00001544e6a2871b in __assert_fail_base (fmt=0x1544e6bdd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5654abc8f5c0 "inited==RND", file=0x5654aba72cbe "/test/11.4_dbg/sql/handler.h", line=3523, function=<optimized out>) at ./assert/assert.c:92
|
#6 0x00001544e6a39e96 in __GI___assert_fail (assertion=0x5654abc8f5c0 "inited==RND", file=0x5654aba72cbe "/test/11.4_dbg/sql/handler.h", line=3523, function=0x5654aba72cdb "int handler::ha_rnd_end()") at ./assert/assert.c:101
|
#7 0x00005654aaf710e5 in handler::ha_rnd_end (this=0x154438027800) at /test/11.4_dbg/sql/handler.h:3523
|
#8 mysql_checksum_table (thd=thd@entry=0x154438000d58, tables=tables@entry=0x154438013580, check_opt=check_opt@entry=0x154438006588) at /test/11.4_dbg/sql/sql_table.cc:12407
|
#9 0x00005654aae98257 in mysql_execute_command (thd=thd@entry=0x154438000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.4_dbg/sql/sql_parse.cc:4359
|
#10 0x00005654aae9d505 in mysql_parse (thd=thd@entry=0x154438000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1544e40fa1e0) at /test/11.4_dbg/sql/sql_parse.cc:7743
|
#11 0x00005654aae9f87b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154438000d58, packet=packet@entry=0x15443800b189 "", packet_length=packet_length@entry=23, blocking=blocking@entry=true) at /test/11.4_dbg/sql/sql_class.h:251
|
#12 0x00005654aaea199b in do_command (thd=0x154438000d58, blocking=blocking@entry=true) at /test/11.4_dbg/sql/sql_parse.cc:1406
|
#13 0x00005654ab001705 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5654aec70538, put_in_cache=put_in_cache@entry=true) at /test/11.4_dbg/sql/sql_connect.cc:1445
|
#14 0x00005654ab0019fa in handle_one_connection (arg=arg@entry=0x5654aec70538) at /test/11.4_dbg/sql/sql_connect.cc:1347
|
#15 0x00005654ab444b8c in pfs_spawn_thread (arg=0x5654aebdd578) at /test/11.4_dbg/storage/perfschema/pfs.cc:2201
|
#16 0x00001544e6a94ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#17 0x00001544e6b26a40 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|