Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init on OPTIMIZE two tables when replaced by recreate
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Sergei Golubchik |
Bug Description
mysqld: sql/sql_
#8 0xb7459014 in __assert_fail () from /lib/libc.so.6
#9 0x0820a75c in thd_progress_init (thd=0x9cd1040, max_stage=2)
at sql/sql_
#10 0x082ccd7d in copy_data_
create=..., ignore=false, order_num=0, order=0x0, copied=0xa6321ed0,
deleted=
at sql/sql_
#11 0x082cb74c in mysql_alter_table (thd=0x9cd1040, new_db=0x9d81628 "test",
new_
alter_
at sql/sql_
#12 0x082cdb56 in mysql_recreate_
at sql/sql_
#13 0x0832d743 in admin_recreate_
at sql/sql_admin.cc:45
#14 0x0832f5e9 in mysql_admin_table (thd=0x9cd1040, tables=0x9d80df8,
check_
open_
prepare_func=0, operator_func=
(int (handler:
#15 0x08330463 in Optimize_
at sql/sql_
#16 0x0823fc19 in mysql_execute_
at sql/sql_
#17 0x08242a67 in mysql_parse (thd=0x9cd1040, rawbuf=0x9d80d58 "OPTIMIZE TABLE t1, t2",
length=21, parser_
#18 0x08236edc in dispatch_command (command=COM_QUERY, thd=0x9cd1040,
packet=
#19 0x082363a1 in do_command (thd=0x9cd1040)
at sql/sql_
#20 0x08320b75 in do_handle_
at sql/sql_
#21 0x083206c0 in handle_
at sql/sql_
#22 0x08548c7b in pfs_spawn_thread (arg=0x9dbc3c8)
at storage/
#23 0xb7738b25 in start_thread () from /lib/libpthread
bzr version-info
revision-id: <email address hidden>
date: 2012-04-05 15:57:27 +0200
build-date: 2012-04-08 00:52:33 +0400
revno: 3364
Notes:
Reproducible with XtraDB, InnoDB plugin, PBXT.
Not reproducible on MariaDB 5.3 (revno 3499), MySQL 5.5, MySQL trunk (revno 3827).
Test case:
--source include/
CREATE TABLE t1 ( a INT ) ENGINE=InnoDB;
CREATE TABLE t2 ( b INT ) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2);
INSERT INTO t2 VALUES (3),(4);
OPTIMIZE TABLE t1, t2;
# End of test case
Set to 'High' rather than 'Critical' because it's a debug assertion, no visible negative effects on a release build. Please adjust if needed.
Also filed in JIRA as https:/ /mariadb. atlassian. net/browse/ MDEV-217.