RAM problem - Gladys no longer responds

Kevin · March 4, 2023, 4:15pm

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 · March 4, 2023, 4:38pm

By continuing to browse and search the forum, I get the impression that it looks a bit like this:

As I recall, I did the following recently:

Added MQTT items to display prices relative to my energy consumption/production
Modified an MQTT item because the topic name was incorrect
Deleted 2 charts because I thought they were the cause of the slowness
Performed a cleanup (impossible to know if it completed correctly since 24h later, no more access

Kevin · March 4, 2023, 6:38pm

I think the problem comes from my DB being over 14GB. I made the bad decision to save everything.
You learn by making mistakes.

However, since the system is completely down, how can I modify the DB manually to delete the data in t_device_feature_state to start?
I exported the DB and used DB Browser on Windows but is it possible to stop the container and then manually perform the operation on the DB?
I’m a novice with SQLite and even more so with containers

Kevin · March 10, 2023, 8:03pm

Can someone explain how to run SQL commands directly in Docker?
The sqlite3 command doesn’t exist. Do I need to install the package?

guim31 · March 10, 2023, 8:19pm

Sorry @Kevin for the silence… Unfortunately I have no idea how to do it

cicoub13 · March 11, 2023, 8:41am

Hello,

Indeed, sqlite3 is installed only in the gladys container but performing the operations while the container is running is a bad idea.

The best (and easiest if you’re not familiar with the command line) is to:

stop the Gladys container
docker stop gladys
make a backup of the database
cp /var/lib/gladysassistant/gladys-production.db /var/lib/gladysassistant/gladys-production.db.backup
copy the file /var/lib/gladysassistant/gladys-production.db to another machine
use an editor like DBBrowser
make your changes (be sure to Save changes)
copy the new database back to /var/lib/gladysassistant/
start Gladys
docker start gladys

Kevin · March 11, 2023, 10:42am

Hello,

Thank you for your detailed reply

I have no problem with the command line, I was a DEV in C# .NET but I was more used to working with stored procedures, transactions and other things on SQL Server instances with SSMS… And having no experience with Docker or SQLite, I was a bit lost and needed a very small getting-started guide

I’ve already recovered the DB after stopping the Gladys container. And I’m doing some manipulations via DB Browser. However, I had two files (***.DB-SHM, ***.DB-WAL) in addition to the DB (cache, queue , … ?) and I wonder if I need to force a merge or something? Or can I simply ignore these files without corrupting my DB if I later put back my modified DB?

Thanks again for your help @cicoub13 !

@guim31 : No worries, thanks anyway for replying

cicoub13 · March 11, 2023, 2:02pm

No worries about these files, you can ignore them. When Gladys restarts, the SHM will start from scratch. The WAL contains the rollback procedures in case of an error. But here, we shut down the database connection cleanly.

Kevin · March 11, 2023, 4:39pm

Ok, perfect. Thank you for this additional information. I will proceed accordingly.

pierre-gilles · March 20, 2023, 3:54am

Uh no, I don’t agree

Normally if you properly stop Gladys, these files should disappear (they only exist when a SQLite program is accessing the DB). You need to make sure that’s the case before copying the DB file, or else copy the 3 files.

If you ever copy a new SQLite DB next to old db-shm / db-wal files, you risk database corruption.

Kevin · March 21, 2023, 9:55am

For my part, it worked by ignoring those files. Was it luck? I don’t know. Afterwards, Gladys was properly shut down, but given the 14GB, I suppose it wasn’t able to do what was necessary with the other two files.

Topic		Replies	Views
Configuration MQTT : Erreur lors de la connexion, veuillez vérifier votre configuration. Après restauration de Gladys sur l'image Bullseye Configuration	31	1533	December 16, 2021
Help! Problème avec l'agrégation? Configuration	90	3543	March 29, 2022
Gladys devient injoignable après quelques heures de fonctionnement Configuration	31	285	July 22, 2024
Problème activation du service Zigbee2mqtt Configuration	34	3293	March 21, 2022
Gladys indispo après reboot Configuration	48	1926	October 21, 2020

RAM problem - Gladys no longer responds

Related topics