Syslog :
Dec 12 22:35:02 nagios /USR/SBIN/CRON[11973]: (nagios) CMD
(/usr/local/nagios/bin/call_nmis nmis.pl type=collect mthread=true > /dev/null
2>&1)
Dec 12 22:35:02 nagios /USR/SBIN/CRON[11972]: (root) CMD (if [ -x /usr/bin/mrtg
] && [ -r /etc/mrtg.cfg ]; then env LANG=C /usr/bin/mrtg /etc/mrtg.cfg >>
/var/log/mrtg/mrtg$
Dec 12 22:35:03 nagios /USR/SBIN/CRON[11975]: (nagios) CMD
(/usr/local/nagios/bin/mrtg_genstats.sh > /dev/null 2>&1)
Dec 12 22:35:15 nagios ndo2db: Successfully disconnected from MySQL database
Dec 12 22:35:15 nagios ndo2db: Successfully connected to MySQL database
Dec 12 22:36:14 nagios ndo2db: Successfully disconnected from MySQL database
Dec 12 22:36:14 nagios ndo2db: Successfully connected to MySQL database
Dec 12 22:36:34 nagios ndo2db: Successfully disconnected from MySQL database
Dec 12 22:36:34 nagios ndo2db: Successfully connected to MySQL database
There are some older items which contain innodb instructions but seem ok to me.
Opsview is still 3.03.2290
My user.log contains the following errors :
Dec 12 16:48:31 nagios ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_servicechecks SET instance_id='1', service_object_id='7636',
check_type='0', current_chec$
Dec 12 16:48:31 nagios ndo2db: mysql_error: 'The total number of locks exceeds
the lock table size'
Dec 12 16:48:31 nagios ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_servicechecks SET instance_id='1', service_object_id='3663',
check_type='0', current_chec$
Dec 12 16:48:31 nagios ndo2db: mysql_error: 'The total number of locks exceeds
the lock table size'
{Truncated !}
They seem to be related to the instert fails. However Í really don't know how
to fix it.
________________________________
From: [email protected]
[mailto:[email protected]] On Behalf Of Ton Voon
Sent: zaterdag 12 december 2009 22:33
To: Opsview Users
Subject: Re: [opsview-users] Status Page contains old info
On 12 Dec 2009, at 21:13, Peter Plate wrote:
Hello All,
Last night our server with OpsView stopped responding , so we needed to
hard reboot it (power off / on).
Now it seems the checks are ok and still scheduled , however our status
page contains old / outdated info.
For example a service check had a problem today at 1:00 am , it was ok
at 1:15 am (restart of service) , even the status of the service check shows ok
now (clicking on it shows status : OK , and last check time was some minutes
ago)
But on the status page (Alerts > All Unhandled) it is still in CRITICAL
state , and last check is about 8 hours ago , while it is checked every 5
minutes.
Can you help us get the Opsview pages in sync again ?
PS : My Unix knowledge is limited , the system was installed by
previous system administrators , however I learn quickly.
You likely have some database problem where the data is not being inserted
correctly. Check syslog messages for mysql problems.
Which version of Opsview are you using?
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
