Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
The test case is very non-deterministic, run with big --repeat=N.
Don't put it into the regression suite, create a deterministic one instead.
It usually fails for me within 20-200 attempts, but it can vary on different machines and builds.
I don't know what relation it has to ORACLE mode/packages, to SHOW WARNINGS, and how the actions on the second table affect the outcome, but I couldn't get rid of any of those. Hopefully it can be simplified after the analysis.
The failure is rr-able.
--source include/have_sequence.inc
|
|
CREATE TABLE t1 SELECT 'x' AS f1 FROM seq_1_to_100; |
CREATE TABLE t2 SELECT NULL AS f2; |
|
--connect (con1,localhost,root,,)
|
DELETE FROM t1 WHERE f1 = 1; |
|
--connection default
|
SET sql_mode= 'ORACLE'; |
--delimiter $
|
CREATE PACKAGE pkg IS PROCEDURE p; END $ |
CREATE PACKAGE BODY pkg IS PROCEDURE p AS BEGIN ALTER TABLE t2 ENGINE=HEAP; END; END $ |
--delimiter ;
|
--send
|
CALL pkg.p;
|
|
--connection con1
|
SHOW WARNINGS;
|
INSERT INTO t2 VALUES (NULL); |
|
--connection default
|
--reap
|
CALL pkg.p;
|
|
# Cleanup
|
DROP TABLE t1, t2; |
DROP PACKAGE pkg; |
bb-11.0-oalter f9b33ac57 |
(rr) bt
|
#0 LEX::first_lists_tables_same (this=0x7f8358310b90) at /data/src/bb-11.0-oalter-debug/sql/sql_lex.cc:4497
|
#1 0x000055dd0c750bcf in mysql_execute_command (thd=0x7f8358000dc8, is_called_from_prepared_stmt=false) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3503
|
#2 0x000055dd0c649e2b in sp_instr_stmt::exec_core (this=0x7f8358310478, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3857
|
#3 0x000055dd0c649149 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f83583104c0, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c, open_tables=false, instr=0x7f8358310478)
|
at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3582
|
#4 0x000055dd0c6499db in sp_instr_stmt::execute (this=0x7f8358310478, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3763
|
#5 0x000055dd0c642977 in sp_head::execute (this=0x7f835830eb00, thd=0x7f8358000dc8, merge_da_on_success=true) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:1459
|
#6 0x000055dd0c64569c in sp_head::execute_procedure (this=0x7f835830eb00, thd=0x7f8358000dc8, args=0x7f8358006148) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:2446
|
#7 0x000055dd0c74ebaa in do_execute_sp (thd=0x7f8358000dc8, sp=0x7f835830eb00) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3026
|
#8 0x000055dd0c74f82c in Sql_cmd_call::execute (this=0x7f8358015598, thd=0x7f8358000dc8) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3271
|
#9 0x000055dd0c759a9d in mysql_execute_command (thd=0x7f8358000dc8, is_called_from_prepared_stmt=false) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:6001
|
#10 0x000055dd0c75fc14 in mysql_parse (thd=0x7f8358000dc8, rawbuf=0x7f83580154d0 "CALL pkg.p", length=10, parser_state=0x7f83693a3370) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:8000
|
#11 0x000055dd0c74b87f in dispatch_command (command=COM_QUERY, thd=0x7f8358000dc8, packet=0x7f835800ba59 "CALL pkg.p", packet_length=10, blocking=true)
|
at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:1894
|
#12 0x000055dd0c74a1e6 in do_command (thd=0x7f8358000dc8, blocking=true) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:1407
|
#13 0x000055dd0c93ca52 in do_handle_one_connection (connect=0x55dd1115d1d8, put_in_cache=true) at /data/src/bb-11.0-oalter-debug/sql/sql_connect.cc:1416
|
#14 0x000055dd0c93c7c7 in handle_one_connection (arg=0x55dd111aa068) at /data/src/bb-11.0-oalter-debug/sql/sql_connect.cc:1318
|
#15 0x000055dd0ce5c240 in pfs_spawn_thread (arg=0x55dd1115cc68) at /data/src/bb-11.0-oalter-debug/storage/perfschema/pfs.cc:2201
|
#16 0x00007f836f8a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#17 0x00007f836f9278d0 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
|
Attachments
Issue Links
- is caused by
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed
- relates to
-
MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part
- Closed