kesm 25 Posted April 9, 2019 Share Posted April 9, 2019 Are you sure? I can't find the link on original post Link to comment Share on other sites More sharing options...
reggi 409 Posted April 9, 2019 Author Share Posted April 9, 2019 Mmm, just checked and it is still there Under the 4 links there should be a line starting with "Feel free to vote here..." Link to comment Share on other sites More sharing options...
kesm 25 Posted April 9, 2019 Share Posted April 9, 2019 oh my bad I though you were talking about this post https://emby.media/community/index.php?/topic/56640-developing-a-standalone-embystat-server/?p=551993 quick question to do you prefer to have issues posted here or on github? Link to comment Share on other sites More sharing options...
reggi 409 Posted April 9, 2019 Author Share Posted April 9, 2019 On github Most of the time I just create issue tickets from the forum posts anyway. Far more easy to keep track of all the bugs on github 1 Link to comment Share on other sites More sharing options...
WilhelmStroker 96 Posted April 9, 2019 Share Posted April 9, 2019 (edited) Just installed this, and it seems to work ok, although every time I go to movies tab I get an Unhandled backend excetion error message. It looks like Embystat doesn't like Frances McDormand Snippet from the log, the only error below (edited my internal IP address): 2019-04-09 14:34:24.0593 [INFO] EMBY-CLIENT Sending GET: http://1.2.3.4:8096/emby/persons/Frances McDormand?SeriesStatuses=&fields=&Filters=&ImageTypes=&AirDays=&EnableImageTypes=&recursive=False&Genres=&StudioIds=&Years=&format=json 2019-04-09 14:34:24.2163 [ERROR] An unhandled error occurred. System.NullReferenceException: Object reference not set to an instance of an object. at EmbyStat.Services.PersonService.GetPersonById(String id) in D:\Darth Vader\work\aa794b64fcf59423\EmbyStat.Services\PersonService.cs:line 24 at EmbyStat.Services.MovieService.GetMostFeaturedActorsPerGenre(List`1 collectionIds) in D:\Darth Vader\work\aa794b64fcf59423\EmbyStat.Services\MovieService.cs:line 421 at EmbyStat.Services.MovieService.GetPeopleStatsForCollections(List`1 collectionIds) in D:\Darth Vader\work\aa794b64fcf59423\EmbyStat.Services\MovieService.cs:line 93 at EmbyStat.Controllers.Movie.MovieController.GetPersonStats(List`1 collectionIds) in D:\Darth Vader\work\aa794b64fcf59423\EmbyStat.Controllers\Movie\MovieController.cs:line 44 at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync() Edit:looks like https://github.com/mregni/EmbyStat/issues/609, so I'll check for updates and see if that fixes it. Edited April 9, 2019 by WilhelmStroker Link to comment Share on other sites More sharing options...
reggi 409 Posted April 9, 2019 Author Share Posted April 9, 2019 It seems EmbyStat is not liking a lot of actors as you can see in this issue => https://github.com/mregni/EmbyStat/issues/621 Thanks for the extra logs! Link to comment Share on other sites More sharing options...
WilhelmStroker 96 Posted April 9, 2019 Share Posted April 9, 2019 I've subscribed to that issue, let me know if you need any additional information Link to comment Share on other sites More sharing options...
purger500 12 Posted April 9, 2019 Share Posted April 9, 2019 I have problem with small sync job too. It never finishes. I am running Embystat on windows 10 64-bit. 2019-04-09 20:55:07.6369 [INFO] PINGEMBYSERVER-JOB We found your Emby server 2019-04-09 20:55:07.6838 [INFO] PINGEMBYSERVER-JOB Job finished after 1 minute. 2019-04-09 20:56:08.5251 [INFO] SMALLEMBYSYNC-JOB Starting job 2019-04-09 20:56:08.5386 [INFO] EMBY-CLIENT Sending GET: http://192.168.2.81:8096/emby/System/Info?format=json 2019-04-09 20:56:08.5561 [INFO] Received web socket message: Sessions 2019-04-09 20:56:08.5561 [INFO] Received web socket message: UserUpdated 2019-04-09 20:56:08.6082 [ERROR] Failed executing DbCommand (2ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:56:08.6261 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:56:08.6261 [ERROR] Error while running job Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.EmbyRepository.AddOrUpdateServerInfo(ServerInfo entity) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\EmbyRepository.cs:line 83 at EmbyStat.Services.EmbyService.GetAndProcessServerInfo(String embyAddress, String accessToken) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Services\EmbyService.cs:line 232 at EmbyStat.Jobs.Jobs.Sync.SmallSyncJob.RunJob() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\Jobs\Sync\SmallSyncJob.cs:line 29 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 46 2019-04-09 20:56:08.6261 [ERROR] Failed executing DbCommand (0ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:56:08.6261 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:56:08.6451 [WARN] Failed to process the job '4c67acff-3975-44c7-9307-1d992663555f': an exception occurred. Retry attempt 1 of 2 will be performed in 00:00:42. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.JobRepository.EndJob(Guid id, DateTime endTime, JobState state) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\Jobrepository.cs:line 54 at EmbyStat.Jobs.BaseJob.FailExecution(String message) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 95 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 57 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2019-04-09 20:56:54.5098 [INFO] SMALLEMBYSYNC-JOB Starting job 2019-04-09 20:56:54.5098 [INFO] EMBY-CLIENT Sending GET: http://192.168.2.81:8096/emby/System/Info?format=json 2019-04-09 20:56:54.5256 [INFO] Received web socket message: Sessions 2019-04-09 20:56:54.5334 [ERROR] Failed executing DbCommand (1ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:56:54.5334 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:56:54.5334 [ERROR] Error while running job Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.EmbyRepository.AddOrUpdateServerInfo(ServerInfo entity) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\EmbyRepository.cs:line 83 at EmbyStat.Services.EmbyService.GetAndProcessServerInfo(String embyAddress, String accessToken) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Services\EmbyService.cs:line 232 at EmbyStat.Jobs.Jobs.Sync.SmallSyncJob.RunJob() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\Jobs\Sync\SmallSyncJob.cs:line 29 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 46 2019-04-09 20:56:54.5334 [ERROR] Failed executing DbCommand (0ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:56:54.5334 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:56:54.5334 [WARN] Failed to process the job '4c67acff-3975-44c7-9307-1d992663555f': an exception occurred. Retry attempt 2 of 2 will be performed in 00:00:16. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.JobRepository.EndJob(Guid id, DateTime endTime, JobState state) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\Jobrepository.cs:line 54 at EmbyStat.Jobs.BaseJob.FailExecution(String message) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 95 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 57 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 2019-04-09 20:57:25.3717 [INFO] SMALLEMBYSYNC-JOB Starting job 2019-04-09 20:57:25.3717 [INFO] EMBY-CLIENT Sending GET: http://192.168.2.81:8096/emby/System/Info?format=json 2019-04-09 20:57:25.3828 [INFO] Received web socket message: Sessions 2019-04-09 20:57:25.3828 [ERROR] Failed executing DbCommand (0ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:57:25.3828 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:57:25.3828 [ERROR] Error while running job Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.EmbyRepository.AddOrUpdateServerInfo(ServerInfo entity) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\EmbyRepository.cs:line 83 at EmbyStat.Services.EmbyService.GetAndProcessServerInfo(String embyAddress, String accessToken) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Services\EmbyService.cs:line 232 at EmbyStat.Jobs.Jobs.Sync.SmallSyncJob.RunJob() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\Jobs\Sync\SmallSyncJob.cs:line 29 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 46 2019-04-09 20:57:25.3923 [ERROR] Failed executing DbCommand (0ms) [Parameters=[@p0='?' (Size = 32), @p1='?' (Size = 66), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?' (Size = 69), @p11='?', @p12='?' (Size = 69), @[member="P13"]='?' (Size = 24), @p14='?' (Size = 65), @p15='?' (Size = 7), @p16='?' (Size = 7), @p17='?' (Size = 60), @p18='?' (Size = 11), @p19='?', @p20='?', @p21='?', @p22='?', @p23='?' (Size = 36), @p24='?' (Size = 7), @p25='?', @p26='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "ServerInfo" ("Id", "CachePath", "CanLaunchWebBrowser", "CanSelfRestart", "CanSelfUpdate", "HardwareAccelerationRequiresPremiere", "HasPendingRestart", "HasUpdateAvailable", "HttpServerPortNumber", "HttpsPortNumber", "InternalMetadataPath", "IsShuttingDown", "ItemsByNamePath", "LocalAddress", "LogPath", "OperatingSystem", "OperatingSystemDisplayName", "ProgramDataPath", "ServerName", "SupportsAutoRunAtStartup", "SupportsHttps", "SupportsLibraryMonitor", "SystemUpdateLevel", "TranscodingTempPath", "Version", "WanAddress", "WebSocketPortNumber") VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @[member="P13"], @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26); Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) 2019-04-09 20:57:25.3923 [ERROR] An exception occurred in the database while saving changes for context type 'EmbyStat.Repositories.ApplicationDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) 2019-04-09 20:57:25.3923 [ERROR] Failed to process the job '4c67acff-3975-44c7-9307-1d992663555f': an exception occurred. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 19: 'NOT NULL constraint failed: ServerInfo.WanAddress'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple`2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at EmbyStat.Repositories.JobRepository.EndJob(Guid id, DateTime endTime, JobState state) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Repositories\Jobrepository.cs:line 54 at EmbyStat.Jobs.BaseJob.FailExecution(String message) in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 95 at EmbyStat.Jobs.BaseJob.Execute() in D:\Yoda\work\aa794b64fcf59423\EmbyStat.Jobs\BaseJob.cs:line 57 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 1 Link to comment Share on other sites More sharing options...
reggi 409 Posted April 10, 2019 Author Share Posted April 10, 2019 Thanks for the log. I create a github issue for it => https://github.com/mregni/EmbyStat/issues/632 WIll be a quick fix normally. Link to comment Share on other sites More sharing options...
purger500 12 Posted April 10, 2019 Share Posted April 10, 2019 Thanks for the log. I create a github issue for it => https://github.com/mregni/EmbyStat/issues/632 WIll be a quick fix normally. Thank You. Link to comment Share on other sites More sharing options...
Spaceboy 2493 Posted April 10, 2019 Share Posted April 10, 2019 hi reggi, unfortunately embystat crashes for me during the initial sync. i've tried in both in synology docker and windows and it seems to stop at the same point. btw i love the anonymised log feature. logs attached. 2019-04-10 (3).log cheers! 2 Link to comment Share on other sites More sharing options...
reggi 409 Posted April 10, 2019 Author Share Posted April 10, 2019 Hey @@Spaceboy Thanks for the log file! Some kind of strange entity problem I see. I create a GitHub issue for it here => https://github.com/mregni/EmbyStat/issues/634 This tracking errors can be a pain in the ass, but I'll see that I can fix this. Link to comment Share on other sites More sharing options...
kesm 25 Posted April 11, 2019 Share Posted April 11, 2019 (edited) Hi @@reggi Don't know if it's wanted or not but in the about page I don't have any number version : EmbyStat version: 0.0.0.0 Operating system: debian x64 9 I'm using a docker image on unRAID with this repository : uping/embystat:nightly-linux Edited April 11, 2019 by kesm Link to comment Share on other sites More sharing options...
WilhelmStroker 96 Posted April 11, 2019 Share Posted April 11, 2019 Beta 35 looks to have fixed the people crash and that's now also showing the right version for me. Good work! 1 Link to comment Share on other sites More sharing options...
kesm 25 Posted April 11, 2019 Share Posted April 11, 2019 Ow thanks! I'll try the trailer feature myself and see what is null then. I'll keep you posted hi, don't know if you got time to check, I still have the issue with latest version, here is a new log in case it helps Hosting environment: Production Content root path: /app Now listening on: http://[::]:5432 Application started. Press Ctrl+C to shut down. Unhandled Exception: Unhandled Exception: System.ArgumentNullException: Value cannot be null. Parameter name: value at Newtonsoft.Json.Linq.Extensions.Value[T,U](IEnumerable`1 value) at EmbyStat.Common.Converters.SessionConverter.ConvertToSessions(JArray sessions)+MoveNext() in /EmbyStat.Common/Converters/SessionConverter.cs:line 31 at System.Collections.Generic.List`1.AddEnumerable(IEnumerable`1 enumerable) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at EmbyStat.Services.WebSocketService.WebSocketApiSessionsUpdated(Object sender, GenericEventArgs`1 e) in /EmbyStat.Services/WebSocketService.cs:line 100 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location where exception was thrown --- at System.Threading.ThreadPoolWorkQueue.Dispatch()System.ArgumentNullException: Value cannot be null. Parameter name: value at Newtonsoft.Json.Linq.Extensions.Value[T,U](IEnumerable`1 value) at EmbyStat.Common.Converters.SessionConverter.ConvertToSessions(JArray sessions)+MoveNext() in /EmbyStat.Common/Converters/SessionConverter.cs:line 31 at System.Collections.Generic.List`1.AddEnumerable(IEnumerable`1 enumerable) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at EmbyStat.Services.WebSocketService.WebSocketApiSessionsUpdated(Object sender, GenericEventArgs`1 e) in /EmbyStat.Services/WebSocketService.cs:line 100 at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location where exception was thrown --- at System.Threading.ThreadPoolWorkQueue.Dispatch() Link to comment Share on other sites More sharing options...
reggi 409 Posted April 13, 2019 Author Share Posted April 13, 2019 Thanks for reminding me about the bug @@kesm, forgot about it. I just push a new version to GitHub 0.1.0-beta.36. Has 4 smaller bug fixes in them. I did found out that the updater is broken, so it's possible that the app is not updating at the moment. I'll create a new release just to fix the updater asap. Link to comment Share on other sites More sharing options...
neik 837 Posted April 14, 2019 Share Posted April 14, 2019 (edited) Hi reggi, thanks for developing and putting so much effort in such a great tool. Have been playing with it especially for narrowing down missing episodes in my tv shows library. In the current status of EmbyStats one can already see if there are episodes missing but it's not possible to see which episodes in particular are missing. Would it be possible to show that also? Looking forward to see this tool developing! :-) Edited April 14, 2019 by neik Link to comment Share on other sites More sharing options...
reggi 409 Posted April 15, 2019 Author Share Posted April 15, 2019 Hey @@neik Thanks for testing out the tool! Sounds indeed like a good idea to add that information as well. But can you please create a suggestion here => https://embystat.featureupvote.com/ That way I can better keep track of features that I need to implement. Link to comment Share on other sites More sharing options...
neik 837 Posted April 15, 2019 Share Posted April 15, 2019 @@reggi, thanks for you feedback. Here it is: https://embystat.featureupvote.com/suggestions/38405/show-missing-episodes 1 Link to comment Share on other sites More sharing options...
Pog22 50 Posted April 16, 2019 Share Posted April 16, 2019 (edited) I'm going to tryout and test the docker image, what volume should I mount so I can save the database between images? Also, is there built in authentication? Edited April 16, 2019 by colfin22 Link to comment Share on other sites More sharing options...
reggi 409 Posted April 16, 2019 Author Share Posted April 16, 2019 For that you need to mount the root folder /app. There you will find the data.db file. Have fun testing! Link to comment Share on other sites More sharing options...
Pog22 50 Posted April 16, 2019 Share Posted April 16, 2019 Thanks reggi, is there authentication? Or can it use Emby Auth? Link to comment Share on other sites More sharing options...
reggi 409 Posted April 16, 2019 Author Share Posted April 16, 2019 At the moment there is no auth on the server itself. So it's a bad idea to open EmbyStat to a public port. But it is on my foto list! But need to implement the new UI first. Link to comment Share on other sites More sharing options...
Pog22 50 Posted April 16, 2019 Share Posted April 16, 2019 Ok I'll have to do auth in Nginx Link to comment Share on other sites More sharing options...
Pog22 50 Posted April 17, 2019 Share Posted April 17, 2019 I've authentication setup with nginx The app won't run when i try to mount the volume /app outside the container. Has anyone successfully setup a volume mount for persistent storge? If so how? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now