[Pkg-nagios-devel] Bug#289762: problem seems to be in FROM_UNIXTIME()

sean finney sean finney <seanius@debian.org>, 289762@bugs.debian.org
Thu, 13 Jan 2005 17:29:14 -0500

Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

reassign 289762 mysql-server
severity 289762 critical
tags 289762 patch

hi folks,

i have some good news, and some bad news.

the good news is that i've figured out where the problem is.
the bad news is that there's not much we can do about it,
other than forward the bug to the mysql-server maintainer.

4.0.23 introduced a "bugfix" for the FROM_UNIXTIME
function which inadvertently introduced another bug, which
will break many applications (including nagios-mysql) that rely on
referencing the epoch in DATETIME variables.

more on the bug can by found at:


and the patch that fixes it (from their bk changeset 1.2014) is attached. =

christian: could you let us know if you would accept this patch
for the current upstream version of mysql-server until the next version
is released?  the patch applies cleanly (-p1) to the current source

if not, i'll conflict nagios against 4.0.23 for the time being.  also,
feel free to change the severity to what you feel is appropriate, i felt
that "makes unrelated software on the system (or the whole system) break"
justified at least initially filing the bug with said severity.



Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

Version: GnuPG v1.2.4 (GNU/Linux)