#17336 new Bugs

Library does not update play count after episode watch

Reported by: Yveske Owned by:
Priority: 4 - Normal
Component: Database / Library for Videos (Movies and TV-Shows) Version: 17.0 "Krypton" RC3
Severity: Normal Keywords: MySQL, Library, play count
Cc: Blocked By:
Blocking: Platform: Linux

Description

Hi,

The problem I have is on my Raspberry Pi 2 running Libreelec. The issue is that when I watched an episode of something on my Pi and go check in the TV shows library the play count is still for example 0/3, so saying that no episodes are watched. The funny thing is that when I check on my home screen under TV shows, the widget 'In progress TV shows' do update the play count from 0/3 to 1/3 after a minute or so. This all happens on the Pi where I watched the episode, this issue only started the moment I started using Mysql. It will refresh when I clean or update the library. It also refresh when I delete the content of /storage/.kodi/temp/archive_cache

When I check Kodi on my Android device there is no problem and the play count is updated to 1/3 so the problem is not in the Mysql database but must be something local.

I run Kodi 17 via Libreelec 7.95.3 and also tried a clean install with Osmc

If more information is needed just let me know.

Thank you.

More information in the forum thread I first started. I made a debug log

Change History (3)

comment:1 Changed at 2017-03-28T11:44:55+01:00 by Yveske

Ok so apparently the problem also occurs when I use a local library. It's not as bad as while using a mysql library but in one of three times the library stops updating the play count and the only way is to delete the files in the archive_cache folder.

comment:2 Changed at 2017-05-03T01:54:32+01:00 by AMoo-Miki

When the watched status of an episode changes, CFileItemList::RemoveDiscCache is called on the episode-list, in the form of videodb://tvshows/titles/104/1/?tvshowid=104.

To fix the problem, we should invalidate the cache for the path's parent, videodb://tvshows/titles/104/ (seasons list of a show), and the grandparent, videodb://tvshows/titles/ (titles list).

I have logs and analysis posted at http://forum.kodi.tv/showthread.php?tid=313580.

PS: Reproduced on Win10 with 17.1 and 17.2 RC1, clean builtin database and MySQL 5.7.18 (latest at the time of writing)

Last edited at 2017-05-05T02:41:13+01:00 by AMoo-Miki (previous) (diff)

comment:3 Changed at 2017-05-05T02:42:54+01:00 by AMoo-Miki

With Jarvis 16.1, I don't see any log about clearing of cache. Is it possible that Jarvis doesn't cache at all, even though queries take over 2000ms all the time?

Note: See TracTickets for help on using tickets.