Bonjour à tous,
Cela fait 3 jours que chaque nuit jeedom plante.
Je dois couper puis rallumer l’alimentation électrique afin que tout redémarre puis tout passe au vert.
Serait ce la sauvegarde automatique?
Merci de votre retour
6 « J'aime »
Bonjour,
Comment répondre ? Nous n’avons aucune information !
Ca pourrait très bien être le fait de couper le wifi la nuit comme certains le font et donc si la boxe Jeedom est en wifi ça pourrait l’expliquer.
→ Page santé Jeedom ?
→ Plantée est-ce encore joignable en ssh ?
→ Y a-t-il quelque chose dans le log http.error ?
Bref il va falloir donner des infos si vous voulez que quelqu’un puisse faire un diagnostic
1 « J'aime »
Voici la page santé et les logs http error:
0184|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0185|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0186|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0187|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0188|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0189|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0190|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0191|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0192|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0193|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0194|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0195|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0196|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0197|[Tue Nov 05 03:23:06.951488 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58556] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0198|Stack trace:
0199|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0200|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0201|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0202|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0203|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0204|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0205|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0206|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0207|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0208|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0209|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0210|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0211|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0212|[Tue Nov 05 03:23:08.784533 2024] [php7:error] [pid 150329:tid 150329] [client 127.0.0.1:58570] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0213|Stack trace:
0214|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0215|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0216|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0217|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0218|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0219|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0220|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0221|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0222|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0223|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0224|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0225|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0226|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0227|[Tue Nov 05 03:23:08.842137 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58584] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0228|Stack trace:
0229|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0230|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0231|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0232|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0233|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0234|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0235|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0236|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0237|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0238|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0239|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0240|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0241|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0242|[Tue Nov 05 03:23:10.719718 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58612] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0243|Stack trace:
0244|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0245|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0246|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0247|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0248|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0249|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0250|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0251|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0252|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0253|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0254|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0255|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0256|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0257|[Tue Nov 05 03:23:11.019156 2024] [php7:error] [pid 150329:tid 150329] [client 127.0.0.1:58598] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0258|Stack trace:
0259|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0260|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0261|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0262|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0263|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0264|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0265|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0266|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0267|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0268|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0269|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0270|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0271|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0272|[Tue Nov 05 03:23:11.186156 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58626] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0273|Stack trace:
0274|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0275|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0276|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0277|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0278|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0279|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0280|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0281|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0282|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0283|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0284|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0285|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0286|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0287|[Tue Nov 05 03:23:11.510331 2024] [php7:error] [pid 150331:tid 150331] [client 127.0.0.1:58506] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0288|Stack trace:
0289|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0290|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0291|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0292|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0293|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0294|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0295|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0296|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0297|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0298|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0299|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0300|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0301|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0302|[Tue Nov 05 03:23:11.649085 2024] [php7:error] [pid 150358:tid 150358] [client 127.0.0.1:58568] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0303|Stack trace:
0304|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0305|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0306|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0307|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0308|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0309|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0310|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0311|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0312|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0313|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0314|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0315|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0316|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0317|[Tue Nov 05 03:23:11.650200 2024] [php7:error] [pid 150333:tid 150333] [client 127.0.0.1:58532] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0318|Stack trace:
0319|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0320|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0321|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0322|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0323|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0324|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0325|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0326|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0327|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0328|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0329|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0330|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0331|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0332|[Tue Nov 05 03:23:11.650200 2024] [php7:error] [pid 150332:tid 150332] [client 127.0.0.1:58522] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0333|Stack trace:
0334|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0335|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0336|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0337|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0338|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0339|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0340|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0341|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0342|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0343|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0344|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0345|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0346|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0347|[Tue Nov 05 03:23:11.667678 2024] [php7:error] [pid 150329:tid 150329] [client 127.0.0.1:58630] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0348|Stack trace:
0349|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0350|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0351|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0352|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0353|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0354|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0355|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0356|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0357|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0358|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0359|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0360|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0361|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0362|[Tue Nov 05 03:23:16.321333 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58634] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0363|Stack trace:
0364|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0365|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0366|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0367|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0368|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0369|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0370|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0371|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0372|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0373|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0374|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0375|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0376|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0377|[Tue Nov 05 03:23:16.749856 2024] [php7:error] [pid 150331:tid 150331] [client 127.0.0.1:58328] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0378|Stack trace:
0379|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0380|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0381|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0382|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0383|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0384|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0385|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0386|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0387|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0388|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0389|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0390|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0391|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0392|[Tue Nov 05 03:23:17.597698 2024] [php7:error] [pid 150333:tid 150333] [client 127.0.0.1:58338] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0393|Stack trace:
0394|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0395|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0396|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0397|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0398|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0399|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0400|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0401|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0402|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0403|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0404|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0405|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0406|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0407|[Tue Nov 05 03:23:19.243379 2024] [php7:error] [pid 150358:tid 150358] [client 127.0.0.1:58344] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0408|Stack trace:
0409|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0410|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0411|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0412|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0413|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0414|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0415|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0416|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0417|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0418|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0419|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0420|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0421|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0422|[Tue Nov 05 03:23:19.248474 2024] [php7:error] [pid 150329:tid 150329] [client 127.0.0.1:58356] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0423|Stack trace:
0424|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0425|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0426|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0427|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0428|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0429|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0430|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0431|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0432|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0433|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0434|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0435|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0436|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0437|[Tue Nov 05 03:23:20.359351 2024] [php7:error] [pid 150331:tid 150331] [client 127.0.0.1:58410] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0438|Stack trace:
0439|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0440|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0441|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0442|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0443|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0444|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0445|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0446|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0447|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0448|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0449|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0450|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0451|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0452|[Tue Nov 05 03:23:21.759041 2024] [php7:error] [pid 150330:tid 150330] [client 127.0.0.1:58414] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0453|Stack trace:
0454|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0455|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0456|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0457|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0458|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0459|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0460|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0461|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0462|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0463|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0464|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0465|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0466|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0467|[Tue Nov 05 03:23:23.310209 2024] [php7:error] [pid 150358:tid 150358] [client 127.0.0.1:42928] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0468|Stack trace:
0469|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0470|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0471|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0472|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0473|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0474|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0475|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0476|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0477|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0478|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0479|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0480|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0481|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0482|[Tue Nov 05 03:23:24.033855 2024] [php7:error] [pid 150331:tid 150331] [client 127.0.0.1:42938] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48
0483|Stack trace:
0484|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0485|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0486|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0487|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0488|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0489|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0490|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0491|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0492|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0493|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0494|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0495|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0496|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0497|[Tue Nov 05 03:17:24.222360 2024] [mpm_prefork:notice] [pid 707:tid 707] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0498|[Tue Nov 05 03:17:24.225830 2024] [core:notice] [pid 707:tid 707] AH00094: Command line: '/usr/sbin/apache2'
0499|[Tue Nov 05 06:26:28.093385 2024] [mpm_prefork:error] [pid 707:tid 707] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
0500|[Wed Nov 06 03:52:57.391382 2024] [mpm_prefork:notice] [pid 707:tid 707] AH00170: caught SIGWINCH, shutting down gracefully
0501|[Wed Nov 06 03:55:15.401091 2024] [mpm_prefork:notice] [pid 157091:tid 157091] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0502|[Wed Nov 06 03:55:15.467926 2024] [core:notice] [pid 157091:tid 157091] AH00094: Command line: '/usr/sbin/apache2'
0503|[Wed Nov 06 03:17:23.565419 2024] [mpm_prefork:notice] [pid 661:tid 661] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0504|[Wed Nov 06 03:17:23.574807 2024] [core:notice] [pid 661:tid 661] AH00094: Command line: '/usr/sbin/apache2'
Voilà pourquoi
Faites un nettoyage des archives/historisations, vous avez une BD de quasiment 700MB, ce qui est enorme, et doit vous saturer le systeme la nuit lors des diverse opérations (archivage à 5h, mais d’autres plugins peuvent avoir d’autres opérations à d’autres heures)
Suivez ce tutoriel, ca reglera vos pbs, et votre jeedom retrouvera une 2nd jeunesse : Tuto - analyser les archives pour détecter des pbs (lenteurs / espaces disques)
Norbert
Bonjour,
J’ai « nettoyer » les historiques et je suis descendu a 85MB.
Cependant les matins Jeedom est toujours HS, je n’ai pas eu le temps d’essayer de me connecter en SSH voir si c’était possible.
Voici les logs « hhtp error »:
0473|#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()
0474|#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()
0475|#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()
0476|#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()
0477|#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()
0478|#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()
0479|#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()
0480|#7 /var/www/html/core/class/translate.class.php(81): translate::exec()
0481|#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()
0482|#9 /var/www/html/core/config/jeedom.config.php(23): __()
0483|#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')
0484|#11 /var/www/html/core/php/core.inc.php(27): include_file()
0485|#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
0486|[Tue Nov 05 03:17:24.222360 2024] [mpm_prefork:notice] [pid 707:tid 707] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0487|[Tue Nov 05 03:17:24.225830 2024] [core:notice] [pid 707:tid 707] AH00094: Command line: '/usr/sbin/apache2'
0488|[Tue Nov 05 06:26:28.093385 2024] [mpm_prefork:error] [pid 707:tid 707] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
0489|[Wed Nov 06 03:52:57.391382 2024] [mpm_prefork:notice] [pid 707:tid 707] AH00170: caught SIGWINCH, shutting down gracefully
0490|[Wed Nov 06 03:55:15.401091 2024] [mpm_prefork:notice] [pid 157091:tid 157091] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0491|[Wed Nov 06 03:55:15.467926 2024] [core:notice] [pid 157091:tid 157091] AH00094: Command line: '/usr/sbin/apache2'
0492|[Wed Nov 06 03:17:23.565419 2024] [mpm_prefork:notice] [pid 661:tid 661] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0493|[Wed Nov 06 03:17:23.574807 2024] [core:notice] [pid 661:tid 661] AH00094: Command line: '/usr/sbin/apache2'
0494|kill: (1489): No such process
0495|[Wed Nov 06 18:52:41.165500 2024] [mpm_prefork:notice] [pid 661:tid 661] AH00170: caught SIGWINCH, shutting down gracefully
0496|[Wed Nov 06 18:53:25.529294 2024] [mpm_prefork:notice] [pid 693:tid 693] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0497|[Wed Nov 06 18:53:25.548047 2024] [core:notice] [pid 693:tid 693] AH00094: Command line: '/usr/sbin/apache2'
0498|[Thu Nov 07 03:17:22.614396 2024] [mpm_prefork:notice] [pid 682:tid 682] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0499|[Thu Nov 07 03:17:22.626132 2024] [core:notice] [pid 682:tid 682] AH00094: Command line: '/usr/sbin/apache2'
0500|[Fri Nov 08 03:17:24.176326 2024] [mpm_prefork:notice] [pid 655:tid 655] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0501|[Fri Nov 08 03:17:24.180979 2024] [core:notice] [pid 655:tid 655] AH00094: Command line: '/usr/sbin/apache2'
0502|[Fri Nov 08 03:17:22.198299 2024] [mpm_prefork:notice] [pid 699:tid 699] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations
0503|[Fri Nov 08 03:17:22.220468 2024] [core:notice] [pid 699:tid 699] AH00094: Command line: '/usr/sbin/apache2'
