Bug #50077 "datetime field overflow" warnings in backup_xpfm_compat tests

• Submitted: 5 Jan 2010 8:07
• Modified: 14 Jan 2010 19:53
• Reporter: Rafal Somla
• Status: Duplicate
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 6.0-codebase-bugfixing
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: disabled

[5 Jan 2010 8:07] Rafal Somla

Description:
In the mysql-6.0-codebase-bugfixing tree, after pushing patches for BUG#48758 and BUG#48920 on 2010-01-04 10:53, backup_xpfm_compat_* tests started to fail. The issue is that RESTORE generates warnings:

+Warnings:
+#	1441	Datetime function: datetime field overflow

Which leads to test result missmatch.

Note that these tests restore from saved backup images created on different platforms and on previous server versions. Perhaps some incompatible change in the server broke backward compatibility of backup images (created with the default, logical backup drivers). 

Another possibility is that year change (from 2009 to 2010) made the difference. This is supported by the fact that failures are observed in the first PB run in the new year.

How to repeat:
This was observed in PB. Should be possible to repeat by restoring from one of the images stored in mysql-test/suite/backup/std_data/ directory. RESTORE should generate the above mentioned warning.

[6 Jan 2010 6:59] Rafal Somla

See very similar BUG#50093.

[6 Jan 2010 8:37] 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/96071

3802 Alexander Nozdrin	2010-01-06
      Disable test cases due to Bug#50077
      ("datetime field overflow" warnings in backup_xpfm_compat tests).

[6 Jan 2010 8:37] Alexander Nozdrin

The failing test cases were disabled due to this bug.

[6 Jan 2010 8:49] Tor Didriksen

The real (underlying) bug is described here:
http://bugs.mysql.com/bug.php?id=50087

[6 Jan 2010 14:53] Tor Didriksen

Re-enabled tests as part of fix for
Bug #50087 Interval arithmetic for Event_queue_element is not portable.

[14 Jan 2010 19:53] Chuck Bell

Duplicate of BUG#50087 which is fixed in 6.0 and back ported to the porting tree.