Bug #35914 BACKUP DATABASE * causes assertion
Submitted: 8 Apr 2008 21:16 Modified: 9 Apr 2008 0:19
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Backup Severity:S1 (Critical)
Version:6.0-BK OS:Any
Assigned to: CPU Architecture:Any

[8 Apr 2008 21:16] Philip Stoev
Description:
BACKUP DATABASE * causes assertion

mysqld: handler.cc:1971: THD* handler::ha_thd() const: Assertion `!table || !table->in_use || table->in_use == _current_thd()' failed.

with the following backtrace:

#0  0x00110402 in __kernel_vsyscall ()
#1  0x00bdc617 in pthread_kill () from /lib/libpthread.so.0
#2  0x0849136f in write_core (sig=6) at stacktrace.c:305
#3  0x082e98bd in handle_segfault (sig=6) at mysqld.cc:2621
#4  <signal handler called>
#5  0x00110402 in __kernel_vsyscall ()
#6  0x00a6e690 in raise () from /lib/libc.so.6
#7  0x00a6ff91 in abort () from /lib/libc.so.6
#8  0x00a6793e in __assert_fail () from /lib/libc.so.6
#9  0x08416c96 in handler::ha_thd (this=0x9bee6b0) at handler.cc:1971
#10 0x0841f285 in handler::mark_trx_read_write (this=0x9bee6b0) at handler.cc:2976
#11 0x08416e6f in handler::ha_write_row (this=0x9bee6b0, buf=0x9bfd750 ">Ь") at handler.cc:5308
#12 0x088f56bc in report_ob_init (process_id=0, state=BUP_STARTING, operation=OP_BACKUP, error_num=0, user_comment=0x8a5f98a "", backup_file=0x9bf5fa8 "a",
    command=0x9bf5f20 "BACKUP DATABASE * to 'a'") at backup_progress.cc:480
#13 0x088e7dc9 in execute_backup_command (thd=0x9bafec0, lex=0x9bb1078) at kernel.cc:287
#14 0x082fbd65 in mysql_execute_command (thd=0x9bafec0) at sql_parse.cc:2134
#15 0x08304550 in mysql_parse (thd=0x9bafec0, inBuf=0x9bf5f20 "BACKUP DATABASE * to 'a'", length=24, found_semicolon=0xa9d4e270) at sql_parse.cc:5623
#16 0x08304f69 in dispatch_command (command=COM_QUERY, thd=0x9bafec0, packet=0x9be72f1 "BACKUP DATABASE * to 'a'", packet_length=24) at sql_parse.cc:1031
#17 0x083061c8 in do_command (thd=0x9bafec0) at sql_parse.cc:723
#18 0x082f2611 in handle_one_connection (arg=0x9bafec0) at sql_connect.cc:1125
#19 0x00bd750b in start_thread () from /lib/libpthread.so.0
#20 0x00b18b2e in clone () from /lib/libc.so.6

How to repeat:
mysql> BACKUP DATABASE * to 'a';
ERROR 2013 (HY000): Lost connection to MySQL server during query
[9 Apr 2008 0:13] Sveta Smirnova
Thank you for the report.

Verified as described.
[9 Apr 2008 0:19] Sveta Smirnova
Duplicate of bug #35595 really.