Bug #50093 backup_cs_names_lctn0 test fails by generating warnings during restore
Submitted: 5 Jan 2010 18:03 Modified: 14 Jan 2010 16:20
Reporter: Hema Sridharan Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:mysql-6.0-backup OS:Any
Assigned to: CPU Architecture:Any

[5 Jan 2010 18:03] Hema Sridharan
Description:
The backup_cs_names_lctn0 test(from backup suite) fails by generating some warnings like " Datetime function: datetime field overflow" and thereby resulting in mismatch with result file.

Note that backup_cs_names_lctn1 and lctn2 test passes and the issue is seen only in backup_cs_names_lctn0.

This issue is noticed in the latest mysql-6.0-backup team tree

How to repeat:
> ./mysql-test-run.pl --suite=backup backup_cs_names_lctn0
..
..
===========================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
backup.backup_cs_names_lctn0             [ fail ]
        Test ended at 2010-01-05 18:46:37

CURRENT_TEST: backup.backup_cs_names_lctn0
--- /
@@ -9,24 +9,32 @@
 backup_id
 ###
 Warnings:
+###    ###     Datetime function: datetime field overflow
 ###    ###     The event 'dbA.eA' was disabled during restore.
+###    ###     Datetime function: datetime field overflow

 # Restoring from cs_names_t.bkp image.
 RESTORE FROM 'cs_names_t.bkp' OVERWRITE;
 backup_id
 ###
 Warnings:
+###    ###     Datetime function: datetime field overflow
 ###    ###     The event 'dbA.eA' was disabled during restore.
+###    ###     Datetime function: datetime field overflow
[6 Jan 2010 6:59] Rafal Somla
Most probably duplicate of BUG#50077. However, note that this bug report contains additional information.
[11 Jan 2010 7:10] Sveta Smirnova
Thank you for the report.

Verified as described.
[14 Jan 2010 16:20] Chuck Bell
Duplicate of BUG#50087 which was pushed to a 6.0.14 tree which will eventually be merged to mysql-6.0-backup.

---8<---

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100112162328-2sblcul1kl08bbib) (version
source revid:guilhem@mysql.com-20100108092756-k0zzf4kvx9b7bh38) (merge vers:
6.0.14-alpha) (pib:15)