Bug #46758 backup_no_data fails in mtr

• Submitted: 17 Aug 2009 13:27
• Modified: 29 Aug 2009 23:21
• Reporter: Jørgen Løland
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Hema Sridharan
• CPU Architecture: Any

[17 Aug 2009 13:27] Jørgen Løland

Description:
backup_no_data was disabled due to bug#42756, but the test can not be enabled because it still fails with errors like these:

@@ -19,6 +19,25 @@
 RESTORE FROM 'all.bak' OVERWRITE;
 backup_id
 #
+Warnings:
+#	1752	The grant 'ALTER ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'BACKUP ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'CREATE ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'CREATE ROUTINE ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'CREATE TEMPORARY TABLES ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'CREATE VIEW ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'DELETE ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'DROP ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'EVENT ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'INDEX ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'INSERT ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'LOCK TABLES ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'REFERENCES ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'RESTORE ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'SELECT ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'SHOW VIEW ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'TRIGGER ON `test`.*' for the user ''@'%' was skipped because the user does not exist.
+#	1752	The grant 'UPDATE ON `test`.*' for the user ''@'%' was skipped because the user does not exist.

How to repeat:
Run backup_no_data in mtr

Suggested fix:
Fix test or backup, whichever is wrong

[17 Aug 2009 13:29] Jørgen Løland

Remember to enable backup_no_data.test after fixing this bug.

[17 Aug 2009 20:05] 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/80924

2860 Hema Sridharan	2009-08-17
      BUG#46758 (backup_no_data fails in MTR)
      The backup_no_data fails because of BUG#46765 where test database produces warnings during restore.
      This bug fix will not use BACKUP DATABASE * in the testcase.
      modified:
        mysql-test/suite/backup/r/backup_no_data.result
        mysql-test/suite/backup/t/backup_no_data.test
        mysql-test/suite/backup/t/disabled.def

[18 Aug 2009 15:05] Chuck Bell

Approved pending adding a note in BUG#46765 to remind developer to reenable test case of BACKUP DATABASE *.

[18 Aug 2009 15:11] Rafal Somla

Approved pending one change (comment out remove_file .../test/db.opt).

[18 Aug 2009 16:52] 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/81005

2860 Hema Sridharan	2009-08-18
      BUG#46758 (backup_no_data test fails in mtr)
      The backup_no_data fails because of BUG#46765
      where test database produces warnings during restore.
      This bug fix will not use BACKUP DATABASE * in the test case.
      modified:
        mysql-test/suite/backup/r/backup_no_data.result
        mysql-test/suite/backup/t/backup_no_data.test
        mysql-test/suite/backup/t/disabled.def

[28 Aug 2009 10:01] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090828100112-r73xkx8dhekz5bbb) (version source revid:[e-mail]-20090819062832-mzgo92b5zw4lfqkc) (merge vers: 5.4.4-alpha) (pib:11)

[29 Aug 2009 23:21] Paul DuBois

Not in any released version. No changelog entry needed.