Error on creating Sync job

[AdilMahboob 4]

Hi,

 

I tried to add "Next Up" under TV Shows as a sync job and pressing the Sync button would do nothing (not even return an error??) so I went into the server logs and noted it was returning a 500 which obviously wasn't parsed as an error and returned to the user. The error log was:

 

2019-08-27 22:07:26.844 Info HttpServer: HTTP POST http://localhost:38096/emby/Sync/Jobs. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0

2019-08-27 22:07:26.846 Error HttpServer: Error processing request

*** Error Report ***

Version: 4.2.1.0

Command line: C:\Users\user\AppData\Roaming\Emby-Server\system\EmbyServer.dll

Operating system: Microsoft Windows NT 6.2.9200.0

64-Bit OS: True

64-Bit Process: True

User Interactive: True

Runtime: file:///C:/Users/user/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll

Processor count: 8

Program data path: C:\Users\user\AppData\Roaming\Emby-Server\programdata

Application directory: C:\Users\user\AppData\Roaming\Emby-Server\system

SQLitePCL.pretty.SQLiteException: Constraint: NOT NULL constraint failed: SyncJobs2.ItemIds

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 Emby.Server.Sync.SyncRepository.Save(SyncJob job)

at Emby.Server.Sync.SyncManager.CreateJob(SyncJobRequest request, CancellationToken cancellationToken)

at Emby.Server.Sync.Api.SyncService.Post(CreateSyncJob request)

at Emby.Server.Implementations.Services.ServiceController.GetTaskResult(Task task)

at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken)

at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 host, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken)

Source: SQLitePCL.pretty

TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)

 

2019-08-27 22:07:26.846 Info HttpServer: HTTP Response 500 to ::1. Time: 2ms. http://localhost:38096/emby/Sync/Jobs

 

Looks like ver 4.2.1 fixed something with sql constraints for new installations but perhaps it was also on existing installations too?

Edited August 28, 2019 by AdilMahboob

[AdilMahboob 4]

Bump

[AdilMahboob 4]

Can someone acknowledge this is being looked into please?

[Luke 37274]

HI, are you willing to delete your library database file? For now that might be the most practical option. I can help you with that. Thanks.

[AdilMahboob 4]

HI, are you willing to delete your library database file? For now that might be the most practical option. I can help you with that. Thanks.

Thanks, it's a bit of a hammer fixes all solution but it did the job as the sync now works.

 

Interestingly, the library db file dropped 700mb in size when compared to the original (after importing played states as well). I'll see, in time, if that space was actually used for anything important!

 

Thanks for getting back to me Luke. Keep up the great work

 

Regards,

[Luke 37274]

Thanks for the feedback.