Error Message after applying a configchange

[sikainfo]

Hi abrist,

attached th DB-Log.

Code: Select all

140206 16:08:41 [Note] /usr/libexec/mysqld: Shutdown complete

140206 16:08:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140206 16:09:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140206 16:09:19  InnoDB: Initializing buffer pool, size = 128.0M
140206 16:09:19  InnoDB: Completed initialization of buffer pool
140206 16:09:20  InnoDB: Started; log sequence number 0 2162582
140206 16:09:20 [Note] Event Scheduler: Loaded 0 events
140206 16:09:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140206 16:09:45 [Note] /usr/libexec/mysqld: Normal shutdown

140206 16:09:45 [Note] Event Scheduler: Purging the queue. 0 events
140206 16:09:47  InnoDB: Starting shutdown...
140206 16:09:50  InnoDB: Shutdown completed; log sequence number 0 2162582
140206 16:09:50 [Note] /usr/libexec/mysqld: Shutdown complete

140206 16:09:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140206 16:09:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140206 16:09:51  InnoDB: Initializing buffer pool, size = 128.0M
140206 16:09:51  InnoDB: Completed initialization of buffer pool
140206 16:09:51  InnoDB: Started; log sequence number 0 2162582
140206 16:09:51 [Note] Event Scheduler: Loaded 0 events
140206 16:09:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
[root@chsismon1 ~]# tail -25 /var/log/mysqld.log
140206 16:08:41 [Note] /usr/libexec/mysqld: Shutdown complete

140206 16:08:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140206 16:09:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140206 16:09:19  InnoDB: Initializing buffer pool, size = 128.0M
140206 16:09:19  InnoDB: Completed initialization of buffer pool
140206 16:09:20  InnoDB: Started; log sequence number 0 2162582
140206 16:09:20 [Note] Event Scheduler: Loaded 0 events
140206 16:09:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140206 16:09:45 [Note] /usr/libexec/mysqld: Normal shutdown

140206 16:09:45 [Note] Event Scheduler: Purging the queue. 0 events
140206 16:09:47  InnoDB: Starting shutdown...
140206 16:09:50  InnoDB: Shutdown completed; log sequence number 0 2162582
140206 16:09:50 [Note] /usr/libexec/mysqld: Shutdown complete

140206 16:09:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140206 16:09:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140206 16:09:51  InnoDB: Initializing buffer pool, size = 128.0M
140206 16:09:51  InnoDB: Completed initialization of buffer pool
140206 16:09:51  InnoDB: Started; log sequence number 0 2162582
140206 16:09:51 [Note] Event Scheduler: Loaded 0 events
140206 16:09:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

I'll be available for further tests now, for about 6 hours.

THX Andy

[lmiltchev]

Hm-m-m, there is nothing in the log about crashed tables, so this is not the problem. Run the following commands and show us the output:

Code: Select all

ll /usr/local/nagiosxi/scripts/nagiosql*
grep "max_execution_time =" /etc/php.ini
grep "memory_limit =" /etc/php.ini

[sikainfo]

Here the results :

Code: Select all

[root@chsismon1 ~]# ll /usr/local/nagiosxi/scripts/nagiosql*
-rw-r----- 1 nagios nagios    153 Feb 19 11:27 /usr/local/nagiosxi/scripts/nagiosql.cookies
-rwxr-x--- 1 nagios nagios 271780 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_defaults.sql
-rw-r----- 1 nagios nagios  22666 Jan 31 12:45 /usr/local/nagiosxi/scripts/nagiosql.delete.contact
-rwxr-x--- 1 nagios nagios    970 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_delete_contact.php
-rwxr-x--- 1 nagios nagios   2010 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_delete_host.php
-rwxr-x--- 1 nagios nagios    505 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_delete_object.sh
-rwxr-x--- 1 nagios nagios   2867 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_delete_service.php
-rw-r----- 1 nagios nagios  23182 Dec  4  2012 /usr/local/nagiosxi/scripts/nagiosql.delete.timeperiod
-rwxr-x--- 1 nagios nagios    993 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_delete_timeperiod.php
-rw-r----- 1 nagios nagios   7400 Feb 19 11:10 /usr/local/nagiosxi/scripts/nagiosql.export.additional
-rwxr-x--- 1 nagios nagios   1637 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_exportall.php
-rw-r----- 1 nagios nagios   4788 Feb 19 11:28 /usr/local/nagiosxi/scripts/nagiosql.export.monitoring
-rwxr-x--- 1 nagios nagios   1323 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_importall.php
-rw-r----- 1 nagios nagios 165117 Feb 18 10:22 /usr/local/nagiosxi/scripts/nagiosql.import.monitoring
-rw-r----- 1 nagios nagios   5286 Feb 19 11:27 /usr/local/nagiosxi/scripts/nagiosql.login
-rwxr-x--- 1 nagios nagios   1847 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_login.php
-rwxr-x--- 1 nagios nagios   2246 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_snapshot.sh
-rwxr-x--- 1 nagios nagios    258 Jan 29 12:41 /usr/local/nagiosxi/scripts/nagiosql_trim_backups.sh

[root@chsismon1 ~]# grep "max_execution_time =" /etc/php.ini
max_execution_time = 30

[root@chsismon1 ~]# grep "memory_limit =" /etc/php.ini
memory_limit = 128M

[lmiltchev]

I don't see any issues with permissions, but you can try to increase the "max_execution_time" from 30 to 60 or 90, depending on how large your setup is. You can also increase the "memory_limit".

Code: Select all

max_execution_time = 90
memory_limit = 256M

Restart apache:

Code: Select all

service httpd restart

then run:

Code: Select all

cd /usr/local/nagiosxi/scripts
 ./reconfigure_nagios.sh

If this doesn't fix your issue, we may have to schedule a remote session to further troubleshoot the issue. Please, send us an email at [email protected].

[sikainfo]

Hey folks,
seems to work i tested two times and did not run on an error after pressing the button Apply configuration.
THX for the moment, if you do not hear me again here till Friday you may close this.

Tanks again

Regards Andy

[tmcdonald]

We'll keep it open for you.

[sikainfo]

Hi there,

everything looks fine, and was tested throughout the last week, you may close this one.

THX again

Andy