Package: ndoutils-nagios3-mysql Version: 1.4b9-1 Severity: grave Justification: renders package unusable
After upgrading a server from Lenny to Squeeze, ndo2db attempts to insert records in its MySQL database started to fail -- in the /var/log/messages we see (lines wrapped for readability purposes): Dec 24 16:19:06 icarus ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='444', status_update_time=FROM_UNIXTIME(1293196746), output='PING OK - Packet loss = 0%, RTA = 0\.31 ms', long_output='', perfdata='rta=0\.306000ms;100\.000000;500\.000000;0\.000000 pl=0%;20;60;0', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='2', last_check=FROM_UNIXTIME(1293196740), next_check=FROM_UNIXTIME(1293196800), check_type='0', last_state_change=FROM_UNIXTIME(1292421071), last_hard_state_change=FROM_UNIXTIME(1292420771), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1293196740), last_time_warning=FROM_UNIXTIME(1292420651), last_time_unknown=FROM_UNIXTIME(1290096021), last_time_critical=FROM_UNIXTIME(1292421011), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgeme Dec 24 16:19:06 icarus ndo2db: mysql_error: 'Unknown column 'long_output' in 'field list'' In the upstream changelog for the 1.4b9 version, we see this line: - Support for long performance data which seems to correlate with the name of the missing column. Further exploration shows that this really corresponds to the integration of the patch http://tracker.nagios.org/view.php?id=18 which, among other things, modifies five tables adding one extra column to each of them. Ideally, this schema change should be handled automatically when upgrading the package, or at least a bold note should be put into NEWS.Debian so that the administrator is set aware of the problem. -- System Information: Debian Release: squeeze/sid APT prefers testing APT policy: (990, 'testing'), (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686 (SMP w/4 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages ndoutils-nagios3-mysql depends on: ii dbconfig-common 1.8.46 common framework for packaging dat ii debconf [debconf-2.0] 1.5.36 Debian configuration management sy ii libc6 2.11.2-7 Embedded GNU C Library: Shared lib ii libmysqlclient16 5.1.49-3 MySQL database client library ii mysql-client-5.1 [mysql-clie 5.1.49-3 MySQL database client binaries ii nagios3 3.2.1-2 A host/service/network monitoring ii ndoutils-common 1.4b9-1 NDOUtils common files ii ucf 3.0025+nmu1 Update Configuration File: preserv Versions of packages ndoutils-nagios3-mysql recommends: ii mysql-server-5.1 [mysql-serve 5.1.49-3 MySQL database server binaries and Versions of packages ndoutils-nagios3-mysql suggests: pn ndoutils-doc <none> (no description available) -- Configuration Files: /etc/default/ndoutils changed: ENABLE_NDOUTILS=1 DAEMON_OPTS="-c /etc/nagios3/ndo2db.cfg" -- debconf information: ndoutils-mysql/install-error: abort ndoutils-mysql/mysql/admin-user: root ndoutils-mysql/remote/newhost: ndoutils-mysql/remote/host: ndoutils-mysql/database-type: mysql ndoutils-mysql/remove-error: abort ndoutils-mysql/remote/port: ndoutils-mysql/db/app-user: ndoutils * ndoutils-mysql/dbconfig-install: true ndoutils-mysql/dbconfig-upgrade: true ndoutils-mysql/internal/reconfiguring: false ndoutils-mysql/upgrade-error: abort ndoutils-mysql/internal/skip-preseed: false ndoutils-mysql/upgrade-backup: true ndoutils-mysql/missing-db-package-error: abort ndoutils-mysql/mysql/method: unix socket ndoutils-mysql/dbconfig-remove: ndoutils-mysql/db/dbname: ndoutils ndoutils-mysql/passwords-do-not-match: ndoutils-mysql/purge: false ndoutils-mysql/dbconfig-reinstall: false -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
