fredokl

Merci. Je regarde.

Bon, j'ai crié victoire trop vite! L'erreur device.php est revenu après avoir cliqué sur le bouton du QA: [25.07.2024] [23:34:30] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Connection error to http://192.168.1.35/domocharts/device.php : Bad file descriptor [25.07.2024] [23:34:30] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/device.php => Connection error : Bad file descriptor [25.07.2024] [23:34:30] [TRACE] [QA_DOMOCHARTS_1300]: Update label "LabelStatus" to "Connection error : Bad file descriptor"

Comme indiqué, la box tournait au ralenti. Je l'ai redémarré et là plus d'erreur dans les logs du QA et tout semble remonter correctement. Les infos sont remontées et affichées correctement. Je vais attendre pour voir si ça recommence.

Bienvenue sur le forum!

@Lazer: lorsque j'appui sur le bouton, cela fonctionne mais il me semble que la box tourne au ralenti, voici le log: [25.07.2024] [22:51:03] [TRACE] [QA_DOMOCHARTS_1300]: UIEvent: {"eventType":"onReleased","values":[],"deviceId":1300,"elementName":"buttonGetDevices"} [25.07.2024] [22:51:03] [DEBUG] [QA_DOMOCHARTS_1300]: QuickApp:buttonGetDevices_onReleased({"eventType":"onReleased","values":[],"deviceId":1300,"elementName":"buttonGetDevices"}) [25.07.2024] [22:51:03] [TRACE] [QA_DOMOCHARTS_1300]: Get devices @jojo: oui pdo_mysql est toujours activée. Et encore un nouveau log: [25.07.2024] [22:54:55] [DEBUG] [QA_DOMOCHARTS_1300]: Next loop at 22:55:00 in 5 seconds... [25.07.2024] [22:54:55] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Connection error to http://192.168.1.35/domocharts/data.php : Bad file descriptor [25.07.2024] [22:54:56] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Connection error : Bad file descriptor [25.07.2024] [22:54:56] [TRACE] [QA_DOMOCHARTS_1300]: Update label "LabelStatus" to "Connection error : Bad file descriptor" [25.07.2024] [22:54:56] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:54:56] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Connection error to http://192.168.1.35/domocharts/data.php : Bad file descriptor [25.07.2024] [22:54:57] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Connection error : Bad file descriptor [25.07.2024] [22:54:57] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:54:57] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Connection error to http://192.168.1.35/domocharts/data.php : Bad file descriptor [25.07.2024] [22:54:57] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Connection error : Bad file descriptor [25.07.2024] [22:54:57] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:54:57] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Connection error : Bad file descriptor [25.07.2024] [22:54:58] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:54:58] [DEBUG] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() success() response = {"status":200,"data":"{\"data\":[{\"type\":\"temperature\",\"success\":true,\"rowcount\":1880},{\"type\":\"humidity\",\"success\":true,\"rowcount\":658},{\"type\":\"light\",\"success\":true,\"rowcount\":188},{\"type\":\"gas\",\"success\":true,\"rowcount\":94},{\"type\":\"sound\",\"success\":true,\"rowcount\":94},{\"type\":\"pressure\",\"success\":true,\"rowcount\":94},{\"type\":\"voltage\",\"success\":true,\"rowcount\":376},{\"type\":\"current\",\"success\":true,\"rowcount\":376},{\"type\":\"power\",\"success\":true,\"rowcount\":3196}],\"success\":false,\"rowcount\":6956,\"error\":{\"code\":\"08S01\",\"message\":\"SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes\"}}","headers":{"Server":"nginx","Vary":"Accept-Encoding","Content-Type":"application\/json; charset=utf-8","Date":"Thu, 25 Jul 2024 20:54:58 GMT","Connection":"close","Transfer-Encoding":"chunked"}} [25.07.2024] [22:54:58] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Error #08S01 => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes [25.07.2024] [22:54:58] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Error #08S01 => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes [25.07.2024] [22:54:58] [TRACE] [QA_DOMOCHARTS_1300]: Update label "LabelStatus" to "Error #08S01 => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes" [25.07.2024] [22:54:59] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:55:01] [DEBUG] [QA_DOMOCHARTS_1300]: loop() [25.07.2024] [22:55:01] [DEBUG] [QA_DOMOCHARTS_1300]: Total memory in use by Lua : 10259.80 KB, CPU consumed : 19515.60 ms ( 9.035 % ) [25.07.2024] [22:55:01] [TRACE] [QA_DOMOCHARTS_1300]: Found 10058 previously stored datas [25.07.2024] [22:55:01] [ERROR] [QA_DOMOCHARTS_1300]: Too much data already in cache

