connection loss of Nagios XI with mysql

[ednaldojta]

Good afternoon friends,
I have a problem in NagiosXI in Data Display of Dashboards. From time to time he is losing the related to the database (MySQL) and asks to run the script repair_databases.sh
And the process of Mysqld is running.



contents of /var/log/mysqld.log

160303 15:02:03 [Note] Event Scheduler: Purging the queue. 0 events
160303 15:02:03 InnoDB: Starting shutdown...
160303 15:02:08 InnoDB: Shutdown completed; log sequence number 0 44233
160303 15:02:08 [Note] /usr/libexec/mysqld: Shutdown complete

160303 15:02:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160303 15:02:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160303 15:02:08 InnoDB: Initializing buffer pool, size = 8.0M
160303 15:02:08 InnoDB: Completed initialization of buffer pool
160303 15:02:08 InnoDB: Started; log sequence number 0 44233
160303 15:02:08 [Note] Event Scheduler: Loaded 0 events
160303 15:02:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
160303 15:20:49 [Note] /usr/libexec/mysqld: Normal shutdown

160303 15:20:49 [Note] Event Scheduler: Purging the queue. 0 events
160303 15:20:51 InnoDB: Starting shutdown...
160303 15:20:55 InnoDB: Shutdown completed; log sequence number 0 44233
160303 15:20:55 [Note] /usr/libexec/mysqld: Shutdown complete

160303 15:20:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160303 15:20:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160303 15:20:56 InnoDB: Initializing buffer pool, size = 8.0M
160303 15:20:56 InnoDB: Completed initialization of buffer pool
160303 15:20:56 InnoDB: Started; log sequence number 0 44233
160303 15:20:56 [Note] Event Scheduler: Loaded 0 events
160303 15:20:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[rkennedy]

Are you running your SQL local, or remotely?

If it's locally, you can also see SQL errors if the Nagios machine is not shut down gracefully.

[ednaldojta]

Yes! the bank I have is location. As I mentioned in the previous comment and picture when I see in the log mysql , it reports that the schedule of the purge queue started. I wanted to solve!

[Box293]

Are you running your SQL local, or remotely?

What is the output of:

Code: Select all

free -m
df -h
df -i

On the Nagios XI server (and the remote mysql server if there is one)

[ednaldojta]

Yes my bank is in the Nagios Host itself.

Follows the exits of the requested commands.

Note: The problem has already been standardized, however I need to know the root of the problem.

[ednaldojta]

Pardon,
the problem was not standardized, as I said in the comment above. He is still going on. Here is a picture I took of the /var/log/dmesg.


Note: I changed the root password of Mysql one days of this. Sera would that be the causing the problem? And if so, how can I solve this? Help me friend!

[hsmith]

What's the output of a service mysql status command? Did you change any of the other mysql user passwords?

[ednaldojta]

The output of the command is requested:

mysqld (pid 18430) is running ...

Does it have something to InnoDB Crashed?

you saw the output above that sent the /var/log/mysqld.log log?


By the way, I also have an enterprise license, how do you have access to Customer Support?

[rkennedy]

I don't see innodb crashing, maybe I'm missing something - can you post that part of the SQL logs?

If you'd like access to the customer forums, please email [email protected] and they will grant you permission.

[hsmith]

By the way, I also have an enterprise license, how do you have access to Customer Support?

Email [email protected].

If you're a customer, could I ask that you send a ticket in to [email protected]? It may be easier to troubleshoot this issue if we can get a profile from you, and possibly do a remote.