Approved Emby won't sync after deleting items on server

[riffy 32]

I deleted some movies & Emby didn't sync the changes after an hour so I restarted Kodi. Would not sync again after that. Same error on 3 different installs. Ran the reset & letting it rescan while I sleep. Error same on all 3 logs...

02:29:25 T:1996  NOTICE: emby WebSocketThread -> Message : {"MessageType":"LibraryChanged","Data":{"FoldersAddedTo":[],"FoldersRemovedFrom":[],"ItemsAdded":[],"ItemsRemoved":[],"ItemsUpdated":["cf38b63530a0bc5199c064e466d5fb70","dbdaaa509d58f04a664f74a8ba914db1","9c6c5a524d92d4e595bafaf13f14340f","59100c01233a4e47b204f3b412488a6e","35c5a90e51674960ba1bcaa14cba5364","6bc1a74278707ea95a9b8cb587f98d6e","4d8ee2761937df564ed4e68f8a674be5","eda96b83c34fe18fc1a7e4626df9ab7f","23f59f977141af478712c6983913d89f","7b3da9baf7badc356bd1e7b7a87faf75","6a315dbe94046f36e1ffb9db27ab8fdc","92ce7df418f33f6605b861679e359d52","d37570fe059b695da68b2b73c87289fd","f5c89b8db6114bf0cc1987cff52c558d","63a9c7c90ccf2de035ce4d2baaf22dac","8a9388f5c0b437cd26c44913f286b838","c565cd5507ea6c49d14af2b707baa5ed","c71e5942f707e009b307a04e50cf4483","a062af14cac0fba0b978be4e47356e35","8c28d189b5e53107fb2d26d9c1e10803","f635e5643a579195b35e7dab7d8ed170","1df77688d71ea8b478a951ec21c2e30a"]}}
02:29:25 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Removed : []
02:29:25 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Added : []
02:29:25 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Updated : [u'cf38b63530a0bc5199c064e466d5fb70', u'dbdaaa509d58f04a664f74a8ba914db1', u'9c6c5a524d92d4e595bafaf13f14340f', u'59100c01233a4e47b204f3b412488a6e', u'35c5a90e51674960ba1bcaa14cba5364', u'6bc1a74278707ea95a9b8cb587f98d6e', u'4d8ee2761937df564ed4e68f8a674be5', u'eda96b83c34fe18fc1a7e4626df9ab7f', u'23f59f977141af478712c6983913d89f', u'7b3da9baf7badc356bd1e7b7a87faf75', u'6a315dbe94046f36e1ffb9db27ab8fdc', u'92ce7df418f33f6605b861679e359d52', u'd37570fe059b695da68b2b73c87289fd', u'f5c89b8db6114bf0cc1987cff52c558d', u'63a9c7c90ccf2de035ce4d2baaf22dac', u'8a9388f5c0b437cd26c44913f286b838', u'c565cd5507ea6c49d14af2b707baa5ed', u'c71e5942f707e009b307a04e50cf4483', u'a062af14cac0fba0b978be4e47356e35', u'8c28d189b5e53107fb2d26d9c1e10803', u'f635e5643a579195b35e7dab7d8ed170', u'1df77688d71ea8b478a951ec21c2e30a']
02:29:25 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Processing Added and Updated : [u'cf38b63530a0bc5199c064e466d5fb70', u'dbdaaa509d58f04a664f74a8ba914db1', u'9c6c5a524d92d4e595bafaf13f14340f', u'59100c01233a4e47b204f3b412488a6e', u'35c5a90e51674960ba1bcaa14cba5364', u'6bc1a74278707ea95a9b8cb587f98d6e', u'4d8ee2761937df564ed4e68f8a674be5', u'eda96b83c34fe18fc1a7e4626df9ab7f', u'23f59f977141af478712c6983913d89f', u'7b3da9baf7badc356bd1e7b7a87faf75', u'6a315dbe94046f36e1ffb9db27ab8fdc', u'92ce7df418f33f6605b861679e359d52', u'd37570fe059b695da68b2b73c87289fd', u'f5c89b8db6114bf0cc1987cff52c558d', u'63a9c7c90ccf2de035ce4d2baaf22dac', u'8a9388f5c0b437cd26c44913f286b838', u'c565cd5507ea6c49d14af2b707baa5ed', u'c71e5942f707e009b307a04e50cf4483', u'a062af14cac0fba0b978be4e47356e35', u'8c28d189b5e53107fb2d26d9c1e10803', u'f635e5643a579195b35e7dab7d8ed170', u'1df77688d71ea8b478a951ec21c2e30a']
02:29:29 T:6864   ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <class 'sqlite3.IntegrityError'>
                                            Error Contents: UNIQUE constraint failed: path.idPath
                                            Traceback (most recent call last):
                                              File "C:\MyApps\Kodi\portable_data\addons\plugin.video.emby\service.py", line 131, in <module>
                                                Service().ServiceEntryPoint()
                                              File "C:\MyApps\Kodi\portable_data\addons\plugin.video.emby\service.py", line 96, in ServiceEntryPoint
                                                worked = librarySync.syncDatabase()
                                              File "C:\MyApps\Kodi\portable_data\addons\plugin.video.emby\resources\lib\LibrarySync.py", line 51, in syncDatabase
                                                completed = completed and self.TvShowsSync(True, True)
                                              File "C:\MyApps\Kodi\portable_data\addons\plugin.video.emby\resources\lib\LibrarySync.py", line 405, in TvShowsSync
                                                WriteKodiDB().addTVShowToKodiLibrary(item)
                                              File "C:\MyApps\Kodi\portable_data\addons\plugin.video.emby\resources\lib\WriteKodiDB.py", line 1017, in addTVShowToKodiLibrary
                                                cursor.execute(pathsql, (pathid,path,None,None,1))
                                            IntegrityError: UNIQUE constraint failed: path.idPath
                                            -->End of Python script error report<--
