Terramaster F4-220
TOS 4.1.24
Plex 1.19.2.2737
I’m having two issues.
I can’t delete old libraries.
Whenever I try to add a new library, I get a “No Items In Library” message. When adding the library, I can navigate to the folder. I can see the files within the folder. After I add the folder, I scan the library.
I’ve tried multiple things, multiple times and no luck.
Can anyone help?
Thanks,
You’ve database corruption.
From Plex Media Server.log:
Jul 06, 2020 22:40:32.412 [0x7fa625a7f700] ERROR - SQLITE3:(nil), 11, database corruption at line 64757 of [bf8c1b2b7a]
Jul 06, 2020 22:40:32.412 [0x7fa625a7f700] ERROR - SQLITE3:(nil), 11, database corruption at line 64798 of [bf8c1b2b7a]
Jul 06, 2020 22:40:32.412 [0x7fa625a7f700] ERROR - SQLITE3:(nil), 11, statement aborts at 24: [insert into statistics_bandwidth (account_id,device_id,timespan,at,lan,bytes) values (:statistics_bandwidth_account_id,:statistics_bandwidth_device_id,:statistics_bandwidth_timespan,:s
Jul 06, 2020 22:40:32.413 [0x7fa625a7f700] ERROR - Exception inside transaction (inside=1) (../Statistics/StatisticsBandwidth.cpp:50): sqlite3_statement_backend::loadOne: database disk image is malformed
Jul 06, 2020 22:40:32.413 [0x7fa625a7f700] ERROR - Exception inside transaction (inside=1) (../Statistics/StatisticsManager.cpp:245): sqlite3_statement_backend::loadOne: database disk image is malformed
Options:
Restoring from backup is probably the easiest, as long as the backup itself is not corrupt.
If you delete the database you will have to re-create all your libraries. Your media is not affected (you won’t lose your movies, etc).
See Repair A Corrupt Database for additional information.
Thank you. This fixed my problem. I tried to use older databases to fix the issue but they just wouldn’t work. I went back to the oldest database and renamed that one. Deleted all the rest. Plex is finally done scanning the files.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
