Database corruption repair failed

Plex Media Server Desktops & Laptops
1

Server Version#: 1.16.2.1321

Hi folks,
Running Plex on Unraid Docker, this morning the Plex dashboard wouldn’t load, so I checked the logs:

Jul 22, 2019 07:23:37.656 [0x147fecf66700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
Jul 22, 2019 07:23:37.656 [0x147fecf66700] ERROR - SQLITE3:(nil), 11, statement aborts at 9: [select statistics_bandwidth.id as 'statistics_bandwidth_id', statistics_bandwidth.account_id as 'statistics_bandwidth_account_id', statistics_bandwidth.device_id as 'statistics_bandwidt

I’ve run through the repair instructions but when running the last step, dumping the repaired dump.sql back to db, it shows an error.

root@Tower:/mnt/user/appdata/binhex-plex/Plex Media Server/Plug-in Support/Databases# sqlite3 com.plexapp.plugins.library.db < dump.sql
Error: near line 70678: UNIQUE constraint failed: statistics_bandwidth.id
Error: near line 70680: UNIQUE constraint failed: statistics_bandwidth.id

and the resulting db file is 0kb.

Any ideas on how to get this working again?

Repairing a Corrupt Database - "Error: no such index: index_title_sort_naturalsort" & "Error: near line" ... ": UNIQUE constraint failed: statistics_bandwidth.id"
2

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