Memory usage - 9 GB
Hello,
I'm currently running hishtory self-hosted in docker. When I went to add a new client today the memory usage went from 38MB to 9GB. I'm wondering if this is due to my large existing sqlite database trying to sync or otherwise. This happened right after I ran the init command against my existing secret key.
services:
hishtory:
image: lscr.io/linuxserver/hishtory-server:latest
container_name: hishtory
restart: unless-stopped
profiles: ["all", "core", "hishtory"]
networks:
- ${APP_NETWORK}
ports:
- 8095:8080
volumes:
- ${APPDATA_DIR}/hishtory:/config
environment:
TZ: ${TZ}
PUID: ${PUID}
PGID: ${PGID}
HISHTORY_SQLITE_DB: /config/hishtory.db
Thank you.
Edit: After about five minutes the usage dropped back to 400 MB. I received this error on the client:
Importing existing shell history...
Persisting history entries
100% |█████████████████████████████████████████████████████████████████████████████████████████████████| (51145/51145, 9165 it/s)
2025/02/05 09:53:16 hishtory v0.318 fatal error at github.com/ddworken/hishtory/client/cmd/install.go:101: failed to upload hishtory import: failed to reupload due to failed POST: failed to POST http://localhost:8095/api/v1/submit?source_device_id=ab694d11-629d-4df3-92ee-8af90f4e7f61: status_code=503
The logs on the container show a lot of what I assume are the syncing logs such as the following:
24-11-04 21:11:07.34","222163ea-0ef3-4838-af33-77fa542047a0",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 21:10:57.992","729557db-e64e-4e42-b26d-f4c43a779796",0,false),("<binary>","�V�<�tj`��""�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 21:10:53.881","4b9a9ffd-00e3-48e5-a433-f7bd53cecac2",0,false),("<binary>","?}w������!��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 21:01:59.794","9f9535a4-baf6-4446-8b86-aa712fda6449",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:58:04.522","48670877-acd5-4367-b466-b28a2eef6955",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:57:57.78","ad678b57-fadd-4ca7-81d8-d29cace89451",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:57:57.514","1ae6a0bc-30c6-4981-b1d1-325218f38b2e",0,false),("<binary>","�k��>��-~{̧","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:57:08.376","1b24cede-5288-4b6d-9873-31979fa18e1e",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:55.891","253397c8-aa22-4823-bfe4-ea01a8523328",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:42.856","24ed3218-cf2d-4226-a751-42e73bd91b8b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:38.182","539e0523-3880-4921-873e-d5018b08ec0f",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:27.974","e3e722ec-371e-4a5e-bf87-7e4e84c25579",0,false),("<binary>","҃+������V�?","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:17.71","139b8974-0d7c-4999-b7ae-028d20b569b2",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:56:04.596","1bdff6ca-9973-4112-9238-484a766e7988",0,false),("<binary>","w��z��'��>@�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","c9261bd9-792d-4caf-ab97-f53e3dda13a3",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:55:11.543","633c4da2-93b7-4cfd-b49f-4b10f5f6d24b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:54:58.538","de522a5e-7c43-4afe-82c2-451eb64309e2",0,false),("<binary>","Dj���O52&@-�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:54:52.209","e50f4b73-6a14-46ed-beeb-49bc24f3b2ff",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:54:52.047","5f5350b3-459e-49c7-9c10-6d4149db3966",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 21:01:55.922","3bd7e2cc-0542-4783-8d48-19540c2eceb5",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:53:01.891","ef0a6f15-c2f1-4eda-8dfc-dae1dc38221d",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:52:58.696","c8008fed-4da2-4f51-bad6-14bf98ddf35b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:52:57.216","6e4960de-2a96-48d8-badf-7962f93b398c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:52:56.831","4ca13ffa-c23a-4662-9694-f8abac029eb7",0,false),("<binary>","x�k��@�q�0��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","8297d197-4c9d-41ac-b5f5-b4c94cf9c224",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:49:48.577","557dfa9a-43c6-4154-b0fb-dc0e8d4917b2",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:49:31.335","a34b706e-e762-410f-9277-defa52d9994d",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:45:13.424","d992d45b-dabe-4cf0-9cc5-a629cf85ed58",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:45:11.616","b70f50fe-4acc-4df5-ba8f-32f63e7a9962",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","b8062e93-b0f1-4c88-a022-b9d6c14f7666",0,false),("<binary>","h,z5!���Z���","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:30.781","212a45ed-30b8-4e2a-ac63-c7cfaf6ef534",0,false),("<binary>","�J��2�if��9�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:30.042","2dd3e6e8-1242-4fc2-8aa4-a8d4b4be64d0",0,false),("<binary>","5�\i�/�̪xk�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","f6b1d1e6-8f23-4fac-9ec5-52dd0c7ffb32",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:24.377","8fff2fbc-1a00-4bab-b79f-cbe431ffbc7a",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:14.522","454b410f-c46b-4cb4-832f-2463b67ea44d",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:06.723","1257ee51-5e20-40f8-86ed-b493f7b86b77",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:05.836","cbce87e5-c5da-436c-9973-1d319711f304",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:05.365","e31c4d7f-dc74-4783-afc6-edaa8446ca74",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:42:04.744","25cf4358-5696-4834-895c-90cc8e62d0ae",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:41:55.401","f843fc67-abfd-4836-9ac6-ae2905d60991",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:41:30.169","5937fb67-1a15-4572-b20c-bbe4b398db05",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:41:27.124","95cd1dd4-ce5d-4e51-ad38-04760b71fc6f",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","c46d66c5-ddf8-4a11-aa34-e41ca3a6eb24",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:41:19.312","dbfdda5b-41bd-41bf-ae0a-6a817f91a216",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:40:53.595","f36a9273-2ae9-4590-a455-e55a97bfd1bc",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:40:44.563","e9fd1c3c-2e8b-491b-9eaa-f98cb1e47e3c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:03:38.225","f7ba6b10-528d-4a37-a614-fbcd8c511bb9",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 20:03:11.22","07940b78-1a22-43ad-b701-b2ba424eba23",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:51.671","f289d61c-786a-42c4-873b-8455ee3aed9f",0,false),("<binary>","��1�J�^��iy�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","ce604980-5dfb-4367-83b9-070ac8b7bf08",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:49.648","a9b7fb46-cb18-4899-bc9a-d8b3175d40e1",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:48.434","61f0a38a-fa32-4c16-a8f3-6d034175cfcc",0,false),("<binary>","�`J��(ӭKl&�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:47.531","35566639-c5e9-4713-9948-9194e80389e3",0,false),("<binary>","K������j��?�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:43.984","3d839bb9-b1dd-4e2f-908e-93fe0631aac9",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","41671341-deff-4b2d-b21b-0e5a6db18cd2",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:43.48","8561efa1-cc07-4d3c-8270-c0656a9ea375",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:35.685","01646924-612f-4a6b-8028-cd1fa25b8ca2",0,false),("<binary>","9���eڑ�o�gq","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:34.553","436f1184-3642-4f52-9ddb-cadb335a8e2a",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:34.17","b7934231-981f-4ef6-bb8c-fea49e19672b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","38a42863-3b77-4c9b-a41e-1e1a23df9d4d",0,false),("<binary>","3>���ڠu�)""�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:28.213","1d730b4c-b166-4025-a10b-d35efae9f1f2",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:41:26.059","458c286b-4128-4bcc-89bd-6a566e93aa19",0,false),("<binary>","�0Ţ��<�����","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:40:42.545","ec5d92d5-d73d-4d2a-949d-6ce134011cb0",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:40:40.741","9aafa376-516b-46e0-9b93-c7a6ffe5b6d3",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:40:40.381","f5df7365-90a7-4ec8-98d9-abde4fa8792f",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","afc5a78d-9a2c-4759-a0fe-736e7bb7abad",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:40:39.023","49500998-bbf7-4c34-88de-f4ff0e5265f8",0,false),("<binary>","G+X�\tݷ����","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:40:37.573","0d39664d-6f07-4fda-9093-f8a5169f100c",0,false),("<binary>","������ěAQ�c","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:38:32.897","cff78237-b3d5-4bac-b83b-1d3eb117674a",0,false),("<binary>","��>�&gc�H��W","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:41.321","6335161d-f442-4214-a923-1f82b8d23f96",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:30.788","023907dc-2704-41c2-8b6f-3caa477d65f1",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:15.392","3f20f051-affe-4ea1-b502-96af6ae01e56",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:14.492","2763f5b6-a85d-439b-b359-0d060eddfd19",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:13.362","98056a65-aba7-423f-b387-0abe1676d470",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","9d9f4b37-c61b-4ff9-a9e5-83741b1659c5",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:10.304","7235364f-ad7d-4a03-9e5a-632c23bec9c4",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:37:05.795","6b9606e4-3249-4d77-9edc-ce7db805d09d",0,false),("<binary>","�I��h����r��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:35:45.599","3e721ad0-3eb4-42b0-bfb8-bcda925cd306",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:35:50.909","cb959c7d-0fc0-4ff7-8c45-115bcf4dd1ec",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:35:39.902","cc2b32bf-4847-478c-b1d9-29463e1eae80",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","45cec916-ef6a-462f-aeea-e1237bfabb33",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","2da1d64b-b622-4ec5-b30d-1a943c3cecb6",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:35:35.187","3e906177-2af6-4ebf-8b28-eb9779361030",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:13.832","243ca0b5-4811-439f-9ddc-1e0063b84a08",0,false),("<binary>","6��� �x�GJ��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:11.311","3e7c1dec-a565-4323-a1cd-70192b8ee706",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:10.109","a1a3862c-1e2e-44d0-b42e-91ad955671f6",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:08.431","6aa3812c-cc91-4f4c-ad3f-28f2bbd8381c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:08.986","f2b14271-0791-425a-b9c1-b7722cc9d77b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:34:09.152","87b110dd-880d-4f65-b7fc-070b5fa4e8e1",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","1d981312-d741-4a0c-b6b4-2d50e95e8c99",0,false
),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:59.473","f947ce2c-26af-4301-b697-23b2743fa58e",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","b3733949-231d-4e84-a85b-9e5b922223d6",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:59.308","4097379e-ec4a-40a8-92d8-cc731660eb94",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:56.427","ae918e65-0e21-4bab-8265-d5c5688dd130",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:48.147","8578ae07-9ca6-41c1-aab0-eb801ae263d2",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","442be201-7e3b-4226-bae3-a457ebc19e18",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:46.044","50dd86b2-73e7-4eec-835d-c29eddf05fa9",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","b8123758-7137-402f-922a-a7948b4c5dbc",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:33:45.66","d349f523-2f66-446c-a392-464e3b78e69b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:26:45.908","8331681f-16e3-464a-8ead-132569e0d094",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:48:46.636","b10481cf-34de-4cb0-b11e-ef976648649c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:21:16.601","be131b8b-53ed-4dd9-9879-91b0efd3e94c",0,false),("<binary>","���X�}���N��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:21:03.04","7aff7d89-3316-4470-b2d2-9210e889544e",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","a75b48a6-3c3e-489f-a42e-694f91f1bd9d",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:54.338","6d2c5c67-1e28-48f4-9a34-a4bc49de23cd",0,false),("<binary>","��Try���Af�(","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:46.869","56a1f607-19fa-4233-b970-a034e1bb0333",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:34.409","f75d656f-0ad0-4f1b-88b7-f54d1121fe92",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","e275bc07-73cc-4fc0-baa9-6a27f1731efe",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:30.038","9193fd74-d00d-4b16-83fa-45e51e249550",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:15.624","6d8d7e82-2811-44cb-9394-5a0090a0c72c",0,false),("<binary>","<�q���6�""���","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:20:02.197","d249e83f-3a93-4388-9835-8998d3c575b9",0,false),("<binary>","ot�N����SM4�","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:53.86","fafaeb26-3811-4413-a421-a3878fc9a41b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:52.939","709891e2-6ffb-4eff-a044-ece4f4452843",0,false),("<binary>","/cb��A�P9���","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:45.88","e206c29b-e066-4d83-b4ea-9c4829ed8210",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:44.782","1b66c04e-799f-4486-9dec-9a785afabcbf",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:42.299","61874309-ddd1-4719-8b43-584994d2ba60",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:41.344","971c5a24-cd03-4898-b38f-d074342daa1b",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","bd72f5e1-cbe3-49e7-a37d-5086008955ff",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:19:35.324","a575db9d-7a8f-4b33-ab2d-612eca13c562",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:18:09.429","ed0d814f-5745-46bd-b5ca-586529229499",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:18:09.361","1c6eb6fe-4192-43ed-b674-a134d5e4d35c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:17:53.864","7b333341-7316-4e61-adbb-fe89f71e6e6c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:17:52.815","f22e254b-4ce2-4ba5-98fa-6bb66f25c7ed",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:17:38.454","c5bacd4a-aebf-4f76-803f-03d83645a5eb",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:28.519","af16ad2d-5dbb-42b6-bdaf-302910783003",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:26.975","06270378-3c88-4af4-8df2-5a8a5c863f78",0,false),("<binary>","��H���-�L��y","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:23.207","c70cbda3-1992-452e-9c9c-a1fc9c97fd17",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:09.691","b491b660-dc59-4cc1-854b-d478c3f82566",0,false),("<binary>","8]��?�Y8&�'d","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:07.745","1ede3f09-2190-4b58-9f6d-5f9180506677",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:07.404","770836da-4911-4d4d-8c3b-0464e60c1f63",0,false),("<binary>","����j�#P:'X/","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:06.277","82a1e258-5ec6-4ada-8649-a4114953221f",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","1970-01-01 00:00:00","9c431d59-57cc-44ef-8ca0-704f7631d891",0,false),("<binary>",":�݆u�id I��","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:16:03.683","a1019880-0bfa-406b-8763-e6e6594a1902",0,false),("<binary>","~���#'W\�ضq","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:04:42.74","691f4fdc-27ed-493d-ac9d-cea6a4bfefd1",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 19:04:23.541","d562d476-e657-4cba-bd8d-bc4facaf25ac",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:49:51.241","6374e605-7624-4bef-bdaf-258b37845832",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:48:36.428","970c453a-e4d8-446b-ab4a-803c731a0ba9",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:47:40.287","2a060a59-ea71-4f75-976c-ba1acaad639c",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:21:17.915","a9bfb8f2-21a9-43bc-9452-0f17fcf68113",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:17:36.308","3bd6eb3c-afc1-461b-8479-792f44048ec6",0,false),("<binary>","B��@��Z%���q","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 18:17:30.498","4d237412-901c-473d-9fa7-1e8459bd6215",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 16:42:18.257","3c797986-0ca2-468a-8348-eb1041843f2a",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 16:40:43.783","0cdedfcd-2f93-451e-bb47-2ef049889835",0,false),("<binary>","<binary>","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2024-11-04 16:40:27.128","09a02a82-d630-412e-97ee-8ec27e663033",0,false)
but then show this at the end, including a caught panic line.
172.19.0.1:39674 POST "/api/v1/submit?source_device_id=ab694d11-629d-4df3-92ee-8af90f4e7f61" v0.318 2.110459724s 0 B failed to execute transaction to add entries to DB: resp.Error: context canceled
caught panic: failed to execute transaction to add entries to DB: resp.Error: context canceled
apiSubmitHandler: received request containg 1 EncHistoryEntry
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/device.go:55
[0.644ms] [rows:31] SELECT * FROM `devices` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (uninstall_date IS NULL OR uninstall_date < '1971-01-01')
apiSubmitHandler: Found 31 devices
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[9.673ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","ecfa843e-a1f6-4770-921d-ff7432b6ba83","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.434ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","0f258cce-f570-4ee2-af59-e032e5da81ad","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.243ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","c3ffa550-c0e7-4bc1-b389-c0540724e20b","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.732ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","36f013bc-8a83-42e2-b160-fcf8d3bdda7c","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.367ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","feb55952-afb8-49c8-ae5a-522b3d7c150d","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.202ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","f14dc39b-17bc-441e-a1b2-6bc011e8867d","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.393ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","7c1e7528-1b4f-4029-a62c-9ce19d21ce7c","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.591ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","62c42fd8-7054-4558-95bf-d53dff55d215","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.292ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","699c85b9-28ac-4a18-b349-b068aee038d8","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.609ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","20400cee-9985-4cb7-95dd-d291a00c8603","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.344ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","edb5ff56-6e1a-4a21-816b-92cdf5673eb7","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.241ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","886b1bb1-ab8e-46f2-8e48-79111945d0c1","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.484ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","4d0f5d19-4f7a-4040-af5a-0e933cf349bc","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.396ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","449088a1-de31-464e-9eb0-534afad05b5b","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.396ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","ea162032-d42a-4f79-8ddc-4faf4dda2645","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.258ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","4e8bf8a4-0e63-42ef-9e84-6c1342b9be5a","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.788ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","23ab3cda-26fe-46de-98f7-9b7c19a4dcb9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.472ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","ac540d0c-f83f-4b8f-9c50-0197a6aff4cc","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.514ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","a0b79162-dabe-4020-9a20-4701e91528fc","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.376ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","8b484676-ea9f-4197-8ba0-939524c8e411","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.518ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","42842af6-8ece-4313-9bf0-6a28d9ba57cd","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.235ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","521f3cb6-f115-4414-ad02-db5398bf0a99","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.391ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","90a5dbe0-f4af-417e-bd55-3eaaf4b6b46f","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.665ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","79fd9553-e95c-4097-8a6a-07330f9b5e25","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.269ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","a92cf7dd-f6f7-41b7-9be8-b4217a9a8322","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.455ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","89f4d087-9ecb-48fa-b20b-7c9cf8f10303","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.249ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","3bd09ba9-f25d-4f5b-b5e2-7a151e26f748","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.224ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","26aba8d7-28e0-41b2-b8f4-759e31efd7bf","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.370ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","de9cad55-513e-4729-94f0-8ed98a257ba4","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.199ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","5c58576d-ebde-480c-b02a-64f82154b1d9","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,false)
2025/02/05 09:53:17 /build/hishtory/backend/server/internal/database/historyentries.go:78
[0.185ms] [rows:1] INSERT INTO `enc_history_entries` (`encrypted_data`,`nonce`,`device_id`,`user_id`,`date`,`encrypted_id`,`read_count`,`is_from_same_device`) VALUES ("<binary>","V[�@]�D�Ln�h","ab694d11-629d-4df3-92ee-8af90f4e7f61","32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","2025-02-05 17:53:17.196","56e16891-246a-469c-b00a-425beedb094a",0,true)
172.19.0.1:42488 POST "/api/v1/submit?source_device_id=ab694d11-629d-4df3-92ee-8af90f4e7f61" v0.318 32.577388ms 48 B
Found a valid version: v0.333
2025/02/05 09:55:20 /build/hishtory/backend/server/internal/database/db.go:346
[1.106ms] [rows:0] DELETE FROM enc_history_entries WHERE read_count > 10
2025/02/05 09:55:20 /build/hishtory/backend/server/internal/database/db.go:350
[323.431ms] [rows:0] DELETE FROM deletion_requests WHERE read_count > 100
Thank you for the detailed issue! I'm starting to dig into this now, though one clarifying question: Is the high memory usage on the server, or on the client? I'm assuming the server?
It's on the server container, yes, thanks!