CPU Usage / Locked Database

[undaunt]

Hello,

I saw a few prior threads about both CPU usage and a locked DB but wasn't sure if it was a similar situation. My CPU load for the container pegs at aronund 100% and I'm not sure why. I'm using this on 3 or so hosts and hosting the server within a docker container on the primary host. Here are some logs.

Thanks!

2024/09/11 10:55:21 /build/hishtory/backend/server/internal/database/db.go:292
[333.621ms] [rows:1299] SELECT * FROM `deletion_requests` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND destination_device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"

2024/09/11 10:55:21 /build/hishtory/backend/server/internal/database/usagedata.go:48 database is locked
[5005.406ms] [rows:0] UPDATE `usage_data` SET `last_used`="2024-09-11 10:55:16.552" WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"
172.19.0.1:51900 POST "/api/v1/submit?source_device_id=8b484676-ea9f-4197-8ba0-939524c8e411" v0.293 5.006070358s 0 B unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
caught panic: unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
addDeletionRequestHandler: received request containg 1 messages to be deleted

2024/09/11 10:55:21 /build/hishtory/backend/server/internal/database/device.go:55
[0.296ms] [rows:20] SELECT * FROM `devices` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (uninstall_date IS NULL OR uninstall_date < '1971-01-01')
db.DeletionRequestCreate: Found 20 devices

2024/09/11 10:55:25 /build/hishtory/backend/server/internal/database/usagedata.go:48 database is locked
[5005.481ms] [rows:0] UPDATE `usage_data` SET `last_used`="2024-09-11 10:55:20.891" WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"
172.19.0.1:51920 POST "/api/v1/submit?source_device_id=8b484676-ea9f-4197-8ba0-939524c8e411" v0.293 5.006113006s 0 B unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
caught panic: unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction

2024/09/11 10:55:25 /build/hishtory/backend/server/internal/database/usagedata.go:48 database is locked
[5005.264ms] [rows:0] UPDATE `usage_data` SET `last_used`="2024-09-11 10:55:20.932" WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"
172.19.0.1:51930 POST "/api/v1/submit?source_device_id=8b484676-ea9f-4197-8ba0-939524c8e411" v0.293 5.006002411s 0 B unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
caught panic: unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
addDeletionRequestHandler: received request containg 1 messages to be deleted

2024/09/11 10:55:25 /build/hishtory/backend/server/internal/database/device.go:55
[0.218ms] [rows:20] SELECT * FROM `devices` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (uninstall_date IS NULL OR uninstall_date < '1971-01-01')
db.DeletionRequestCreate: Found 20 devices

