Bug #33562 Backup: no warning about disabled storage engine
Submitted: 28 Dec 2007 23:41 Modified: 26 Feb 2008 2:27
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0-alpha-debug OS:Linux (SUSE 10 64-bit)
Assigned to: Chuck Bell CPU Architecture:Any

[28 Dec 2007 23:41] Peter Gulutzan 
Description:
I create an InnoDB table.
I stop mysqld and re-start mysqld with --skip-innodb.
I say BACKUP DATABASE.
I see this on mysqld:
"071227 17:38:32 [Warning] Backup: Skipping table test.t since it has no valid storage engine"
... but that warning does not appear on the mysql client.
A warning should be part of what the BACKUP statement returns.

Built from mysql-6.0-backup source with BUILD/compile-pentium-debug-max.
Last changeset = "ChangeSet@1.2753, 2007-12-20 15:32:22-05:00".

How to repeat:
Start mysqld.

On mysql client, say:
USE test
CREATE TABLE t (s1 INT) engine=innodb;

Stop mysqld.
Restart mysqld with --skip-innodb switch.

On mysql client, say:
BACKUP DATABASE test;
[29 Dec 2007 5:24] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[22 Jan 2008 18:30] Chuck Bell 
This is a problem in the logger class. The logger is not pushing the warnings and errors to the thread's (as in THD) error list. A patch for this will enable errors to be displayed at the client and to allow SHOW ERRORS and SHOW WARNINGS commands to function properly. Patch forthcoming.
[22 Jan 2008 18:30] Chuck Bell 
This is a problem in the logger class. The logger is not pushing the warnings and errors to the thread's (as in THD) error list. A patch for this will enable errors to be displayed at the client and to allow SHOW ERRORS and SHOW WARNINGS commands to function properly. Patch forthcoming.
[22 Jan 2008 18:30] Chuck Bell 
This is a problem in the logger class. The logger is not pushing the warnings and errors to the thread's (as in THD) error list. A patch for this will enable errors to be displayed at the client and to allow SHOW ERRORS and SHOW WARNINGS commands to function properly. Patch forthcoming.
[23 Jan 2008 18:59] Chuck Bell 
Patch submitted for review. See http://lists.mysql.com/commits/41166.
[5 Feb 2008 16:46] Chuck Bell 
New patch ready for review. See:

http://lists.mysql.com/commits/41729
[7 Feb 2008 11:18] Rafal Somla 
Good to push.
[8 Feb 2008 19:24] Chuck Bell 
Patch queued.
[25 Feb 2008 20:19] Bugs System 
Pushed into 6.0.5-alpha
[26 Feb 2008 2:27] Paul DuBois 
Noted in 6.0.5 changelog.

Warnings generated during a BACKUP DATABASE operation were not logged
properly, and thus could not be displayed with a subsequent SHOW
WARNINGS statement.
[14 Mar 2008 1:34] Paul DuBois 
Correction: No changelog entry needed; this bug did not appear in any released version.