Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
CREATE TABLE t1 (i INT) ENGINE=Aria; |
INSERT INTO t1 VALUES (1),(2); |
|
CREATE TABLE t2 (c CHAR(1)) ENGINE=Aria; |
INSERT INTO t2 VALUES ('a'),('b'); |
|
--connect (con1,localhost,root,,test)
|
LOCK TABLE t1 WRITE; |
OPTIMIZE TABLE t1; |
|
--connection default
|
DELETE FROM t2 WHERE c < 1; |
|
--connection con1
|
OPTIMIZE TABLE t1; |
|
# Cleanup
|
--disconnect con1
|
--connection default
|
DROP TABLE t1, t2; |
5.5 20089f5a39fa8f6f08113f12ed87c34e844c4fc6 |
mysqld: /data/src/5.5/storage/maria/ha_maria.cc:2771: virtual int ha_maria::start_stmt(THD*, thr_lock_type): Assertion `file->trn == trn' failed.
|
171216 0:44:06 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fc0ece7eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000000000094d51d in ha_maria::start_stmt (this=0x7fc0e7878078, thd=0x7fc0e8a69060, lock_type=TL_WRITE) at /data/src/5.5/storage/maria/ha_maria.cc:2771
|
#9 0x00000000005a70ba in check_lock_and_start_stmt (thd=0x7fc0e8a69060, prelocking_ctx=0x7fc0e8a6c2e0, table_list=0x7fc0e7424148) at /data/src/5.5/sql/sql_base.cc:5522
|
#10 0x00000000005a7fc0 in lock_tables (thd=0x7fc0e8a69060, tables=0x7fc0e7424148, count=1, flags=0) at /data/src/5.5/sql/sql_base.cc:5993
|
#11 0x00000000005a7751 in open_and_lock_tables (thd=0x7fc0e8a69060, tables=0x7fc0e7424148, derived=true, flags=0, prelocking_strategy=0x7fc0ee8a8610) at /data/src/5.5/sql/sql_base.cc:5741
|
#12 0x000000000059abff in open_and_lock_tables (thd=0x7fc0e8a69060, tables=0x7fc0e7424148, derived=true, flags=0) at /data/src/5.5/sql/sql_base.h:525
|
#13 0x000000000070cddb in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fc0e8a69060, tables=0x7fc0e7424148, check_opt=0x7fc0e8a6d190, operator_name=0xd3ebe2 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x7b577c <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/5.5/sql/sql_admin.cc:439
|
#14 0x000000000070f166 in Optimize_table_statement::execute (this=0x7fc0e7424720, thd=0x7fc0e8a69060) at /data/src/5.5/sql/sql_admin.cc:1138
|
#15 0x000000000060658a in mysql_execute_command (thd=0x7fc0e8a69060) at /data/src/5.5/sql/sql_parse.cc:4503
|
#16 0x00000000006098ce in mysql_parse (thd=0x7fc0e8a69060, rawbuf=0x7fc0e7424078 "OPTIMIZE TABLE t1", length=17, parser_state=0x7fc0ee8a9640) at /data/src/5.5/sql/sql_parse.cc:5923
|
#17 0x00000000005fd5e3 in dispatch_command (command=COM_QUERY, thd=0x7fc0e8a69060, packet=0x7fc0e8a6e061 "", packet_length=17) at /data/src/5.5/sql/sql_parse.cc:1066
|
#18 0x00000000005fc7d5 in do_command (thd=0x7fc0e8a69060) at /data/src/5.5/sql/sql_parse.cc:793
|
#19 0x00000000006ff7cf in do_handle_one_connection (thd_arg=0x7fc0e8a69060) at /data/src/5.5/sql/sql_connect.cc:1268
|
#20 0x00000000006ff55c in handle_one_connection (arg=0x7fc0e8a69060) at /data/src/5.5/sql/sql_connect.cc:1184
|
#21 0x0000000000a0d6d9 in pfs_spawn_thread (arg=0x7fc0e9793080) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#22 0x00007fc0ee525494 in start_thread (arg=0x7fc0ee8aa700) at pthread_create.c:333
|
#23 0x00007fc0ecf3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- duplicates
-
MDEV-10130 Assertion `share->in_trans == 0' failed in storage/maria/ma_close.c
- Closed