# Database Corruption

**URL:** <https://forums.plex.tv/t/database-corruption/828750>\
**Category:** Plex Media Server\
**Tags:** server-docker, server-unraid\
**Created:** [January 29, 2023, 3:23pm UTC](https://forums.plex.tv/t/database-corruption/828750 "2023-01-29T15:23:51Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![078emil](https://avatars.discourse-cdn.com/v4/letter/0/ecb155/32.png) [@078emil](https://forums.plex.tv/u/078emil)\
**Post date:** [January 29, 2023, 3:23pm UTC](https://forums.plex.tv/t/database-corruption/828750/1 "2023-01-29T15:23:51Z")

</div>

I might have the same problem. I cannot play movies from any client (web, Android phone, Android TV). All movie posters are gone except for a few probably locally cached on the respective devices. When I try to play/go to a movie I get that something went wrong or that the server is not accessible. A quick look in the log file gives many `Got exception from request handler: std::bad_cast` errors. I am running PMS 1.30.2.6563 on Unraid 6.11.0.

[Plex Media Server Logs\_2023-01-29\_16-11-46.zip](https://forums.plex.tv/uploads/short-url/m5fxG9nPh1p1u23qsGh1HH7e1i9.zip) (4.6 MB)

---

<div class="post-metadata">

**Author:** ![FordGuy61](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@FordGuy61](https://forums.plex.tv/u/FordGuy61)\
**Post date:** [January 29, 2023, 3:58pm UTC](https://forums.plex.tv/t/database-corruption/828750/2 "2023-01-29T15:58:52Z")

</div>

Moved your post to the unraid & docker areas.

You’ve database corruption.

Use the [PlexDBRepair](https://github.com/ChuckPa/PlexDBRepair) utility to correct it.

You can restore from a backup, if available, or repair the current database.

See Scenario A & B in the readme file.

```auto
Jan 29, 2023 16:10:07.631 [0x148bad80faa0] ERROR - SQLITE3:0x80000001, 11, database corruption at line 88814 of [1b256d97b5]
Jan 29, 2023 16:10:07.631 [0x148bad80faa0] ERROR - SQLITE3:0x80000001, 11, statement aborts at 24: [update taggings set created_at = iif(typeof(created_at) in ('integer', 'real'), created_at, strftime('%s', created_at, 'utc'))] database disk image is malformed
Jan 29, 2023 16:10:07.632 [0x148bad80faa0] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3524661465/Library/DatabaseMigrations.cpp:289): sqlite3_statement_backend::loadOne: database disk image is malformed
Jan 29, 2023 16:10:07.633 [0x148bad80faa0] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed

```

---

<div class="post-metadata">

**Author:** ![078emil](https://avatars.discourse-cdn.com/v4/letter/0/ecb155/32.png) [@078emil](https://forums.plex.tv/u/078emil)\
**Post date:** [January 30, 2023, 9:37pm UTC](https://forums.plex.tv/t/database-corruption/828750/3 "2023-01-30T21:37:50Z")

</div>

Thank you for your help. It was indeed a corrupted database, and the repair function fixed it for me.

---

<div class="post-metadata">

**Author:** ![mvondracek](https://avatars.discourse-cdn.com/v4/letter/m/e495f1/32.png) [@mvondracek](https://forums.plex.tv/u/mvondracek)\
**Post date:** [January 30, 2023, 10:50pm UTC](https://forums.plex.tv/t/database-corruption/828750/4 "2023-01-30T22:50:22Z")

</div>

I can play from every platform except Plex.

---

<div class="post-metadata">

**Author:** ![mvondracek](https://avatars.discourse-cdn.com/v4/letter/m/e495f1/32.png) [@mvondracek](https://forums.plex.tv/u/mvondracek)\
**Post date:** [January 30, 2023, 10:55pm UTC](https://forums.plex.tv/t/database-corruption/828750/5 "2023-01-30T22:55:42Z")

</div>

I am looking at all of the solutions available and apparently I am screwed. I am not a programmer or coder.

---

<div class="post-metadata">

**Author:** ![FordGuy61](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@FordGuy61](https://forums.plex.tv/u/FordGuy61)\
**Post date:** [January 30, 2023, 11:18pm UTC](https://forums.plex.tv/t/database-corruption/828750/6 "2023-01-30T23:18:57Z")

</div>

@mvondracek

Suggest you continue the conversation in your original thread:

> [@Server won't play videos after last update](https://forums.plex.tv/t/server-wont-play-videos-after-last-update/828656):
>
> Server Version#: 1.30.2.6563 Player Version#: After the last update, my video files will not play off my server, regardless if I am on the desktop itself, PS4, my LG smart tv, or Roku. The files play flawlessly when using them locally with any other player and stream fine using means outside of Plex. If I could get an older version of Plex or if Plex could actually provide customer service (it would be nice since I paid them money for a lifetime subscription pass) and fix the issue, that wou…

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [April 30, 2023, 11:19pm UTC](https://forums.plex.tv/t/database-corruption/828750/7 "2023-04-30T23:19:06Z")

</div>

Closed on April 30, 2023, 11:19pm UTC

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