Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
how many poller.php / poller-wrapper.py and discovery.php processes are running?
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
observium had 45 processes configured and was running fine. Previously we had mysql 5.7
El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running?
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
That's not what I asked.
How many of those processes are running on the system when it is complaining about connections?
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:
observium had 45 processes configured and was running fine. Previously we had mysql 5.7
El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (<observium@lists.observium.org mailto:observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running? adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:Hi We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections. By defaults, Mariadb support only 100 connections, How much connections we must enabled (recommended)? pd: we changed to 500 connections but the message shows again -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7
El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
That's not what I asked.
How many of those processes are running on the system when it is complaining about connections?
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:
observium had 45 processes configured and was running fine. Previously we had mysql 5.7
El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running?
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
"ps aux" on the server console
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:
I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7
El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (<observium@lists.observium.org mailto:observium@lists.observium.org>) escribió:
That's not what I asked. How many of those processes are running on the system when it is complaining about connections? Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:observium had 45 processes configured and was running fine. Previously we had mysql 5.7 El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: how many poller.php / poller-wrapper.py and discovery.php processes are running? adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:Hi We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections. By defaults, Mariadb support only 100 connections, How much connections we must enabled (recommended)? pd: we changed to 500 connections but the message shows again -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
ps aux | wc -l ->533 ps aux | grep wrapper | wc -l ->39
El mié, 15 mar 2023 a las 15:08, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
"ps aux" on the server console
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:
I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7
El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
That's not what I asked.
How many of those processes are running on the system when it is complaining about connections?
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:
observium had 45 processes configured and was running fine. Previously we had mysql 5.7
El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running?
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
If it's running 39 wrappers, it's going to be running a bazillion pollers.
Reboot the machine and see if it behaves better after that (or kill all *.php and *.py processes, but reboot is easier)
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:15:
ps aux | wc -l ->533 ps aux | grep wrapper | wc -l ->39
El mié, 15 mar 2023 a las 15:08, Adam Armstrong via observium (<observium@lists.observium.org mailto:observium@lists.observium.org>) escribió:
"ps aux" on the server console adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7 El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: That's not what I asked. How many of those processes are running on the system when it is complaining about connections? Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:observium had 45 processes configured and was running fine. Previously we had mysql 5.7 El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: how many poller.php / poller-wrapper.py and discovery.php processes are running? adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:Hi We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections. By defaults, Mariadb support only 100 connections, How much connections we must enabled (recommended)? pd: we changed to 500 connections but the message shows again -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
ok. thanks
El mié, 15 mar 2023 a las 15:22, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
If it's running 39 wrappers, it's going to be running a bazillion pollers.
Reboot the machine and see if it behaves better after that (or kill all *.php and *.py processes, but reboot is easier)
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:15:
ps aux | wc -l ->533 ps aux | grep wrapper | wc -l ->39
El mié, 15 mar 2023 a las 15:08, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
"ps aux" on the server console
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:
I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7
El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
That's not what I asked.
How many of those processes are running on the system when it is complaining about connections?
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:
observium had 45 processes configured and was running fine. Previously we had mysql 5.7
El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (< observium@lists.observium.org>) escribió:
how many poller.php / poller-wrapper.py and discovery.php processes are running?
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:
Hi
We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections.
By defaults, Mariadb support only 100 connections,
How much connections we must enabled (recommended)?
pd: we changed to 500 connections but the message shows again
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
-- Sent from Postbox https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
This is likely caused by your system being quite close to the limit for performance for the number of devices you're monitoring.
If it gets overloaded, poller processes won't end quickly enough, more poller processes will be started causing everything to get slower and slower, and you end up with a snowball effect that consumes all of the mysql connections.
We do have some limiters to help prevent this, but it's not easily possible to totally prevent it, given the massive range of installations we have.
It shouldn't be the case that MySQL was significantly faster than Mariadb, but more likely that the act of upgrading and starting/stopping the database caused the issue.
It might also be a warning to increase resources on the polling server.
adam.
Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:23:
ok. thanks
El mié, 15 mar 2023 a las 15:22, Adam Armstrong via observium (<observium@lists.observium.org mailto:observium@lists.observium.org>) escribió:
If it's running 39 wrappers, it's going to be running a bazillion pollers. Reboot the machine and see if it behaves better after that (or kill all *.php and *.py processes, but reboot is easier) Arnoldo Vidal Bravo via observium wrote on 15/03/2023 18:15:ps aux | wc -l ->533 ps aux | grep wrapper | wc -l ->39 El mié, 15 mar 2023 a las 15:08, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: "ps aux" on the server console adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:37:I'm not sure where to see that information. We have configured Observium according to the help for installation in Centos 7 El mié, 15 mar 2023 a las 14:30, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: That's not what I asked. How many of those processes are running on the system when it is complaining about connections? Arnoldo Vidal Bravo via observium wrote on 15/03/2023 17:25:observium had 45 processes configured and was running fine. Previously we had mysql 5.7 El mié, 15 mar 2023 a las 14:12, Adam Armstrong via observium (<observium@lists.observium.org <mailto:observium@lists.observium.org>>) escribió: how many poller.php / poller-wrapper.py and discovery.php processes are running? adam. Arnoldo Vidal Bravo via observium wrote on 15/03/2023 14:17:Hi We perform an update to our DB to mariadb 10.11, but now it show this message DB not connected, please check database connection configuration.DB Error 1040: Too many connections. By defaults, Mariadb support only 100 connections, How much connections we must enabled (recommended)? pd: we changed to 500 connections but the message shows again -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org> -- Saluda cordialmente _______________________________________________ observium mailing list --observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email toobservium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>-- Sent from Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=siglink&utm_campaign=reach> _______________________________________________ observium mailing list -- observium@lists.observium.org <mailto:observium@lists.observium.org> To unsubscribe send an email to observium-leave@lists.observium.org <mailto:observium-leave@lists.observium.org>--
Saluda cordialmente
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
partisipan (2)
-
Adam Armstrong -
Arnoldo Vidal Bravo