Database Failure

RichardGH · 07-23-2012, 04:31 AM

Anyone know why Calibre regularly corrupts its own database when adding new metadata and the rebuild never works ?

DoctorOhh · 07-23-2012, 05:43 AM

Quote:

Originally Posted by RichardGH

Anyone know why Calibre regularly corrupts its own database when adding new metadata and the rebuild never works ?

Since calibre does not "regularly" corrupt its own database you are going to have to give us more info. What OS? What version of calibre? exactly what are you doing when this happens?

I have used calibre for years and have never once had a corrupted database.

theducks · 07-23-2012, 09:16 AM

In addition to Walt's question:

Are you keeping your Library on a removable/Network drive?

RichardGH · 07-23-2012, 11:44 AM

Unfortuately I have had at least three corrupted databases and I am not using a removable or network drive. My system is Windows 7 Pro based and Calibre version 0.8.50. And I am about to manually rebuild the database for the 4th time. There are 242 books in the database and corruption is always associated with downloading new metadata. In each case it has been after a new book was added and the rebuild option has not worked.

RichardGH · 07-23-2012, 11:47 AM

Sorry I should have added that the corruption occurs when the metadata popup is closed - by pressing ok - to make the addition.

itimpi · 07-23-2012, 11:51 AM

This is definitely not a behaviour I have seen in several years of heavy use of Calibre and I also use Windows 7 Pro. It sounds as if on your system there is something interfering with Calibre's disk access.

One thing that occurs to me - have you excluded the Calibre library from checking with your Anti-Virus software? I did this to improve performance, and because eBooks are not something that needs checking for a virus.

theducks · 07-23-2012, 09:34 PM

adding to Itimpi
Books are normally checked by A/V before adding (the browser/mail download folders should never be excluded).

RichardGH · 07-24-2012, 04:04 AM

I use Virgin Media's own A/V and upgraded Defender Firewall. They should alert me before taking any action. The metadate does seem to download and the problem I think occurs when I accept it and Calibre tries to add it to the main database. By the way the library files are storred on a different disk to the program files as is my normal practice. That disk is a normal fixed disk connected directly to a motherboard sata port.

Does anyone know how to manually repair the database ? Possibly by using the databse engine.

itimpi · 07-24-2012, 07:05 AM

I tried the Virgin Media A/V software but it caused me problems with the AV software interfering with normal program execution.. I switched to Microsoft Security Essentials and that seemed to solve the problems I was encountering.

RichardGH · 07-25-2012, 05:59 AM

Thanks itimpi, I think you have solved it. I transfered all files to another computer not using the Virgin Media A/V and recovered everything immediately. I then transfered the restored files back to my main machine and can use Calibre again. It certainly looks like a clash with the VM protection. I will log that with their help desk, not that I expect any action from them, but it might help someone else.
Many thanks

07-23-2012, 04:31 AM	#1
RichardGH Junior Member Posts: 5 Karma: 10 Join Date: Jul 2012 Device: Sony PRS600	Database Failure Anyone know why Calibre regularly corrupts its own database when adding new metadata and the rebuild never works ?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PRS-T1 Sorry - Failure - must close ??	amyb	Sony Reader	0	12-05-2011 08:45 PM
Serious firmware or database failure in Kobo Wireless - help!	tigeraid	Kobo Reader	5	09-27-2011 10:13 PM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM
Email failure	daesdaemar	Calibre	0	02-04-2011 04:56 PM
Conversion Failure	edbro	Calibre	1	02-27-2010 02:31 PM

07-23-2012, 09:16 AM	#3
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	In addition to Walt's question: Are you keeping your Library on a removable/Network drive?

07-23-2012, 11:44 AM	#4
RichardGH Junior Member Posts: 5 Karma: 10 Join Date: Jul 2012 Device: Sony PRS600	Unfortuately I have had at least three corrupted databases and I am not using a removable or network drive. My system is Windows 7 Pro based and Calibre version 0.8.50. And I am about to manually rebuild the database for the 4th time. There are 242 books in the database and corruption is always associated with downloading new metadata. In each case it has been after a new book was added and the rebuild option has not worked.

07-23-2012, 11:47 AM	#5
RichardGH Junior Member Posts: 5 Karma: 10 Join Date: Jul 2012 Device: Sony PRS600	Sorry I should have added that the corruption occurs when the metadata popup is closed - by pressing ok - to make the addition.

07-23-2012, 11:51 AM	#6
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	This is definitely not a behaviour I have seen in several years of heavy use of Calibre and I also use Windows 7 Pro. It sounds as if on your system there is something interfering with Calibre's disk access. One thing that occurs to me - have you excluded the Calibre library from checking with your Anti-Virus software? I did this to improve performance, and because eBooks are not something that needs checking for a virus.

07-23-2012, 09:34 PM	#7
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	adding to Itimpi Books are normally checked by A/V before adding (the browser/mail download folders should never be excluded).

07-24-2012, 04:04 AM	#8
RichardGH Junior Member Posts: 5 Karma: 10 Join Date: Jul 2012 Device: Sony PRS600	I use Virgin Media's own A/V and upgraded Defender Firewall. They should alert me before taking any action. The metadate does seem to download and the problem I think occurs when I accept it and Calibre tries to add it to the main database. By the way the library files are storred on a different disk to the program files as is my normal practice. That disk is a normal fixed disk connected directly to a motherboard sata port. Does anyone know how to manually repair the database ? Possibly by using the databse engine.

07-24-2012, 07:05 AM	#9
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	I tried the Virgin Media A/V software but it caused me problems with the AV software interfering with normal program execution.. I switched to Microsoft Security Essentials and that seemed to solve the problems I was encountering.

07-25-2012, 05:59 AM	#10
RichardGH Junior Member Posts: 5 Karma: 10 Join Date: Jul 2012 Device: Sony PRS600	Thanks itimpi, I think you have solved it. I transfered all files to another computer not using the Virgin Media A/V and recovered everything immediately. I then transfered the restored files back to my main machine and can use Calibre again. It certainly looks like a clash with the VM protection. I will log that with their help desk, not that I expect any action from them, but it might help someone else. Many thanks

Advert

Advert