Description:
Doing on-line backup of the same database back to back causes the MySQLD to get signal 15.
080220 18:31:24 [Note] Backup: Starting backup process
080220 18:31:24 [Note] Backup: Backing up selected databases
080220 18:31:25 [Note] Backup: Backup completed
080220 18:31:30 [Note] Got signal 15 to shutdown mysqld
080220 18:31:30 [Note] /space/hema/mysql-6.0-backup/sql/mysqld: Normal shutdown
How to repeat:
--source include/have_innodb.inc
--source include/not_embedded.inc
--source include/have_debug.inc
connect (backup,localhost,root,,);
connect (breakpoints,localhost,root,,);
--disable_warnings
--error 0,1
--remove_file $MYSQLTEST_VARDIR/master-data/bup_default.bak
--enable_warnings
connection backup;
# We are testing basic backup abilitiy
--echo *** Create and load TPCB database ***
--echo
--source include/tpcb.inc
CALL tpcb.load();
--echo
--echo *** Ensure 1000 rows in account table ****
--echo
USE tpcb;
SELECT COUNT(*) FROM account;
--echo
--echo *** Doing backup number 1 ****
--echo
BACKUP DATABASE tpcb TO 'tpcb.bak';
sleep 5
BACKUP DATABASE tpcb TO 'tpcb.bak';
sleep 5
BACKUP DATABASE tpcb TO 'tpcb.bak';
# Test cleanup section
--echo
--echo *** DROP TPCB DATABASE ****
--echo
DROP DATABASE tpcb;
Suggested fix:
We think it should give error or warning that backup file already exists