# Plex broken after snap update **URL:** \ **Category:** Plex Media Server\ **Tags:** server-linux, roku, server-snap\ **Created:** [October 27, 2021, 5:58pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500 "2021-10-27T17:58:53Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![rrivais](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rrivais](https://forums.plex.tv/u/rrivais)\ **Post date:** [October 27, 2021, 5:58pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/1 "2021-10-27T17:58:53Z")
Server Version#: 1.24.5.5173 Player Version#: all **an updated version of plexmediaserver was pushed to my machine today** server:/media/user$ snap changes ID Status Spawn Ready Summary 16 Done today at 09:13 EDT today at 09:14 EDT Auto-refresh snap “plexmediaserver” **in the logs on the server i can see various errors during the update** Oct 27, 2021 09:14:21.013 [0x7ff68c88f6e8] ERROR - SQLITE3:0x80000001, 11, database corruption at line 67183 of [1b256d97b5] Oct 27, 2021 09:14:21.013 [0x7ff68c88f6e8] ERROR - SQLITE3:0x80000001, 11, statement aborts at 11: [SELECT idx, start\_block, leaves\_end\_block, end\_block, root FROM ‘main’.‘fts4\_tag\_titles\_icu\_segdir’ WHERE level = ? ORDER BY idx ASC] database disk image is malformed Oct 27, 2021 09:14:21.020 [0x7ff68c88f6e8] ERROR - SQLITE3:0x80000001, 11, statement aborts at 10: [delete from fts4\_tag\_titles\_icu] database disk image is malformed Oct 27, 2021 09:14:21.045 [0x7ff68c88f6e8] ERROR - Exception inside transaction (inside=1) (../Library/FullTextSearch.cpp:81): sqlite3\_statement\_backend::loadOne: database disk image is malformed Oct 27, 2021 09:14:21.057 [0x7ff68c88f6e8] ERROR - Exception inside transaction (inside=1) (../Library/DatabaseMigrations.cpp:237): sqlite3\_statement\_backend::loadOne: database disk image is malformed Oct 27, 2021 09:14:21.063 [0x7ff68c88f6e8] ERROR - Exception thrown during migrations, aborting: sqlite3\_statement\_backend::loadOne: database disk image is malformed \*\*after this, i cannot play any content from my server. i have tried through android app, roku and directly from the browser on the local machine. \*\* \*\*i can play the files locally via VLC without issue \*\* \*\*tried restarting snap as well as rebooting and remounting the drives. \*\* **still no playback possible** \*\*playback errors: \*\* **on ROKU: Playback Error: please check that this file exists and the necessary drive is mounted** **Browser: Playback Error: An error occurred loading items to play.** **In the [server logs](https://support.plex.tv/articles/200250417-plex-media-server-log-files/) i see three types of errors that i do not see prior to the refresh:** Oct 27, 2021 11:45:28.849 [0x7ff685e3fb38] ERROR - Metadata /system/agents/media/get request failed with code: 500: [http://127.0.0.1:35251/system/agents/media/get?guid=com.plexapp.agents.thetvdb%3A%2F%2F72231%2F19%2F15%3Flang%3Den&mediaType=4&url=metadata%3A%2F%2Fseasons%2F19%2Fepisodes%2F15%2Fthumbs%2Fcom.plexapp.agents.thetvdb\_46febaac5f305e59960613526d780feff4512c22](http://127.0.0.1:35251/system/agents/media/get?guid=com%2Eplexapp%2Eagents%2Ethetvdb%3A%2F%2F72231%2F19%2F15%3Flang%3Den&mediaType=4&url=metadata%3A%2F%2Fseasons%2F19%2Fepisodes%2F15%2Fthumbs%2Fcom%2Eplexapp%2Eagents%2Ethetvdb_46febaac5f305e59960613526d780feff4512c22) Oct 27, 2021 11:45:31.546 [0x7ff686f99b38] ERROR - SQLITE3:0x80000001, 1, no such table: metadata\_item\_setting\_markers in "select metadata\_item\_setting\_markers.id as ‘metadata\_item\_setting\_markers\_id’, metadata\_item\_setting\_markers.marker\_type as 'metadata\_item\_setting\_markers\_marke Oct 27, 2021 11:45:31.547 [0x7ff686f99b38] ERROR - Soci Exception handled: sqlite3\_statement\_backend::prepare: no such table: metadata\_item\_setting\_markers for SQL: select metadata\_item\_setting\_markers.id as ‘metadata\_item\_setting\_markers\_id’, metadata\_item\_setting\_markers.marker\_type as ‘metadata\_item\_setting\_markers\_marker\_type’, metadata\_item\_setting\_markers.metadata\_item\_setting\_id as ‘metadata\_item\_setting\_markers\_metadata\_item\_setting\_id’, metadata\_item\_setting\_markers.start\_time\_offset as ‘metadata\_item\_setting\_markers\_start\_time\_offset’, metadata\_item\_setting\_markers.end\_time\_offset as ‘metadata\_item\_setting\_markers\_end\_time\_offset’, metadata\_item\_setting\_markers.title as ‘metadata\_item\_setting\_markers\_title’, metadata\_item\_setting\_markers.created\_at as ‘metadata\_item\_setting\_markers\_created\_at’, metadata\_item\_setting\_markers.updated\_at as ‘metadata\_item\_setting\_markers\_updated\_at’, metadata\_item\_setting\_markers.extra\_data as ‘metadata\_item\_setting\_markers\_extra\_data’ from metadata\_item\_setting\_markers join metadata\_item\_settings on metadata\_item\_settings.id = metadata\_item\_setting\_markers.metadata\_item\_setting\_id where metadata\_item\_settings.guid = ? and metadata\_item\_settings.account\_id = ? order by metadata\_item\_setting\_markers.start\_time\_offset, metadata\_item\_setting\_markers.end\_time\_offset ---
**Author:** ![plexseanshonagh](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@plexseanshonagh](https://forums.plex.tv/u/plexseanshonagh)\ **Post date:** [October 27, 2021, 6:01pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/2 "2021-10-27T18:01:51Z")
**Having the same issue, three hours now** TimeOct 27, 2021 18:58:29.821 LevelError Thread0x146a17234b38 MessageSQLITE3:0x80000001, 1, no such table: metadata\_item\_setting\_markers in "select metadata\_item\_setting\_markers.id as ‘metadata\_item\_setting\_markers\_id’, metadata\_item\_setting\_markers.marker\_type as 'metadata\_item\_setting\_markers\_marke Nothing plays. ---
**Author:** ![plexseanshonagh](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@plexseanshonagh](https://forums.plex.tv/u/plexseanshonagh)\ **Post date:** [October 27, 2021, 6:03pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/3 "2021-10-27T18:03:06Z")
Oct 27, 2021 19:02:12.446 [0x146a169beb38] Error — SQLITE3:0x80000001, 1, no such table: metadata\_item\_setting\_markers in "select metadata\_item\_setting\_markers.id as ‘metadata\_item\_setting\_markers\_id’, metadata\_item\_setting\_markers.marker\_type as 'metadata\_item\_setting\_markers\_marke Oct 27, 2021 19:02:12.446 [0x146a169beb38] Error — Soci Exception handled: sqlite3\_statement\_backend::prepare: no such table: metadata\_item\_setting\_markers for SQL: select metadata\_item\_setting\_markers.id as ‘metadata\_item\_setting\_markers\_id’, metadata\_item\_setting\_markers.marker\_type as ‘metadata\_item\_setting\_markers\_marker\_type’, metadata\_item\_setting\_markers.metadata\_item\_setting\_id as ‘metadata\_item\_setting\_markers\_metadata\_item\_setting\_id’, metadata\_item\_setting\_markers.start\_time\_offset as ‘metadata\_item\_setting\_markers\_start\_time\_offset’, metadata\_item\_setting\_markers.end\_time\_offset as ‘metadata\_item\_setting\_markers\_end\_time\_offset’, metadata\_item\_setting\_markers.title as ‘metadata\_item\_setting\_markers\_title’, metadata\_item\_setting\_markers.created\_at as ‘metadata\_item\_setting\_markers\_created\_at’, metadata\_item\_setting\_markers.updated\_at as ‘metadata\_item\_setting\_markers\_updated\_at’, metadata\_item\_setting\_markers.extra\_data as ‘metadata\_item\_setting\_markers\_extra\_data’ from metadata\_item\_setting\_markers join metadata\_item\_settings on metadata\_item\_settings.id = metadata\_item\_setting\_markers.metadata\_item\_setting\_id where metadata\_item\_settings.guid = ? and metadata\_item\_settings.account\_id = ? order by metadata\_item\_setting\_markers.start\_time\_offset, metadata\_item\_setting\_markers.end\_time\_offset Oct 27, 2021 19:02:12.447 [0x146a1819db38] Debug — Completed: [10.0.0.10:49466] 500 POST /playQueues? ---
**Author:** ![rrivais](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rrivais](https://forums.plex.tv/u/rrivais)\ **Post date:** [October 27, 2021, 10:57pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/4 "2021-10-27T22:57:35Z")
Update, I rolled back the snap package to the previous version and seems to have resolved the issue now. in terminal type sudo snap revert plexmediaserver Should get a message like this plexmediaserver reverted to 1.24.2.5022-8489a6711 can also confirm with command: snap changes ID Status Spawn Ready Summary 16 Done today at 09:13 EDT today at 09:14 EDT Auto-refresh snap “plexmediaserver” 20 Done today at 18:51 EDT today at 18:51 EDT Revert “plexmediaserver” snap 21 Done today at 18:51 EDT today at 18:51 EDT Running service command ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [October 27, 2021, 11:04pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/5 "2021-10-27T23:04:00Z")
If you had some actual database corruption, it’s very unlikely this will be fixed by rolling back to another version. To avoid greater damage you might want to check your database and if needed attempt to repair it. > **[Repair a Corrupted Database | Plex Support](https://support.plex.tv/articles/repair-a-corrupted-database/)** > > Note: This article is for Plex Media Server version 1.23.2 and newer. If using an earlier version, see . Though... ---
**Author:** ![plexseanshonagh](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@plexseanshonagh](https://forums.plex.tv/u/plexseanshonagh)\ **Post date:** [October 28, 2021, 2:20pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/6 "2021-10-28T14:20:57Z")
@Plex Ninja how do you repair it in a docker container ![docker](https://global.discourse-cdn.com/plex/original/4X/f/f/f/fff6862035abdaf8c337b23f16c697a341bfebb2.jpeg) Don’t see it in the help . ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [October 28, 2021, 3:31pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/7 "2021-10-28T15:31:25Z")
Never tried that myself. From what I’ve been reading you cannot fix it from within the container (due to the container restrictions). You’ll need to create a dummy PMS install on another system. Run that install’s `Plex SQLite` executable with the docker container’s DB path. Make sure both Plex Media Servers are stopped when to work on the database!! ---
**Author:** ![plexseanshonagh](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@plexseanshonagh](https://forums.plex.tv/u/plexseanshonagh)\ **Post date:** [October 28, 2021, 4:32pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/8 "2021-10-28T16:32:46Z")
@ Plex Ninja to late I followed [How do I repair my database when running PMS in a Docker container on an Unraid server](https://www.reddit.com/r/PleX/comments/p5fk1b/how_do_i_repair_my_database_when_running_pms_in_a/) Completely messed it up, had to remove the container and then I installed the Plex Server on windows pc. It running away re-adding the media, bummer is I have to now mark those films I watched as played. will take a while lol -🙂 ---
**Author:** ![rrivais](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rrivais](https://forums.plex.tv/u/rrivais)\ **Post date:** [December 1, 2021, 4:27pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/9 "2021-12-01T16:27:38Z")
autmatic snap update happened again last night and again broke plex. same errors noted in the logs as last time. Snap ver. 1.25.0.5282 i guess this means I’ll never be able to update plex since it fails every time…? how do i fix this? ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [December 2, 2021, 4:17am UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/10 "2021-12-02T04:17:10Z")
May I ask a , perhaps foolish, question? Why use SNAP when the native package is so much more capable and also has automatic updating via the repository available ? ---
**Author:** ![rrivais](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rrivais](https://forums.plex.tv/u/rrivais)\ **Post date:** [December 2, 2021, 4:26pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/12 "2021-12-02T16:26:35Z")
it did appear to be the most popular way to install it, figured it was safe especially considering I’m running it on an Ubuntu distribution and Canonical are the ones that developed snaps but I’m definitely regretting that decision now. ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [December 2, 2021, 4:40pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/13 "2021-12-02T16:40:19Z")
Ubuntu only supports SNAP packages from their App Store. It’s not popular but is what they’re pushing. It is possible to pull all your Plex metadata out of the SNAP package so you can get away from it. ---
**Author:** ![rrivais](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rrivais](https://forums.plex.tv/u/rrivais)\ **Post date:** [December 2, 2021, 7:17pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/14 "2021-12-02T19:17:01Z")
agreed, i had to rebuild my server recently where i was running the native app before and decided to try the snap install so was able to successfully import the database from the previous install to this one. So i’m sure i can figure out how to do the reverse but, question is, will i still have this db corruption issue and therefore have the same problem? and i guess, perhaps the even larger question is, should plex put out some official statement about not supporting snap installs? There’s like 0 documentation available … ---
**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\ **Post date:** [December 2, 2021, 7:46pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/15 "2021-12-02T19:46:34Z")
Plex does support SNAPs else there wouldn’t be a package. There are users who are quite happy with SNAPs because their streaming needs don’t require full access to the hardware which transcoding and tonemapping mandates ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [March 2, 2022, 7:47pm UTC](https://forums.plex.tv/t/plex-broken-after-snap-update/753500/16 "2022-03-02T19:47:17Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.