Buffering associated with SQLITE error

Plex Players Streaming Devices
1

Server Version#: 1.23.2.4656
Player Version#: tvOS 7.18.1

For the last few weeks I have noticed a lot more buffering on all of the streaming platforms I use (macOS, iOS and tvOS). Server is running in Docker. I have troubleshooted this evening and noted that every time it buffers I get this huge repetition of an SQLite error in the logs (have attached a brief sample below). Any idea what could be causing this and how I can resolve it?

un 14, 2021 21:08:01.313 [0x15400f598b38] VERBOSE - Auth: Came in with a super-token, authorization succeeded.
Jun 14, 2021 21:08:01.313 [0x15400c8efb38] DEBUG - Request: [10.0.1.3:59204 (Subnet)] GET /tv.plex.providers.epg.xmltv:2/hubs/discover?count=30&excludeFields=summary&includeCollections=1&includeExternalMedia=1&includeExternalMetadata=1&includeLibraryPlaylists=1&includeMeta=1&includeRecentChannels=1&includeRelated=1&includeStations=1&includeTrailers=1&includeTypeFirst=1 (10 live) TLS GZIP Signed-in Token (chrislawrence) / Accept => text/xml,application/xml / Accept-Encoding => gzip, deflate, br / Accept-Language => en-AU;q=1 / Connection => keep-alive / Host => 10-0-1-2.941b5b964f954a9c87d4e9dae3bc8860.plex.direct:32400 / User-Agent => PlexTV/7.18.1 (Apple TV; tvOS 14.4; Scale/1.00) / X-Plex-Client-Capabilities => audioDecoders=mp3,aac,ac3{bitrate:800000&channels:8} / X-Plex-Client-Identifier => BE7BA095-A714-490E-85C5-EC691D00B6DC / X-Plex-Device => Apple TV / X-Plex-Device-Name => Living Room / X-Plex-Device-Screen-Density => 1 / X-Plex-Device-Screen-Resolution => 1920x1080 / X-Plex-Device-Vendor => Apple / X-Plex-Drm => fairplay:video / X-Plex-Features => external-media / X-Plex-Http-Pipeline => infinite / X-Plex-Language => en / X-Plex-Model => 5,3 / X-Plex-Platform => tvOS / X-Plex-Platform-Version => 14.4 / X-Plex-Product => Plex for Apple TV / X-Plex-Provider-Version => 3.2.0 / X-Plex-Provides => client,player,pubsub-player,provider-playback / X-Plex-Supported-Commands => abort,changeQuality / X-Plex-Sync-Version => 2 / X-Plex-Token => xxxxxxxxxxxxxxxxxxxx / X-Plex-Username => chrislawrence / X-Plex-Version => 7.18.1
Jun 14, 2021 21:08:01.315 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.315 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.322 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.322 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.329 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.329 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.333 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.333 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.339 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.339 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.342 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.342 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.347 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.347 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.349 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.350 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.362 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:01”
Jun 14, 2021 21:08:01.362 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 11:08:02”
Jun 14, 2021 21:08:01.366 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 13:00:00”
Jun 14, 2021 21:08:01.366 [0x15400c8efb38] ERROR - SQLITE3:0x80000001, 28, double-quoted string literal: “2021-06-14 09:00:00”
Jun 14, 2021 21:08:01.402 [0x15400f5bbb38] VERBOSE - Auth: We found auth token (xxxxxxxxxxxxxxxxxxxx), enabling token-based authentication.
Jun 14, 2021 21:08:01.402 [0x15400f5bbb38] DEBUG - Auth: authenticated user 1 as chrislawrence
Jun 14, 2021 21:08:01.402 [0x15400f5bbb38] VERBOSE - Auth: Came in with a super-token, authorization succeeded.
Jun 14, 2021 21:08:01.402 [0x15400d620b38] DEBUG - Request: [10.0.1.3:59215 (Subnet)] GET /tv.plex.providers.epg.xmltv:2/hubs/discover?

2

That error is just logging. It should not have an effect in performance. Please provide your full PMS logs and Apple TV logs after seeing the issue.

3

Double quoted string literals don’t have any ill effect as SQLITE will work around the issue itself. Really it’s a typographical error in the code and all strings should be single quoted ’ instead of double quoted "

The error is more of an annoyance than anything…

4

In addition to the above comments, I believe the “double-quoted string literal” issues have been addressed in 1.23.3.

5

So it’s a coincidence then?

6

Yea, just a coincidence.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.