Page 1 of 2
Too many connections to database
Posted: Wed Jun 29, 2011 2:33 pm
by perryell
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
Re: Too many connections to database
Posted: Wed Jun 29, 2011 3:10 pm
by nscott
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.
Re: Too many connections to database
Posted: Wed Jun 29, 2011 3:42 pm
by perryell
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
Posted: Wed Jun 29, 2011 4:26 pm
by nscott
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
Re: Too many connections to database
Posted: Wed Jun 29, 2011 4:28 pm
by perryell
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
Posted: Wed Jun 29, 2011 4:31 pm
by nscott
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.
Re: Too many connections to database
Posted: Wed Jun 29, 2011 5:03 pm
by perryell
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
Posted: Thu Jun 30, 2011 10:39 am
by mguthrie
Have you run the database repair procedure outlined in the document posted above?
Re: Too many connections to database
Posted: Thu Jun 30, 2011 1:33 pm
by perryell
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
Re: Too many connections to database
Posted: Thu Jun 30, 2011 2:46 pm
by perryell
I ended rebooting the server , it looks fine now