MySQL Bugs: #35967: Backup: can't delete from mysql.online_backup

Bug #35967	Backup: can't delete from mysql.online_backup_progress
Submitted:	10 Apr 2008 17:37	Modified:	16 Sep 2008 18:58
Reporter:	Peter Gulutzan	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S3 (Non-critical)
Version:	6.0.5-alpha-debug	OS:	Linux (SUSE 10 \| 32-bit)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
I'm using mysql-6.0 backup.

I'm root.
I can't delete from the mysql.online_backup_progress
table. I believe that I must have ability to do so,
else after a few years it will become absurdly large.

How to repeat:
mysql> delete from mysql.online_backup_progress\G
ERROR 1556 (HY000): You can't use locks with log tables.

Thank you for the bug report. Verified as described.

Your MySQL connection id is 1
Server version: 6.0.5-alpha-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> delete from mysql.online_backup_progress\G
ERROR 1556 (HY000): You can't use locks with log tables.
mysql>

The work for WL#4296 has changed the backup tables to logs. The new log tables are backup_history and backup_log. But you still cannot delete from them.

However, this bug is a duplicate of BUG#33364. Solution to BUG#33364 is the problem reported in this bug report: purging of the backup logs is essential for proper maintenance.

Note: The priority of BUG#33364 should be changed since it is P4 and this bug is P3.