What is your CPU load / IO load?
PMS is overloaded and cannot complete lookups in time.
Sep 23, 2018 17:10:14.802 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:15:16.932 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:20:17.455 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:25:17.905 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:30:18.109 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:35:18.153 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 17:40:19.687 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.290000 seconds
Sep 23, 2018 17:50:19.972 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
Sep 23, 2018 18:00:20.329 [0x7f003afff700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.270000 seconds
It looks as if DVR/LiveTV is running and the box is attempting to transcode and getting very poor signal quaity
Sep 23, 2018 23:01:00.347 [0x7f0022bff700] ERROR - Unable to find title for item of type 5
Sep 23, 2018 23:01:01.201 [0x7f0031911700] ERROR - [Transcoder] [h264 @ 0x167f300] SPS unavailable in decode_picture_timing
Sep 23, 2018 23:01:01.203 [0x7f003ba23700] ERROR - [Transcoder] [h264 @ 0x167f300] non-existing PPS 0 referenced
Sep 23, 2018 23:01:01.206 [0x7f0031911700] ERROR - [Transcoder] [h264 @ 0x167f300] SPS unavailable in decode_picture_timing
Sep 23, 2018 23:01:01.208 [0x7f003ba23700] ERROR - [Transcoder] [h264 @ 0x167f300] non-existing PPS 0 referenced
Sep 23, 2018 23:01:01.210 [0x7f0031911700] ERROR - [Transcoder] [h264 @ 0x167f300] decode_slice_header error
Sep 23, 2018 23:01:01.212 [0x7f003ba23700] ERROR - [Transcoder] [h264 @ 0x167f300] no frame!
Plus, the database is fragmented as heck.
Did you add a ton of media at once?
tv%2Eplex%2Exmltv%3A%2F%2Fepisode%2FFormel%25201%253A%2520Singapores%2520Grand%2520Prix%2520-%2520Tr%25C3%25A6ning%25201%2F1%2F1
Sep 24, 2018 02:30:44.458 [0x7f001d37d700] WARN - Held transaction for too long (../Sync/SyncItemGenerator.cpp:153): 1.700000 seconds
Sep 24, 2018 02:48:42.992 [0x7f001e7ff700] WARN - SLOW QUERY: It took 2810.000000 ms to retrieve 0 items.
Sep 24, 2018 02:48:57.133 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:49:27.122 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:49:57.135 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:50:27.468 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:50:27.628 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:50:57.194 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:51:27.182 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:51:27.188 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream
Sep 24, 2018 02:51:57.195 [0x7f0029223700] ERROR - buildIndexFile: part has no video stream