ndo2db have some problem to update nagios tables on mysql

worm-fr

Beginner

Posts: 13

Birthday: Jun 3rd 1972 (38)

Gender: male

Location: FRANCE - PARIS

Occupation: Network & Systems Administrator Engineer

Number of Nagios server: 3

Nagios Versions: 3.0rc3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 200

Number of services: 600

OS: linux windows sun sco aix

Plugin Versions: nagios-plugins-1.4.11

NagVis Version: nagvis-1.3b1

NDO Version: ndoutils-1.4b7

Other Addons: nrpe-2.11

1

Sunday, March 9th 2008, 11:28am

hi all

i have some problem with ndo2db an dmysql :

i have on my syslog :

Mar 9 09:55:45 nagios ndo2db: Successfully connected to MySQL database

Mar 9 10:17:22 nagios ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_timedeventqueue SET instance_id='1', event_type='0',
queued_time=FROM_UNIXTIME(1205054242), queued_time_usec='243300',
scheduled_time=FROM_UNIXTIME(1205054815), recurring_event='0',
object_id='328''

Mar 9 10:18:47 nagios ndo2db: Error: mysql_query() failed for 'DELETE
FROM nagios_servicechecks WHERE instance_id='1' AND
start_time<FROM_UNIXTIME(1204449500)'

and the ndo2db can't insert, delete on the table

the mysql user for this base can SELECT, INSERT, UPDATE, DELETE, FILE on this database

some idea?

ps : versions :
ndoutils-1.4b7a
nagios 3.0rc3
mysql : 5.0.51a-3-log
system : debian SID

Go to the top of the page

einhorn

Trainee

Posts: 94

Gender: male

Location: Oldenburg

Number of Nagios server: 6

Nagios Versions: 2.5

Distributed monitoring: Ja

Redundant monitoring: Ja

Number of hosts: x00

Number of services: x0000

OS: Suse 9.3

Plugin Versions: 1.4.1

NDO Version: 1.3.1

Perfparse Version: 0.105.6

2

Sunday, March 9th 2008, 8:33pm

Hello!

Your problem sounds to me like a problem I had also; NDO starts deleting and Indexes are missing in the database resulting in timeouts.

Can you read german?

Then you could look here: http://www.nagios-portal.de/wbb/index.ph…d&threadID=8172

... otherwise we might have to translate.

You could switch on your slow query log in mysql writing this in your my.cnf and restart mysql:

Quoted

log-slow-queries

long_query_time=2

You will get the slow query log, usually in your data directory of mysql with hints what is lasting to long. I had to add some indexes for delete-queries.

Bernd

Go to the top of the page

worm-fr

Beginner

Posts: 13

Birthday: Jun 3rd 1972 (38)

Gender: male

Location: FRANCE - PARIS

Occupation: Network & Systems Administrator Engineer

Number of Nagios server: 3

Nagios Versions: 3.0rc3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 200

Number of services: 600

OS: linux windows sun sco aix

Plugin Versions: nagios-plugins-1.4.11

NagVis Version: nagvis-1.3b1

NDO Version: ndoutils-1.4b7

Other Addons: nrpe-2.11

3

Sunday, March 9th 2008, 10:02pm

hi einhorn

thinks for your help

i don t read deuch .....

i make long_query_time = 5

i try and i tell you if it s ok

Go to the top of the page

djet

Beginner

Posts: 2

Gender: male

Location: Moscow

Number of Nagios server: 1

Nagios Versions: 3.0.3rc3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 5

OS: CentOS 5.1

Plugin Versions: 1.4.12

NDO Version: 1.4b7

4

Sunday, September 7th 2008, 1:31pm

I have similar entries in syslog:

Quoted