2024/09/11 10:55:26 /build/hishtory/backend/server/internal/database/db.go:270 database is locked
[5007.005ms] [rows:0] DELETE FROM `enc_history_entries` WHERE false OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ceedf612-3b33-4d53-9570-b31bcedc55a8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1e6a486a-729a-46e0-99da-4f68949410b7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8378257c-f98f-4fee-8f39-c2885662a9a2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f97746e7-95f1-4baa-8156-5ba5e651603d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f22407db-7aa0-4900-8f92-b4dee20084ab")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f22407db-7aa0-4900-8f92-b4dee20084ab")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f8638fa4-ece5-4b21-8ccc-911932041436")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "687be083-8a20-41bc-8fa2-8ab75266996e")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2bc88d8a-0648-4d29-8f4e-993d46fa70d4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3325dd14-5c60-4598-b488-aaca4273c4c6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "05ff59bc-9d25-4e3f-a428-5339c7c0df70")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f36771e2-81a8-4ad3-a6aa-8c3333364c1f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ae4f2709-fbc8-44bf-90f2-fe75bb0e3a7b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b381f8b7-0269-425d-88cb-4c7c4a46bde2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8ed13766-d9f5-4b33-9565-06587fee6922")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a302b35f-d6cc-4452-8a9a-c5d8625faeb4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0bfcd558-4576-44d8-9e08-39f9cea8de08")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d4455884-1180-4bd2-951a-591f9db068e8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d4455884-1180-4bd2-951a-591f9db068e8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "94a02c4f-74b7-48a7-8ca3-cffee402f581")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3590ba74-eed9-45b4-94f0-d8b7cc7c52a6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2f721bc3-9230-4a01-bc96-f655ec823da5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0bedeaf6-caef-4d2b-9d8f-4dc15a5ecb7d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d16cb5bf-c97b-4bfa-9d49-1b2ec83c20d0")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "643d0e07-8108-4b3e-b804-132f0a26ae63")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8586a62c-ddaf-4763-bee1-577a85f351ed")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "52a38b3c-f585-4573-bc5f-cce825f28948")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d06cd782-fa7b-44c4-86d3-42586bf8c2f3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "153526cf-7297-4f73-9407-26672d9b41e1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "694cfe89-cf05-46f9-a89b-d962cb412244")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "46298a96-09d9-40b3-a6c1-1e90b5105703")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "81d53963-7fdd-4f7c-a7b3-48eceaf568b1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "c6c00c3a-c45f-4af6-a0f3-2953f88cf40d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "99cb12d7-d7ac-4495-bde7-fec8dc8d5503")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2adcfbe5-da60-470a-8972-37f3fb7f8486")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2adcfbe5-da60-470a-8972-37f3fb7f8486")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "9388c74b-1717-42f3-a814-2ebd47f02d0c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4f0bc5ed-83d9-4c87-b6c8-cd86ddc1cab8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "85039eb9-eb1c-4990-86bc-5fd5b87e5fa2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6b7400c3-4c1d-49c5-96df-d529435cc43f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e9ac82f9-82a9-459b-b7d8-b2ed44a95910")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "29c7768a-c207-4b9e-8896-fb060a36b249")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f861a92d-44ec-4a93-9d8b-cc169b97d6aa")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1b393ef4-19d4-4499-b283-31b4e4301da3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "19b9575f-72c9-4e82-b636-2fb475d03d52")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "eb8d4b49-250b-4576-8c86-91c75b633ddf")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "dc62c27b-8d2f-4467-abe9-9412b809b16c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ef727ccf-c439-4bd0-baef-42e22d3e014a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "c6d4c824-8820-4067-b987-9d7f17b13f23")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a1a3a991-47d4-4f7f-b08b-4c9c3f3a065f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "394fdaae-5e59-482f-a7a0-212cf8f681ab")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "c239adb1-f62b-4fd8-93fa-e11566a3724d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5f2e3702-e27e-4719-af11-41f5a6616967")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0a2a7583-9d97-41f5-8507-655fe262ea9b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ae9d8cb7-f53a-4458-9820-2f609e616c03")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f683f463-35e1-406d-b85c-00491ffcc311")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8c4459b7-87f0-42aa-b249-87086f7f0a10")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4fd6b2fc-d5dd-4e62-8157-f27c7392c9a3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "487a57ac-c0c1-4015-b6ce-5b2df42527e8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7b8f53b5-7d90-4720-9ab5-40c793ce67b7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "402ea496-ef8e-4ff1-a32a-b90648d0a0f2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "c5379a58-b40d-44be-9812-c40347826de7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f702428f-da67-4110-abc5-1ffdcd7a0a9a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f702428f-da67-4110-abc5-1ffdcd7a0a9a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f702428f-da67-4110-abc5-1ffdcd7a0a9a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "64f395b3-d819-428f-beca-192b5d81027c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a9f18ca1-c6d3-4c35-bcee-6cd5ac6a6307")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "611bf5b2-7146-46fa-82a2-cb898502054b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "bfe8a4a8-0448-48d8-8d26-8c529615c495")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "865ab743-3ae3-4b6a-8d29-d526acb27b23")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "14cb6b8a-2516-4d8d-8821-b779203f6894")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b6b87974-7b1f-456b-b58d-57e3b3f2edc5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1601e5e5-094f-4561-ada8-555f884ec043")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "bcbd33a7-1f26-4d4f-b009-27f0a5e244a5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "9f7ed9ee-02cc-4404-acd5-2a1e30905f58")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b785a896-754a-47ca-a606-800372035028")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "68dc4d26-26c7-473f-b691-17e06ef914fe")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "eb56f6c1-4531-427b-9392-fc40555311e9")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d02e5b12-8d78-4861-a719-55c8f443457f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "dd5de298-02ce-4a5d-9c1a-b13738ee8257")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "14770241-e068-45ac-bfde-0b57fb18ce15")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1eedb0f6-806d-4d77-8317-cc67f911d645")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "612b02ff-6af9-4be8-a7ff-c0d6a968a7ce")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "43122c94-eef6-400a-a91c-f547cbdd1f0c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0326923b-747e-4178-a427-2fc430a3494c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7271c8c5-c5c0-44ab-aa30-045bc2c2532d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3e2ec7a1-cf0d-4640-b637-2ed3c41eeb80")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e29a2444-7ce2-4fbe-b8d6-99b493e55784")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "07cb95da-511b-4003-a306-8cff9c9be745")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "28fa6b91-3c9c-459f-8881-15fd4f2f708d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "249f697b-7ef9-44eb-a59d-465f599c3627")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d98277d4-14d7-432d-9f8a-6e604d5aff9f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4151dce5-8c4c-4411-a2fd-c224ad8cc2c5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a40698f6-3037-4ebd-9603-d4cf78151922")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5e5f2842-9ea3-48d3-a759-9ff38b575ffd")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "694bbba1-9c38-4725-a2ef-56a03557f55e")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1848e342-3664-4753-af04-e8fba6e38512")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "716ec36a-4684-4d87-beeb-88ea3c469e74")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "72b7c525-85dd-4e5d-8baf-8b23165df1b7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "be006a0d-4a86-4515-8638-1f533578cba5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7171ac93-a8b6-4aa8-85b9-31a74d6a427a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "bb7fa5d5-6378-451e-ba7f-d81b0ffcbdea")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "397089cf-5ac5-43bc-9a2d-0ad53e5f4fba")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "66e97cf4-c33e-4a4b-8fd5-bc6c9c53a0b1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "9cf4fe8f-900a-4c9a-829a-95f7e9bc3b22")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "70758224-e173-45dc-bafa-70ff27e89148")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "69708d47-f81b-4b17-a32b-fd0663deba82")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "485544bc-4f66-41c9-82d0-49e621a508b2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2ed4ba9c-9d3b-42a3-b95b-70d39196a454")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b7a6ebb6-7d76-49f8-b4eb-c954a5ee1c83")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "dfd0ff0e-95fa-44ac-b35c-10bbfff3227a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0b11dc8b-a41c-426d-a8c4-578202818f98")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a5d1a102-fe4e-4792-87d9-62d92507bff9")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "004d9d98-30bc-48ee-894f-790c4b9fad44")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d0cf0637-5032-4fd1-a657-dfcfd6dcdaf4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "80733b7b-bc06-4614-b18a-db6e6a892b87")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f8e49a86-c7d2-4151-826d-c44df9898641")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2d081133-624a-42a0-ac2d-ca878273c105")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "11d24666-680f-4fa4-b47a-87bbaf606188")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5058826c-4a46-4467-b9d3-265c128a13ef")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "34bb6031-bd73-4f0a-bb96-6fdabded6336")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3340e4c7-d9d9-4aac-95f5-f978f7568649")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0742d325-148c-4c90-beff-9a494704c812")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8a12a06c-d9a7-420a-9c12-ba930e24846d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "51700beb-a2b9-4f8b-99ff-bf5c9682a668")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "85d64706-140f-45a6-a198-b951d99730d7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0e9d1190-a1ed-4ee7-900d-6058c00bd7aa")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b59e7b0a-e21b-478f-b4db-f13428c5fdd2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "38c25bca-de72-4eaa-98a9-79253a0d81ad")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5e270801-34c8-43ec-88b6-54f8d3757714")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4323e62f-ba75-4fd5-951a-fb1c98433a0a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "403aa544-2840-420c-85e8-f6a5a19de7c9")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ad3956d4-3547-41d3-9102-bc8ad8fd370a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encr
ypted_id = "98687846-551f-46a4-a6b3-d745056d889a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "110ed7a6-aabf-4c5b-b448-7fa07b47c797")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "50224d42-0ced-4adc-9c22-be10238e63ef")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "dfd83950-ddee-41f0-a8c0-adf467f4a816")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "befe4fa9-45d8-4952-b2aa-b61a8b25e5e8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "26013d32-9bc6-4eaa-bd0e-f9c0a59f9b54")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "483481ec-4daa-49dc-bbff-84972ff68435")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2c32391d-59fd-4b67-96c4-c632c8bff1f6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a39dff8d-0980-41a7-866e-6d860917ef9b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "794da68c-6da3-4a0a-b7b4-3dafac5efb5c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e04fb948-ddd1-45f8-b27c-1aba8091dce1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4235140a-9b95-41de-8037-50584132d55f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b6479ac4-c0c1-4107-a7a6-4da1384f74d9")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a39dff8d-0980-41a7-866e-6d860917ef9b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "794da68c-6da3-4a0a-b7b4-3dafac5efb5c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e04fb948-ddd1-45f8-b27c-1aba8091dce1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3d7e59eb-186f-4eef-93c0-b3a6dea8df32")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "25e45e38-f56d-44ff-b9a5-4fd9a19780ec")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2f0e719d-a22d-4c44-a9e5-bada4bb6cc2c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "933edd42-db18-4787-8e18-86da43de18cc")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "9e55b3f2-4037-4cb4-82fd-4fbf815476a4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3e6cd21a-923b-4d0b-96a9-4f6cfa14250a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "9ca3bd5d-b871-47b5-b535-e7a00d1e0bbc")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "73664e35-5c05-44a1-a3eb-59d4aa4a82aa")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "44e0691b-f444-422a-af5b-73ab8b3fffa3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ed934e66-80d4-4c5d-b5df-5d5f47c4e9f8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f4a08da4-8270-4472-8a3c-fdc4565eb6b8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d760f4bb-97d9-4374-8aa9-ef8b8f7ea5a0")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e0bf9ead-0ab0-409c-83c8-ca1573c9681b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "241d8117-0d27-4d90-ba9d-13b9b2fa8837")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b1c843e8-456c-4874-881a-1cc68793c4b8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6185d649-2460-4cd4-a798-f2e3f1b6123f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ee2711c6-f067-480a-a681-558c063fd190")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "00d05cb8-3dfb-4fe5-8f4e-210d15063304")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "fcacb8a7-76a3-4001-82a5-40703c5be53a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1f082aa6-74dc-4411-aa2b-3e8e9c60ceaf")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f691151e-f63a-4e0e-8fc9-91cf748ae5c6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e3376d2c-1faa-4cc0-a0e8-b6307457b356")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "fd112d27-608a-404e-a9dc-9fb134557af4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3a94f867-c1b8-4669-b4a2-fb9a8550400a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "67b14802-25fb-4283-9b54-a9ed8fc9c4a1")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7a468d16-f699-48b1-a9fa-cfcb5d6aecc4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "af2cfd57-c53e-46bf-ae94-a3db1b342054")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "cea14883-7255-49e1-a677-d2ae0f5a9c5f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "fff77db1-26d1-45ee-8eb5-894e386f0a40")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "45d8a410-85f2-4041-962e-cb888d68d16c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "d9c60827-7b10-4d7a-a665-aa31e1058e4d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ec5e4c0f-05be-4907-bfdb-d8f264d2ffc8")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f862f0b2-9493-4981-8bc4-6268c8a25f54")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e28272be-702e-4755-8224-2f18486b141b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e4533d14-437f-402c-9dc8-0617f8ccb40c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5c157a28-2188-4a24-840f-a6930b034f5f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "975094f6-5fa5-4b51-8cd4-7875f746f3ab")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b908e552-2752-4deb-abf7-4ad1f6196bd6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f4533fa2-054c-4b9c-b0c1-1d5b4f12fb76")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3fb9c6dd-ac15-4995-9ffb-423fe2577011")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "df9c793a-43fb-4a37-b045-1fc285e21082")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7bb50ba1-2517-4bd2-911a-39ce810cbf30")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "10ddb01f-1e78-45ce-8f64-ffde9dfc7677")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "97e5ec0e-a1b2-454f-8949-5b8c3eeaf759")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7fd69069-c17d-4578-a458-ed3e78ec8d71")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7ec823be-0921-49f2-a029-b54345128d1b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f525b16f-d67b-426c-96d7-21294b9e271b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "b93ec260-5994-42b0-a0b0-846a98b063f7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "aa8a36b0-8189-403b-a883-5f242178c5e7")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "73938fc6-eb32-4326-9dbe-3164431a45fc")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2630e830-9ce5-4be4-ae90-e45376886f7b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "fbbdbf02-2191-4b38-aaa7-b7215c6ab3e3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "2389f2bc-78a5-429d-9975-3d86acb57e21")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f9963c02-6b4d-4c83-a801-6105dcc192e3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3d6bbd20-7344-4832-8f53-7514cce510e9")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a11dd54c-a09e-4ca1-b9b7-cf7faa7148d3")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a0903ee8-1eff-459b-8b01-97c208604aeb")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "ee4c8b3a-2514-48fd-bfab-b9fc047e3141")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "59f0ca5b-bd91-4626-a8d0-40de622656d4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "08464a93-4c4b-4874-8eef-1e2e7fe4b36a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "7510a61a-719c-4e43-9d55-37b74e3d28fc")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0d5f45b2-40b3-4244-9e47-aa70112af159")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a10972e5-7f0a-47fd-b601-dbe78ee48ed4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "823875cd-079f-4d53-b423-78d7be94be66")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4efb15c8-672b-419c-808a-9e95f7ac7005")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1532b4b8-3d2f-4122-a435-35907a520fbf")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "f5a96a71-1718-496b-afaf-ed285acb1a8b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "e5743ff7-e0f4-4661-ba8a-7b158e035dc2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6eb84e34-4469-432b-b530-77b5349ea3d2")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a5a95983-1c1e-4825-ab2c-bf68d7e7a2c6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "df93b021-56a6-49da-a586-7c95c4ee8f2a")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "088400ea-80d8-43ac-b458-5689314d2f57")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3435550b-cc52-4cd5-88c3-e571b2dd924b")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0ab996b7-942d-4ae7-964f-7b951dc8e9b4")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "92a8696d-4599-4440-93bc-9c3decfd2823")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6ffae58d-dcfb-4493-a0ed-6ce5a511c63f")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "5c74bdfa-f6f1-4796-96f4-cb1523682003")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "bbad758a-ab3c-4e9e-a955-f3f4bc0c6c70")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8d3ca496-245e-46eb-8da0-5cb35e9bd354")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "bc07ff5d-a3b1-4eed-ade7-16c0cf60c2ab")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "22910a24-917e-4782-9ea3-425e0c61d743")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6a284418-0e94-4ccd-9129-deea7eaa05e6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "40408dc8-f087-4a23-b026-8daa95ae675d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "05dd51a8-f15c-40d8-8bd9-76e4e9937ecb")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1583c56b-128d-4cce-8036-09c18462a104")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "a86e999e-a34f-4021-87e4-1c423e644670")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "c3b5eca2-3ab6-4560-a4b3-daa0450fc626")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "58170218-f11f-4d4f-8fb2-227d98433907")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "67c064df-696a-4b49-a897-b0db3beaf36d")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "801949d7-2be7-4e92-a278-4d71daaa5d5e")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "801949d7-2be7-4e92-a278-4d71daaa5d5e")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "1c30fb3a-4c0f-4c9d-8f14-753b509fd710")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "0ae9e377-cd6c-4049-8ced-4a8553be43f5")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "4c102e3c-d92b-4ef2-9e33-0bdac365b831")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "19438c44-cd49-451b-a2d4-d0e55bb848de")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "8da7a89f-fe9c-4822-b68a-a0ed16a61888")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "afc54026-e272-4a72-b760-47a207c99b37")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "60f6e8e0-1ed1-4379-af35-75574968f7c6")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "852c1c88-748e-4135-b9f3-4387fa86ee52")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "82d70b23-c7dd-4f07-a83c-170e80ec6492")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "20966360-b2fa-41d9-90db-38308c168a9c")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6819daa6-607a-4383-91c4-db7d3b5b8490")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "40244bf6-3794-4efe-8395-ab3255c2d785")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6a0b639e-6a81-432a-adbe-c86b0fbff930")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "3e973e3f-5e2a-4a1b-a888-d62084098fb0")) OR (user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (encrypted_id = "6a0b639e-6a81-432a-adbe-c86b0fbff930"))
172.19.0.1:51908 GET "/api/v1/query?device_id=8b484676-ea9f-4197-8ba0-939524c8e411&user_id=32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=&queryReason=preload" v0.293 5.341824978s 0 B DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:108: result.Error: database is locked
caught panic: DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:108: result.Error: database is locked

