2012-08-21, 17:25
For many years I've been an avid user of XBMC, which has always worked perfectly.
It's running XBMC 11.0 (Compiled Mar 24 2012 to be precise) on Ubuntu 11.10 (XBMCbuntu)
However, the last few months parts of the videodb has collapsed several times (the recently added episodes part). This is what comes up in xbmc.log (however, the corruption happened earlier, so I have no logs for that):
17:19:17 T:3016939280 DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 0
17:19:17 T:3016939280 DEBUG: OnKey: return (f00d) pressed, action is Select
17:19:17 T:3016939280 DEBUG: CGUIMediaWindow::GetDirectory (videodb://5/)
17:19:17 T:3016939280 DEBUG: ParentPath = []
17:19:17 T:2863004528 DEBUG: RunQuery took 1 ms for 35 items query: select * from episodeview order by idEpisode desc limit 35
17:19:17 T:2863004528 ERROR: SQL: The database disk image is malformed
Query: SELECT * FROM streamdetails WHERE idFile = 10292
17:19:17 T:2863004528 ERROR: GetEpisodesByWhere failed
17:19:17 T:3016939280 ERROR: GetDirectory - Error getting videodb://5/
17:19:17 T:3016939280 ERROR: CGUIMediaWindow::GetDirectory(videodb://5/) failed
17:19:17 T:3016939280 DEBUG: CGUIMediaWindow::GetDirectory ()
17:19:17 T:3016939280 DEBUG: ParentPath = []
17:19:17 T:2958982000 DEBUG: Thread Background Loader start, auto delete: 0
17:19:17 T:2958982000 DEBUG: Thread Background Loader 2958982000 terminating
17:19:17 T:3016939280 INFO: Loading skin file: DialogOK.xml
17:19:17 T:3016939280 DEBUG: ------ Window Init (DialogOK.xml) ------
This was never an issue before, but once I started getting a fairly large collection (something like 15k items), it has started occuring at an alarming rate.
Now, my question is, have I hit some limit? Should I swap to MySQL as a backend instead of sqlite?
The best fix for this seems to be deleting myvideos60.db and rescanning, but just the scan cycle takes several hours to complete and it only catches about half my content, so it's not a working longtime solution.
I'm not whining about the product here, I love it and have no intention to swap. I just want the "Recently added" to work like it should. Any easy fix is also acceptable, as long as I don't have to rescan the library.
It's running XBMC 11.0 (Compiled Mar 24 2012 to be precise) on Ubuntu 11.10 (XBMCbuntu)
However, the last few months parts of the videodb has collapsed several times (the recently added episodes part). This is what comes up in xbmc.log (however, the corruption happened earlier, so I have no logs for that):
17:19:17 T:3016939280 DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 0
17:19:17 T:3016939280 DEBUG: OnKey: return (f00d) pressed, action is Select
17:19:17 T:3016939280 DEBUG: CGUIMediaWindow::GetDirectory (videodb://5/)
17:19:17 T:3016939280 DEBUG: ParentPath = []
17:19:17 T:2863004528 DEBUG: RunQuery took 1 ms for 35 items query: select * from episodeview order by idEpisode desc limit 35
17:19:17 T:2863004528 ERROR: SQL: The database disk image is malformed
Query: SELECT * FROM streamdetails WHERE idFile = 10292
17:19:17 T:2863004528 ERROR: GetEpisodesByWhere failed
17:19:17 T:3016939280 ERROR: GetDirectory - Error getting videodb://5/
17:19:17 T:3016939280 ERROR: CGUIMediaWindow::GetDirectory(videodb://5/) failed
17:19:17 T:3016939280 DEBUG: CGUIMediaWindow::GetDirectory ()
17:19:17 T:3016939280 DEBUG: ParentPath = []
17:19:17 T:2958982000 DEBUG: Thread Background Loader start, auto delete: 0
17:19:17 T:2958982000 DEBUG: Thread Background Loader 2958982000 terminating
17:19:17 T:3016939280 INFO: Loading skin file: DialogOK.xml
17:19:17 T:3016939280 DEBUG: ------ Window Init (DialogOK.xml) ------
This was never an issue before, but once I started getting a fairly large collection (something like 15k items), it has started occuring at an alarming rate.
Now, my question is, have I hit some limit? Should I swap to MySQL as a backend instead of sqlite?
The best fix for this seems to be deleting myvideos60.db and rescanning, but just the scan cycle takes several hours to complete and it only catches about half my content, so it's not a working longtime solution.
I'm not whining about the product here, I love it and have no intention to swap. I just want the "Recently added" to work like it should. Any easy fix is also acceptable, as long as I don't have to rescan the library.