Server Version#: 1.23.6.4881
Player Version#: N/A
ul 29 12:24:16 cloyster Plex message repeated 22 times: [ Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.]
Jul 29 12:25:07 cloyster Plex Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.
Jul 29 12:25:07 cloyster Plex message repeated 22 times: [ Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.]
Jul 29 12:25:51 cloyster Plex Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.
Jul 29 12:25:51 cloyster Plex message repeated 22 times: [ Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.]
Jul 29 12:26:18 cloyster Plex Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.
Jul 29 12:26:18 cloyster Plex message repeated 22 times: [ Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry busy DB.]
Jul 29 12:27:29 cloyster Plex Media Server[3059133]: Sqlite3: Sleeping for 200ms to retry
Slowly, over a long period of time I saw more and more of the above in the syslog until Plex would get sqlite3 “DB Locked” errors and collapse like a cheap card table.
It took me a while but the following fixed it:
service plexmediaserver stop
cd “/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases”
You must use Plex’s version of sqlite3!
/usr/lib/plexmediaserver/Plex\ SQLite com.plexapp.plugins.library.db .dump > dbdump.sql
mv com.plexapp.plugins.library.db com.plexapp.plugins.library.previous.db
/usr/lib/plexmediaserver/Plex\ SQLite com.plexapp.plugins.library.db < dbdump.sql
chown plex.plex com.plexapp.plugins.library.db
service plexmediaserver start
