Emby stops working after upgrade to 4.8.7

[alibali 1]

Hi there, I upgraded a running version 4.7.4 (or 4.7.1, don't remember exactly) to recent version 4.8.7.0 on DSM 6.2.4.

After installation it went in running mode for some seconds. But then it stopped. I tried that some times, all the same.

Then  I uninstalled the package and reinstalled again. But unfortunately with no success.

What's going wrong here?

DSM is DS1517+

Prozessor

INTEL Atom C2538

[Neminem 1518]

 

[alibali 1]

Sorry, but I can't tell you any more. There hasn't been any error message.

I attach the emby log. May be this will be useful.

embyserver-63852076665.txt

[Luke 42077]

OK thanks for following up.

[alibali 1]

Sorry, uploaded wrong log. Here are the logs created during installation (?) / running of new version

embyserver-63852077000.txt embyserver-63852079135.txt embyserver-63852079322.txt embyserver-63852079352.txt embyserver-63852079452.txt embyserver-63852079516.txt embyserver-63852079686.txt

[Luke 42077]

Hi, please see this to get squared away:

Corrupt Database

[alibali 1]

Hi, I deleted the 2 files in \data and restarted Emby. It has been running for a 20...30 seconds. When I tried to open the server it went back to stop state.

In the log it still says:

................................

2024-05-24 08:13:16.962 Error Main: Error in appHost.Init
    *** Error Report ***
    Version: 4.8.7.0
    Command line: /volume3/@appstore/EmbyServer/system/EmbyServer.dll -programdata /volume2/Emby -ffdetect /var/packages/EmbyServer/target/bin/ffdetect -ffmpeg /var/packages/EmbyServer/target/bin/ffmpeg -ffprobe /var/packages/EmbyServer/target/bin/ffprobe -nolocalportconfig -ignore_vaapi_enabled_flag -pidfile /volume2/Emby/EmbyServer.pid -defaultdirectory /volume1/Public -updatepackage emby-server-synology_{version}_x86_64.spk
    Operating system: Linux version 3.10.105 (root@build7) (gcc version 4.9.3 20150311 (prerelease) (crosstool-NG 1.20.0) ) #25556 SMP Tue Mar 21 22:24:38 CST 2023
    Framework: .NET 6.0.25
    OS/Process: x64/x64
    Runtime: volume3/@appstore/EmbyServer/system/System.Private.CoreLib.dll
    Processor count: 4
    Data path: /volume2/Emby
    Application path: /volume3/@appstore/EmbyServer/system
    SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
       at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
       at SQLitePCL.pretty.StatementImpl.MoveNext()
       at SQLitePCL.pretty.DatabaseConnection.ExecuteAll(IDatabaseConnection This, String sql)
       at Emby.Server.Implementations.Data.SqliteItemRepository.Initialize(SqliteUserDataRepository userDataRepo, SyncRepository syncRepo)
       at Emby.Server.Implementations.ApplicationHost.InitDatabases()
       at Emby.Server.Implementations.ApplicationHost.Init()
       at EmbyServer.HostedService.StartAsync(CancellationToken cancellationToken)
    Source: SQLitePCL.pretty
    TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)
.......................................    

 

Then I checked the library.db. DB Browser says that there are wrong # of entries and missing indexes:

 

wrong # of entries in index idx_unique_UserDataKeys

row 72 missing from index idx_MediaItems11

row 92 missing from index idx_MediaItems49

row 117 missing from index idx_MediaItems48

row 119 missing from index idx_MediaItems47

row 158 missing from index idx_MediaItems47

row 179 missing from index idx_MediaItems49

row 189 missing from index idx_MediaItems47

row 224 missing from index idx_MediaItems48

row 257 missing from index idx_MediaItems48

row 302 missing from index idx_MediaItems10

row 315 missing from index idx_MediaItems48

row 317 missing from index idx_MediaItems49

row 325 missing from index idx_MediaItems24

row 340 missing from index idx_MediaItems45

row 363 missing from index idx_MediaItems49

row 394 missing from index idx_MediaItems42

row 395 missing from index idx_MediaItems42

row 17153 missing from index idx_MediaItems11

row 31795 missing from index idx_MediaItems42

row 31795 missing from index idx_MediaItems46

row 31795 missing from index idx_MediaItems45

row 31795 missing from index idx_MediaItems43

row 31795 missing from index idx_MediaItems11

row 31795 missing from index idx_MediaItems4

row 31796 missing from index idx_MediaItems46

row 31796 missing from index idx_MediaItems43

row 32128 missing from index idx_MediaItems45

wrong # of entries in index idx_MediaItems42

wrong # of entries in index idx_MediaItems48

wrong # of entries in index idx_MediaItems47

wrong # of entries in index idx_MediaItems45

wrong # of entries in index idx_MediaItems43

wrong # of entries in index idx_MediaItems29

wrong # of entries in index idx_MediaItems24

wrong # of entries in index idx_MediaItems22

wrong # of entries in index idx_MediaItems16

wrong # of entries in index idx_MediaItems11

wrong # of entries in index idx_MediaItems10

wrong # of entries in index idx_MediaItems4

row 356 missing from index idxAncestorIds2_1

row 357 missing from index idxAncestorIds2_1

row 168400 missing from index idxAncestorIds2_1

row 168402 missing from index idxAncestorIds2_1

wrong # of entries in index idxAncestorIds2_1

 

Edited May 24, 2024 by alibali

[alibali 1]

...exported as sql and imported to a new database:

error in import: Fehler im Statement #38679: UNIQUE constraint failed: AncestorIds2.ItemId, AncestorIds2.AncestorId.

There is no data in imported database.

Edited May 24, 2024 by alibali

[sa2000 674]

2 hours ago, alibali said:

error in import: Fehler im Statement #38679: UNIQUE constraint failed: AncestorIds2.ItemId, AncestorIds2.AncestorId.

There may be some duplicate entries. I could check the database and see if it can be recovered. Alternatively, you could start with a fresh setup and database for your media. 

Send me zip of the original corrupt database - upload externally and send me a link to download by Private Message.

You could also include zip of the sql file you are importing in

The corruption was detected during database updates on upgrade to 4.8.7 - some database corruptions lay dormant and have limited impact until the database structure / data needs to be updated in a new version of the server software

[Luke 42077]

@alibali  are you going to start with a fresh database?

[Scozz1976 3]

I had the same issue with 4.8.7.
Tried 4.9.0.22 and it was ok.. Reinstalled 4.8.7 and the problem came back.

Ended up renaming library.db to library.corrupt and starting with a fresh database.

 

[Luke 42077]

52 minutes ago, Scozz1976 said:

I had the same issue with 4.8.7.
Tried 4.9.0.22 and it was ok.. Reinstalled 4.8.7 and the problem came back.

Ended up renaming library.db to library.corrupt and starting with a fresh database.

 

Right if you go from 4.9 to 4.8 then you would have to do that. Thanks for following up.

[Scozz1976 3]

40 minutes ago, Luke said:

Right if you go from 4.9 to 4.8 then you would have to do that. Thanks for following up.

I’m not sure if you misunderstood me.

4.8 had issues so I went to 4.9 - worked perfectly.

went back to 4.8 and got original problem again so I ended up starting a new database. 

[Luke 42077]

OK thanks for the update.