"Clean Library" corrupting myvideos34.db

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #1
I was hoping someone might be able to help. I'm running the latest version of Dharma and the Cirrus Extended skin in Windows 7 32-bit. I've been encountering a problem where when I run the "clean library" request, it is corrupting myvideos34.db. All of a sudden my TV Shows and Movies disappears from my home screen.

This has resulted in me having to do a full re-scan of my library (a PITA to say the least...since I customize the fan art, etc). Once my re-scan was complete, I backed up all of the.db files (in case they got corrupted again).

Well, today I deleted a few movies from my NAS, then booted XBMC and ran "clean library" again...guess what...it corrupted myvideos34.db again!! (good thing I had a backup). Anyone else encountering this issue? Is there some sort of fix or something I should be aware of?
find quote
Philmatic Offline
Fan
Posts: 432
Joined: Nov 2009
Reputation: 0
Location: Elk Grove, CA
Post: #2
If it's reproducible, can you turn on debug logging then clean the library again? If it results in a corrupted db, the the debug log should be able to tell us why.

Living Room: Dell Optiplex 755 / Intel C2D E6550 / 4GB Ram / NVIDIA GT 430 / LiteOn BD-ROM / Harmony 700 / XBMC B2 on Win 8 Pro
Bedroom: Dell Optiplex 755 / Intel C2D E6550 / 4GB Ram / NVIDIA GT 520 / LiteOn BD-ROM / Harmony 650 / XBMC B2 on Win 8 Pro
Windows Home Server: Intel Core i3-2100T / 8GB Ram / 20TB / MySQL / StableBit DrivePool on WHS 2011
find quote
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #3
Philmatic Wrote:If it's reproducible, can you turn on debug logging then clean the library again? If it results in a corrupted db, the the debug log should be able to tell us why.

Please excuse the total N00b question....how do I turn on debug mode and where is that log file found (so I can copy and paste it here).
find quote
gabbott Offline
Team-XBMC Member
Posts: 1,547
Joined: Jul 2007
Reputation: 26
Post: #4
Dr.Know Wrote:Please excuse the total N00b question....how do I turn on debug mode and where is that log file found (so I can copy and paste it here).

a bit down in this post explains it:

http://forum.xbmc.org/showthread.php?tid=42708
find quote
Philmatic Offline
Fan
Posts: 432
Joined: Nov 2009
Reputation: 0
Location: Elk Grove, CA
Post: #5
From the sticky thread:

Jester Wrote:Where is my (debug) log?
IMPORTANT! The normal XBMC log IS NOT a debug log, to enable debug logging you must toggle it on under XBMC Settings - System.
The location depends on your windows version:

1. Windows Xp: Documents and Settings\[user]\Application Data\XBMC\xbmc.log
2. Vista/Win7: Users\[user]\AppData\Roaming\XBMC\xbmc.log

If you start XBMC in "portable" mode (with the -p commandline argument) then the log will be in the XBMC folder itself.

Living Room: Dell Optiplex 755 / Intel C2D E6550 / 4GB Ram / NVIDIA GT 430 / LiteOn BD-ROM / Harmony 700 / XBMC B2 on Win 8 Pro
Bedroom: Dell Optiplex 755 / Intel C2D E6550 / 4GB Ram / NVIDIA GT 520 / LiteOn BD-ROM / Harmony 650 / XBMC B2 on Win 8 Pro
Windows Home Server: Intel Core i3-2100T / 8GB Ram / 20TB / MySQL / StableBit DrivePool on WHS 2011
find quote
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #6
Okay, here's my xbmc.log file after turning on debugging. I was able to replicate the problem. I turned on debugging and then did a "clean library". Once it was done, my Movies and TV Shows disappeared.

http://pastebin.com/xEXpzffX
find quote
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #7
Can anyone help??
find quote
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #8
Bump

I still need some help on this. I ended up exporting my entire library to a file and uninstalling xbmc 10.1 and then reinstalling it. Then I imported my library from file. Once it was completed, I then did a "clean library"....same thing happened...Movies and TV Shows disappeared. This is getting really annoying!
find quote
isamu.dragon Offline
Posting Freak
Posts: 949
Joined: Feb 2009
Reputation: 4
Location: T.A.R.D.I.S.
Post: #9
Stupid question, are you using the PVR branchConfused?
Quote:20:22:09 T:1760 M:2987073536 ERROR: Error evaluating boolean expression !PVR.IsRecording + PVR.HasTimer
Cause that may be your problem

[Image: all-fanart.jpg]
XBMC Server/Client:
Database Type: MySQL
OS: WIN7 64-Bit/XBMCuntu CPU: i7/Intel Atom (Dual Core)
GPU: Nvidia GeForce GTS450/Nvidia Ion RAM: 12GB/2GB (512MB GPU)
XBMC Version: Frodo 12.2/XBMCbuntu Frodo 12.2Skin: Aeon Nox
find quote
Dr.Know Offline
Junior Member
Posts: 20
Joined: Apr 2011
Reputation: 0
Post: #10
isamu.dragon Wrote:Stupid question, are you using the PVR branchConfused?

Cause that may be your problem

No, I am not using the PVR branch....how do I go about turning it off?
find quote
Post Reply