Help! Database corrupted

thrak · 05-15-2023, 05:12 PM

Running Calibre on my Mac, the power cycled and now Calibre says my library is corrupted. It asks if I want it to try and rebuild it. I tell it to go ahead. It gives me an error, saying that "Restoring database failed." When I look at the details, it says:

Traceback (most recent call last):
File "calibre/db/restore.py", line 151, in run
Exception: Something bad happened

What do I try now? The library and its files exist. It looks like the database is bad. Can I fix it? Or, can I somehow import the books into another library?

The books still exist, so it's not a total loss. I would hate to have to enter them all again by hand.

Any ideas? Thanks in advance.

thrak

thrak · 05-15-2023, 05:20 PM

Aha! I just tried adding books to a new library. It asked me for a folder and it's grinding away now. That looks like the solution to my problem. I'll know for sure in a few hours.

georgemk · 05-16-2023, 08:25 AM

@thrak
If your database has corrupted itself once then in all likelihood it will happen again unless you find the root cause.

Please ensure that the directories where Calibre is storing its data is not on a NAS device or a One drive/idrive/google/any old cloud based backup system. Any system that has a 2 way backup /sync will cause corruption at some point.

JSWolf · 05-16-2023, 10:20 AM

Quote:

Originally Posted by georgemk

@thrak
If your database has corrupted itself once then in all likelihood it will happen again unless you find the root cause.

Please ensure that the directories where Calibre is storing its data is not on a NAS device or a One drive/idrive/google/any old cloud based backup system. Any system that has a 2 way backup /sync will cause corruption at some point.

If you read the OP's first post, the database became corrupted when the computer power cycled.

georgemk · 05-16-2023, 12:02 PM

yes John, I missed that bit so I'm sorry I posted.Really sorry.

p.s. looking forward to you apologising when you don't read all the thread or miss out 1 bit of information which happens an awful lot.

Bookstooge · 05-17-2023, 05:50 AM

Quote:

Originally Posted by georgemk

yes John, I missed that bit so I'm sorry I posted.Really sorry.

p.s. looking forward to you apologising when you don't read all the thread or miss out 1 bit of information which happens an awful lot.

I have yet to see him EVER apologize. Even when he is blatantly in the wrong. The most we can hope for is a timeout for him harassing members with his behavior.

nica · 07-06-2023, 08:55 AM

Quote:

Originally Posted by georgemk

@thrak
If your database has corrupted itself once then in all likelihood it will happen again unless you find the root cause.

Please ensure that the directories where Calibre is storing its data is not on a NAS device or a One drive/idrive/google/any old cloud based backup system. Any system that has a 2 way backup /sync will cause corruption at some point.

Any idea how to start looking for the root cause?

ownedbycats · 07-06-2023, 10:50 AM

Memtest and hard drive health check are a good place to start. I don't know of tools to do that for Mac, though.

05-15-2023, 05:12 PM	#1
thrak Junior Member Posts: 2 Karma: 10 Join Date: May 2023 Device: Kindle	Help! Database corrupted Running Calibre on my Mac, the power cycled and now Calibre says my library is corrupted. It asks if I want it to try and rebuild it. I tell it to go ahead. It gives me an error, saying that "Restoring database failed." When I look at the details, it says: Traceback (most recent call last): File "calibre/db/restore.py", line 151, in run Exception: Something bad happened What do I try now? The library and its files exist. It looks like the database is bad. Can I fix it? Or, can I somehow import the books into another library? The books still exist, so it's not a total loss. I would hate to have to enter them all again by hand. Any ideas? Thanks in advance. thrak

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Corrupted database	Ktz	Library Management	3	08-30-2016 09:22 AM
And..... Again my database is corrupted	Mondriaan	Devices	15	01-16-2016 12:05 AM
Corrupted database	Qylie	Calibre	8	08-28-2014 02:02 AM
Database Corrupted	karimnaguib	Calibre	2	05-12-2014 09:19 AM
Corrupted Database	chilady1	Library Management	20	11-12-2013 08:13 PM

05-15-2023, 05:20 PM	#2
thrak Junior Member Posts: 2 Karma: 10 Join Date: May 2023 Device: Kindle	Aha! I just tried adding books to a new library. It asked me for a folder and it's grinding away now. That looks like the solution to my problem. I'll know for sure in a few hours.

05-16-2023, 08:25 AM	#3
georgemk Addict Posts: 243 Karma: 291844 Join Date: Oct 2019 Device: Kobo Nia	@thrak If your database has corrupted itself once then in all likelihood it will happen again unless you find the root cause. Please ensure that the directories where Calibre is storing its data is not on a NAS device or a One drive/idrive/google/any old cloud based backup system. Any system that has a 2 way backup /sync will cause corruption at some point.

05-16-2023, 12:02 PM	#5
georgemk Addict Posts: 243 Karma: 291844 Join Date: Oct 2019 Device: Kobo Nia	yes John, I missed that bit so I'm sorry I posted.Really sorry. p.s. looking forward to you apologising when you don't read all the thread or miss out 1 bit of information which happens an awful lot.

07-06-2023, 10:50 AM	#8
ownedbycats Custom User Title Posts: 10,948 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Memtest and hard drive health check are a good place to start. I don't know of tools to do that for Mac, though.

Advert

Advert