[fernandovg]

XBMC (13.0-ALPHA12 Git:20140130-e9998cd). Platform: ARM Linux 32-bit
Using Release XBMC x32 build, compiled Jan 30 2014 by GCC 4.7.1 for ARM Linux 32-bit 3.2.21
Running on Linux 32-bit (Debian GNU/Linux 7.0 (wheezy), 3.10.21 armv6l)
Raspbmc
miappa build: http://forum.xbmc.org/showthread.php?tid...pid1615387

Whenever I delete an episode from library, then choose to not delete the physical file and re-enter again the tv-show, XBMC crashes.
After XBMC restated I navigate to Videos. Deleted the physical file

Code:

Log file line 2814: FileManager: delete  /media/SAMSUNG/Divx/.....

Navigate again to that tv-show. XBMC crashes
Last log line is the query to list the episodes from that tv-show

Code:

21:38:44 92185.101562 T:2753557568   DEBUG: RunQuery took 204 ms for 0 items query: SELECT episodeview.c12, path.strPath, tvshowview.c00, tvshowview.c01, tvshowview.c05, tvshowview.c08, tvshowview.c14, tvshowview.c13, seasons.idSeason, count(1), count(files.playCount) FROM episodeview JOIN tvshowview ON tvshowview.idShow = episodeview.idShow JOIN seasons ON (seasons.idShow = tvshowview.idShow AND seasons.season = episodeview.c12) JOIN files ON files.idFile = episodeview.idFile JOIN tvshowlinkpath ON tvshowlinkpath.idShow = tvshowview.idShow JOIN path ON path.idPath = tvshowlinkpath.idPath WHERE tvshowview.idShow = 83 GROUP BY episodeview.c12

UPDATE: fixed with https://github.com/xbmc/xbmc/pull/4185
thanks!

[fernandovg]

Still happening with 31/Jan build

How to reproduce:
- Delete an episode (in my case there's only one episode - always)
- Exit that tv-show library
- Uncheck "hide watched"
- Enter tv-show that was deteted
- XBMC crashes

[fernandovg]

The query runs ok in the .db file (using Sqlite database browser).
It runs empty as there's no more episodes to watch.

Also, XBMC don't scrap that episode again. The .mkv file still exists but it don't recognize.
I have to remove the tv-show from library (without deleting the physical file), do a library scan and then it recognizes.

[fernandovg]

edited

[un1versal]

I tried this and it seems to work as expected... Its not beta 12 its alpha12 btw. My Linux is 64bit and its not Debian so your clew may be this, or something else. I just noticed its raspbmc so like its platform specific issue which is why I replied here.

[fernandovg]

Thanks for the reply

[fernandovg]

What happens when XBMC tries to execute a query on videodb and the database is locked? Is there a try:except or something to handle the locked db? I think this is the issue. Xbmc crashes after the second query (after enter any tvshow library item)
I tried clean db and also change scrapper (rescanned everything). Nothing works.

I got this before delete from library:

Code:

22:37:04 11821.722656 T:2659185728   DEBUG: RunQuery took 110 ms for 1 items query: SELECT episodeview.c12, path.strPath, tvshowview.c00, tvshowview.c01, tvshowview.c05, tvshowview.c08, tvshowview.c14, tvshowview.c13, seasons.idSeason, count(1), count(files.playCount) FROM episodeview JOIN tvshowview ON tvshowview.idShow = episodeview.idShow JOIN seasons ON (seasons.idShow = tvshowview.idShow AND seasons.season = episodeview.c12) JOIN files ON files.idFile = episodeview.idFile JOIN tvshowlinkpath ON tvshowlinkpath.idShow = tvshowview.idShow JOIN path ON path.idPath = tvshowlinkpath.idPath WHERE tvshowview.idShow = 24 GROUP BY episodeview.c12
22:37:04 11821.802734 T:2659185728   DEBUG: RunQuery took 78 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie WHERE movielinktvshow.idShow = 24
22:37:04 11821.832031 T:2659185728 WARNING: GetIcon - Unknown nodetype requested videodb://tvshows/tags/4/24/2/?tagid=4&tvshowid=24
22:37:04 11821.889648 T:3038863360   DEBUG: CGUIMediaWindow::GetDirectory (videodb://tvshows/tags/4/24/-2/?tagid=4&tvshowid=24)
22:37:04 11821.889648 T:3038863360   DEBUG:   ParentPath = [videodb://tvshows/tags/4/]
22:37:04 11821.933594 T:2659185728   DEBUG: GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=24) order by idShow
22:37:04 11821.954102 T:2659185728   DEBUG: Previous line repeats 1 times.
22:37:04 11821.954102 T:2659185728   DEBUG: RunQuery took 7 ms for 1 items query: select * from episodeview  WHERE episodeview.idShow = 24
22:37:04 11821.975586 T:2659185728   DEBUG: RunQuery took 19 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie WHERE movielinktvshow.idShow = 24