I have this same issue while Media Scanner is running. The scan “locks up” in subfolders as it scans through TV shows and takes forever. I keep getting database lockups and busy/held transaction messages throughout logs.
Navigating in the web or Android TV client takes a while and often ends up with a “Something went wrong” and “An unexpected error occurred.” message.
If I stop the scan it returns back to normal. If I restart the service, it may or may not return back to normal (depending on what it does on startup).
This started happening a few months back or so and nothing I’ve done (reinstall, db repairs, setting various cache sizes, moving db to memory, etc) helps the issue.
May 11, 2023 10:09:04.499 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:14.713 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:24.929 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:35.142 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:45.357 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:55.572 [140522153052984] ERROR - [Req#62f95] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:09:58.737 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.570000 seconds
May 11, 2023 10:09:58.738 [140522115926840] WARN - [Grabber] Took too long (56.600000 seconds) to start a transaction on /data/jenkins/server/3526496464/MediaProviders/Grabbers/MediaGrabber.cpp:132
May 11, 2023 10:09:58.738 [140522115926840] WARN - [Grabber] Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:09:58.739 [140522143472440] WARN - Took too long (56.550000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:09:58.739 [140522143472440] WARN - Transaction that was running was started on thread 140522115926840 at /data/jenkins/server/3526496464/MediaProviders/Grabbers/MediaGrabber.cpp:132
May 11, 2023 10:10:29.358 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:10:39.579 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:10:44.773 [140522074479416] INFO - Request: [10.1.1.145:54137 (Allowed Network (Subnet))] OPTIONS /:/prefs (6 live) #636bc TLS GZIP Signed-in Token ()
May 11, 2023 10:10:44.773 [140522278873912] INFO - Completed: [10.1.1.145:54137] 200 OPTIONS /:/prefs (6 live) #636bc TLS GZIP 0ms 376 bytes (pipelined: 3)
May 11, 2023 10:10:45.290 [140522153052984] INFO - [Req#636c7] AutoUpdate: no updates available
May 11, 2023 10:10:49.801 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:10:56.165 [140522074479416] ERROR - [Req#636d3] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:00.016 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:06.378 [140522074479416] ERROR - [Req#636d3] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:10.229 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:15.163 [140522120145720] WARN - NAT: PMP, timed out waiting for response.
May 11, 2023 10:11:15.234 [140522120145720] WARN - MPM: ignoring preferred-interface pref due to no matching valid address
May 11, 2023 10:11:16.592 [140522074479416] ERROR - [Req#636d3] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:20.442 [140522115926840] ERROR - [Req#185ae/ViewStateSync] Waited over 10 seconds for a busy database; giving up.
May 11, 2023 10:11:24.832 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.440000 seconds
May 11, 2023 10:11:24.832 [140522143472440] WARN - Took too long (56.330000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:11:24.832 [140522143472440] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:12:50.966 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.240000 seconds
May 11, 2023 10:12:50.966 [140522076588856] WARN - Took too long (56.180000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:12:50.966 [140522076588856] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:14:17.086 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.260000 seconds
May 11, 2023 10:14:17.087 [140522118036280] WARN - [NSB/SSDP/Grabber] Took too long (65.570000 seconds) to start a transaction on /data/jenkins/server/3526496464/MediaProviders/Grabbers/MediaGrabber.cpp:132
May 11, 2023 10:14:17.087 [140522118036280] WARN - [NSB/SSDP/Grabber] Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:14:17.087 [140522143472440] WARN - Took too long (56.170000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:14:17.087 [140522143472440] WARN - Transaction that was running was started on thread 140522118036280 at /data/jenkins/server/3526496464/MediaProviders/Grabbers/MediaGrabber.cpp:132
May 11, 2023 10:15:43.184 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.270000 seconds
May 11, 2023 10:15:43.184 [140522120145720] WARN - Took too long (56.160000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:15:43.184 [140522120145720] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:17:09.334 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.320000 seconds
May 11, 2023 10:17:09.335 [140522120145720] WARN - Took too long (56.200000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:17:09.335 [140522120145720] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:18:35.467 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.300000 seconds
May 11, 2023 10:18:35.468 [140522124077880] WARN - Took too long (56.190000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:18:35.468 [140522124077880] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:20:01.559 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.260000 seconds
May 11, 2023 10:20:01.559 [140522120145720] WARN - Took too long (56.150000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:20:01.559 [140522120145720] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:21:27.556 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.180000 seconds
May 11, 2023 10:21:27.556 [140522076588856] WARN - Took too long (56.060000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:21:27.556 [140522076588856] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:22:53.575 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.180000 seconds
May 11, 2023 10:22:53.575 [140522143472440] WARN - Took too long (56.060000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:22:53.575 [140522143472440] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
May 11, 2023 10:24:19.646 [140522178800440] WARN - Held transaction for too long (/data/jenkins/server/3526496464/Library/MetadataCollection.cpp:481): 83.240000 seconds
May 11, 2023 10:24:19.647 [140522076588856] WARN - Took too long (56.130000 seconds) to start a transaction on /data/jenkins/server/3526496464/Statistics/StatisticsManager.cpp:301
May 11, 2023 10:24:19.647 [140522076588856] WARN - Transaction that was running was started on thread 140522178800440 at /data/jenkins/server/3526496464/Library/MetadataCollection.cpp:306
MODERATOR EDIT: Readability