Im editing services with CM.When i go Monitoring-->Services Im getting
Error while connecting to database:
[localhost] Connection to the database server has failed by reason:
Too many connections
The error is random and few seconds later is showing all the services correctly
Thanks
Too many connections to database
Re: Too many connections to database
Can you run:
mysql -u root -p'nagiosxi' -e "SHOW PROCESSLIST;"
From the command line, if you changed your default MySQL password, use that in place of nagiosxi.
mysql -u root -p'nagiosxi' -e "SHOW PROCESSLIST;"
From the command line, if you changed your default MySQL password, use that in place of nagiosxi.
Nicholas Scott
Former Nagios employee
Former Nagios employee
Re: Too many connections to database
Code: Select all
[root@pevrtmon1 etc]# mysql -u root -p'nagiosxi' -e "SHOW PROCESSLIST;"
+--------+----------+-----------+----------+---------+-------+-------+----------
--------+
| Id | User | Host | db | Command | Time | State | Info
|
+--------+----------+-----------+----------+---------+-------+-------+----------
--------+
| 228386 | ndoutils | localhost | nagios | Sleep | 18933 | | NULL
|
| 228387 | nagiosql | localhost | nagiosql | Sleep | 18933 | | NULL
|
| 228390 | ndoutils | localhost | nagios | Sleep | 19513 | | NULL
|
| 228391 | nagiosql | localhost | nagiosql | Sleep | 19513 | | NULL
|
| 250970 | ndoutils | localhost | nagios | Sleep | 18823 | | NULL
|
| 250971 | nagiosql | localhost | nagiosql | Sleep | 18823 | | NULL
|
| 250974 | ndoutils | localhost | nagios | Sleep | 19035 | | NULL
|
| 250975 | nagiosql | localhost | nagiosql | Sleep | 19035 | | NULL
|
| 250978 | ndoutils | localhost | nagios | Sleep | 19000 | | NULL
|
| 250979 | nagiosql | localhost | nagiosql | Sleep | 19001 | | NULL
|
| 250980 | ndoutils | localhost | nagios | Sleep | 17833 | | NULL
|
| 250981 | nagiosql | localhost | nagiosql | Sleep | 17833 | | NULL
|
| 279837 | ndoutils | localhost | nagios | Sleep | 18988 | | NULL
|
| 279838 | nagiosql | localhost | nagiosql | Sleep | 18988 | | NULL
|
| 279925 | ndoutils | localhost | nagios | Sleep | 19035 | | NULL
|
| 279926 | nagiosql | localhost | nagiosql | Sleep | 19035 | | NULL
|
| 280287 | ndoutils | localhost | nagios | Sleep | 17768 | | NULL
|
| 280288 | nagiosql | localhost | nagiosql | Sleep | 17768 | | NULL
|
| 290523 | ndoutils | localhost | nagios | Sleep | 18934 | | NULL
|
| 290524 | nagiosql | localhost | nagiosql | Sleep | 18935 | | NULL
|
| 292185 | ndoutils | localhost | nagios | Sleep | 17384 | | NULL
|
| 292186 | nagiosql | localhost | nagiosql | Sleep | 17384 | | NULL
|
| 292193 | ndoutils | localhost | nagios | Sleep | 18831 | | NULL
|
| 292194 | nagiosql | localhost | nagiosql | Sleep | 18831 | | NULL
|
| 295696 | nagiosql | localhost | nagiosql | Sleep | 19472 | | NULL
|
| 295949 | ndoutils | localhost | nagios | Sleep | 16909 | | NULL
|
| 295950 | nagiosql | localhost | nagiosql | Sleep | 16909 | | NULL
|
| 295953 | ndoutils | localhost | nagios | Sleep | 17761 | | NULL
|
| 295954 | nagiosql | localhost | nagiosql | Sleep | 17761 | | NULL
|
| 295957 | ndoutils | localhost | nagios | Sleep | 17696 | | NULL
|
| 295958 | nagiosql | localhost | nagiosql | Sleep | 17696 | | NULL
|
| 295959 | ndoutils | localhost | nagios | Sleep | 18582 | | NULL
|
| 295960 | nagiosql | localhost | nagiosql | Sleep | 18582 | | NULL
|
| 295985 | ndoutils | localhost | nagios | Sleep | 18822 | | NULL
|
| 295986 | nagiosql | localhost | nagiosql | Sleep | 18822 | | NULL
|
| 296025 | ndoutils | localhost | nagios | Sleep | 17368 | | NULL
|
| 296026 | nagiosql | localhost | nagiosql | Sleep | 17368 | | NULL
|
| 296027 | ndoutils | localhost | nagios | Sleep | 17693 | | NULL
|
| 296028 | nagiosql | localhost | nagiosql | Sleep | 17693 | | NULL
|
| 296033 | ndoutils | localhost | nagios | Sleep | 17330 | | NULL
|
| 296034 | nagiosql | localhost | nagiosql | Sleep | 17330 | | NULL
|
| 296565 | ndoutils | localhost | nagios | Sleep | 17727 | | NULL
|
| 296566 | nagiosql | localhost | nagiosql | Sleep | 17733 | | NULL
|
| 296601 | ndoutils | localhost | nagios | Sleep | 17735 | | NULL
|
| 296602 | nagiosql | localhost | nagiosql | Sleep | 17735 | | NULL
|
| 296627 | ndoutils | localhost | nagios | Sleep | 28 | | NULL
|
| 296628 | nagiosql | localhost | nagiosql | Sleep | 28 | | NULL
|
| 296631 | ndoutils | localhost | nagios | Sleep | 25 | | NULL
|
| 296632 | nagiosql | localhost | nagiosql | Sleep | 30 | | NULL
|
| 296633 | ndoutils | localhost | nagios | Sleep | 17461 | | NULL
|
| 296634 | nagiosql | localhost | nagiosql | Sleep | 17461 | | NULL
|
| 296661 | ndoutils | localhost | nagios | Sleep | 13 | | NULL
|
| 296662 | nagiosql | localhost | nagiosql | Sleep | 14 | | NULL
|
| 296665 | ndoutils | localhost | nagios | Sleep | 17143 | | NULL
|
| 296666 | nagiosql | localhost | nagiosql | Sleep | 17143 | | NULL
|
| 296671 | ndoutils | localhost | nagios | Sleep | 17120 | | NULL
|
| 296672 | nagiosql | localhost | nagiosql | Sleep | 17120 | | NULL
|
| 296679 | ndoutils | localhost | nagios | Sleep | 16903 | | NULL
|
| 296680 | nagiosql | localhost | nagiosql | Sleep | 16903 | | NULL
|
| 296775 | ndoutils | localhost | nagios | Sleep | 82 | | NULL
|
| 296776 | nagiosql | localhost | nagiosql | Sleep | 83 | | NULL
|
| 296787 | ndoutils | localhost | nagios | Sleep | 43 | | NULL
|
| 296788 | nagiosql | localhost | nagiosql | Sleep | 43 | | NULL
|
| 296913 | ndoutils | localhost | nagios | Sleep | 28 | | NULL
|
| 296914 | nagiosql | localhost | nagiosql | Sleep | 28 | | NULL
|
| 297173 | ndoutils | localhost | nagios | Sleep | 5 | | NULL
|
| 297174 | nagiosql | localhost | nagiosql | Sleep | 5 | | NULL
|
| 297475 | ndoutils | localhost | nagios | Sleep | 24 | | NULL
|
| 297476 | nagiosql | localhost | nagiosql | Sleep | 25 | | NULL
|
| 297607 | ndoutils | localhost | nagios | Sleep | 13 | | NULL
|
| 297608 | nagiosql | localhost | nagiosql | Sleep | 13 | | NULL
|
| 298296 | ndoutils | localhost | nagios | Sleep | 34 | | NULL
|
| 298297 | nagiosql | localhost | nagiosql | Sleep | 34 | | NULL
|
| 300616 | ndoutils | localhost | nagios | Sleep | 28 | | NULL
|
| 300617 | nagiosql | localhost | nagiosql | Sleep | 28 | | NULL
|
| 300937 | ndoutils | localhost | nagios | Sleep | 23 | | NULL
|
| 300938 | nagiosql | localhost | nagiosql | Sleep | 24 | | NULL
|
| 300957 | ndoutils | localhost | nagios | Sleep | 4 | | NULL
|
| 300958 | nagiosql | localhost | nagiosql | Sleep | 4 | | NULL
|
| 302962 | ndoutils | localhost | nagios | Sleep | 28 | | NULL
|
| 302963 | nagiosql | localhost | nagiosql | Sleep | 28 | | NULL
|
| 302964 | ndoutils | localhost | nagios | Sleep | 13 | | NULL
|
| 302965 | nagiosql | localhost | nagiosql | Sleep | 13 | | NULL
|
| 302966 | ndoutils | localhost | nagios | Sleep | 13 | | NULL
|
| 302967 | nagiosql | localhost | nagiosql | Sleep | 13 | | NULL
|
| 302968 | ndoutils | localhost | nagios | Sleep | 43 | | NULL
|
| 302969 | nagiosql | localhost | nagiosql | Sleep | 44 | | NULL
|
| 303800 | ndoutils | localhost | nagios | Sleep | 43 | | NULL
|
| 303801 | nagiosql | localhost | nagiosql | Sleep | 43 | | NULL
|
| 303822 | ndoutils | localhost | nagios | Sleep | 4 | | NULL
|
| 303823 | nagiosql | localhost | nagiosql | Sleep | 4 | | NULL
|
| 303824 | ndoutils | localhost | nagios | Sleep | 34 | | NULL
|
| 303855 | nagiosql | localhost | nagiosql | Sleep | 34 | | NULL
|
| 305203 | ndoutils | localhost | nagios | Sleep | 0 | | NULL
|
| 305384 | ndoutils | localhost | nagios | Sleep | 47 | | NULL
|
| 305385 | nagiosql | localhost | nagiosql | Sleep | 47 | | NULL
|
| 305390 | root | localhost | NULL | Query | 0 | NULL | SHOW PROC
ESSLIST |
+--------+----------+-----------+----------+---------+-------+-------+----------Re: Too many connections to database
That is an abnormal amount to be sure. It may be possible that your database became corrupted. Have you tried repairing the database? The doc outlines how to do that:
http://assets.nagios.com/downloads/nagi ... tabase.pdf
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Nicholas Scott
Former Nagios employee
Former Nagios employee
Re: Too many connections to database
Another issue, the last services addes keeps the sync status showing up as "Out of Sync" after I apply the configuration sucessfully
Re: Too many connections to database
Lets determine if the database is corrupted, if your database is corrupted that really has to be fixed before we can attempt to fix anything else.
Nicholas Scott
Former Nagios employee
Former Nagios employee
Re: Too many connections to database
Code: Select all
the msql process now, still other problems with out of sync
[root@pevrtmon1 etc]# mysql -u root -p'nagiosxi' -e "SHOW PROCESSLIST;"
+-----+----------+-----------+----------+---------+------+--------+-------------
--------------------------------------------------------------------------------
---------+
| Id | User | Host | db | Command | Time | State | Info
|
+-----+----------+-----------+----------+---------+------+--------+-------------
--------------------------------------------------------------------------------
---------+
| 2 | ndoutils | localhost | nagios | Sleep | 5 | | NULL
|
| 3 | nagiosql | localhost | nagiosql | Sleep | 5 | | NULL
|
| 4 | ndoutils | localhost | nagios | Sleep | 11 | | NULL
|
| 5 | nagiosql | localhost | nagiosql | Sleep | 11 | | NULL
|
| 6 | ndoutils | localhost | nagios | Sleep | 212 | | NULL
|
| 7 | nagiosql | localhost | nagiosql | Sleep | 212 | | NULL
|
| 8 | ndoutils | localhost | nagios | Sleep | 200 | | NULL
|
| 9 | nagiosql | localhost | nagiosql | Sleep | 200 | | NULL
|
| 10 | ndoutils | localhost | nagios | Sleep | 245 | | NULL
|
| 11 | nagiosql | localhost | nagiosql | Sleep | 245 | | NULL
|
| 12 | ndoutils | localhost | nagios | Sleep | 20 | | NULL
|
| 13 | nagiosql | localhost | nagiosql | Sleep | 20 | | NULL
|
| 14 | ndoutils | localhost | nagios | Sleep | 9 | | NULL
|
| 15 | nagiosql | localhost | nagiosql | Sleep | 9 | | NULL
|
| 16 | ndoutils | localhost | nagios | Sleep | 155 | | NULL
|
| 17 | nagiosql | localhost | nagiosql | Sleep | 155 | | NULL
|
| 18 | ndoutils | localhost | nagios | Query | 0 | update | INSERT INTO
nagios_hoststatus SET instance_id='1', host_object_id='455', status_update_time=
FROM_UNI |
| 19 | ndoutils | localhost | nagios | Sleep | 5 | | NULL
|
| 20 | nagiosql | localhost | nagiosql | Sleep | 5 | | NULL
|
| 29 | ndoutils | localhost | nagios | Sleep | 14 | | NULL
|
| 30 | nagiosql | localhost | nagiosql | Sleep | 14 | | NULL
|
| 48 | ndoutils | localhost | nagios | Sleep | 5 | | NULL
|
| 49 | nagiosql | localhost | nagiosql | Sleep | 5 | | NULL
|
| 57 | ndoutils | localhost | nagios | Sleep | 5 | | NULL
|
| 58 | nagiosql | localhost | nagiosql | Sleep | 5 | | NULL
|
| 59 | ndoutils | localhost | nagios | Sleep | 4 | | NULL
|
| 60 | nagiosql | localhost | nagiosql | Sleep | 4 | | NULL
|
| 61 | ndoutils | localhost | nagios | Sleep | 185 | | NULL
|
| 62 | nagiosql | localhost | nagiosql | Sleep | 185 | | NULL
|
| 65 | ndoutils | localhost | nagios | Sleep | 19 | | NULL
|
| 66 | nagiosql | localhost | nagiosql | Sleep | 19 | | NULL
|
| 67 | ndoutils | localhost | nagios | Sleep | 16 | | NULL
|
| 68 | nagiosql | localhost | nagiosql | Sleep | 16 | | NULL
|
| 138 | ndoutils | localhost | nagios | Sleep | 11 | | NULL
|
| 139 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 140 | ndoutils | localhost | nagios | Sleep | 58 | | NULL
|
| 141 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 144 | ndoutils | localhost | nagios | Sleep | 58 | | NULL
|
| 146 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 148 | ndoutils | localhost | nagios | Sleep | 58 | | NULL
|
| 149 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 151 | ndoutils | localhost | nagios | Sleep | 58 | | NULL
|
| 152 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 153 | ndoutils | localhost | nagios | Sleep | 58 | | NULL
|
| 154 | nagiosql | localhost | nagiosql | Sleep | 58 | | NULL
|
| 171 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESS
LIST
|
+-----+----------+-----------+----------+---------+------+--------+-------------
--------------------------------------------------------------------------------
---------+
[root@pevrtmon1 etc]#Re: Too many connections to database
Have you run the database repair procedure outlined in the document posted above?
Re: Too many connections to database
I just opened another topic to get HELP ASAP
We run the repairs, the too many connections error went away, but changes were out of sync after aplly configuration. Now im getting
now im getting
DB Connect Error [nagiosxi]: Database connection failed
We run the repairs, the too many connections error went away, but changes were out of sync after aplly configuration. Now im getting
now im getting
DB Connect Error [nagiosxi]: Database connection failed
Re: Too many connections to database
I ended rebooting the server , it looks fine now