quarnster / boxeebox-xbmc

Aiming to get xbmc up and running on the boxee box
Other
118 stars 44 forks source link

Corrupt videos DB causes crash #148

Open gmerrall opened 9 years ago

gmerrall commented 9 years ago

Moved from running XMBC on SD Card to over NFS. I just copied the files over and kept on trucking. All media files were stored on same point on NAS so in theory everything should just keep humming along.

Every time I opened a library directory, XMBC would crash and restart Boxee. Looking in the xbmc log revealed the following:

15:21:00 T:144547840 ERROR: SQL: The database disk image is malformed Query: ...

Regretably the specific SQL has rolled from the logs. However the steps seem quote simple to replicate

  1. Create an initial TV database
  2. Corrupt it in some way. Manually mess with it?
  3. Browse to Videos and select Library
  4. Attempt to open the library with the corrupted DB

Manually removing and rebuilding the corrupted DB solved the problem.