Asustor NAS sql setup fail

[shawnleelz87_gmail_com]

Server Version#: v1.23.6.4881-e2e58f321
Player Version#:

Hi,

I just setup my new Asustor NAS system with Plex, however I am unable to launch plex (with port 32400) as there is something wrong with the sql database (base on findings from log). Anyone can provide any help? Thanks!

Logs:
Aug 09, 2021 16:53:21.319 [0xb4296d48] INFO - /usr/local/AppCentral/plexmediaserver/Plex Media Server
Aug 09, 2021 16:53:21.321 [0xb6d48e80] DEBUG - BPQ: [Idle] → [Starting]
Aug 09, 2021 16:53:21.328 [0xb6d48e80] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.35.5, threadsafe=1
Aug 09, 2021 16:53:21.328 [0xb6d48e80] DEBUG - Installing Library Database from ["/volume1/.@plugins/AppCentral/plexmediaserver/Resources/com.plexapp.plugins.library.db"] to ["/volume1/Plex/Library/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"]
Aug 09, 2021 16:53:21.328 [0xb6d48e80] ERROR - Couldn’t copy file “/volume1/.@plugins/AppCentral/plexmediaserver/Resources/com.plexapp.plugins.library.db” to “/volume1/Plex/Library/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db”: Invalid argument
Aug 09, 2021 16:53:21.966 [0xb6d48e80] DEBUG - Running migrations. (EPG 0)
Aug 09, 2021 16:53:21.966 [0xb6d48e80] ERROR - SQLITE3:(nil), 1, no such table: schema_migrations in “select version from schema_migrations order by version”
Aug 09, 2021 16:53:21.967 [0xb6d48e80] ERROR - Database corruption: sqlite3_statement_backend::prepare: no such table: schema_migrations for SQL: select version from schema_migrations order by version
Aug 09, 2021 16:53:21.967 [0xb6d48e80] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: schema_migrations for SQL: select version from schema_migrations order by version (N4soci10soci_errorE)

[shawnleelz87_gmail_com]

Hi,

I have tried the instructions on database recovery with no success, the database creation still fails. I tried putty in and ran sqlite to create a dump and attempt to repair the sql, but the recovery from the dump file always output to an empty “com.plex.app.plugins.library.db” with 0kb.

I did an initial PRAMA integrity check and it returns with “OK” but recovery turns out to be unsuccessful (0kb file size). I wondered if the com.plex.app.plugins.library.db file was not packed properly from the apk installer. Can any plex staff from tech support help on this?