CREATE OR REPLACE TABLE (MDEV-5491)

[MDEV-5517] Assertion `thd->transaction.stmt.is_empty()' fails in Locked_tables_list::unlock_locked_tables on CREATE OR REPLACE on a locked table Created: 2014-01-10  Updated: 2014-01-29  Resolved: 2014-01-29

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.8

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 Description   

--source include/have_innodb.inc
 
create table t1 (i int) engine=InnoDB;
lock table t1 write;
create or replace table t1 (j int);

mariadb-monty/sql/sql_base.cc:2704: void Locked_tables_list::unlock_locked_tables(THD*): Assertion `thd->transaction.stmt.is_empty()' failed.
140110 21:23:22 [ERROR] mysqld got signal 6 ;

#6  0x00007f052eae9621 in *__GI___assert_fail (assertion=0xfc97e8 "thd->transaction.stmt.is_empty()", file=<optimized out>, line=2704, function=0xfcc320 "void Locked_tables_list::unlock_locked_tables(THD*)") at assert.c:81
#7  0x0000000000606459 in Locked_tables_list::unlock_locked_tables (this=0x7f0527ff7ba8, thd=0x7f0527ff4070) at mariadb-monty/sql/sql_base.cc:2704
#8  0x000000000070a727 in mysql_rm_table_no_locks (thd=0x7f0527ff4070, tables=0x7f05187fbe60, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=true) at mariadb-monty/sql/sql_table.cc:2619
#9  0x000000000070fd82 in create_table_impl (thd=0x7f0527ff4070, db=0x7f052250a750 "test", table_name=0x7f052250a148 "t1", path=0x7f05187fc8c0 "./test/t1", create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40, create_table_mode=0, is_trans=0x7f05187fcb66, key_info=0x7f05187fcae8, key_count=0x7f05187fcae4, frm=0x7f05187fcad0) at mariadb-monty/sql/sql_table.cc:4607
#10 0x000000000071056f in mysql_create_table_no_lock (thd=0x7f0527ff4070, db=0x7f052250a750 "test", table_name=0x7f052250a148 "t1", create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40, is_trans=0x7f05187fcb66, create_table_mode=0) at mariadb-monty/sql/sql_table.cc:4787
#11 0x00000000007106c6 in mysql_create_table (thd=0x7f0527ff4070, create_table=0x7f052250a180, create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40) at mariadb-monty/sql/sql_table.cc:4833
#12 0x0000000000665921 in mysql_execute_command (thd=0x7f0527ff4070) at mariadb-monty/sql/sql_parse.cc:3009
#13 0x000000000066eb90 in mysql_parse (thd=0x7f0527ff4070, rawbuf=0x7f052250a088 "create or replace table t1 (j int)", length=34, parser_state=0x7f05187fd630) at mariadb-monty/sql/sql_parse.cc:6383
#14 0x0000000000661ade in dispatch_command (command=COM_QUERY, thd=0x7f0527ff4070, packet=0x7f0525da3071 "create or replace table t1 (j int)", packet_length=34) at mariadb-monty/sql/sql_parse.cc:1296
#15 0x0000000000660e80 in do_command (thd=0x7f0527ff4070) at mariadb-monty/sql/sql_parse.cc:993
#16 0x000000000077a779 in do_handle_one_connection (thd_arg=0x7f0527ff4070) at mariadb-monty/sql/sql_connect.cc:1379
#17 0x000000000077a4cc in handle_one_connection (arg=0x7f0527ff4070) at mariadb-monty/sql/sql_connect.cc:1293
#18 0x0000000000a9d651 in pfs_spawn_thread (arg=0x7f0525ffe8b0) at mariadb-monty/storage/perfschema/pfs.cc:1853
#19 0x00007f0530049b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#20 0x00007f052eb98a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

revision-id: monty@askmonty.org-20140110153917-3r8owmbgslg2552n
revno: 3965
branch-nick: mariadb-monty
BUILD/compile-pentium-debug-max-no-ndb



 Comments   
Comment by Michael Widenius [ 2014-01-29 ]

Fixed in my development tree

Generated at Thu Feb 08 07:04:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.