Nagios Support Forum

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

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.

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!

Are you running your SQL local, or remotely?

What is the output of:
On the Nagios XI server (and the remote mysql server if there is one)

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.

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!

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

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?

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.

ednaldojta wrote: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.