"Cleaning database" message pops up in nightly
#1
I have xbmc set up to retrieve new data on startup, hide library updates, and advancedsettings clean database on update. Up until recently this all happened seamless, I never got any on screen messages which is the way I want it. However, in the recent nightlies after xbmc finishes cleaning the database I get a pop up message on the screen that says "cleaning database, this may take a few moments" or something to that affect, an then the slider goes from 0-100%. I don't want this to happen in the middle of playing a video. Did something change recently and how do I go about turning off this message now?
Reply
#2
Could be a recent change, yeah. Please post a bug report on trac with details as you've done here. A Debug Log should show the dialog popping up (search for "Init").

cc vdrfan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
Entire log:
http://pastebin.com/qiDqyH6K

Perhaps this is the part you're looking for?

20:18:38 T:4152 NOTICE: CVideoDatabase::CleanDatabase: Starting videodatabase cleanup ..
20:18:38 T:4152 INFO: Loading skin file: DialogProgress.xml
20:18:38 T:4152 DEBUG: DialogProgress::StartModal called
20:18:38 T:4152 DEBUG: ------ Window Init (DialogProgress.xml) ------
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning files table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning streamdetails table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning bookmark table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning settings table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning stacktimes table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning paths that don't exist and have content set...
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning tvshow table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning actorlinktvshow table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning directorlinktvshow table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning tvshowlinkpath table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning genrelinktvshow table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning seasons table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning movielinktvshow table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning path table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning genre table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning country table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning actor table of actors, directors and writers
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning studio table
20:18:39 T:4152 DEBUG: CVideoDatabase::CleanDatabase: Cleaning set table
20:18:39 T:4152 NOTICE: CVideoDatabase::CleanDatabase: Cleaning videodatabase done. Operation took 00:00
20:18:39 T:4152 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:09
20:18:39 T:4152 DEBUG: CAnnouncementManager - Announcement: OnScanFinished from xbmc
20:18:39 T:4152 DEBUG: GOT ANNOUNCEMENT, type: 8, from xbmc, message OnScanFinished
20:18:39 T:5180 DEBUG: CRecentlyAddedJob::UpdateVideos() - Running RecentlyAdded home screen update
20:18:39 T:4152 DEBUG: Thread CVideoInfoScanner 4152 terminating
20:18:39 T:5180 DEBUG: CVideoDatabase::RunQuery took 33 ms for 10 items query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
20:18:39 T:588 DEBUG: CThumbExtractor:Big GrinoWork - trying to extract filestream details from video file I:\Movies\Project.X.2012.1080p.BluRay.x264.DTS-HDC\Project.X.2012.1080p.BluRay.x264.DTS-HDC.mkv
20:18:39 T:588 DEBUG: CDVDDemuxFFmpeg::Open - probing detected format [matroska,webm]
20:18:39 T:5180 DEBUG: CVideoDatabase::RunQuery took 48 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
20:18:39 T:588 DEBUG: CDVDDemuxFFmpeg::Open - avformat_find_stream_info starting
20:18:39 T:6080 DEBUG: ------ Window Deinit (DialogProgress.xml) ------
20:18:39 T:5180 DEBUG: CVideoDatabase::GetMusicVideosByWhere query = select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
20:18:39 T:5180 DEBUG: CVideoDatabase::GetMusicVideosByWhere time for actual SQL query = 0
20:18:39 T:5180 DEBUG: CRecentlyAddedJob::UpdateTotal() - Running RecentlyAdded home screen update
20:18:39 T:588 DEBUG: CDVDDemuxFFmpeg::Open - av_find_stream_info finished
20:18:39 T:588 INFO: ffmpeg[24C]: Input #0, matroska,webm, from 'I:\Movies\Project.X.2012.1080p.BluRay.x264.DTS-HDC\Project.X.2012.1080p.BluRay.x264.DTS-HDC.mkv':
20:18:39 T:588 INFO: ffmpeg[24C]: Duration: 01:32:59.78, start: 0.000000, bitrate: 15161 kb/s
20:18:39 T:588 INFO: ffmpeg[24C]: Stream #0:0(eng): Video: h264 (High), yuv420p, 1920x1080 [SAR 1:1 DAR 16:9], 23.98 fps, 23.98 tbr, 1k tbn, 47.95 tbc (default)
20:18:39 T:588 INFO: ffmpeg[24C]: Stream #0:1: Audio: dts (DTS), 48000 Hz, 5.1(side), s16, 1536 kb/s (default)
20:18:39 T:588 DEBUG: CThumbExtractor:Big GrinoWork - trying to extract thumb from video file J:\TV Series\The Soup\the.soup.2012.05.30.720p.hdtv.x264-killers.mkv
20:18:39 T:588 DEBUG: CDVDDemuxFFmpeg::Open - probing detected format [matroska,webm]
20:18:39 T:588 DEBUG: CDVDDemuxFFmpeg::Open - avformat_find_stream_info starting
20:18:40 T:588 DEBUG: CDVDDemuxFFmpeg::Open - av_find_stream_info finished
20:18:40 T:588 INFO: ffmpeg[24C]: Input #0, matroska,webm, from 'J:\TV Series\The Soup\the.soup.2012.05.30.720p.hdtv.x264-killers.mkv':
20:18:40 T:588 INFO: ffmpeg[24C]: Duration: 00:21:31.35, start: 0.000000, bitrate: 2230 kb/s
20:18:40 T:588 INFO: ffmpeg[24C]: Stream #0:0(eng): Video: h264 (High), yuv420p, 1280x720, SAR 1:1 DAR 16:9, 29.97 fps, 29.97 tbr, 1k tbn, 59.94 tbc (default)
20:18:40 T:588 INFO: ffmpeg[24C]: Stream #0:1: Audio: ac3, 48000 Hz, stereo, s16, 384 kb/s (default)
20:18:40 T:588 DEBUG: CDVDFactoryCodec: compiled in hardware support: CrystalHD:yes DXVA:yes
20:18:40 T:588 DEBUG: FactoryCodec - Video: - Opening
20:18:40 T:588 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/players/dvdplayer/swscale-2.dll)
20:18:40 T:588 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/players/dvdplayer/swresample-0.dll)
20:18:40 T:588 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/players/dvdplayer/avfilter-2.dll)
20:18:40 T:588 NOTICE: CDVDVideoCodecFFmpeg::Open() Using codec: H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10
20:18:40 T:588 DEBUG: FactoryCodec - Video: ff-h264 - Opened
20:18:40 T:588 DEBUG: CDVDFileInfo::ExtractThumb - seeking to pos 430452ms (total: 1291356ms) in J:\TV Series\The Soup\the.soup.2012.05.30.720p.hdtv.x264-killers.mkv
20:18:40 T:588 DEBUG: CDVDDemuxFFmpeg::SeekTime - seek ended up on time 423089
20:18:40 T:588 DEBUG: ffmpeg[24C]: [swscaler] Warning: data is not aligned! This can lead to a speedloss
20:18:40 T:588 DEBUG: CDVDFileInfo::ExtractThumb - measured 484 ms to extract thumb from file <J:\TV Series\The Soup\the.soup.2012.05.30.720p.hdtv.x264-killers.mkv>
20:18:48 T:6080 DEBUG: Keyboard: scancode: 5b, sym: 0137, unicode: 0000, modifier: 10
20:18:48 T:6080 DEBUG: CApplication::OnKey: win-leftwindows (10f0d6) pressed, action is
20:18:49 T:6080 DEBUG: CWinEventsWin32::WndProcWindow is inactive
20:19:00 T:6080 DEBUG: Previous line repeats 1 times.
20:19:00 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/ImageLib.dll)
20:19:01 T:6080 INFO: XCURL:Big GrinllLibCurlGlobal::CheckIdle - Closing session to http://feeds.feedburner.com (easy=003E8CA8, multi=00A97A58)
20:19:07 T:6080 INFO: XCURL:Big GrinllLibCurlGlobal::CheckIdle - Closing session to http://thetvdb.com (easy=0E913008, multi=00A97D88)
20:19:08 T:6080 INFO: XCURL:Big GrinllLibCurlGlobal::CheckIdle - Closing session to http://www.thetvdb.com (easy=0E91FDD0, multi=00A97E98)
20:19:09 T:6080 INFO: XCURL:Big GrinllLibCurlGlobal::CheckIdle - Closing session to http://api.themoviedb.org (easy=0EA40BD8, multi=00A97FA8)
20:19:09 T:2056 DEBUG: Thread Jobworker 2056 terminating (autodelete)
20:19:09 T:5180 DEBUG: Thread Jobworker 5180 terminating (autodelete)
20:19:10 T:588 DEBUG: Thread Jobworker 588 terminating (autodelete)
20:19:10 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/avutil-51.dll)
20:19:11 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/avcodec-53.dll)
20:19:11 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/avformat-53.dll)
20:19:12 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/swscale-2.dll)
20:19:12 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/swresample-0.dll)
20:19:13 T:6080 DEBUG: SECTION:UnloadDelayed(DLL: special://xbmcbin/system/players/dvdplayer/avfilter-2.dll)
Reply
#4
Yup - please post it on trac and cc vdrfan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#5
lol, I'll have to figure out what that means first. I know trac is some kind of bug reporting site for xbmc but never used it before.
Reply
#6
Just wanted to let you know, this problem has not been fixed yet. Still using Eden full time because the pop up messages are a deal breaker.
Reply
#7
Still present in latest nightlies, I'm hoping this is at least fixed before Frodo final hits?
Reply
#8
Did you post a bug-report on trac?
Frodo is still in developement, so you shouldn't expect too fast bug-fixing, because the devs have their workload full.
If the bug is being recognized it will get fixed before a final hits.

If you didn't post a bug-report yet, you can do so with the help of this how-to:
http://wiki.xbmc.org/?title=HOW-TO_Submi...Bug_Report
Need help? Check out my XBMC Frodo Guide. It contains full featured guides to Sickbeard and CouchPotato as well.

Image
Reply
#9
Still isn't fixed in Alpha 7.
Reply
#10
Is there a bug report on trac? We don't remember months old forum topics Smile

trac.xbmc.org
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#11
http://trac.xbmc.org/ticket/13547
Reply
#12
Just wanted to comment that this has been bugging me for a few months as well, I have seen this post but never did my part to help file a bug or anything. If you need anything else to get this resolved let me know and I can help out.
Reply
#13
I'm still getting this in RC2, I've got library updates hidden but whenever a clean occurs it pops up on screen. I wouldn't mind if it was just like the library updating notification where it disappears when you are playing a video and you can browse about XBMC normally. But it's an intrusive popup that prevents you from moving about XBMC or watching a video.
Reply
#14
5 years later and this issue still persists on V17.
Reply
#15
Your original trac ticket got closed with a status of 'Fixed' so the developers thought it was solved. Looking at the code changes, they added a new variable that determines if progress should be shown or not which makes sense but my coding skill is not good enough to tell why that new logic doesn't work.

I think it would be best to create a new ticket because of the age of the old one. Any maybe don't wait 5 years to mention the fix doesn't work next time :p Big Grin
Reply

Logout Mark Read Team Forum Stats Members Help
"Cleaning database" message pops up in nightly2