NFS Share on Apple TV App not working

[Doppelherz]

Server Version#: 1.19.4.2865
Player Version#: 7.4

PMS is installed on a RaspBerry Pi as an add-on inside home assistant. To get all music, movies and images from my local NAS, I mounted a folder in /etc/fstab:

nas.ip:/volume1/Public /usr/share/hassio/share/public nfs rsize=8192,wsize=8192,timeo=14,intr

I can start any movie over the web app, or on ios as well, but on the apple tv the loading spinner circles a few seconds and thats it. It seems, that the apple tv cannot find the file and gives up.

Do I have to fix the mount or what can I do? Or is it a bug inside the apple tv app of plex?

That’s the error log from apple tv:

PMKPlayerManager.m:275 | Error loading Play Queue of type video: Error Domain=PMKPlaybackErrorDomain Code=2015 "Couldn't retrieve the Play Queue" UserInfo={NSLocalizedDescription=Couldn't retrieve the Play Queue, NSUnderlyingError=0x2831509c0 {Error Domain=PMKHTTPResponseError Code=500 "Antwortfehler" UserInfo={NSLocalizedDescription=Antwortfehler}}}

[Volts]

The Apple TV is interacting with Plex, not with the NFS share. The Apple TV isn’t aware of the NFS share at all.

But obviously something is wrong.

I’m guessing that it’s a permissions or disk space issue on the PMS server. If something needs to be transcoded (which may be problematic for multiple reasons) or remuxed, perhaps Plex can’t write to a directory it is configured to use.

I’d first check that the Apple TV “Home Streaming” quality is set to “Maximum” and that “Allow Direct Play” is on. Those might avoid any need for transcoding/remuxing, which is the best case.

If that doesn’t avoid the issue, then sharing logs from the Plex Server and Apple TV a few minutes after you watch a video might be helpful.

[Doppelherz]

Home Streaming Quality is already set to maximum and Allew Direct Play was still on.

Logs from TV:

2020/08/21 14:59:38.372 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079b1b0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.373 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280798360: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.373 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079a250: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.374 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280799e30: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.374 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079d6e0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.375 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079de60: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.375 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079df80: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.376 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28079c870: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.376 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280782760: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.377 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280781ad0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.377 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280781830: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.377 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807814d0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.378 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280786d60: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.378 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807873f0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.379 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280787a50: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.379 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807856e0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.380 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280789920: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.380 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807b3420: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.381 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807b2790: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.381 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807b3d20: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.382 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807ba6a0: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.383 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807b9680: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.383 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807bd050: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.384 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807bd320: {type:1 name:Field xml:“”}
2020/08/21 14:59:38.385 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807ccf30: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.385 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806078d0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.386 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280606d90: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.387 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807cde30: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.388 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280604930: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.388 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280605e90: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.389 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280607840: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.389 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806075d0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.390 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807cdf50: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.390 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bfab0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.391 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806be190: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.391 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bf210: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.391 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bdef0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.392 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bdbf0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.392 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bd860: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.393 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807ce790: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.393 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bc5d0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.394 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806bec40: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.394 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807f1260: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.395 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806a8120: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.395 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806a9290: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.396 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806a8d20: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.396 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806aa190: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.396 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807f05d0: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.397 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806a8510: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.397 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2806a8ab0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.398 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807f21c0: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.398 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280607390: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.399 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x280607150: {type:1 name:Operator xml:“”}
2020/08/21 14:59:38.399 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x2807f2070: {type:1 name:FieldType xml:“”}
2020/08/21 14:59:38.400 (307 MB) (2770950) PMKModel.m:316 | No class found for element GDataXMLElement 0x28062c3c0: {type:1 name:Operator xml:“”}
2020/08/21 14:59:40.803 (307 MB) (2770564) PMKGlobalPlaybackContextManager.m:46 | Clearing cached metrics contexts
2020/08/21 14:59:41.440 (298 MB) (2770972) PMKEventSourceManager.m:201 | Event received (ping): {}
2020/08/21 14:59:43.220 (298 MB) (2770616) PTVBridgeConsole.m:22 | APPEAR event: Settings
2020/08/21 14:59:43.472 (298 MB) (2770616) PTVBridgeConsole.m:22 | Reloading existing page…
2020/08/21 14:59:51.442 (297 MB) (2770953) PMKEventSourceManager.m:201 | Event received (ping): {}
2020/08/21 15:00:01.442 (288 MB) (2770988) PMKEventSourceManager.m:201 | Event received (ping): {}
2020/08/21 15:00:04.938 (288 MB) (2770564) PMKMetricsEngine.m:557 | Error received during submission: 0 Error Domain=NSURLErrorDomain Code=-1003 “Es wurde kein Server mit dem angegebenen Hostnamen gefunden.” UserInfo={_kCFStreamErrorCodeKey=8, NSUnderlyingError=0x2807956b0 {Error Domain=kCFErrorDomainCFNetwork Code=-1003 “(null)” UserInfo={_kCFStreamErrorCodeKey=8, _kCFStreamErrorDomainKey=12}}, _NSURLErrorFailingURLSessionTaskErrorKey=LocalDataTask .<2>, _NSURLErrorRelatedURLSessionTaskErrorKey=(
“LocalDataTask .<2>”
), NSLocalizedDescription=Es wurde kein Server mit dem angegebenen Hostnamen gefunden., NSErrorFailingURLStringKey=https://analytics.plex.tv/collect/event, NSErrorFailingURLKey=https://analytics.plex.tv/collect/event, _kCFStreamErrorDomainKey=12}
2020/08/21 15:00:11.443 (287 MB) (2770989) PMKEventSourceManager.m:201 | Event received (ping): {}

Logs from PMS:

Aug 21, 2020 14:57:29.608 [0xbbafe450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:57:29.611 [0xbbafe450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:29.611 [0xbbafe450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:29.612 [0xbbafe450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:38.017 [0xce0ff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:57:38.017 [0xce0ff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:57:38.017 [0xce0ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:38.017 [0xce0ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:38.017 [0xce0ff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:58.072 [0xca9ff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:57:58.072 [0xca9ff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:57:58.073 [0xca9ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:58.073 [0xca9ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:57:58.073 [0xca9ff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:12.790 [0xcffff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:58:12.790 [0xcffff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:58:12.790 [0xcffff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:12.790 [0xcffff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:12.791 [0xcffff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:18.097 [0xca9ff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:58:18.097 [0xca9ff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:58:18.097 [0xca9ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:18.098 [0xca9ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:18.098 [0xca9ff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:30.206 [0xce0ff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:58:30.206 [0xce0ff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:58:30.206 [0xce0ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:30.206 [0xce0ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:30.207 [0xce0ff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:58:56.486 [0xcffff450] ERROR - Unknown metadata type: folder
Aug 21, 2020 14:58:58.054 [0xcffff450] ERROR - Unknown metadata type: folder
Aug 21, 2020 14:59:00.903 [0xebcf9450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/7a/7a2ec886524dd8858f50bea3fb39a13ea6b0763c.jpg]
Aug 21, 2020 14:59:00.904 [0xc97ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/d8/d851925aee20bf8762daf7d3deb0459019791c0a.jpg]
Aug 21, 2020 14:59:00.907 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/f6/f62d5f8e743a3e0daa62f3bcb096b11839fb7174.jpg]
Aug 21, 2020 14:59:01.393 [0xebcf9450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:59:01.393 [0xebcf9450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:59:01.393 [0xebcf9450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:01.393 [0xebcf9450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:01.394 [0xebcf9450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:01.839 [0xc97ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/7a/7a2ec886524dd8858f50bea3fb39a13ea6b0763c.jpg]
Aug 21, 2020 14:59:01.846 [0xce0ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/f6/f62d5f8e743a3e0daa62f3bcb096b11839fb7174.jpg]
Aug 21, 2020 14:59:01.852 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/d8/d851925aee20bf8762daf7d3deb0459019791c0a.jpg]
Aug 21, 2020 14:59:01.853 [0xc97ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/d8/d851925aee20bf8762daf7d3deb0459019791c0a.jpg]
Aug 21, 2020 14:59:01.866 [0xebcf9450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/f6/f62d5f8e743a3e0daa62f3bcb096b11839fb7174.jpg]
Aug 21, 2020 14:59:04.015 [0xce0ff450] ERROR - Unknown metadata type: folder
Aug 21, 2020 14:59:09.530 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/ac/acc08b895a2a5d4b8ac0c1d177c54e2713e46f7c.jpg]
Aug 21, 2020 14:59:09.689 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/db/db50de14399ca18d50ff9833a4fdbe65a6d9eb61.jpg]
Aug 21, 2020 14:59:09.956 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/b8/b8899945d5f8a0eb20a1eddf55ce70f3a5df445d.jpg]
Aug 21, 2020 14:59:10.454 [0xcffff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/ac/acc08b895a2a5d4b8ac0c1d177c54e2713e46f7c.jpg]
Aug 21, 2020 14:59:10.466 [0xcffff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:59:10.467 [0xcffff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:59:10.467 [0xcffff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:10.467 [0xcffff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:10.467 [0xcffff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:10.516 [0xc97ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/db/db50de14399ca18d50ff9833a4fdbe65a6d9eb61.jpg]
Aug 21, 2020 14:59:10.518 [0xce0ff450] ERROR - Error resizing an image, we don’t trust what we cached [/data/Plex Media Server/Cache/PhotoTranscoder/b8/b8899945d5f8a0eb20a1eddf55ce70f3a5df445d.jpg]
Aug 21, 2020 14:59:12.948 [0xebcf9450] ERROR - Unknown metadata type: folder
Aug 21, 2020 14:59:25.412 [0xebcf9450] ERROR - Unknown metadata type: folder
Aug 21, 2020 14:59:35.535 [0xc41ff450] ERROR - SQLITE3:0x154, 11, database corruption at line 87331 of [bf8c1b2b7a]
Aug 21, 2020 14:59:35.535 [0xc41ff450] ERROR - SQLITE3:0x154, 11, statement aborts at 10: [delete from play_queue_items where play_queue_id=? and id<>?] database disk image is malformed
Aug 21, 2020 14:59:35.535 [0xc41ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueue.cpp:114): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:35.535 [0xc41ff450] ERROR - Exception inside transaction (inside=1) (…/Playlists/PlayQueueRequestHandler.cpp:125): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:35.535 [0xc41ff450] ERROR - Soci Exception handled: sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2020 14:59:38.379 [0xc41ff450] ERROR - Unknown metadata type: folder
Aug 21, 2020 15:03:41.744 [0xc41ff450] WARN - QueryParser: Invalid field ‘libraryHubsOnly’ found, ignoring.
Aug 21, 2020 15:03:41.750 [0xc41ff450] WARN - QueryParser: Invalid field ‘libraryHubsOnly’ found, ignoring.
Aug 21, 2020 15:03:41.757 [0xc41ff450] WARN - QueryParser: Invalid field ‘libraryHubsOnly’ found, ignoring.

[Doppelherz]

That’s the log inside Plex, when I start a movie on Apple TV

[Doppelherz]

$ sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”
$ ok

the db check returns an OK

[Volts]

Are you storing your .db on NFS? Say no …

That’s definitely database corruption. It’s hard to know if fixing it will also address the Apple TV issues, but it needs to be addressed first.

PRAGMA integrity_check can identify some broken databases, but not all. It can’t validate or prove that a database is good.

I’m a little surprised that Plex keeps trying after multiple high-severity DB errors.

I would follow the processes in the Plex DB backup / fix support document first. I’m curious if the “dump” process would even succeed.

Ugh. Sorry. Good luck.

[Doppelherz]

the db is not inside the mounted folder. I try to find and follow the support document

[Volts]

These are the docs I would look at:

Restore a Database Backed Up via 'Scheduled Tasks' | Plex Support

Repair a Corrupt Database | Plex Support

Sorry, I assumed you had them - PRAGMA integrity_check isn’t something people usually trip over.

[Doppelherz]

oh, now there is a better output

$ sudo sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check”

*** in database main ***

On tree page 168187 cell 60: Rowid 26507 out of order

On tree page 50498 cell 20: Rowid 26517 out of order

On tree page 215201 cell 12: 2nd reference to page 215762

On tree page 43 cell 5: Rowid 52275 out of order

On tree page 203559 cell 27: Rowid 52287 out of order

Error: database disk image is malformed

[Doppelherz]

what does this mean?

$ sqlite3 com.plexapp.plugins.library.db < dump.sql

Error: near line 395023: UNIQUE constraint failed: play_queue_items.id

Error: near line 395024: UNIQUE constraint failed: play_queue_items.id

Error: near line 395025: UNIQUE constraint failed: play_queue_items.id

Error: near line 395026: UNIQUE constraint failed: play_queue_items.id

Error: near line 395027: UNIQUE constraint failed: play_queue_items.id

Error: near line 395028: UNIQUE constraint failed: play_queue_items.id

Error: near line 395029: UNIQUE constraint failed: play_queue_items.id

Error: near line 395030: UNIQUE constraint failed: play_queue_items.id

Error: near line 395058: UNIQUE constraint failed: play_queue_items.id

Error: near line 399652: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399653: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399654: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399655: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399656: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399657: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399658: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399659: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399660: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399661: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399662: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399668: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399669: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399670: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399671: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399672: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399673: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399674: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399675: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399676: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399677: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399678: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399679: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399680: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399681: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399682: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399683: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399684: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399685: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399686: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399687: UNIQUE constraint failed: statistics_bandwidth.id

Error: near line 399688: UNIQUE constraint failed: statistics_bandwidth.id

[Doppelherz]

after I’ve followed the repair document and proofed sqlite3 com.plexapp.plugins.library.db “PRAGMA integrity_check” again, it says:
ok

After that, I tried Plex on Apple TV again and it works!!! Thank You!!!