| Bug #41360 | backup_views fails after merge of main and backup trees | ||
|---|---|---|---|
| Submitted: | 10 Dec 2008 15:44 | Modified: | 26 Mar 2009 23:40 |
| Reporter: | Ingo Strüwing | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S3 (Non-critical) |
| Version: | 6.0.9 | OS: | Linux |
| Assigned to: | Jørgen Løland | CPU Architecture: | Any |
[10 Dec 2008 16:13]
Ingo Strüwing
The merge has revision-id: ingo.struewing@sun.com-20081210155306-n9f5l3nmea1obn39 Suggested triage values: Defect class minor. Wrong error message. Workaround acceptable. Accept the wrong message. Impact minimal. This is not in the main trees yet.
[11 Feb 2009 12:08]
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/65889 2765 Jorgen Loland 2009-02-11 Bug#41360 - backup_views fails after merge of main and backup trees The backup error stack was reordered a while ago to match the ordering of the server error stack. When a view cannot be restored due to a missing dependency, the top-level error ER_BACKUP_CANT_RESTORE_VIEW is now displayed, whereas the underlying problem ER_NO_SUCH_TABLE was displayed earlier. This patch changes the backup_views test to accommodate this reordering.
[11 Feb 2009 17:13]
Chuck Bell
Patch approved. No need for second revewer.
[12 Feb 2009 6:41]
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/65984 2769 Jorgen Loland 2009-02-12 Bug#41360 - backup_views fails after merge of main and backup trees The backup error stack was reordered a while ago to match the ordering of the server error stack. When a view cannot be restored due to a missing dependency, the top-level error ER_BACKUP_CANT_RESTORE_VIEW is now displayed, whereas the underlying problem ER_NO_SUCH_TABLE was displayed earlier. This patch changes the backup_views test to accommodate this reordering.
[26 Mar 2009 12:33]
Bugs System
Pushed into 6.0.11-alpha (revid:alik@sun.com-20090326121822-pt84kzxxayzho4mn) (version source revid:rafal.somla@sun.com-20090302164601-znhm4tadplfi2iqu) (merge vers: 6.0.11-alpha) (pib:6)
[26 Mar 2009 23:40]
Paul DuBois
Test case changes. No changelog entry needed.
Description: After merge of mysql-6.0 and mysql-6.0-backup, I get: backup.backup_views [ fail ] mysqltest: At line 209: query 'RESTORE FROM 'bup_objectview1.bak'' failed with wrong errno 1685: 'Could not restore view `bup_db1`.`v5`. Please check the view definition for possible missing dependencies.', instead of 1146... The result from queries just before the failure was: < snip > backup database BACKUP DATABASE bup_db1, bup_db2 TO 'bup_objectview.bak'; backup_id # BACKUP DATABASE bup_db1 TO 'bup_objectview1.bak'; backup_id # BACKUP DATABASE bup_db2 TO 'bup_objectview2.bak'; backup_id # dropping database. DROP TABLE bup_db1.t3; DROP TABLE bup_db1.t5; DROP TABLE bup_db2.t2; DROP DATABASE bup_db1; DROP DATABASE bup_db2; Restore database. restore database with view dependency to other, non-existing db RESTORE FROM 'bup_objectview1.bak'; ERROR HY000: Could not restore view `bup_db1`.`v5`. Please check the view definition for possible missing dependencies. More results from queries before failure can be found in /home2/mydev/bzrtest/testdir-6.0-backup-merge-1/mysql-test/var/log/backup_views.log Warnings from just before the error: Error 1146 Table 'bup_db2.t2' doesn't exist Stopping All Servers That is ER_BACKUP_CANT_RESTORE_VIEW instead of ER_NO_SUCH_TABLE. Top revision from mysql-6.0: 2773 Alexander Nozdrin 2008-12-08 [merge] revision-id:alik@sun.com-20081208112915-alxg2mejaq7i1dhx Merge from 6.0 Top revision from mysql-6.0-backup: 2732 oystein.grovlen@sun.com 2008-12-08 revision-id:oystein.grovlen@sun.com-20081208103021-ljm9pabojqf9k3jf Bug#40741 backup.backup test fails if blackhole engine is not available - Make sure test backup.backup only runs if blackhole engine is available. - Fixed have_blackhole.inc to give an informative message when a test is skipped because the blackhole engine is missing - Some clean-up to backup.backup result file to cater for changes that has happened while it was disabled. I will disable the test case. Please re-enable after fix. How to repeat: Branch the merged revision from mysql-6.0-backup-merge. I will push it there after creating the bug report.