Server Version#: 1.27.2.5929
Player Version#: Web 4.84.1
Tuner Make/Model: Xteve 2.4.0
Guide/Lineup name: Multiple
Using XMLTV?: No
Channel number/Name: All
Somehow my Plex EPG database keeps getting corrupted. Two days ago I had the same issue, figured it was a one-off so I deleted the Tuner and spent time re-mapping all the channels. It was working fine for less than 48 hours, until sometime early this morning, and its back to broken again. The “Guide” page never populates and the “Browse” page shows the message Something went wrong An unexpected error occurred.
In the logs, I see these entries when I try to access the guide:
[Req#3edf4] SQLITE3:0xd286f7c8, 11, database corruption at line 81887 of [1b256d97b5]
[Req#3edf4] SQLITE3:0xd286f7c8, 11, statement aborts at 18: [select distinct grandparents.id as metadata_items_grandparents_id,grandparents.title as metadata_items_grandparents_title,grandparents.user_thumb_url as metadata_items_grandparents_use
Got exception from request handler: sqlite3_statement_backend::loadRS: database disk image is malformed
I’ve attempted guide refresh, server reboot, database optimization, nothing works other than fully deleting and re-adding the Tuner which is very time consuming. I’m considering downgrading to an older server version, but I’m not sure how far back to go. Does anyone else have this problem? Is there any solution?
When doing a guide update, the log messages are:
[Req#3efaf/Database analyze/com.plexapp.plugins.library.db] SQLITE3:0xd286f7c8, 11, database corruption at line 67183 of [1b256d97b5]
[Req#3efaf/Database analyze/com.plexapp.plugins.library.db] SQLITE3:0xd286f7c8, 11, statement aborts at 97: [analyze] database disk image is malformed
Thread: Uncaught exception running async task which was spawned by thread 21928: sqlite3_statement_backend::loadOne: database disk image is malformed
[Req#3efaf] SQLITE3:0xd286f7c8, 11, database corruption at line 81887 of [1b256d97b5]
[Req#3efaf] SQLITE3:0xd286f7c8, 11, statement aborts at 14: [SELECT level, idx, end_block FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level BETWEEN ? AND ? ORDER BY level DESC, idx ASC] database disk image is malformed
[Req#3efaf] Failed to commit transaction (E:\jenkins\server\3582333205\Library\MetadataItem.cpp:1118) (tries=1): Cannot commit transaction. database disk image is malformed
[Req#3efaf] SQLITE3:0xd286f7c8, 1, statement aborts at 1: [COMMIT] cannot commit - no transaction is active
Live TV is one of the main reasons I purchased Plex Pass and its frustrating seeing how little attention it gets.
