Linux Max number of items in database?
#1
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.
Reply
#2
And now, for no reason at all (I've done nothing to fix the problem), it works again. Or well, I have added 4 episodes and a few movies since then, but nothing else.

I just don't get it Smile
Reply
#3
There is definitely no limit. If you're getting a corrupt database then it's likely caused by a crash situation leaving the database in a screwed up state - ofcourse, catching it is essentially not possible unless it's reproducible, and these type of things normally aren't.

My only suggestion is to export to a separate file/folder structure so you can quickly reimport.
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
#4
Ok, thanks for the reply. I'll just start making more regular backups of the database so I can restore if the worst happens.
Reply
#5
What kind of database is it running off of?
Reply

Logout Mark Read Team Forum Stats Members Help
Max number of items in database?0