2024/09/11 10:55:26 /build/hishtory/backend/server/internal/database/db.go:317 database is locked
[5005.232ms] [rows:0] INSERT INTO `deletion_requests` (`user_id`,`destination_device_id`,`send_time`,`messages`,`read_count`) VALUES ("32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","ecfa843e-a1f6-4770-921d-ff7432b6ba83","2024-09-11 10:47:41.914","{""message_ids"":[{""device_id"":""8b484676-ea9f-4197-8ba0-939524c8e411"",""date"":""0001-01-01T00:00:00Z"",""entry_id"":""7f814709-df3a-4f72-b305-693cdf2a81c7""}]}",0)
172.19.0.1:51900 POST "/api/v1/add-deletion-request" v0.293 5.00567717s 0 B DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked
caught panic: DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked

2024/09/11 10:55:30 /build/hishtory/backend/server/internal/database/db.go:317 database is locked
[5005.600ms] [rows:0] INSERT INTO `deletion_requests` (`user_id`,`destination_device_id`,`send_time`,`messages`,`read_count`) VALUES ("32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","ecfa843e-a1f6-4770-921d-ff7432b6ba83","2024-09-11 10:47:41.914","{""message_ids"":[{""device_id"":""8b484676-ea9f-4197-8ba0-939524c8e411"",""date"":""0001-01-01T00:00:00Z"",""entry_id"":""7f814709-df3a-4f72-b305-693cdf2a81c7""}]}",0)
172.19.0.1:51930 POST "/api/v1/add-deletion-request" v0.293 5.006017469s 0 B DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked
caught panic: DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked
addDeletionRequestHandler: received request containg 1 messages to be deleted

