Server Shutting Down

[fuzzyemby 2]

@LukeI believe I have a similar issue with 4.8.1.0 on unbuntu. Here are my logs.

embyserver-63844409155.txt

Edited February 24 by fuzzyemby

[Luke 37071]

@fuzzyembycan you please describe your issue in more detail? Thanks.

[fuzzyemby 2]

My emby server will lock up randomly, I think it's database issue but not sure.

I ran sqlite3 library.db "PRAGMA integrity_check" and the results said okay.

but those logs say I have a database error

SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
       at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
       at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3_stmt stmt, Int32 rc)
       at SQLitePCL.pretty.StatementImpl.MoveNext()
       at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(IDatabaseConnection db, Int64 userId, Int64 userSettingsKeyId, String value)
       at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(Int64 userId, NameValuePair[] settings)
       at Emby.Server.Implementations.Library.UserManager.SetUserSettings(Int64 userId, NameValuePair[] settings)
       at Emby.Server.Implementations.Library.UserManager.SetTypedUserSetting(Int64 userId, String key, Object configuration)
       at Trakt.ServerMediator.Run()
       at Emby.Server.Implementations.ApplicationHost.RunEntryPoints(IEnumerable`1 entryPoints, Boolean isBeforeStartup)
    Source: SQLitePCL.pretty
    TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

[Luke 37071]

What do you mean by lock up?

[fuzzyemby 2]

The libraries won't load and playback stops.

[Happy2Play 8282]

32 minutes ago, fuzzyemby said:

My emby server will lock up randomly, I think it's database issue but not sure.

I ran sqlite3 library.db "PRAGMA integrity_check" and the results said okay.

but those logs say I have a database error

SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
       at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
       at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3_stmt stmt, Int32 rc)
       at SQLitePCL.pretty.StatementImpl.MoveNext()
       at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(IDatabaseConnection db, Int64 userId, Int64 userSettingsKeyId, String value)
       at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(Int64 userId, NameValuePair[] settings)
       at Emby.Server.Implementations.Library.UserManager.SetUserSettings(Int64 userId, NameValuePair[] settings)
       at Emby.Server.Implementations.Library.UserManager.SetTypedUserSetting(Int64 userId, String key, Object configuration)
       at Trakt.ServerMediator.Run()
       at Emby.Server.Implementations.ApplicationHost.RunEntryPoints(IEnumerable`1 entryPoints, Boolean isBeforeStartup)
    Source: SQLitePCL.pretty
    TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

So you are saying Trakt plugin is causing issues?

2024-02-24 12:13:26.871 Error App: Error in Trakt.ServerMediator
	*** Error Report ***
	Version: 4.8.1.0
	Command line: /app/emby/system/EmbyServer.dll -programdata /config -ffdetect /app/emby/bin/ffdetect -ffmpeg /app/emby/bin/ffmpeg -ffprobe /app/emby/bin/ffprobe -restartexitcode 3
	Operating system: Linux version 6.1.51-x64v3-xanmod1 (root@runner-4xxinz-1p-project-46614684-concurrent-0) (gcc-13 (Debian 13.2.0-2) 13.2.0, GNU ld (GNU Binutils for De
	Framework: .NET 6.0.25
	OS/Process: x64/x64
	Runtime: app/emby/system/System.Private.CoreLib.dll
	Processor count: 20
	Data path: /config
	Application path: /app/emby/system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3_stmt stmt, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(IDatabaseConnection db, Int64 userId, Int64 userSettingsKeyId, String value)
	   at Emby.Server.Implementations.Data.SqliteUserRepository.SetUserSettings(Int64 userId, NameValuePair[] settings)
	   at Emby.Server.Implementations.Library.UserManager.SetUserSettings(Int64 userId, NameValuePair[] settings)
	   at Emby.Server.Implementations.Library.UserManager.SetTypedUserSetting(Int64 userId, String key, Object configuration)
	   at Trakt.ServerMediator.Run()
	   at Emby.Server.Implementations.ApplicationHost.RunEntryPoints(IEnumerable`1 entryPoints, Boolean isBeforeStartup)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)
	
2024-02-24 12:13:26.871 Info App: Entry point completed: Trakt.ServerMediator. Duration: 0.0147803 seconds

 

But should be unrelated to why the server shutdown as I really don't see any command at the end of the log to see why,

2024-02-24 22:05:44.178 Info Server: Stopping HttpListener...
2024-02-24 22:05:50.182 Info Server: HttpListener stopped

 

[fuzzyemby 2]

I don't know but I did a .restore on the library db and removed the trakt plugin and seems to be stable now.

[Luke 37071]

7 hours ago, fuzzyemby said:

I don't know but I did a .restore on the library db and removed the trakt plugin and seems to be stable now.

How did you do a restore?

[fuzzyemby 2]

26 minutes ago, Luke said:

How did you do a restore?

I ran the sqlite3 .restore command and also removed the trakt plugin.

[fuzzyemby 2]

well it locked up again and now can't load the libraries. It's unusable now.

[Luke 37071]

2 hours ago, fuzzyemby said:

well it locked up again and now can't load the libraries. It's unusable now.

Can you please attach the emby server log? Thanks.

[Happy2Play 8282]

Potentially need the log showing locked and the log before it.