Posts: 705
Joined: Oct 2008
Reputation:
0
Hello,
I'm using MySQL DB to share the Movie and TV libraries between 2 devices. Everything worked perfectly on Jarvis, but since the upgrade to Krypton i have a strange issue - in Jarvis i used to only update the library in the main Kodi and this would update the library in the second device as well, but now only one device is updated and on the second device i have to manually trigger library update, the same goes for watched shows and movies - if i watch a show on one device - the other will still have that show as unwatched until i do a manual library update. The only thing that still works perfectly is resume between the devices so if i start a show on one device and stop in the middle - when i start the same show on the other device it continues from the same point.
Any ideas?
Thanks!
Posts: 191
Joined: Aug 2011
Reputation:
0
In that case you might want to check the logs of both to see if one is having trouble accessing the database. I just updated to Krypton and was getting unable to access database errors in one machine until I turned on the "wait for network" option.
Posts: 705
Joined: Oct 2008
Reputation:
0
2017-01-26, 23:46
(This post was last modified: 2017-01-26, 23:54 by logictester.)
i don't see any DB related errors in the log, it shows: 7:43:40.286 T:2948588448 NOTICE: Running database version xbmc_video107 which is correct on both and i am able to connect to everything and see everything correctly after manual library update.. it's very strange
where can i find the "wait for network" setting? is it in advancedsettings.xml?
Posts: 705
Joined: Oct 2008
Reputation:
0
just tried another scan, main device shows:
1:45:12.312 T:139644013868800 NOTICE: VideoInfoScanner: Starting scan ..
21:45:13.551 T:139644013868800 ERROR: GetDirectory - Error getting ------ don't know what this error message means
21:45:26.810 T:139644013868800 ERROR: Previous line repeats 2 times.
21:45:26.810 T:139644013868800 NOTICE: CleanDatabase: Starting videodatabase cleanup ..
21:45:27.604 T:139644013868800 NOTICE: CleanDatabase: Cleaning videodatabase done. Operation took 00:00
21:45:27.614 T:139644013868800 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:15
but second device has no scan messages in the log...
Posts: 5,952
Joined: Sep 2008
Reputation:
201
Koying
Retired Team-Kodi Member
Posts: 5,952
Are you actually sure both devices use mysql?
From your description, it'd seem the 2nd one does not.
Look for a "connected to mysql" message in the logs
Posts: 705
Joined: Oct 2008
Reputation:
0
2017-01-27, 17:31
(This post was last modified: 2017-01-27, 17:32 by logictester.)
i don't see connected to mysql on either devices logs. but the advancedsettings.xml has mysql configured on both and resume video works perfectly, also after manually scanning the library - it adjusts itself and gets all the correct watched statuses
Posts: 705
Joined: Oct 2008
Reputation:
0
2017-01-27, 21:27
(This post was last modified: 2017-01-27, 21:29 by logictester.)
after enabling debug log, both devices logs show: DEBUG: Mysql execute: update path set and other mysql related lines on scan library execute
Posts: 5,952
Joined: Sep 2008
Reputation:
201
Koying
Retired Team-Kodi Member
Posts: 5,952
Post both full debug logs, please
Posts: 705
Joined: Oct 2008
Reputation:
0
what could be causing this? used to work fine before the upgrade.... should i maybe remove the db on the second device and tart over? what would be the be the process?
Thanks for looking into this
Posts: 5,952
Joined: Sep 2008
Reputation:
201
Koying
Retired Team-Kodi Member
Posts: 5,952
That being said, that's probably not the cause of you initial issue.
When you say "the other will still have that show as unwatched", is it true even if you exit Kodi and re-enter?
Posts: 705
Joined: Oct 2008
Reputation:
0
I haven't tried rebooting, but simply running a manual library scan marks everything as it should be, all watched statuses match on both boxes and all new items are added to the second box