Sep 7 15:04:06 user.info nagios: Nagios 3.0.3 starting... (PID=10812)
Sep 7 15:04:06 user.info nagios: Local time is Sun Sep 07 15:04:06 MSD 2008
Sep 7 15:04:06 user.info nagios: LOG VERSION: 2.0
Sep 7 15:04:06 user.info nagios: ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad ([email][url=mailto:nagios@nagios.org]nagios@nagios.org[/url][/email])
Sep 7 15:04:06 user.info nagios: ndomod: Successfully connected to data sink. 0 queued items to flush.
Sep 7 15:04:06 user.info nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully.
Sep 7 15:04:06 user.info ndo2db: Successfully connected to MySQL database
Sep 7 15:04:06 user.info nagios: Finished daemonizing... (New PID=10815)
Sep 7 15:04:07 user.info ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/contacts\.cfg''
Sep 7 15:04:07 user.info ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/timeperiods\.cfg''
Sep 7 15:04:07 user.info ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/templates\.cfg''
Sep 7 15:04:07 user.info ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/localhost\.cfg''

This is when I try to do the same with mysql:

Quoted

[centreon-2.0-RC3]# mysql -unagios -pnagios nagios

mysql> INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='3', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/localhost\.cfg';
ERROR 1062 (23000): Duplicate entry '1-3-cfg_file' for key 2

I've just installed nagios so don't know if these errors matter..

Go to the top of the page

pitchfork

Super Moderator

Posts: 13,323

Birthday: Jun 13th 1971 (39)

Gender: male

Location: Kassel

Occupation: Sysadmin SAP / Linux / AIX

Number of Nagios server: 2

Hobbies: Motorrad fahren, wenns die Zeit erlaubt :-)

Nagios Versions: 3.2.1

Icinga-Version(en): ---

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 310

Number of services: 4500

OS: Debian 5.0 Lenny

Plugin Versions: 1.4.x

NagVis Version: 1.4.1

NDO Version: ---

IDO-Version: ---

Perfparse Version: ---

Other Addons: SNMPTT, NagTrap, NagVis 1.4.5, check_mk, PNP-0.6.x. Thruk

5

Sunday, September 7th 2008, 2:20pm

Please stop you nagios instance and truncate the table "nagios_configfilevariables"

Start Nagios again.

Regards
Joerg

PNP Developer.
PNP 0.6.6 ist online !
Fragen zu PNP mit Angabe der verwendeten PNP Version werden bevorzugt beantwortet.

Go to the top of the page

djet

Beginner

Posts: 2

Gender: male

Location: Moscow

Number of Nagios server: 1

Nagios Versions: 3.0.3rc3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 5

OS: CentOS 5.1

Plugin Versions: 1.4.12

NDO Version: 1.4b7

6

Monday, September 8th 2008, 12:40am

No go. And it won't help as these actions violate the table specs:

	Source code
1	UNIQUE KEY `instance_id` (`instance_id`,`configfile_id`,`varname`)

Go to the top of the page

hardaway

Beginner

Posts: 3

Number of Nagios server: 1

Nagios Versions: 3.1.5

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 10

Number of services: 50

OS: Debian

Plugin Versions: ndo 1.4 b7

7

Monday, September 22nd 2008, 9:45pm

Hello,

I have exactly the same problem. It happened after a kill of ndomod and when started again some items were not flushed as they reached the limit. In the /var/log/syslog appears:

Sep 22 20:27:36 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='8', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/democontacts\.cfg''
Sep 22 20:27:36 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='8', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/demotimeperiods\.cfg''
Sep 22 20:27:36 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='8', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/demotemplates\.cfg''
Sep 22 20:27:36 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='8', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/demolocalhost\.cfg''

As a result. The notifications (email and sms) takes too long time to arrive!

I tried to reinstall the database and ndomods. Change the filenames in the cfg file. Everything!

I have a demo of Nagios tomorrow... it is going to be a disaster... please I am desperate. Help!

Go to the top of the page

Wolfgang

Sage

Posts: 4,288

Gender: male

Number of Nagios server: 2

Nagios Versions: 3.2.1

Icinga-Version(en): Icinga 1.0.1

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: >70

Number of services: >200

OS: SLES10

Plugin Versions: 1.4.11

NagVis Version: 1.4.5

NDO Version: 1.4b7

Other Addons: NRPE 2.6, NSCA 2.7, PNP 0.4.14 / 0.6

