This is normal? Connection closing and opening

Server Version#: 1.16.5.1488Plex Media Server Logs_2019-08-15_21-52-35.zip (2.5 MB)
Player Version#:

Something is not right here with your networking:

  1. PMS can’t get valid replies from itself
Aug 15, 2019 10:57:24.910 [0x7fe9f75e4700] ERROR - Error parsing HTTP request: ET /server-status?auto HTTP/1.1
Host: localhost
X-Real-IP: 127.0.0.1
X-Forwarded-For: 127.0.0.1
X-Forwarded-Proto: http
Connection: Upgrade
Accept-Encoding: identity

  1. The reason for this is the Database has been corrupted.
Aug 15, 2019 10:37:08.476 [0x7f1e9cff9700] DEBUG - Collections: Synced tags in section 3 in 2ms.
Aug 15, 2019 10:37:08.478 [0x7f1e9cff9700] ERROR - SQLITE3:(nil), 11, database corruption at line 68841 of [bf8c1b2b7a]
Aug 15, 2019 10:37:08.478 [0x7f1e9cff9700] ERROR - SQLITE3:(nil), 11, statement aborts at 23: [REPLACE INTO 'main'.'fts4_metadata_titles_segdir' VALUES(?,?,?,?,?,?)] database disk image is malformed
Aug 15, 2019 10:37:08.478 [0x7f1e9cff9700] ERROR - SQLITE3:(nil), 11, statement aborts at 171: [update metadata_items set extra_data=? where metadata_type=? and library_section_id=? and `index`=?] database disk image is malformed
Aug 15, 2019 10:37:08.511 [0x7f1e9cff9700] ERROR - Exception inside transaction (inside=1) (../Library/MetadataCollection.cpp:236): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 15, 2019 10:37:08.519 [0x7f1eaf7fe700] DEBUG - HTTP 200 response from GET https://plex.tv/media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx
Aug 15, 2019 10:37:08.526 [0x7f1e9cff9700] ERROR - Fixup 29DatabaseFixupsSyncCollections threw an exception: sqlite3_statement_backend::loadOne: database disk image is malformed

In the future, Please leave VERBOSE logging turned off unless requested. It wastes a huge amoung of log space (we only have 26 MB) and makes initial diagnosis difficult in the 2 minutes of elapsed time we end up getting.

At this point, the simplest is to stop Plex and switch to the backup database (presuming it has one). If you don’t, just delete the Library directory and all below it (with plex stopped) and start again.

Here is the full procedure for your reference so you can decide what’s best for you.

https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

Would restoring a db of 2019-03-08 solve? Are disconnect errors due to this?

Would you know which library is in trouble?

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