Completed Sync Error whilst resetting local DB

[cw-kid 192]

Hi

 

I was just resetting my local database and it came up with a sync error and said to report it on the forum:

:06:54 T:10752  NOTICE: EMBY.default -> plugin.video.emby started
17:06:54 T:10752  NOTICE: EMBY.default -> Parameter string: ?content_type=video
17:06:54 T:10752  NOTICE: EMBY.default -> plugin.video.emby stopped
17:06:54 T:5332  NOTICE: Thread BackgroundLoader start, auto delete: false
17:06:54 T:10752 WARNING: CPythonInvoker(18, C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\default.py): the python script "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\default.py" has left several classes in memory that we couldn't clean up. The classes include: class XBMCAddon::xbmcaddon::Addon
17:07:04 T:5092  NOTICE: EMBY.utils -> Resetting the Emby database.
17:07:22 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"LibraryChanged","Data":{"FoldersAddedTo":[],"FoldersRemovedFrom":[],"ItemsAdded":[],"ItemsRemoved":[],"ItemsUpdated":["7f45658987a1247b0734dff1fcc15ab3"]}}
17:07:22 T:4972  NOTICE: EMBY.librarysync -> Queue update: [u'7f45658987a1247b0734dff1fcc15ab3']
17:07:23 T:10096  NOTICE: EMBY.ga_client -> ERROR:: ('C:\\Users\\Stuart\\AppData\\Roaming\\Kodi\\addons\\plugin.video.emby\\resources\\lib\\embydb_functions.py', 251, 'getMediaType_byId', 'self.embycursor.execute(query, (embyid,))')
17:07:23 T:10096  NOTICE: EMBY.ga_client -> ERROR:: OperationalError - embydb_functions.py:251(no such table: emby)(self.embycursor.execute(query, (embyid,)))
17:07:23 T:10096  NOTICE: EMBY.ga_client -> GA: {'el': 'embydb_functions.py:251(no such table: emby)(self.embycursor.execute(query, (embyid,)))', 'cid': '5ed473ca4b05facfb5071324fe04d438', 'v': '1', 'ea': 'OperationalError', 'ec': 'Exception', 'an': 'Kodi4Emby', 'ul': 'English', 't': 'event', 'av': '2.2.51', 'tid': 'UA-85356267-1', 'aid': '1', 'ua': 'Kodi/15.2 (Windows NT)', 'ds': 'plugin'}
17:07:23 T:10096  NOTICE: EMBY.librarysync -> ERROR:: no such table: emby
                                            Traceback (most recent call last):
                                              File "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\resources\lib\librarysync.py", line 860, in run
                                                self.run_internal()
                                              File "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\resources\lib\librarysync.py", line 967, in run_internal
                                                self.incrementalSync()
                                              File "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\resources\lib\librarysync.py", line 799, in incrementalSync
                                                items = emby_db.sortby_mediaType(listItems)
                                              File "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\resources\lib\embydb_functions.py", line 266, in sortby_mediaType
                                                mediatype = self.getMediaType_byId(itemid)
                                              File "C:\Users\Stuart\AppData\Roaming\Kodi\addons\plugin.video.emby\resources\lib\embydb_functions.py", line 251, in getMediaType_byId
                                                self.embycursor.execute(query, (embyid,))
                                            OperationalError: no such table: emby
17:12:42 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2016-10-19T15:00:22.0963493Z","EndTimeUtc":"2016-10-19T16:12:40.6645488Z","Status":"Completed","Name":"Refresh Guide","Key":"RefreshGuide","Id":"3c6a16ed7db828baeb3bb3c1cff74810"}}
17:13:19 T:2420  NOTICE: Thread JobWorker start, auto delete: true
17:13:46 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"LibraryChanged","Data":{"FoldersAddedTo":[],"FoldersRemovedFrom":[],"ItemsAdded":[],"ItemsRemoved":[],"ItemsUpdated":["d76204ad069e50e6b6312a674626c820"]}}
17:13:46 T:4972  NOTICE: EMBY.librarysync -> Queue update: [u'd76204ad069e50e6b6312a674626c820']
17:14:10 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2016-10-19T16:14:01.6103543Z","EndTimeUtc":"2016-10-19T16:14:08.4117363Z","Status":"Completed","Name":"Cloud & Folder Sync","Key":"ServerSync","Id":"d2abaeece4b6c98c888bb52f637151a8"}}
17:14:54 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"LibraryChanged","Data":{"FoldersAddedTo":[],"FoldersRemovedFrom":[],"ItemsAdded":[],"ItemsRemoved":[],"ItemsUpdated":["a51db5d08a2f0e98eef29b22aa17d594","5411624a02ba46b54eadfb17a67eea65"]}}
17:14:54 T:4972  NOTICE: EMBY.librarysync -> Queue update: [u'a51db5d08a2f0e98eef29b22aa17d594', u'5411624a02ba46b54eadfb17a67eea65']
17:17:39 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2016-10-19T15:10:41.0533103Z","EndTimeUtc":"2016-10-19T16:17:37.7258273Z","Status":"Completed","Name":"Scan media library","Key":"RefreshLibrary","Id":"2d67d886717cdade18d9640d4ebbb9cb"}}
17:21:44 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2016-10-19T16:21:42.6529457Z","EndTimeUtc":"2016-10-19T16:21:42.7621415Z","Status":"Completed","Name":"Convert media","Key":"SyncPrepare","Id":"12e0945fba4d49b1f482115adb46c341"}}
17:22:17 T:4972  NOTICE: EMBY.downloadutils -> SessionId: 8dd02693756c7deacd5b5fa4e7f81243
17:22:37 T:4972  NOTICE: EMBY.websocket_client -> Message: {"MessageType":"ScheduledTaskEnded","Data":{"StartTimeUtc":"2016-10-19T16:22:24.8493227Z","EndTimeUtc":"2016-10-19T16:22:35.9716949Z","Status":"Completed","Name":"Download missing subtitles","Id":"2c66a88bca43e565d7f8099f825478f1"}}
17:23:23 T:4160  NOTICE: Thread JobWorker start, auto delete: true
17:23:43 T:5092  NOTICE: EMBY.default -> plugin.video.emby stopped

After clicking OK on the error dialogue box it then proceeded to ask the normal questions about clearing the artwork cache and if you wanted to delete the add-on settings etc. 

 

Upon re-opening Kodi it has started its initial sync process. 

 

Thanks. 

[Angelblue05 4130]

@@cw-kid

 

Thanks for reporting, I'll correct this. It's only because you were resetting and items tried to be processed. I will terminate updates when the reset is in progress to prevent this issue from happening.

Edited October 20, 2016 by Angelblue05

[Angelblue05 4130]

This will be resolved with the next beta. The fix is on github currently.