02:29:29 T:1996  NOTICE: Sync Episodes -> Finished 0:0
02:29:32 T:1996  NOTICE: emby WebSocketThread -> Message : {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2015-04-04T07:16:34.4585469Z","EndTimeUtc":"2015-04-04T07:29:31.9503976Z","Status":"Completed","Name":"Scan media library","Key":"RefreshLibrary","Id":"2d67d886717cdade18d9640d4ebbb9cb"}}
02:30:08 T:3048  NOTICE: ES: Client  from 192.168.1.101 timed out
02:31:03 T:3024   ERROR: Window Translator: Can't find window tv
02:31:03 T:2416  NOTICE: Thread BackgroundLoader start, auto delete: false
02:31:03 T:4580  NOTICE: Thread LanguageInvoker start, auto delete: false
02:31:03 T:7420   ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://tvshows/extrafanart/
02:31:03 T:4580  NOTICE: -->Python Interpreter Initialized<--
02:31:04 T:4580  NOTICE: script.tv.show.next.aired: ### TV Show - Next Aired starting GUI proc (6.0.13)
02:31:05 T:3004  NOTICE: Thread BackgroundLoader start, auto delete: false
02:31:24 T:1996  NOTICE: emby WebSocketThread -> Message : {"MessageType":"LibraryChanged","Data":{"FoldersAddedTo":[],"FoldersRemovedFrom":[],"ItemsAdded":[],"ItemsRemoved":[],"ItemsUpdated":["e04d2504e6e090371b3e888037e3bcd8","c8b792fbf763c58d68a9c9d5b22627b1","6c8f1ecaa02038485f61f4b176d6ba44"]}}
02:31:24 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Removed : []
02:31:24 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Added : []
02:31:24 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Items Updated : [u'e04d2504e6e090371b3e888037e3bcd8', u'c8b792fbf763c58d68a9c9d5b22627b1', u'6c8f1ecaa02038485f61f4b176d6ba44']
02:31:24 T:1996  NOTICE: emby WebSocketThread -> Message : Doing LibraryChanged : Processing Added and Updated : [u'e04d2504e6e090371b3e888037e3bcd8', u'c8b792fbf763c58d68a9c9d5b22627b1', u'6c8f1ecaa02038485f61f4b176d6ba44']
02:31:26 T:1996  NOTICE: Sync Episodes -> Finished 0:0
02:31:39 T:1996  NOTICE: emby WebSocketThread -> Message : {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2015-04-04T07:31:38.6081097Z","EndTimeUtc":"2015-04-04T07:31:38.8553454Z","Status":"Completed","Name":"Organize new media files","Key":"AutoOrganize","Id":"415f8db75e909cdef2a3da79d1e2c636"}}
02:31:45 T:3024  NOTICE: Storing total System Uptime
02:31:45 T:3024  NOTICE: Saving settings
02:31:45 T:3024  NOTICE: stop all
02:31:45 T:3024  NOTICE: stop player
02:31:45 T:3024  NOTICE: ES: Stopping event server
02:31:45 T:3024  NOTICE: Webserver: Stopping...
02:31:46 T:3048  NOTICE: ES: UDP Event server stopped

Edited April 4, 2015 by riffy

[riffy 32]

Well it won't rebuild the data bases now. I get the "OperationalError: no such table: actors" same as another another thread. It worked for most the night...

[xnappo 1593]

Can you confirm this is only on Isengard?

[riffy 32]

Woke up... down graded to 14.2... letting it rebuild now. I'm sure I can find something to delete after & see what happens.

[riffy 32]

Deleted a few movies & it never removed them but did continue to sync normally on 14.2.

 

Ran the library clean up & that removed the deleted items just fine. So looks like it might have been an Isengard thing, cuz I can't seem to reproduce the error again on 14.2. Would be nice if the items where deleted from the database on sync instead of having to run the clean up tho. :-)

 

I can't test it on Isengard with the current "OperationalError: no such table: actors" error to be sure. Since it won't build a database with that error. Cuz I did update the server last night & only after that did I start getting these errors. 

 

On a side note... when the server gets disconnected does the addon retry every so often to reconnect to continue syncing or do you have to restart Kodi? Noticed Kodi on my firetv stick stopped syncing with a disconnected error or something this morning. It still has Isengard on it too. Wasn't awake enough to really pay attention. :-p

[riffy 32]

Figures as soon as I hit post... I believe 3 movies were just removed from the database by the sync all on it's own. Saw the list of movies flicker & went to the home screen to see what I think is a lower number on the Movies total. 

 

So... I don't know... maybe it's working just fine in 14.2... I need more caffeine! LOL