[Pkg-nagios-devel] Bug#289762: nagios-mysql: no status update after mysql update

[Philipp Niemann]

Package: nagios-mysql
Version: 2:1.3-0+pre6
Severity: important

I experience problems after upgrading mysql from 4.0.22-6 to 4.0.23-1
I am not shure, if this is really a mysql problem. But as all my other
applications don't complain, I am posting it here.

So, after the upgrade, there are no longer useable hoststatus and
servicestatus tables. The WebUI almost hangs on reload and has zero
hosts and zero services configured.

This error message is logged to syslogd (actually
/var/log/nagios/nagios.log):
Error: Could not insert/update status record for host 'datamart' in table 'hoststatus' of database 'nagios'

Any more information? The tables do exist, but have no longer any
content. There often is a process locking the mysql tables.

Maybe it is because nagios is running during the update of mysql?

Regards,
Philipp Niemann

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.4.27-1-686-smp
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages nagios-mysql depends on:
ii  libc6                       2.3.2.ds1-20 GNU C Library: Shared libraries an
ii  libgd2-noxpm                2.0.33-1.1   GD Graphics Library version 2 (wit
ii  libjpeg62                   6b-9         The Independent JPEG Group's JPEG 
ii  libmysqlclient10            3.23.56-2    LGPL-licensed client library for M
ii  libpng12-0                  1.2.8rel-1   PNG library - runtime
ii  nagios-common               2:1.3-0+pre6 A host/service/network monitoring 
ii  zlib1g                      1:1.2.2-3    compression library - runtime

-- no debconf information