Kodi Community Forum
v18 MySQL Resume Play (Bookmark, Files, Path corruption) - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: v18 MySQL Resume Play (Bookmark, Files, Path corruption) (/showthread.php?tid=336244)

MySQL Resume Play (Bookmark, Files, Path corruption) - ChadM - 2018-10-07

Debug Log: https://paste.kodi.tv/ifosujiwoy.kodi

Greetings all.  I have been a long-time Kodi/SPMC user, first time poster.  I am running V18-Beta 3, which has been relatively stable for me with one exception - resuming play from where I left off (same device or different device, same MySQL/NAS instance).

I have 5 nVidia Shield TVs, all are in the same subnet, all use the same NAS and MySQL backend.

Looking at the SQL queries/updates, I can observe the problem relatively easily.

The experiment I ran was enabling debug logging, force stopping Kodi, going into Kodi, launching the "Movies" smart playlist (Aeon Nox), firing up "30 Minutes or Less", skipping ahead 30 minutes, stopping the movie, and killing the debug log.


sql:


SELECT * FROM MyVideos112.files where strFilename like '30 Minutes%';



idFile    idPath    strFilename    playCount    lastPlayed    dateAdded

5    2    30 Minutes Or Less.m2ts    NULL    2018-10-07 14:01:40    2011-12-03 18:14:03




sql:


SELECT * FROM MyVideos112.path where idPath=2;



idPath    strPath    strContent    strScraper    strHash    scanRecursive    useFolderNames    strSettings    noUpdate    exclude    dateAdded    idParentPath

2    nfs://10.11.12.2/volume1/video/Movies/0 - 9/            cab7f16f2eaeddfa81d3a0bce9e9b7a7    0    0        NULL    NULL    NULL    NULL

The idFile for "30 Minutes or Less" is 5, the idPath is 2.  However, inspecting the bookmark table (where the resume is stored) illustrates why the resume doesn't function:

sql:


SELECT * FROM MyVideos112.bookmark;



idBookmark    idFile    timeInSeconds    totalTimeInSeconds    thumbNailImage    player    playerState    type

14    1707    1817.005377    4983.018        VideoPlayer        1


The bookmark stored is for idFile 1707.  Inspecting idFile 1707, we see that something new called "236" with path "133" has been inserted into the files table:


sql:


SELECT * FROM MyVideos112.files where idFile=1707;



idFile    idPath    strFilename    playCount    lastPlayed    dateAdded

1707    133    236    NULL    NULL    NULL




sql:


SELECT * FROM MyVideos112.path where idPath=133;



idPath    strPath    strContent    strScraper    strHash    scanRecursive    useFolderNames    strSettings    noUpdate    exclude    dateAdded    idParentPath

133    videodb://movies/titles/    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

This videodb://movies/titles null/null....etc and strFilename "236" reference may have temporary meaning to the current video client, but has zero meaning to the other video clients.  When a client goes to retrieve the bookmark (resume point) for "30 Minutes or less", no results are returned, which results in no resume point. 

This function works fantastic in v17, but is broken in v18.

RE: MySQL Resume Play (Bookmark, Files, Path corruption) - ChadM - 2018-10-24

I tested v18 Beta 4 this evening, the same problem exists unfortunately.

RE: MySQL Resume Play (Bookmark, Files, Path corruption) - jooones - 2018-11-15

I have similar issues since updating to LibreELEC 9.0 alpha, which comes with Kodi Leia. Resume sometimes works, sometimes doesn't. Even from the same machine, when I resume a file and stop it again, the resume point is deleted. It doesn't remember downloaded subtitles, as Kodi v17 did, I always have to re-download them each time I resume a video.