8

Monday, September 22nd 2008, 10:20pm

have you tried to truncate the table mentioned above?

Nagios-Dokumentation im Wiki-Format (3.x) oder als PDF (3.0.6)

aktuelle Icinga-Dokumentation

PNP prüfen ### Format Performance-Daten

Go to the top of the page

hardaway

Beginner

Posts: 3

Number of Nagios server: 1

Nagios Versions: 3.1.5

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 10

Number of services: 50

OS: Debian

Plugin Versions: ndo 1.4 b7

9

Tuesday, September 23rd 2008, 1:01am

Yes, I did it, and it didn't work. I got the same error when starting Nagios again.

What I don't understand it is why it is connected with the fact of that the alerts are not sended (or are sended but half hour or so later)

Its incredible the typical demo efect, When you want to show something, it doesn't work...

Go to the top of the page

Sascha

Professional

Posts: 870

Birthday: Jun 1st

Gender: male

Number of Nagios server: 2

Nagios Versions: 3.0.6

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: >500

Number of services: >2000

OS: Win200x, RHEL3/4/5, VI3, Netware 6.5

Plugin Versions: 1.4.1[12]

NagVis Version: 1.4ß

NDO Version: 1.47b

Other Addons: PNP 0.4.10, Brain 2.0

10

Tuesday, September 23rd 2008, 9:47am

I'm not entirely sure, but I think I remember that brokering inside nagios was blocking. So if nagios is busy with brokering something into the ndo, then the queue comes to an halt and nagios waits for the brokering to finish.

Have you turned on mysql logging? There must be a reason why it refuses to insert those values, as I can see no fault in them.
Do you happen to run innoDB and your ibdata files are full?
What happens if you connect manually as nagios user to the mysql db and issue one of those INSERT statements? Mysql should give you a more in depth error message at least.
Did you create an index by chance?
Do you happen to have 2 instances of nagios/ndomod running, which might try to write into the DB simultanously? Stop nagios/ndo, wait a minute and recheck if all processes are really gone.

S

Go to the top of the page

hardaway

Beginner

Posts: 3

Number of Nagios server: 1

Nagios Versions: 3.1.5

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 10

Number of services: 50

OS: Debian

Plugin Versions: ndo 1.4 b7

11

Tuesday, September 23rd 2008, 1:59pm

I don't understant the thing about brokering, but as explained in the ndo installation, in the nagios.cfg file I have:

	Source code
1 2	event_broker_options=-1 broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

I didn't turned on mysql login

inndoDB and ibdata files? how I check them?

If I tried to add the data manually this is what it happens:

	MySQL queries
1	ERROR 1062 (23000): Duplicate entry '1-17-cfg_file' for key 2

There are 2 processes of ndo running. Is this wrong?

Source code

test2:/usr/local/nagios/etc# ps fax | grep ndo
16995 pts/0	S+ 	0:00      	\_ grep ndo
15286 ?    	Ss 	0:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
14702 ?    	S  	0:00  \_ /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg

Thank you in advance!

Go to the top of the page

Sascha

Professional

Posts: 870

Birthday: Jun 1st

Gender: male

Number of Nagios server: 2

Nagios Versions: 3.0.6

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: >500

Number of services: >2000

OS: Win200x, RHEL3/4/5, VI3, Netware 6.5

Plugin Versions: 1.4.1[12]

NagVis Version: 1.4ß

NDO Version: 1.47b

Other Addons: PNP 0.4.10, Brain 2.0

12

Tuesday, September 23rd 2008, 2:41pm

Quoted from "hardaway"
I don't understant the thing about brokering, but as explained in the ndo installation, in the nagios.cfg file I have:
Source code
1
2
event_broker_options=-1
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

Doesn't matter, as it is obvious that it has to be another problem.

Quoted
If I tried to add the data manually this is what it happens:
MySQL queries
1
ERROR 1062 (23000): Duplicate entry '1-17-cfg_file' for key 2

This still sounds like you have 2 instances running...

Quoted

There are 2 processes of ndo running. Is this wrong?

