Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
CREATE TABLE t1 (a INT); |
CREATE PROCEDURE sp() BEGIN END; |
--delimiter $
|
CREATE EVENT ev ON SCHEDULE EVERY 1 SECOND |
DO
|
CALL sp;
|
ALTER TABLE t1 NOWAIT; |
SET STATEMENT lock_wait_timeout=1 FOR ALTER TABLE t1 ADD b INT |
$
|
--delimiter ;
|
|
# Cleanup
|
DROP EVENT ev; |
DROP PROCEDURE sp; |
DROP TABLE t1; |
10.3 e1dc05a69 |
mysqld: /data/src/10.3/sql/sql_lex.cc:4926: bool LEX::set_arena_for_set_stmt(Query_arena*): Assertion `arena_for_set_stmt== 0' failed.
|
181114 13:31:22 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fbe97844ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000056302da982d8 in LEX::set_arena_for_set_stmt (this=0x7fbe800048e8, backup=0x7fbe919ea6d0) at /data/src/10.3/sql/sql_lex.cc:4926
|
#9 0x000056302dabd05e in mysql_execute_command (thd=0x7fbe80000b00) at /data/src/10.3/sql/sql_parse.cc:3481
|
#10 0x000056302dacba09 in mysql_parse (thd=0x7fbe80000b00, rawbuf=0x7fbe80014d28 "SET STATEMENT lock_wait_timeout=1 FOR ALTER TABLE t1 ADD b INT", length=62, parser_state=0x7fbe919eb5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
|
#11 0x000056302dab9081 in dispatch_command (command=COM_QUERY, thd=0x7fbe80000b00, packet=0x7fbe8000b1e1 "", packet_length=143, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1940
|
#12 0x000056302dab75f3 in do_command (thd=0x7fbe80000b00) at /data/src/10.3/sql/sql_parse.cc:1395
|
#13 0x000056302dc1f07a in do_handle_one_connection (connect=0x5630315fdb30) at /data/src/10.3/sql/sql_connect.cc:1402
|
#14 0x000056302dc1edfe in handle_one_connection (arg=0x5630315fdb30) at /data/src/10.3/sql/sql_connect.cc:1308
|
#15 0x000056302e0b3053 in pfs_spawn_thread (arg=0x563031611490) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#16 0x00007fbe99300494 in start_thread (arg=0x7fbe919ec700) at pthread_create.c:333
|
#17 0x00007fbe9790193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
No visible effect on non-debug builds.
The test case is not applicable to 10.2 and earlier, because they don't have NOWAIT, and I don't know what it could be replaced with to keep the test failing.
Attachments
Issue Links
- is duplicated by
-
MDEV-31160 multiple use of "SET STATEMENT sql_select_limit=xx FOR" set it at session level.
- Closed
-
MDEV-31485 SIGSEGV in PROF_MEASUREMENT::~PROF_MEASUREMENT | QUERY_PROFILE::~QUERY_PROFILE
- Stalled