Solved XBMC alpha 12 - crashing after removing episode from library
#1
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 4185 (PR)
thanks!
Image
Reply
#2
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
Image
Reply
#3
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.
Image
Reply
#4
edited
Image
Reply
#5
I tried this and it seems to work as expected... Big Grin Its not beta 12 its alpha12 btw. Wink 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.
Reply
#6
Thanks for the reply
Image
Reply
#7
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
Image
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
XBMC alpha 12 - crashing after removing episode from library00
This forum uses Lukasz Tkacz MyBB addons.