Bug #34184 Backup: hang if locked table

• Submitted: 31 Jan 2008 1:54
• Modified: 25 Apr 2008 13:40
• Reporter: Peter Gulutzan
• Status: Duplicate
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 6.0.5-alpha-debug
• OS: Linux (SUSE 10 64-bit)
• Assigned to: Rafal Somla
• CPU Architecture: Any

[31 Jan 2008 1:54] Peter Gulutzan

Description:
I'm using 6.0-backup.

I create an empty table named t.
This is the only table in the database.
I say LOCK TABLES t WRITE.
I say BACKUP DATABASE.
It hangs. Well, that would be okay, but ...
I cannot KILL the process from another connection.
I cannot stop the server with mysqladmin shutdown.

How to repeat:
create database k;
use k
create table t (s1 int);
lock table t write;
backup database k to '1';

[31 Jan 2008 10:10] MySQL Verification Team

Thank you for the bug report. Verified as described.

[25 Apr 2008 13:40] Rafal Somla

This is a duplicate of BUG#35079 - can't interrupt BACKUP/RESTORE command.