Problème de RAM - Gladys ne réagit plus

Kevin · Mars 4, 2023, 4:15

Bonjour,

Cela fait quelques jours que j’ai énormément de problème avec mon instance Gladys, depuis +/- la dernière mise à jour. Surement un hasard…

Je m’explique : mon Gladys prend de plus en plus de temps à charger les pages jusqu’à saturation. Il fini par ne plus répondre au ping et je suis obligé de le redémarrer physiquement.

Je possède un Raspberry PI 4 avec une carte SD et j’ai n’ai pas de souci avec les autres containers (sauf quand la machine ne répond plus au ping évidemment).

En regardant un peu les stats, je constate que ma mémoire gonfle très rapidement :

Si je redémarre en faisant un stop + start le container Gladys, la mémoire repart à 0 et continue à gonfler continuellement jusqu’à saturation.

Au niveau des logs Gladys, les quelques dernières lignes sont les suivantes :

Coupé car limité à 33000 caractères sur le forum
c6e3b76b2ee4','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.74,'2023-03-03 11:50:25.428 +00:00','2023-03-03 11:50:25.428 +00:00'),('12a018e2-de2b-4064-bc43-37dad72d4418','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.74,'2023-03-03 11:50:49.622 +00:00','2023-03-03 11:50:49.622 +00:00'),('d028d2a3-ae03-4894-8f56-1a75b6bc9f7b','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.75,'2023-03-03 11:50:49.900 +00:00','2023-03-03 11:50:49.900 +00:00'),('00b54221-d81c-4ba1-95ca-f435d5c62f64','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.75,'2023-03-03 11:50:53.704 +00:00','2023-03-03 11:50:53.704 +00:00'),('287dac16-70bf-4d72-b44c-e3fefba1b122','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.77,'2023-03-03 11:50:56.318 +00:00','2023-03-03 11:50:56.318 +00:00'),('93b65da7-7ea2-49e6-a797-8c715b169425','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.77,'2023-03-03 11:51:09.528 +00:00','2023-03-03 11:51:09.528 +00:00'),('a68474c1-0118-4580-88a8-a1a0298dc5db','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.79,'2023-03-03 11:51:10.957 +00:00','2023-03-03 11:51:10.957 +00:00'),('13a8eb25-0bb3-44c7-a541-7fd7ccd66c82','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.79,'2023"... 71575 more characters
  },
  sql: "INSERT INTO `t_device_feature_state_aggregate` (`id`,`type`,`device_feature_id`,`value`,`created_at`,`updated_at`) VALUES ('845abfdf-0b1d-4d3f-b97d-fc22cedecd9e','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:40:56.658 +00:00','2023-03-03 11:40:56.658 +00:00'),('2d39ea57-4b05-462a-a564-f0176d6a0afb','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:03.455 +00:00','2023-03-03 11:41:03.455 +00:00'),('72977bf1-ab8a-4d98-bc17-81a66770ba21','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:31.983 +00:00','2023-03-03 11:41:31.983 +00:00'),('9de003b4-b225-4f41-9992-8ad3a997d43f','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:32.545 +00:00','2023-03-03 11:41:32.545 +00:00'),('fdbbc379-cfe8-479d-ba52-004900fe77fc','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:33.064 +00:00','2023-03-03 11:41:33.064 +00:00'),('e989a2c4-93d4-478f-989b-c5693d4e6e71','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:56.507 +00:00','2023-03-03 11:41:56.507 +00:00'),('92c53759-760a-4c9f-80a4-e29684b2ec27','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:57.870 +00:00','2023-03-03 11:41:57.870 +00:00'),('90e04050-d6c5-41e5-98cb-d33020061371','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:41:59.210 +00:00','2023-03-03 11:41:59.210 +00:00'),('ecdbf7ef-7493-451e-8c79-5c7ce9b078cf','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.52,'2023-03-03 11:42:20.977 +00:00','2023-03-03 11:42:20.977 +00:00'),('b554cd97-5743-49c1-9e78-bbcfa7a5cc0e','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.53,'2023-03-03 11:42:23.006 +00:00','2023-03-03 11:42:23.006 +00:00'),('d81ccfe6-3f01-49f3-b52a-aaf6f60fb2e3','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.53,'2023-03-03 11:42:23.863 +00:00','2023-03-03 11:42:23.863 +00:00'),('a4cd6ba3-c97f-4d12-b7d8-bec4c6601bf9','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.53,'2023-03-03 11:42:28.796 +00:00','2023-03-03 11:42:28.796 +00:00'),('ad6c2877-d1f2-474d-83d3-4255dd811975','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.53,'2023-03-03 11:43:14.703 +00:00','2023-03-03 11:43:14.703 +00:00'),('e1573b3c-923d-4969-a164-44126cd5f8aa','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.53,'2023-03-03 11:43:43.029 +00:00','2023-03-03 11:43:43.029 +00:00'),('52b1e277-eab2-4ad6-85f0-37814fdccc0c','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.54,'2023-03-03 11:43:43.485 +00:00','2023-03-03 11:43:43.485 +00:00'),('fc280e59-b0c7-4053-947f-def5dd897286','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.54,'2023-03-03 11:43:45.205 +00:00','2023-03-03 11:43:45.205 +00:00'),('582342d7-670d-4d7f-8351-37ce3728a813','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.54,'2023-03-03 11:43:54.564 +00:00','2023-03-03 11:43:54.564 +00:00'),('bbcfe04e-bdb1-493b-8a0c-d562f44416df','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.54,'2023-03-03 11:43:55.313 +00:00','2023-03-03 11:43:55.313 +00:00'),('7669551d-0598-477b-8e39-a61e0a283cee','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.55,'2023-03-03 11:43:55.942 +00:00','2023-03-03 11:43:55.942 +00:00'),('d92dd66a-5ae9-4180-806c-33c3f290dbb8','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.55,'2023-03-03 11:44:00.595 +00:00','2023-03-03 11:44:00.595 +00:00'),('0538f564-c88c-458f-b3f1-9fb4c72ea1d3','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.55,'2023-03-03 11:44:11.168 +00:00','2023-03-03 11:44:11.168 +00:00'),('0c2be398-a97c-491f-a046-bad893f2e09f','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.56,'2023-03-03 11:44:11.695 +00:00','2023-03-03 11:44:11.695 +00:00'),('bbbf8aa0-0df7-4954-9c43-584b619d8363','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.56,'2023-03-03 11:44:35.776 +00:00','2023-03-03 11:44:35.776 +00:00'),('7cc4667c-3533-41f2-8a9b-18aece1f7cda','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.56,'2023-03-03 11:44:51.348 +00:00','2023-03-03 11:44:51.348 +00:00'),('15cfc8a5-5408-4cf0-a18f-2a9443e8a3ed','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.56,'2023-03-03 11:45:02.861 +00:00','2023-03-03 11:45:02.861 +00:00'),('b6ea4db6-3a2a-4a93-ba78-e66989e74700','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.57,'2023-03-03 11:45:05.984 +00:00','2023-03-03 11:45:05.984 +00:00'),('80c479df-df16-4a85-aed5-e1cb145d1cac','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.57,'2023-03-03 11:45:27.558 +00:00','2023-03-03 11:45:27.558 +00:00'),('3e90b059-e47e-479f-954e-edd1540c9685','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.58,'2023-03-03 11:45:28.406 +00:00','2023-03-03 11:45:28.406 +00:00'),('f5aecbef-37a1-4f42-ae64-ad3d2bf87717','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.58,'2023-03-03 11:45:31.542 +00:00','2023-03-03 11:45:31.542 +00:00'),('2608823a-5d34-4f48-be9b-1f9ae955c6c0','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.59,'2023-03-03 11:45:33.406 +00:00','2023-03-03 11:45:33.406 +00:00'),('a9b89113-60c3-4534-a50d-e185fa09df5b','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.59,'2023-03-03 11:46:13.230 +00:00','2023-03-03 11:46:13.230 +00:00'),('7dad08f8-214f-4897-93f0-057f907764d8','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.6,'2023-03-03 11:46:14.440 +00:00','2023-03-03 11:46:14.440 +00:00'),('4c28038d-7f8c-4395-9646-196b75faecbf','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.6,'2023-03-03 11:46:33.827 +00:00','2023-03-03 11:46:33.827 +00:00'),('ecaf559a-5107-4b64-bda2-3a65393f539b','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.61,'2023-03-03 11:46:34.410 +00:00','2023-03-03 11:46:34.410 +00:00'),('2fec9d90-af1c-4d1a-b603-8fc2f1f6a57a','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.61,'2023-03-03 11:46:47.497 +00:00','2023-03-03 11:46:47.497 +00:00'),('fddaedea-1736-49f5-8c49-dc54bd664802','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.62,'2023-03-03 11:46:48.213 +00:00','2023-03-03 11:46:48.213 +00:00'),('3d510609-e6c8-4152-a49c-8f2c0df92b3a','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.62,'2023-03-03 11:47:19.053 +00:00','2023-03-03 11:47:19.053 +00:00'),('e961d03c-915d-4449-9b71-e068f5d047d2','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.63,'2023-03-03 11:47:19.773 +00:00','2023-03-03 11:47:19.773 +00:00'),('df5cc243-cfe0-429d-bfe4-7faa2d655aca','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.64,'2023-03-03 11:47:23.118 +00:00','2023-03-03 11:47:23.118 +00:00'),('b3491b45-b29f-4317-b76d-2f0620c4d4fd','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.64,'2023-03-03 11:47:36.780 +00:00','2023-03-03 11:47:36.780 +00:00'),('6530ae27-23f7-4c80-a69a-8767c881c8ee','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.65,'2023-03-03 11:47:37.820 +00:00','2023-03-03 11:47:37.820 +00:00'),('4437e920-e4f3-4a17-bc17-c118ab6a6942','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.65,'2023-03-03 11:47:41.105 +00:00','2023-03-03 11:47:41.105 +00:00'),('96ec9763-76ac-4a7c-8ec0-2eb472edee6a','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.66,'2023-03-03 11:47:41.400 +00:00','2023-03-03 11:47:41.400 +00:00'),('6deda66e-8f14-40bd-a18d-a1637a7522f2','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.66,'2023-03-03 11:48:05.313 +00:00','2023-03-03 11:48:05.313 +00:00'),('49ec1545-03a2-4c05-8ccb-adf20c7c9ce0','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.67,'2023-03-03 11:48:08.369 +00:00','2023-03-03 11:48:08.369 +00:00'),('c88d69c4-b78c-4795-b231-1bbaa123769f','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.67,'2023-03-03 11:48:52.565 +00:00','2023-03-03 11:48:52.565 +00:00'),('de505b72-74a9-4c2c-adf9-48bffc731751','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.69,'2023-03-03 11:49:07.442 +00:00','2023-03-03 11:49:07.442 +00:00'),('99fb1526-1bd0-464e-8eaf-d65ad52f3242','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.69,'2023-03-03 11:49:27.363 +00:00','2023-03-03 11:49:27.363 +00:00'),('749433a7-518a-40cc-a043-670c92617487','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.7,'2023-03-03 11:49:31.778 +00:00','2023-03-03 11:49:31.778 +00:00'),('c05d39cc-c753-41bc-88af-68a422f3a4da','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.71,'2023-03-03 11:49:36.984 +00:00','2023-03-03 11:49:36.984 +00:00'),('f0a51b95-d6dd-4132-9c7a-b9e7946b592b','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.71,'2023-03-03 11:49:51.566 +00:00','2023-03-03 11:49:51.566 +00:00'),('c519be09-5dc2-464e-919e-5e147bea76f6','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.72,'2023-03-03 11:49:51.690 +00:00','2023-03-03 11:49:51.690 +00:00'),('a7b915a8-1c55-4dbe-ae7f-065d14817c36','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.72,'2023-03-03 11:50:08.667 +00:00','2023-03-03 11:50:08.667 +00:00'),('7a498e1d-6f52-4d38-883d-c6e3b76b2ee4','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.74,'2023-03-03 11:50:25.428 +00:00','2023-03-03 11:50:25.428 +00:00'),('12a018e2-de2b-4064-bc43-37dad72d4418','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.74,'2023-03-03 11:50:49.622 +00:00','2023-03-03 11:50:49.622 +00:00'),('d028d2a3-ae03-4894-8f56-1a75b6bc9f7b','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.75,'2023-03-03 11:50:49.900 +00:00','2023-03-03 11:50:49.900 +00:00'),('00b54221-d81c-4ba1-95ca-f435d5c62f64','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.75,'2023-03-03 11:50:53.704 +00:00','2023-03-03 11:50:53.704 +00:00'),('287dac16-70bf-4d72-b44c-e3fefba1b122','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.77,'2023-03-03 11:50:56.318 +00:00','2023-03-03 11:50:56.318 +00:00'),('93b65da7-7ea2-49e6-a797-8c715b169425','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.77,'2023-03-03 11:51:09.528 +00:00','2023-03-03 11:51:09.528 +00:00'),('a68474c1-0118-4580-88a8-a1a0298dc5db','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.79,'2023-03-03 11:51:10.957 +00:00','2023-03-03 11:51:10.957 +00:00'),('13a8eb25-0bb3-44c7-a541-7fd7ccd66c82','hourly','ba4e30b3-bb76-4e8b-a61a-feaa42c53cf7',6176.79,'2023"... 71575 more characters,
  parameters: {}
}

    at ChildProcess.<anonymous> (/src/server/lib/device/device.calculateAggregate.js:102:23)
    at ChildProcess.emit (node:events:513:28)
    at maybeClose (node:internal/child_process:1091:16)
    at Process.ChildProcess._handle.onexit (node:internal/child_process:302:5)