2024/09/11 10:55:31 /build/hishtory/backend/server/internal/database/device.go:55
[0.262ms] [rows:20] SELECT * FROM `devices` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND (uninstall_date IS NULL OR uninstall_date < '1971-01-01')
db.DeletionRequestCreate: Found 20 devices

2024/09/11 10:55:31 /build/hishtory/backend/server/internal/database/db.go:282 database is locked
[5005.448ms] [rows:0] UPDATE deletion_requests SET read_count = read_count + 1 WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND destination_device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"
172.19.0.1:51908 GET "/api/v1/get-deletion-requests?user_id=32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=&device_id=8b484676-ea9f-4197-8ba0-939524c8e411" v0.293 5.005489219s 0 B DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:255: tx.Error: database is locked
caught panic: DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:255: tx.Error: database is locked

2024/09/11 10:55:36 /build/hishtory/backend/server/internal/database/db.go:317 database is locked
[5005.416ms] [rows:0] INSERT INTO `deletion_requests` (`user_id`,`destination_device_id`,`send_time`,`messages`,`read_count`) VALUES ("32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=","ecfa843e-a1f6-4770-921d-ff7432b6ba83","2024-09-11 10:55:31.039","{""message_ids"":[{""device_id"":""8b484676-ea9f-4197-8ba0-939524c8e411"",""date"":""0001-01-01T00:00:00Z"",""entry_id"":""78f9145f-60b9-46c1-a97b-601959cca54d""}]}",0)
172.19.0.1:51930 POST "/api/v1/add-deletion-request" v0.293 5.005865825s 0 B DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked
caught panic: DB error at /build/hishtory/backend/server/internal/server/api_handlers.go:274: create: tx.Error: database is locked
apiSubmitHandler: received request containg 1 EncHistoryEntry

