Held transaction for too long (../Statistics/StatisticsManager.cpp:253)

Plex Media Server Desktops & Laptops
73

Forgive me, while I found these instructions helpful, they were a bit vague. Here’s a step-by-step for how I went through this process on my FreeNAS server:

Navigate to the appropriate directory –
cd /usr/local/plexdata/Plex\ Media\ Server/Plug-in\ Support/Databases/

Stop the Plex Media Service –
service plexmediaserver stop

Make a backup of the Plex database file –
cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.bak

List the database tables –
sqlite3 com.plexapp.plugins.library.db .tables

Nuke the data within the appropriate tables –

sqlite3 com.plexapp.plugins.library.db "DELETE FROM statistics_bandwidth"
sqlite3 com.plexapp.plugins.library.db "DELETE FROM statistics_media"
sqlite3 com.plexapp.plugins.library.db "DELETE FROM statistics_resources"

Start the Plex Media Service once again –
service plexmediaserver start

And just for good measure, you should probably go into Settings > Troubleshooting > and click “OPTIMIZE DATABASE.”

3 Likes