2023-03-04T16:16:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:16:00 GMT
2023-03-04T16:16:52+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval daily
2023-03-04T16:17:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:17:00 GMT
2023-03-04T16:18:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:18:00 GMT
2023-03-04T16:19:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:19:00 GMT
2023-03-04T16:20:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:20:00 GMT
2023-03-04T16:21:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:21:00 GMT
2023-03-04T16:22:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:22:00 GMT
2023-03-04T16:23:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:23:00 GMT
2023-03-04T16:24:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:24:00 GMT
2023-03-04T16:24:03+0100 <warn> device.calculateAggregate.js:95 (Socket.<anonymous>) device.calculateAggregate stderr: Error
    at Database.<anonymous> (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:179:27)
    at /src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:177:50
    at new Promise (<anonymous>)
    at Query.run (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:177:12)
    at /src/server/node_modules/sequelize/lib/sequelize.js:314:28
    at async SQLiteQueryInterface.bulkDelete (/src/server/node_modules/sequelize/lib/dialects/abstract/query-interface.js:403:12)
    at async /src/server/lib/device/device.calculcateAggregateChildProcess.js:142:7 {
  name: 'SequelizeTimeoutError',
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'"
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'"
  },
  sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'",
  parameters: {}
}

2023-03-04T16:24:03+0100 <warn> device.calculateAggregate.js:101 (ChildProcess.<anonymous>) device.calculateAggregate: Exiting child process with code 1
2023-03-04T16:25:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:25:00 GMT
2023-03-04T16:26:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:26:00 GMT
2023-03-04T16:27:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:27:00 GMT
2023-03-04T16:28:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:28:00 GMT
2023-03-04T16:29:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:29:00 GMT
2023-03-04T16:30:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:30:00 GMT
2023-03-04T16:31:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:31:00 GMT
2023-03-04T16:32:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:32:00 GMT
2023-03-04T16:33:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:33:00 GMT
2023-03-04T16:34:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:34:00 GMT
2023-03-04T16:35:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:35:00 GMT
2023-03-04T16:35:10+0100 <error> device.onHourlyDeviceAggregateEvent.js:27 (DeviceManager.onHourlyDeviceAggregateEvent) Error: Error
    at Database.<anonymous> (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:179:27)
    at /src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:177:50
    at new Promise (<anonymous>)
    at Query.run (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:177:12)
    at /src/server/node_modules/sequelize/lib/sequelize.js:314:28
    at async SQLiteQueryInterface.bulkDelete (/src/server/node_modules/sequelize/lib/dialects/abstract/query-interface.js:403:12)
    at async /src/server/lib/device/device.calculcateAggregateChildProcess.js:142:7 {
  name: 'SequelizeTimeoutError',
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'"
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'"
  },
  sql: "DELETE FROM `t_device_feature_state_aggregate` WHERE `type` = 'daily' AND `device_feature_id` = '91b9a6c2-068d-442f-b9da-356a12197d1a' AND `created_at` BETWEEN '2023-03-02 23:00:00.000 +00:00' AND '2023-03-03 23:00:00.000 +00:00'",
  parameters: {}
}

    at ChildProcess.<anonymous> (/src/server/lib/device/device.calculateAggregate.js:102:23)
    at ChildProcess.emit (node:events:513:28)
    at maybeClose (node:internal/child_process:1091:16)
    at Process.ChildProcess._handle.onexit (node:internal/child_process:302:5)
