[Pkg-nagios-devel] Bug#607925: ndoutils-nagios3-mysql: MySQL database schema is not updated when upgrading to 1.4b9

[Julien Cristau]

user release.debian.org at packages.debian.org
usertag 607925 squeeze-will-remove
kthxbye

On Fri, Dec 24, 2010 at 16:52:16 +0300, Konstantin Khomoutov wrote:

> 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'' 
> 
This needs to get fixed soon or the package will have to be removed from
squeeze; tagging accordingly.

Cheers,
Julien
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 836 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-nagios-devel/attachments/20101226/707c8045/attachment.pgp>