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
Triage: Triaged: D1 (Critical)

[28 Sep 2010 8:12] Philip Stoev
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
[28 Sep 2010 8:15] Philip Stoev
Test case uploaded to ftp.mysql.com as bug57054.zip
[28 Sep 2010 11:59] Susanne Ebrecht
Hello Philip,

which command did you use for restoring?
[28 Sep 2010 13:01] Philip Stoev
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.
[28 Sep 2010 14:28] Susanne Ebrecht
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.
[15 Oct 2012 14:35] Erlend Dahl
Can't repeat on 5.6