2023-03-04T16:36:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:36:00 GMT
2023-03-04T16:37:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:37:00 GMT
2023-03-04T16:38:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:38:00 GMT
2023-03-04T16:38:34+0100 <info> device.purgeStates.js:29 (DeviceManager.purgeStates) Purging device feature states of the last 7 days. States older than Sat Feb 25 2023 16:38:34 GMT+0100 (Central European Standard Time) will be purged.
2023-03-04T16:39:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:39:00 GMT
2023-03-04T16:39:47+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval monthly
2023-03-04T16:40:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:40:00 GMT
2023-03-04T16:41:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:41:00 GMT
2023-03-04T16:42:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:42:00 GMT
2023-03-04T16:43:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:43:00 GMT
2023-03-04T16:44:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:44:00 GMT
2023-03-04T16:45:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:45:00 GMT
2023-03-04T16:46:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:46:00 GMT
2023-03-04T16:47:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:47:00 GMT
2023-03-04T16:48:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:48:00 GMT
2023-03-04T16:49:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:49:00 GMT
2023-03-04T16:50:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:50:00 GMT
2023-03-04T16:51:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:51:00 GMT
2023-03-04T16:52:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:52:00 GMT
2023-03-04T16:53:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:53:00 GMT
2023-03-04T16:54:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:54:00 GMT
2023-03-04T16:55:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:55:00 GMT
2023-03-04T16:56:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:56:00 GMT
2023-03-04T16:57:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:57:00 GMT
2023-03-04T16:58:00+0100 <info> scene.checkCalendarTriggers.js:24 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Sat, 04 Mar 2023 15:58:00 GMT

