Services disappeared

[Morse]

I am running the latest version.

No segmentation faults, but there are a huge amount of errors (several a second since around the time the issue started) mentioning an undefined index Max/min/avg_execution/latency_time in /usr/local/nagiosxi/html/includex/utils-xmlsysstat.inc.php on line 117/18/19/20, with the referer being my nagiosxi config url.

Hi,

I have the same error and I'm repairing the database but have this exit

/usr/local/nagiosxi/scripts/repairmysql.sh nagios
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /var/lib/mysql/nagios
Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
myisamchk: error: File '*.MYI' doesn't exist
/var/lib/mysql/nagios

===============
REPAIR COMPLETE
===============

And this error in the HTTPD log: /var/log/httpd/error_log


[error] [client x.x.x.x] PHP Notice: Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://x.x.x.x/nagiosxi/config/nagioscorecfg/

Thanks

[mguthrie]

I think you're missing the last argument for that script:

Try:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios *

[Morse]

I think you're missing the last argument for that script:

Try:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios *

With arguments have the same error :

# /usr/local/nagiosxi/scripts/repairmysql.sh nagios *
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
myisamchk: error: File '*.MYI' doesn't exist
~

===============
REPAIR COMPLETE
===============

[snel afvallen]

also thanks for the useful information

[raise]

Has anyone found a way around this?

Thank you in advance!

[djl]

I had the same problem. It looks like this fixed it. Thanks!

[josephlott]

it works for me now too. Thanks for good info

[mguthrie]

Morse, your tables are EXTREMELY large at this point, and the repair might be failing due to a memory limit in the mysql repair tool (there's a known bug in this particular version of mysql related to very large tables). Run:

Code: Select all

 ll /var/lib/mysql/nagios

To show us a listing of how large those files are. I also recommend setting some table maintenance options in the Admin->Performance settings page, to keep the tables smaller. Then run:

Code: Select all

/usr/local/nagiosxi/cron/dbmaint.php

And see if it can trim the table down. If both the repair script and the dbmaint.php scripts are still giving those errors afterwards then the tables might need to be dropped and rebuilt.

[SamJenks]

Yeah, I had exact same problem and this fixed it!

[monkeybiz]

Also had this problem. it was fixed. Thinking about the time I wasted dealing with this problem and the solution is right here.