Bug #40218 Setting backup_{history,progress}_log to DEFAULT turns them OFF

• Submitted: 21 Oct 2008 19:29
• Modified: 15 Nov 2008 1:34
• Reporter: Paul DuBois
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 6.0 bzr
• OS: Any
• Assigned to: Chuck Bell
• CPU Architecture: Any

[21 Oct 2008 19:29] Paul DuBois

Description:
The default values of the backup_history_log and backup_progess_log system variables is ON.

But explicitly setting them to DEFAULT turns them off.

How to repeat:
Test script:
SHOW VARIABLES LIKE 'backup%log';
SET GLOBAL backup_history_log=DEFAULT;
SET GLOBAL backup_progress_log=DEFAULT;
SHOW VARIABLES LIKE 'backup%log';

Result:
mysql> SHOW VARIABLES LIKE 'backup%log';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| backup_history_log  | ON    | 
| backup_progress_log | ON    | 
+---------------------+-------+
2 rows in set (0.01 sec)

mysql> SET GLOBAL backup_history_log=DEFAULT;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL backup_progress_log=DEFAULT;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'backup%log';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| backup_history_log  | OFF   | 
| backup_progress_log | OFF   | 
+---------------------+-------+
2 rows in set (0.00 sec)

[21 Oct 2008 20:02] MySQL Verification Team

Thank you for the bug report. Verified as described.

[4 Nov 2008 19:55] Chuck Bell

The problem is the code is shared with the slow and query log (intentionally) and the default for these is OFF (deactivate), but the default for the backup logs is ON (activate). Thus, modification is necessary to correct this behaviour.

[4 Nov 2008 20:00] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/57832

2727 Chuck Bell	2008-11-04
      BUG#40218 : Setting backup_{history,progress}_log to DEFAULT turns them OFF
      
      The problem is the code is shared with the slow and query log (intentionally) and the
      default for these is OFF (deactivate), but the default for the backup logs is ON
      (activate). 
      
      This patch correctly sets the default for the backup logs.

[5 Nov 2008 12:44] Øystein Grøvlen

Patch approved.

[10 Nov 2008 15:39] Jørgen Løland

Good to push

[14 Nov 2008 14:50] Bugs System

Pushed into 6.0.9-alpha  (revid:[e-mail]-20081104195947-jdywb4dt02jc2oic) (version source revid:[e-mail]-20081114134411-xypyf8wyjc2nm3ly) (pib:5)

[15 Nov 2008 1:34] Paul DuBois

Noted in 6.0.9 changelog.

The default value of the backup_history_log and backup_progess_log 
system variables is ON, but explicitly setting them to DEFAULT set
them to OFF.