Voici les messages d'erreur sur le QA. [25.07.2024] [22:45:46] [DEBUG] [QA_DOMOCHARTS_1300]: Next loop at 22:46:00 in 14 seconds... [25.07.2024] [22:45:47] [DEBUG] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() success() response = {"status":200,"data":"{\"data\":[{\"type\":\"temperature\",\"success\":true,\"rowcount\":1880},{\"type\":\"humidity\",\"success\":true,\"rowcount\":658},{\"type\":\"light\",\"success\":true,\"rowcount\":188},{\"type\":\"gas\",\"success\":true,\"rowcount\":94},{\"type\":\"sound\",\"success\":true,\"rowcount\":94},{\"type\":\"pressure\",\"success\":true,\"rowcount\":94},{\"type\":\"voltage\",\"success\":true,\"rowcount\":376},{\"type\":\"current\",\"success\":true,\"rowcount\":376},{\"type\":\"power\",\"success\":true,\"rowcount\":3196}],\"success\":false,\"rowcount\":6956,\"error\":{\"code\":\"08S01\",\"message\":\"SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes\"}}","headers":{"Server":"nginx","Vary":"Accept-Encoding","Content-Type":"application\/json; charset=utf-8","Date":"Thu, 25 Jul 2024 20:45:46 GMT","Connection":"close","Transfer-Encoding":"chunked"}} [25.07.2024] [22:45:47] [ERROR] [QA_DOMOCHARTS_1300]: DomoCharts:postAPI() Error #08S01 => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes [25.07.2024] [22:45:47] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Error #08S01 => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes [25.07.2024] [22:45:47] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data [25.07.2024] [22:46:00] [DEBUG] [QA_DOMOCHARTS_1300]: loop() [25.07.2024] [22:46:01] [DEBUG] [QA_DOMOCHARTS_1300]: Total memory in use by Lua : 10095.36 KB, CPU consumed : 18522.03 ms ( 7.848 % ) [25.07.2024] [22:46:01] [TRACE] [QA_DOMOCHARTS_1300]: Found 10058 previously stored datas [25.07.2024] [22:46:01] [ERROR] [QA_DOMOCHARTS_1300]: Too much data already in cache

Merci pour vos suggestions. Pour répondre aux questions: - les utilisateurs Domocharts sont bon. - la config pour le Webserveur n'ont pas été changé donc sont bon normalement. - le port de MariaDB est bon soit le 3307. J'ai fait une sauvegarde de la DB et ensuite une restauration. Je me retrouve maintenant avec seulement les données de températures qui sont remontées. Pour le reste, j'ai une page noir avec "No device found". Le QA, lui, fonctionne parfaitement sauf qu'il n'arrive pas à se connecter au fichier device.php Étant une buse dans le domaine, la recherche de l'erreur risque d'être assez longue.

Bon. J'ai une piste mais je n'en suis pas sur du tout. Lors d'une mise à jour de phpMyAdmin sur mon Synology, la version PHP est passé en 8.0828 alors que jusqu'à présent j'était en 7.4. Qu'est-ce-que vous en pensez?

OK merci. Je vais regarder ça.

Hello. J'ai une erreur qui est apparue sans que je ne fasse quoi que ce soit. Est-ce-que quelqu'un a le même problème? [22.07.2024] [23:01:01] [TRACE] [QA_DOMOCHARTS_1300]: Found 10058 previously stored datas [22.07.2024] [23:01:01] [ERROR] [QA_DOMOCHARTS_1300]: Too much data already in cache [22.07.2024] [23:01:10] [ERROR] [QA_DOMOCHARTS_1300]: http://192.168.1.35/domocharts/data.php => Error #8 => PDOStatement::execute(): send of 32768 bytes failed with errno=104 Connection reset by peer [22.07.2024] [23:01:10] [WARNING] [QA_DOMOCHARTS_1300]: Memorize 10058 sensors data

Bienvenue sur le forum!

Bienvenue sur le forum!

Bienvenue sur le forum!

Bienvenue sur le forum!

Bienvenue sur le forum!