2024/09/11 10:55:36 /build/hishtory/backend/server/internal/database/usagedata.go:23
[0.140ms] [rows:1] SELECT * FROM `usage_data` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"

2024/09/11 10:55:36 /build/hishtory/backend/server/internal/database/usagedata.go:28
[0.052ms] [rows:1] SELECT * FROM `usage_data` WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411" ORDER BY `usage_data`.`user_id` LIMIT 1

2024/09/11 10:55:41 /build/hishtory/backend/server/internal/database/usagedata.go:48 database is locked
[5005.584ms] [rows:0] UPDATE `usage_data` SET `last_used`="2024-09-11 10:55:36.057" WHERE user_id = "32-JqbyhdSXaV-pknZrXLlV7q_-FezVCKb8ozB_v28E=" AND device_id = "8b484676-ea9f-4197-8ba0-939524c8e411"
172.19.0.1:51930 POST "/api/v1/submit?source_device_id=8b484676-ea9f-4197-8ba0-939524c8e411" v0.293 5.005890085s 0 B unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction
caught panic: unexpected non-critical error: db.UsageDataUpdate: db.WithContext.Model.Where.Update: database is locked; invalid transaction```

[ddworken]

Thanks for opening this issue! I'm not entirely sure why you're getting errors about the database being locked, I haven't seen any errors with the hishtory server like this before. What kind of database are you using with your server, postgres or sqlite?

Though looking at your log did make me realize that for self-hosted instances we likely don't need to track usage stats (since those are primarily useful for me to keep track of metadata about the shared production instance that I run). #250 disables this tracking which I'm hoping might reduce load for you (though I don't expect it to completely solve your issues).

[undaunt]

@ddworken Cool, thanks! I'm running sqlite so perhaps that's part of the issue. I am also using the Linuxserver.io image.

Is it possible to import the existing history into Postgres if I go that direction? Thanks.

[undaunt]

Hey, I realized my sqlite database is over 4 gigs. Just wondering if it's possible to decrypt/convert/migrate somehow to Postgres to possibly help with the concurrency lock I may be seeing.

Thank you again.