Impossible d’accéder à une de mes Smart ce matin : SQLSTATE[HY000] [1040] Too many connections. Après reboot, j’ai vérifié le nombre max. de connections possibles : 151. Mémoire disponible : 1,7GB. Jeedom à jour. Charge système 0.1 en moyenne, max 0.25. Aucun script. Dans les log scénarios, problèmes récurrents de « Chauffage » pour moi aussi qui, cumulés et vu leur fréquence, ont certainement entraînés l’emballement du nombre de connections… Cette Smart était stable depuis plusieurs mois. J’ai dû l’arrêter il y a une semaine pour insérer un UPS sur son alim mais rien d’autre. J’ai bien lu tous vos posts ci-dessus et vous en remercie car j’y ai appris quelque chose mais j’hésite à bidouiller la BD sans savoir quel est l’impact de mettre les connections en non-persistant. Dit différemment, pourquoi un développeur l’aurait-t-il mis sur persistant si le non-persistant est plus pertinent ? Le béotien que je suis a besoin d’aide !
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
Stack trace:
#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40`
0900|Stack trace:
0901|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0902|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0903|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0904|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0905|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0906|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0907|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0908|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0909|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0910|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0911|[Wed Apr 20 07:11:00.843533 2022] [php7:error] [pid 17944] [client 127.0.0.1:53633] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0912|Stack trace:
0913|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0914|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0915|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0916|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0917|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0918|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0919|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0920|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0921|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0922|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0923|[Wed Apr 20 07:11:00.865017 2022] [php7:error] [pid 15707] [client 127.0.0.1:53634] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0924|Stack trace:
0925|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0926|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0927|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0928|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0929|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0930|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0931|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0932|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0933|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0934|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0935|[Wed Apr 20 07:11:00.883700 2022] [php7:error] [pid 15708] [client 127.0.0.1:53635] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0936|Stack trace:
0937|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0938|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0939|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0940|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0941|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0942|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0943|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0944|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0945|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0946|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0947|[Wed Apr 20 07:11:04.755703 2022] [php7:error] [pid 14038] [client 127.0.0.1:53644] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0948|Stack trace:
0949|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0950|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0951|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0952|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0953|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0954|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0955|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0956|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0957|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0958|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0959|[Wed Apr 20 07:11:04.775236 2022] [php7:error] [pid 15732] [client 127.0.0.1:53645] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0960|Stack trace:
0961|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0962|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0963|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0964|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0965|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0966|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0967|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0968|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0969|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0970|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0971|[Wed Apr 20 07:11:04.796590 2022] [php7:error] [pid 15702] [client 127.0.0.1:53646] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:40
0972|Stack trace:
0973|#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '8007f680c36b1d8', Array)
0974|#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
0975|#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
0976|#3 /var/www/html/core/class/config.class.php(190): DB::Prepare('SELECT `key`,`v...', Array, 1)
0977|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys(Array)
0978|#5 /var/www/html/core/class/translate.class.php(205): translate::getConfig('language', 'fr_FR')
0979|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0980|#7 /var/www/html/core/class/translate.class.php(81): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
0981|#8 /var/www/html/core/class/translate.class.php(218): translate::sentence('Chauffage', '/var/www/html/c...', false)
0982|#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage', '/ in /var/www/html/core/class/DB.class.php on line 40
0983|[Wed Apr 20 06:26:19.115112 2022] [mpm_prefork:notice] [pid 428] AH00163: Apache/2.4.38 (Debian) configured -- resuming normal operations
0984|[Wed Apr 20 06:26:19.115824 2022] [core:notice] [pid 428] AH00094: Command line: '/usr/sbin/apache2'
0985|[Wed Apr 20 08:07:18.359521 2022] [php7:error] [pid 4461] [client 192.168.0.152:56883] PHP Fatal error: Uncaught Error: Call to undefined method openzwave::getBackgroundColor() in /var/www/html/plugins/widget/core/class/widget.class.php:421
0986|Stack trace:
0987|#0 /var/www/html/plugins/widget/core/ajax/widget.ajax.php(152): widget->displayExemple()
0988|#1 {main}
0989|thrown in /var/www/html/plugins/widget/core/class/widget.class.php on line 421, referer: http://192.168.0.154/index.php?v=d&m=widget&p=widget
0990|[Wed Apr 20 08:07:49.747057 2022] [php7:error] [pid 561] [client 192.168.0.152:56897] PHP Fatal error: Uncaught Error: Call to undefined method Monitoring::getBackgroundColor() in /var/www/html/plugins/widget/core/class/widget.class.php:421
0991|Stack trace:
0992|#0 /var/www/html/plugins/widget/core/ajax/widget.ajax.php(152): widget->displayExemple()
0993|#1 {main}
0994|thrown in /var/www/html/plugins/widget/core/class/widget.class.php on line 421, referer: http://192.168.0.154/index.php?v=d&m=widget&p=widget
0995|[Wed Apr 20 08:08:39.635804 2022] [php7:error] [pid 561] [client 192.168.0.152:56907] PHP Fatal error: Uncaught Error: Call to undefined method openzwave::getBackgroundColor() in /var/www/html/plugins/widget/core/class/widget.class.php:421
0996|Stack trace:
0997|#0 /var/www/html/plugins/widget/core/ajax/widget.ajax.php(152): widget->displayExemple()
0998|#1 {main}
0999|thrown in /var/www/html/plugins/widget/core/class/widget.class.php on line 421, referer: http://192.168.0.154/index.php?v=d&m=widget&p=widget