Bonjour,
Depuis 6 semaines environ j’ai des saturations aléatoires du nombre de connexion à la BDD. Cela peut se corriger tout seul, ou pas … Cela peut tenir 1 jour ou 1 semaine.
Je n’arrive pas à relier à une quelconque cause, et je ne sais pas où chercher.
Bien sûr, cela induit le crash de beaucoup de choses, et m’oblige la plupart du temps à un reboor de Jeedom.
Le plus vicieux est que parfois cela n’induit pas de surcharge CPU, ce qui rend le problème difficile à détecter.
Des idées ? Des pistes ?
Evolution du nombre de connexion aujourd’hui :
http.error (les lignes se répètent) :
10000|[Tue Jun 18 16:24:02.076879 2024] [php7:error] [pid 1886430] [client 127.0.0.1:57428] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48\nStack trace:\n#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()\n#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()\n#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()\n#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()\n#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()\n#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()\n#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()\n#7 /var/www/html/core/class/translate.class.php(81): translate::exec()\n#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()\n#9 /var/www/html/core/config/jeedom.config.php(23): __()\n#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')\n#11 /var/www/html/core/php/core.inc.php(27): include_file()\n#12 /var/www/html/plugins/JeedomConnect/core/api/JeedomConnect.api in /var/www/html/core/class/DB.class.php on line 48
10001|[Tue Jun 18 16:24:02.180623 2024] [php7:error] [pid 1886436] [client 127.0.0.1:57462] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48\nStack trace:\n#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()\n#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()\n#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()\n#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()\n#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()\n#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()\n#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()\n#7 /var/www/html/core/class/translate.class.php(81): translate::exec()\n#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()\n#9 /var/www/html/core/config/jeedom.config.php(23): __()\n#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')\n#11 /var/www/html/core/php/core.inc.php(27): include_file()\n#12 /var/www/html/plugins/JeedomConnect/core/api/JeedomConnect.api in /var/www/html/core/class/DB.class.php on line 48
10002|[Tue Jun 18 16:24:03.904519 2024] [php7:error] [pid 1886430] [client 127.0.0.1:53976] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48\nStack trace:\n#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()\n#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()\n#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()\n#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()\n#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()\n#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()\n#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()\n#7 /var/www/html/core/class/translate.class.php(81): translate::exec()\n#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()\n#9 /var/www/html/core/config/jeedom.config.php(23): __()\n#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')\n#11 /var/www/html/core/php/core.inc.php(27): include_file()\n#12 /var/www/html/plugins/JeedomConnect/core/api/JeedomConnect.api in /var/www/html/core/class/DB.class.php on line 48
10003|[Tue Jun 18 16:24:03.920369 2024] [php7:error] [pid 1886430] [client 90.115.44.124:0] PHP Fatal error: Uncaught Error: Class 'ajax' not found in /var/www/html/core/ajax/event.ajax.php:36\nStack trace:\n#0 {main}\n thrown in /var/www/html/core/ajax/event.ajax.php on line 36
10004|[Tue Jun 18 16:24:03.935095 2024] [php7:error] [pid 1886430] [client 127.0.0.1:53982] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48\nStack trace:\n#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()\n#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()\n#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()\n#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()\n#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()\n#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()\n#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()\n#7 /var/www/html/core/class/translate.class.php(81): translate::exec()\n#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()\n#9 /var/www/html/core/config/jeedom.config.php(23): __()\n#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')\n#11 /var/www/html/core/php/core.inc.php(27): include_file()\n#12 /var/www/html/plugins/JeedomConnect/core/api/JeedomConnect.api in /var/www/html/core/class/DB.class.php on line 48
10005|[Tue Jun 18 16:24:04.277115 2024] [php7:error] [pid 1886430] [client 127.0.0.1:53996] PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections in /var/www/html/core/class/DB.class.php:48\nStack trace:\n#0 /var/www/html/core/class/DB.class.php(48): PDO->__construct()\n#1 /var/www/html/core/class/DB.class.php(59): DB::initConnection()\n#2 /var/www/html/core/class/DB.class.php(91): DB::getConnection()\n#3 /var/www/html/core/class/config.class.php(192): DB::Prepare()\n#4 /var/www/html/core/class/translate.class.php(51): config::byKeys()\n#5 /var/www/html/core/class/translate.class.php(207): translate::getConfig()\n#6 /var/www/html/core/class/translate.class.php(102): translate::getLanguage()\n#7 /var/www/html/core/class/translate.class.php(81): translate::exec()\n#8 /var/www/html/core/class/translate.class.php(220): translate::sentence()\n#9 /var/www/html/core/config/jeedom.config.php(23): __()\n#10 /var/www/html/core/php/utils.inc.php(84): require_once('/var/www/html/c...')\n#11 /var/www/html/core/php/core.inc.php(27): include_file()\n#12 /var/www/html/plugins/mqtt2/core/php/jeeMqtt2.php(18): require in /var/www/html/core/class/DB.class.php on line 48
Extrait log mqttd (il y a un décalage d’heure selon moi : les erreurs sont simultanées je pense) :
5352|[2024-06-18 14:24:05] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"590","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"awtrix_6cc048\":{\"10521c6cc048\":{\"6cc048_bat\":{\"stat_t\":100},\"6cc048_temp\":{\"stat_t\":24},\"6cc048_hum\":{\"stat_t\":37},\"6cc048_lux\":{\"stat_t\":9},\"6cc048_sig\":{\"stat_t\":-72},\"6cc048_ram\":{\"stat_t\":133380},\"6cc048_up\":{\"stat_t\":1800390},\"6cc048_ip_address\":{\"stat_t\":\"192.168.1.101\"}},\"stats\":{\"bat\":100,\"bat_raw\":655,\"type\":0,\"lux\":8,\"ldr_raw\":549,\"ram\":133380,\"bri\":32,\"temp\":24,\"hum\":37,\"uptime\":1800390,\"wifi_signal\":-72,\"messages\":138,\"version\":\"0.96\",\"indicator1\":false,\"indicator2\":false,\"indicator3\":false,\"app\":\"Time\",\"uid\":\"awtrix_6cc048\",\"matrix\":true,\"ip_address\":\"192.168.1.101\"}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5353|[2024-06-18 14:24:06] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"622","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"582D34104783\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:47:83\",\"rssi\":-62,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":21.8,\"tempf\":71.24,\"hum\":78.3,\"batt\":71,\"mac\":\"58:2D:34:10:47:83\"},\"348518691BD2\":{\"manufacturerdata\":\"260402050004060c0d01\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-51,\"mfr\":\"Husqvarna AB\"},\"5C857EB09827\":{\"name\":\"Flower care\",\"id\":\"5C:85:7E:B0:98:27\",\"rssi\":-79,\"brand\":\"Xiaomi/VegTrug\",\"model\":\"MiFlora\",\"model_id\":\"HHCCJCY01HHCC\",\"type\":\"PLANT\",\"tempc\":21.8,\"tempf\":71.24,\"mac\":\"5C:85:7E:B0:98:27\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5354|[2024-06-18 14:24:07] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"372","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"348518691BD2\":{\"manufacturerdata\":\"260402050004060c0d01\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-51,\"mfr\":\"Husqvarna AB\"},\"582D341048C1\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:48:C1\",\"rssi\":-81,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"batt\":18,\"mac\":\"58:2D:34:10:48:C1\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5355|[2024-06-18 14:24:09] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"672","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"6EDD352B7CAE\":{\"name\":\"nut\",\"id\":\"6E:DD:35:2B:7C:AE\",\"rssi\":-73,\"brand\":\"nut\",\"model\":\"Smart Tracker\",\"model_id\":\"NUT\",\"type\":\"TRACK\",\"device\":\"nut Tracker\"},\"348518691BD2\":{\"manufacturerdata\":\"26040504a829d00d\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-66,\"mfr\":\"Husqvarna AB\"},\"5C857EB09827\":{\"name\":\"Flower care\",\"id\":\"5C:85:7E:B0:98:27\",\"rssi\":-75,\"brand\":\"Xiaomi/VegTrug\",\"model\":\"MiFlora\",\"model_id\":\"HHCCJCY01HHCC\",\"type\":\"PLANT\",\"tempc\":21.8,\"tempf\":71.24,\"mac\":\"5C:85:7E:B0:98:27\"},\"68B6B340D142\":{\"manufacturerdata\":\"260402050004060a1f02\",\"name\":\"Bender\",\"id\":\"68:B6:B3:40:D1:42\",\"rssi\":-66,\"mfr\":\"Husqvarna AB\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5356|[2024-06-18 14:24:09] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"1547","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"348518691BD2\":{\"manufacturerdata\":\"260402050004060c0d01\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-63,\"mfr\":\"Husqvarna AB\"},\"6D6C38F15B5F\":{\"id\":\"6D:6C:38:F1:5B:5F\",\"rssi\":-82,\"servicedatauuid\":\"fef3\",\"servicedata\":\"4a17235938494b1132cf88fff20a67e043225708b5e65d4d299b5e\"},\"582D34104783\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:47:83\",\"rssi\":-63,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":21.8,\"tempf\":71.24,\"hum\":78.3,\"batt\":71,\"mac\":\"58:2D:34:10:47:83\"},\"6EDD352B7CAE\":{\"name\":\"nut\",\"id\":\"6E:DD:35:2B:7C:AE\",\"rssi\":-62,\"brand\":\"nut\",\"model\":\"Smart Tracker\",\"model_id\":\"NUT\",\"type\":\"TRACK\",\"device\":\"nut Tracker\"},\"5C857EB09827\":{\"name\":\"Flower care\",\"id\":\"5C:85:7E:B0:98:27\",\"rssi\":-78,\"brand\":\"Xiaomi/VegTrug\",\"model\":\"MiFlora\",\"model_id\":\"HHCCJCY01HHCC\",\"type\":\"PLANT\",\"lux\":7540,\"mac\":\"5C:85:7E:B0:98:27\"},\"582D341048C1\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:48:C1\",\"rssi\":-81,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":22.7,\"tempf\":72.86,\"mac\":\"58:2D:34:10:48:C1\"}}},\"TGW2\":{\"BTtoMQTT\":{\"582D34103C48\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:3C:48\",\"rssi\":-83,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":23.4,\"tempf\":74.12,\"hum\":75.4,\"batt\":5,\"mac\":\"58:2D:34:10:3C:48\"},\"6EDD352B7CAE\":{\"name\":\"nut\",\"id\":\"6E:DD:35:2B:7C:AE\",\"rssi\":-91,\"brand\":\"nut\",\"model\":\"Smart Tracker\",\"model_id\":\"NUT\",\"type\":\"TRACK\",\"device\":\"nut Tracker\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5357|[2024-06-18 14:24:09] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"446","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW2\":{\"BTtoMQTT\":{\"582D341048C1\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:48:C1\",\"rssi\":-69,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":22.7,\"tempf\":72.86,\"mac\":\"58:2D:34:10:48:C1\"},\"582D3410CBE8\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:CB:E8\",\"rssi\":-69,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"batt\":9,\"mac\":\"58:2D:34:10:CB:E8\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5358|[2024-06-18 14:24:13] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"590","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"awtrix_6cc048\":{\"10521c6cc048\":{\"6cc048_bat\":{\"stat_t\":100},\"6cc048_temp\":{\"stat_t\":24},\"6cc048_hum\":{\"stat_t\":37},\"6cc048_lux\":{\"stat_t\":9},\"6cc048_sig\":{\"stat_t\":-70},\"6cc048_ram\":{\"stat_t\":133380},\"6cc048_up\":{\"stat_t\":1800400},\"6cc048_ip_address\":{\"stat_t\":\"192.168.1.101\"}},\"stats\":{\"bat\":100,\"bat_raw\":655,\"type\":0,\"lux\":8,\"ldr_raw\":550,\"ram\":133076,\"bri\":32,\"temp\":24,\"hum\":37,\"uptime\":1800400,\"wifi_signal\":-70,\"messages\":138,\"version\":\"0.96\",\"indicator1\":false,\"indicator2\":false,\"indicator3\":false,\"app\":\"Time\",\"uid\":\"awtrix_6cc048\",\"matrix\":true,\"ip_address\":\"192.168.1.101\"}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5359|[2024-06-18 14:24:13] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"191","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"6EDD352B7CAE\":{\"name\":\"nut\",\"id\":\"6E:DD:35:2B:7C:AE\",\"rssi\":-82,\"brand\":\"nut\",\"model\":\"Smart Tracker\",\"model_id\":\"NUT\",\"type\":\"TRACK\",\"device\":\"nut Tracker\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5360|[2024-06-18 14:24:13] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"173","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"348518691BD2\":{\"manufacturerdata\":\"260402050004060c0d01\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-51,\"mfr\":\"Husqvarna AB\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
5361|[2024-06-18 14:24:15] ERROR : Error on send to jeedom : {"message":"Request failed with status code 500","name":"AxiosError","stack":"AxiosError: Request failed with status code 500\n at settle (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:1913:12)\n at IncomingMessage.handleStreamEnd (/var/www/html/plugins/mqtt2/resources/mqtt2d/node_modules/axios/dist/node/axios.cjs:2995:11)\n at IncomingMessage.emit (node:events:526:35)\n at endReadableNT (node:internal/streams/readable:1359:12)\n at process.processTicksAndRejections (node:internal/process/task_queues:82:21)","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/x-www-form-urlencoded","User-Agent":"axios/1.5.1","Content-Length":"866","Accept-Encoding":"gzip, compress, deflate, br"},"method":"post","url":"http://127.0.0.1:80/plugins/mqtt2/core/php/jeeMqtt2.php?apikey=jncWmI9KjnTZQvGwpEr74gx9LVv9FPpQyWuVkHkEabOguSNyh44ChxD0B84f09bK","data":"{\"home\":{\"TGW1\":{\"BTtoMQTT\":{\"348518691BD2\":{\"manufacturerdata\":\"260402050004060c0d01\",\"name\":\"ChargingStation\",\"id\":\"34:85:18:69:1B:D2\",\"rssi\":-66,\"mfr\":\"Husqvarna AB\"},\"5C857EB09827\":{\"name\":\"Flower care\",\"id\":\"5C:85:7E:B0:98:27\",\"rssi\":-76,\"brand\":\"Xiaomi/VegTrug\",\"model\":\"MiFlora\",\"model_id\":\"HHCCJCY01HHCC\",\"type\":\"PLANT\",\"lux\":7540,\"mac\":\"5C:85:7E:B0:98:27\"},\"68B6B340D142\":{\"manufacturerdata\":\"260402050004060a1f02\",\"name\":\"Bender\",\"id\":\"68:B6:B3:40:D1:42\",\"rssi\":-62,\"mfr\":\"Husqvarna AB\"},\"582D34104F15\":{\"name\":\"ClearGrass Temp & RH\",\"id\":\"58:2D:34:10:4F:15\",\"rssi\":-72,\"brand\":\"ClearGrass/Qingping\",\"model\":\"Round TH\",\"model_id\":\"CGG1\",\"type\":\"THB\",\"tempc\":22.6,\"tempf\":72.68,\"mac\":\"58:2D:34:10:4F:15\"},\"6D6C38F15B5F\":{\"id\":\"6D:6C:38:F1:5B:5F\",\"rssi\":-84,\"servicedatauuid\":\"fef3\",\"servicedata\":\"4a17235938494b1132cf88fff20a67e043225708b5e65d4d299b5e\"}}}}}"},"code":"ERR_BAD_RESPONSE","status":500}
Log JeedomConnect :
1178|[2024-06-18 16:23:19,497] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1179|[2024-06-18 16:23:20,044] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1180|[2024-06-18 16:23:21,417] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1181|[2024-06-18 16:23:22,203] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1182|[2024-06-18 16:23:23,512] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1183|[2024-06-18 16:23:24,334] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1184|[2024-06-18 16:23:26,035] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1185|[2024-06-18 16:23:26,490] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
1186|[2024-06-18 16:23:27,847] ERROR : Error on send request to jeedom HTTPConnectionPool(host='127.0.0.1', port=80): Read timed out. (read timeout=120) retry : 0/3
Page Santé :
MariaDB est toujours vers les 10 % CPU :
MAIS après un redémarrage je suis MariaDB est à 30 % avc une charge de 5 :
MAIS CPU revenu à la normale apès un autre redémarrage.
→ globalement c’est souvent le cas quand le problème survient : il me faut 2 redémarrage pour que le cpu ré mariadb revienne à la normale.