That's correct if nagios is running.
One process is forked by nagios for the ndo connect and the other you should have started yourself before starting nagions.

Source code

1
2

1   500  4585     1  18   0   6692   384 414507 Ss   ?          0:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
1   500 19817  4585  18   0   7100  1560 -      S    ?          6:29  \_ /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg

One of them should have PPID 1 and the other has the PPID of the first ndo2db instance.

Please do the following:

	Source code
1	/etc/init.d/nagios stop (or whatever way you start/stop your nagios)

wait a minute and do a

	Source code
1	ps axu \| egrep "nagios\|ndo"

.

Please post the output of that here.

S

Go to the top of the page

worm-fr

Beginner

Posts: 13

Birthday: Jun 3rd 1972 (38)

Gender: male

Location: FRANCE - PARIS

Occupation: Network & Systems Administrator Engineer

Number of Nagios server: 3

Nagios Versions: 3.0rc3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 200

Number of services: 600

OS: linux windows sun sco aix

Plugin Versions: nagios-plugins-1.4.11

NagVis Version: nagvis-1.3b1

NDO Version: ndoutils-1.4b7

Other Addons: nrpe-2.11

13

Wednesday, September 24th 2008, 5:40am

always some problem....

hi

ps axu | egrep "nagios|ndo"
nagios 394 1.6 1.2 4800 1576 ? S 01:12 4:23 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios 395 1.1 1.7 15940 2236 ? Ssl 01:12 3:05 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 26435 0.0 0.2 4560 256 ? Ss Sep23 0:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg

Sep 24 05:34:55 nagios3 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_timedevents SET instance_id='1', event_type='8', queued_time=FROM_UNIXTIME(1222227295), queued_time_usec='80559', scheduled_
time=FROM_UNIXTIME(1222227305), recurring_event='1', object_id='0' ON DUPLICATE KEY UPDATE instance_id='1', event_type='8', queued_time=FROM_UNIXTIME(1222227295), queued_time_usec='80559', scheduled_time=FROM
_UNIXTIME(1222227305), recurring_event='1', object_id='0''

and a second type error

Sep 24 04:22:47 nagios3 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='66', status_update_time=FROM_UNIXTIME(1222222967), output='SWAP OK - 5
6% free \(269 MB out of 486 MB\)', perfdata='swap=269MB;24;4;0;486', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='4', last_check=FROM_UNIXTI
ME(1222221237), next_check=FROM_UNIXTIME(1222222967), check_type='0', last_state_change=FROM_UNIXTIME(1222135717), last_hard_state_change=FROM_UNIXTIME(1221854463), last_hard_state='0', last_time_ok=FROM_UNIX
TIME(1222221237), last_time_warning=FROM_UNIXTIME(1221819819), last_time_unknown=FROM_UNIXTIME(1222135657), last_time_critical=FROM_UNIXTIME(1221854583), state_type='1', last_notification=FROM_UNIXTIME(0), ne
xt_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_chec

some one have the same problem?

thx

Go to the top of the page

lbou16

Beginner

Posts: 1

Birthday: May 12th

Location: france

Occupation: ingenieur

Number of Nagios server: 1

Nagios Versions: 3.0.3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 10

Number of services: 30

OS: Centos 5.2

Plugin Versions: 1.4.13

NDO Version: 1.4b7

14

Friday, October 10th 2008, 10:23am

ndo2db have some problem to update nagios tables on mysql

Yes I have exactly the same problem.

I've googled for this probleme but I don't find a lot of people having the same problem.....

The log message ends on "passive_chec" just in a middle of the word, is it due to a maximal size of log message, or a syntax error in the binary ndo2db-3x ?

My log Message :

Oct 9 18:35:00 server-nagios ndo2db-3x: Error: mysql_query() failed for 'INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='156', status_update_time=FROM_UNIXTIME(1223570100), output='A linkUp trap signifies that the SNMP entity, acting in an 4', perfdata='', current_state='2', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='1', last_check=FROM_UNIXTIME(1223564809), next_check=FROM_UNIXTIME(1223564869), check_type='1', last_state_change=FROM_UNIXTIME(1223564809), last_hard_state_change=FROM_UNIXTIME(1223564809), last_hard_state='2', last_time_ok=FROM_UNIXTIME(1223564186), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1223564809), state_type='1', last_notification=FROM_UNIXTIME(1223564811), next_notification=FROM_UNIXTIME(2147483648), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='1', passive_chec

