# Corrupt database HELP!

**URL:** <https://forums.plex.tv/t/corrupt-database-help/844868>\
**Category:** Plex Media Server\
**Tags:** server-mac\
**Created:** [June 19, 2023, 2:02pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868 "2023-06-19T14:02:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbirke](https://avatars.discourse-cdn.com/v4/letter/p/34f0e0/32.png) [@pbirke](https://forums.plex.tv/u/pbirke)\
**Post date:** [June 19, 2023, 2:02pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/1 "2023-06-19T14:02:49Z")

</div>

Plex stopped recognizing new files, so I rebooted and now it will not start at all. Tried reinstalling and that did not help. I see this in the log:

Jun 19, 2023 08:57:34.336 [0x70000bb98000] DEBUG - ChangestampAllocator: initialized to 46298079  
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - SQLITE3:(nil), 11, database corruption at line 69165 of [a29f994989]  
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - SQLITE3:(nil), 11, statement aborts at 21: [update activities set finished\_at=started\_at where finished\_at is null] database disk image is malformed  
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - Database corruption: sqlite3\_statement\_backend::loadOne: database disk image is malformed  
Jun 19, 2023 08:57:34.348 [0x70000bb98000] ERROR - Error: Unable to set up server: sqlite3\_statement\_backend::loadOne: database disk image is malformed (N4soci10soci\_errorE)

How do I fix this? Can I remove that corrupted entry? Is there a backup of the database? Any help would be great appreciated. Freaking out over here. Thank you

Server Version#: PMS 1.32.4 on Mac OS 12.6.6

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [June 19, 2023, 2:08pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/2 "2023-06-19T14:08:19Z")

</div>

[https://support.plex.tv/articles/repair-a-corrupted-database/](https://support.plex.tv/articles/repair-a-corrupted-database/)

as well as [GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases](https://github.com/ChuckPa/PlexDBRepair)

---

<div class="post-metadata">

**Author:** ![pbirke](https://avatars.discourse-cdn.com/v4/letter/p/34f0e0/32.png) [@pbirke](https://forums.plex.tv/u/pbirke)\
**Post date:** [June 19, 2023, 2:13pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/3 "2023-06-19T14:13:40Z")

</div>

Thank you!

It is better to try to repair it or replace with a recent backup?

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [June 19, 2023, 2:15pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/4 "2023-06-19T14:15:25Z")

</div>

It is possible that the issue was already present in older versions of the database.  
So even if you can successfully restore an older backup of the database, I recommend to use the repair script from the second link anyway.

---

<div class="post-metadata">

**Author:** ![pbirke](https://avatars.discourse-cdn.com/v4/letter/p/34f0e0/32.png) [@pbirke](https://forums.plex.tv/u/pbirke)\
**Post date:** [June 19, 2023, 2:16pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/5 "2023-06-19T14:16:03Z")

</div>

Noted, thank you!

---

<div class="post-metadata">

**Author:** ![pbirke](https://avatars.discourse-cdn.com/v4/letter/p/34f0e0/32.png) [@pbirke](https://forums.plex.tv/u/pbirke)\
**Post date:** [June 19, 2023, 3:14pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/6 "2023-06-19T15:14:18Z")

</div>

PlexDBRepair-1.0.8 utility worked perfectly!!! Thank you so much for the info and quick response

---

<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:** [September 17, 2023, 3:15pm UTC](https://forums.plex.tv/t/corrupt-database-help/844868/7 "2023-09-17T15:15:02Z")

</div>

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