MySQL Bugs: #57054: Assertion `! is_set() || can_overwrite

Bug #57054	Assertion `! is_set() \|\| can_overwrite_status' failed with large --init-file
Submitted:	28 Sep 2010 8:12	Modified:	15 Oct 2012 14:35
Reporter:	Philip Stoev	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	next-mr	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When loading mysqldump-produced files back into the server with --init-file , mysqld asserted as follows:

mysqld: /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_error.cc:425: void Diagnostics_area::set_error_status(THD*, uint, const char*, const char*): Assertion `! is_set() || can_overwrite_status' failed.

backtrace:

#8  0x00a72d98 in __assert_fail () from /lib/libc.so.6
#9  0x081c4856 in Diagnostics_area::set_error_status (this=0xb16ffd4, thd=0xb16e328, sql_errno_arg=1149,
    message_arg=0xa881314 "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use", sqlstate=0x86bfcaf "42000") at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_error.cc:425
#10 0x081b5173 in THD::raise_condition (this=0xb16e328, sql_errno=1149, sqlstate=0x86bfcaf "42000", level=MYSQL_ERROR::WARN_LEVEL_ERROR,
    msg=0xa881314 "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use")
    at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_class.cc:848
#11 0x081b4a61 in THD::raise_error (this=0xb16e328, sql_errno=1149) at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_class.cc:694
#12 0x081db850 in handle_bootstrap_impl (thd=0xb16e328) at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_parse.cc:533
#13 0x081dbb52 in do_handle_bootstrap (thd=0xb16e328) at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_parse.cc:616
#14 0x081dbade in handle_bootstrap (arg=0xb16e328) at /home/philips/bzr/mysql-next-mr-bugfixing/sql/sql_parse.cc:599
#15 0x00bea919 in start_thread () from /lib/libpthread.so.0
#16 0x00b2ccbe in clone () from /lib/libc.so.6

bzr version-info:

revision-id: mats.kindahl@oracle.com-20100921212743-lz53e73lcjw38ye7
date: 2010-09-21 23:27:43 +0200
build-date: 2010-09-28 11:11:35 +0300
revno: 3297
branch-nick: mysql-next-mr-bugfixing

How to repeat:
Load attached file with --init-file

Test case uploaded to ftp.mysql.com as bug57054.zip

Hello Philip,

which command did you use for restoring?

MTR_VERSION=1 perl mysql-test-run.pl --start-and-exit 1st --mysqld=--init-file=...

This may cause mysqld to start certain MTR-specific defaults.

Many thanks for your quick answer.

I was able to reproduce this by taking test from above.

I used mysql-next revision 3195 (actual bzr tree from today CEST morning)

Verified as described.

Can't repeat on 5.6