Database maintenance in error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
bennyboy
Posts: 157
Joined: Thu Oct 29, 2015 9:42 am

Re: Database maintenance in error

Post by bennyboy »

Its possible to schedule a zoom to troubleshoot together ?
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Database maintenance in error

Post by ssax »

Did you make these changes from the other post? (please do it if you didn't)

Code: Select all

max_allowed_packet=512M
max_connections=800
Please create a ticket for this and include a link back to this forum thread so we can get a remote session setup:

https://support.nagios.com/tickets/

Thank you!
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Database maintenance in error

Post by ssax »

Locking thread, ticket received, we will continue support through the ticket.

Thank you!

EDIT: The fix was to set these (back to the defaults) as they were set too low:

Code: Select all

# /etc/my.cnf
[mysqld]
interactive_timeout = 28800
wait_timeout = 28800
Then restart the msyqld/mysql/mariadb service.
Locked