Is there something missing here when coming from Linux → macOS? There is nothing mentioned in needing to replace the .plist file in this documentation when coming from Linux. Any other details would be amazing. I tried to convert the plist to xml & replace machineID/etc and the reconvert to binary but that did not solve the problem at all.
Here is the error I’m getting – maybe I need to fully .tar the DB up instead of using rsync?
Mar 20, 2023 12:40:51.843 [0x16fef7000] DEBUG - HttpServer: Set up a thread pool with 2 threads.
Mar 20, 2023 12:40:51.843 [0x16fc3b000] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.35.5, threadsafe=1
Mar 20, 2023 12:40:51.844 [0x16fc3b000] ERROR - SQLITE3:0x1400286a8, 11, database corruption at line 68176 of [1b256d97b5]
Mar 20, 2023 12:40:51.844 [0x16fc3b000] ERROR - SQLITE3:0x1400286a8, 11, database disk image is malformed in "PRAGMA cache_size=2048"
Mar 20, 2023 12:40:51.844 [0x16fc3b000] ERROR - Database corruption: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2048
If copying the database files, make sure to actually stop the server on the source and target systems.
In your case it appears the database has been corrupted. If this is indeed due to copying the database table while your server was still active, you could try to re-do the migration. Otherwise you might attempt to repair the database.
Yep – that was the case. Totally makes sense that we would need to do that. It is mentioned, but not in bold so didn’t click with me the first time. Moved the DB again after stopping services and that fixed it.