Je précise que je n’ai pas de caméra (j’ai lu un souci avec les caméras sur le forum).
Si besoin d’autres logs, n’hésitez pas

Merci d’avance à celui qui mettra le nez dans ce qui « merde »

Kevin · Mars 4, 2023, 4:38

En continuant de feuilleter et rechercher sur le forum, j’ai l’impression que ça ressemble un peu à ça :

Dans mes souenirs, j’ai fait ceci ces derniers temps :

Ajouter des éléments MQTT pour afficher des prix par rapport à ma consommation/production d’énergie
Modifier un élément MQTT car le nom du topic n’était pas bon
Supprimer 2 graphiques car je pensais que c’était la cause de ma lenteur
Effectué un nettoyage (impossible de savoir s’il s’est correctement terminé vu que 24h après, plus d’accès

Kevin · Mars 4, 2023, 6:38

Je pense que le souci vient de ma DB de plus de 14Go. J’ai eu la mauvaise idée de tout enregistrer.
C’est en faisant des erreurs qu’on apprend.

Par contre, étant donné que le système est directement dans les choux, comment modifier la DB manuellement pour supprimer les données dans t_device_feature_state pour commencer ?
J’ai exporté la DB et utilisé DB Browser sur Windows mais possible de stopper le container et ensuite manuellement faire la manipulation sur la DB ?
Je suis un novice en SQLite et encore plus dans un container

Kevin · Mars 10, 2023, 8:03

Personne pour m’expliquer comment lancer des commandes SQL directement dans Docker ?
La commande SQlite3 n’existe pas. Il fait installer le package ?

guim31 · Mars 10, 2023, 8:19

Désolé @Kevin pour le silence… Malheureusement je n’ai aucune idée de comment on fait

cicoub13 · Mars 11, 2023, 8:41

Bonjour,

Effectivement, sqlite3 est installé uniquement dans le container gladys mais faire les manipulations alors que le container est démarré est une mauvaise idée.

Le mieux (et plus simple si tu n’es pas familier avec les lignes de commande) est de:

stopper le container Gladys
docker stop gladys
faire un backup de la base de données
cp /var/lib/gladysassistant/gladys-production.db /var/lib/gladysassistant/gladys-production.db.backup
copier le fichier /var/lib/gladysassistant/gladys-production.db sur une autre machine
utiliser un éditeur comme DBBrowser
faire tes manipulations (pense bien à Enregistrer les modifications)
recopier la nouvelle base de données dans /var/lib/gladysassistant/
démarrer Gladys
docker start gladys

Kevin · Mars 11, 2023, 10:42

Hello,

Je te remercie pour ta réponse détaillée

Je n’ai aucun souci avec les lignes de commandes, j’étais DEV en C# .NET mais j’avais plutôt l’habitude des manipulations de procédures stockées, transactions et autre sur des instances SQL serveurs avec SSMS… Et n’ayant pas d’expérience avec Docker ni SQLite, j’étais un peu perdu et j’avais besoin d’un tout petit guide de démarrage

J’ai déjà récupéré la DB après avoir arrêté le container Gladys. Et je fais quelques manipulations via DB Browser. Par contre, j’avais deux fichiers (***.DB-SHM, ***.DB-WAL) en plus de la DB (cache, queue , … ?) et je me demande s’il faut forcer un merge ou autre ? Ou je peux simplement faire abstraction de ces fichiers sans corrompre ma DB si je remets ma future DB modifée par la suite ?

Encore merci pour ton aide @cicoub13 !

@guim31 : Pas grave, merci quand même d’avoir répondu

cicoub13 · Mars 11, 2023, 2:02

Aucun souci avec ces fichiers, tu peux les ignorer. Lorsque Gladys va redémarrer, le SHM repartira de zéro. Le WAL contient les procédures de rollback en cas d’erreur. Mais là, on a éteint la connection à la base de manière propre.

Kevin · Mars 11, 2023, 4:39

Ok, parfait. Merci pour ce complément d’information. Je vais procéder de la sorte.

pierre-gilles · Mars 20, 2023, 3:54

Euh non je suis pas d’accord

Normalement si tu stoppe bien Gladys, ces fichiers doivent disparaitre (ils n’existent que quand un programme SQLite accède à la DB). Il faut bien s’assurer que c’est le cas avant de copier le fichier de DB, ou alors copier les 3 fichiers.

Si jamais tu copie une nouvelle DB SQlite à côté d’anciens fichiers db-shm / db-wal, tu risques la corruption de base de donnée.

Kevin · Mars 21, 2023, 9:55

Pour ma part, cela a fonctionné en ignorant ces fichiers. Est-ce le hasard ? Je ne sais pas. Après, Gladys était correctement éteint mais vu les 14Go, je suppose qu’il n’a pas réussi à faire le nécessaire avec les deux autres fichiers.