[MDEV-11317] Assertion `! is_set()' or `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' fails in Diagnostics_area::set_ok_status on CREATE OR REPLACE with ARCHIVE table Created: 2016-11-19  Updated: 2017-01-08  Resolved: 2017-01-08

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 10.0.29

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


 Description   

--source include/have_archive.inc
 
CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE;
CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE;

10.0 03ddc19ab2

mysqld: /data/src/10.0/sql/sql_error.cc:378: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
161119 21:09:55 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f695072b312 in __GI___assert_fail (assertion=0xe939d8 "! is_set()", file=0xe93910 "/data/src/10.0/sql/sql_error.cc", line=378, function=0xe93dc0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
#8  0x00000000006230a2 in Diagnostics_area::set_ok_status (this=0x7f694bbe1d58, affected_rows=0, last_insert_id=0, message=0x0) at /data/src/10.0/sql/sql_error.cc:378
#9  0x00000000005e01cf in my_ok (thd=0x7f694bbdd070, affected_rows=0, id=0, message=0x0) at /data/src/10.0/sql/sql_class.h:3830
#10 0x0000000000648de5 in mysql_execute_command (thd=0x7f694bbdd070) at /data/src/10.0/sql/sql_parse.cc:3039
#11 0x0000000000652350 in mysql_parse (thd=0x7f694bbdd070, rawbuf=0x7f6948cfa088 "CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE", length=81, parser_state=0x7f69529f0650) at /data/src/10.0/sql/sql_parse.cc:6570
#12 0x0000000000644e66 in dispatch_command (command=COM_QUERY, thd=0x7f694bbdd070, packet=0x7f694bbd3071 "CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE", packet_length=81) at /data/src/10.0/sql/sql_parse.cc:1309
#13 0x0000000000644129 in do_command (thd=0x7f694bbdd070) at /data/src/10.0/sql/sql_parse.cc:999
#14 0x000000000076251c in do_handle_one_connection (thd_arg=0x7f694bbdd070) at /data/src/10.0/sql/sql_connect.cc:1378
#15 0x000000000076228e in handle_one_connection (arg=0x7f694bbdd070) at /data/src/10.0/sql/sql_connect.cc:1293
#16 0x00000000009fb5de in pfs_spawn_thread (arg=0x7f694a591370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
#17 0x00007f695262d0a4 in start_thread (arg=0x7f69529f1700) at pthread_create.c:309
#18 0x00007f69507e587d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

10.2 b162068456

mysqld: /data/src/10.2/sql/sql_error.cc:380: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
161119 21:13:05 [ERROR] mysqld got signal 6 ;
 
#6  0x00007f6afc3e4266 in __assert_fail_base (fmt=0x7f6afc51d238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f6aff92efb0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x7f6aff92eee8 "/data/src/10.2/sql/sql_error.cc", line=line@entry=380, function=function@entry=0x7f6aff92f400 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
#7  0x00007f6afc3e4312 in __GI___assert_fail (assertion=0x7f6aff92efb0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x7f6aff92eee8 "/data/src/10.2/sql/sql_error.cc", line=380, function=0x7f6aff92f400 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
#8  0x00007f6afee87a0f in Diagnostics_area::set_ok_status (this=0x7f6af341b058, affected_rows=0, last_insert_id=0, message=0x0) at /data/src/10.2/sql/sql_error.cc:380
#9  0x00007f6afee3e427 in my_ok (thd=0x7f6af3416070, affected_rows=0, id=0, message=0x0) at /data/src/10.2/sql/sql_class.h:4304
#10 0x00007f6afeeb4f63 in mysql_execute_command (thd=0x7f6af3416070) at /data/src/10.2/sql/sql_parse.cc:3893
#11 0x00007f6afeec191c in mysql_parse (thd=0x7f6af3416070, rawbuf=0x7f6af3464088 "CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE", length=81, parser_state=0x7f6afffdbdd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7799
#12 0x00007f6afeeaf66c in dispatch_command (command=COM_QUERY, thd=0x7f6af3416070, packet=0x7f6af3458071 "CREATE OR REPLACE TABLE t1 ( pk INT AUTO_INCREMENT PRIMARY KEY ) ENGINE = ARCHIVE", packet_length=81, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1808
#13 0x00007f6afeeae046 in do_command (thd=0x7f6af3416070) at /data/src/10.2/sql/sql_parse.cc:1368
#14 0x00007f6afeff54e4 in do_handle_one_connection (connect=0x7f6afb8714f0) at /data/src/10.2/sql/sql_connect.cc:1354
#15 0x00007f6afeff5271 in handle_one_connection (arg=0x7f6afb8714f0) at /data/src/10.2/sql/sql_connect.cc:1260
#16 0x00007f6aff32faf8 in pfs_spawn_thread (arg=0x7f6afb813370) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#17 0x00007f6afe4f10a4 in start_thread (arg=0x7f6afffdd300) at pthread_create.c:309
#18 0x00007f6afc49e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111



 Comments   
Comment by Michael Widenius [ 2017-01-08 ]

Problem was with deleting non existing .frm file for storage engines that doesn't have .frm files.

Comment by Michael Widenius [ 2017-01-08 ]

Pushed into 10.0
Component should be Storage-engines Archive

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