It is a trap received (test) that must be inserted in the nagios_servicestatus table of the ndo database.

Any help would be great !

thanks in advance.

Go to the top of the page

klauskinski

Beginner

Posts: 1

Number of Nagios server: 4

Nagios Versions: 3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: ??

Number of services: ??

OS: RedHat

Plugin Versions: 1.4.13

NDO Version: 4

15

Monday, November 10th 2008, 11:57pm

Hi,

Has anybody found a solution? I'm facing the same problem - help would be appreciated (yes, I tried to truncate the table and it did not work). Thanks!

Klaus

Nov 10 23:41:43 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='11', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/contacts\.cfg''
Nov 10 23:41:43 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='11', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/timeperiods\.cfg''
Nov 10 23:41:43 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='11', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/templates\.cfg''
Nov 10 23:41:43 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='11', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/localhost\.cfg''

Go to the top of the page

Sascha

Professional

Posts: 870

Birthday: Jun 1st

Gender: male

Number of Nagios server: 2

Nagios Versions: 3.0.6

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: >500

Number of services: >2000

OS: Win200x, RHEL3/4/5, VI3, Netware 6.5

Plugin Versions: 1.4.1[12]

NagVis Version: 1.4ß

NDO Version: 1.47b

Other Addons: PNP 0.4.10, Brain 2.0

16

Tuesday, November 11th 2008, 9:35am

Quoted from "klauskinski"

Hi,

Has anybody found a solution? I'm facing the same problem - help would be appreciated (yes, I tried to truncate the table and it did not work). Thanks!

Nov 10 23:41:43 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='11', varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/contacts\.cfg''

Did you have a recent crash on your system, or did you kill ndo/nagios manually?
This sometimes happens when ndo doesn't have the chance to clean up the "realtime" tables.
If you don't have any historical data you need, you could just wipe the DB and recreate it with the scripts from the ndoutils.

S

Go to the top of the page

lausser

Professional

Posts: 1,216

Gender: male

Location: München

Occupation: Informatiker

Number of Nagios server: 1

Nagios Versions: 3.2.0

Distributed monitoring: Nein

Redundant monitoring: Ja

Number of hosts: 204

Number of services: 3855

OS: Linux/SLES10, CentOS5.2

Plugin Versions: 1.4.14

NDO Version: 1.4b7

Other Addons: PNP

17

Tuesday, November 11th 2008, 11:50am

This is a known bug. Use Google and this forum's search function and you will find the solution.

	Source code
1 2	ALTER TABLE `nagios_configfilevariables` DROP INDEX `instance_id` , ADD INDEX `instance_id` ( `instance_id` , `configfile_id` )

Gerhard

Go to the top of the page

Reead

Beginner

Posts: 1

Number of Nagios server: 1

Nagios Versions: 3

Distributed monitoring: Ja

Redundant monitoring: Nein

Number of hosts: 250

Number of services: 250

OS: 5

Plugin Versions: 3

NDO Version: 1

18

Wednesday, August 12th 2009, 12:00pm

check the table columns

A sample in my messages log:

Aug 12 15:32:23 server ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='1', status_update_time=FROM_UNIXTIME(1250076743), output='PING OK - Packet loss = 0%, RTA = 0\.08 ms', long_output='', p ......

what i did was to first get the full statement in log

1) I changed my mysql config file, my.cnf

log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog.
#
# Here you can see queries with especially long duration
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 5

2) copied the statement from mysql.log and pasted it in the cmd of mysql

3) add Column " long_output " to the tables of nagios_servicecheck, nagios_servicestatus,nagios_hoststatus

4) alter table nagios_hoststatus
add column long_output varchar(255);

it solved the problem