problem after upgrading from 0.8.7 to 0.8.8

ElizabethN · 07-03-2011, 12:14 PM

I upgraded calibre to 0.8.8 today and am now having difficulty opening my main library. 3 out of 4 libraries switch with no problems but I get the following message when I try to access my main library.

calibre, version 0.8.8
ERROR: Unhandled exception: <b>DatabaseException</b>:duplicate column name: link
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 268, in run
OperationalError: duplicate column name: link

Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 300, in dispatch
File "site-packages\calibre\gui2\actions\choose_library.py", line 362, in switch_requested
File "site-packages\calibre\gui2\ui.py", line 478, in library_moved
File "site-packages\calibre\library\database2.py", line 194, in __init__
File "site-packages\calibre\library\schema_upgrades.py", line 24, in __init__
File "site-packages\calibre\library\schema_upgrades.py", line 611, in upgrade_version_20
File "site-packages\calibre\library\sqlite.py", line 308, in run
DatabaseException: duplicate column name: link
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 268, in run
OperationalError: duplicate column name: link

Something I can fix or do I need to un-install & re-install calibre?

Thanks for your help

kovidgoyal · 07-03-2011, 12:16 PM

Attach the metadata.db file from your main library.

ElizabethN · 07-03-2011, 12:36 PM

I just tried to attach the .db file and was informed that it was an invalid attachment. Do I need to temporarily change the file type in order to upload it?

Plus that library now has a .db and an .db.tmp , latter probably created when calibre informed me that my database was corrupt after upgrading.

theducks · 07-03-2011, 12:50 PM

Quote:

Originally Posted by ElizabethN

I just tried to attach the .db file and was informed that it was an invalid attachment. Do I need to temporarily change the file type in order to upload it?

Plus that library now has a .db and an .db.tmp , latter probably created when calibre informed me that my database was corrupt after upgrading.

Zip it up ,then MR will allow that attachment type.

ElizabethN · 07-03-2011, 01:04 PM

thanks! should be attached now.

fyi - I'm on windows 7 - 64 running 0.8.7 through last night with no reported problems - closed 0.8.7 with current problem library as the active library.

upgraded to 0.8.8 this am - when calibre launched I was given a choice of repairing my database or opening an empty library. I tried repair and was eventually told that the library couldn't be repaired.

kovidgoyal · 07-03-2011, 01:11 PM

Here's a fixed metadata.db (just replace the existing one, with this one and you should be fine)

ElizabethN · 07-03-2011, 01:21 PM

worked, opened that library with no problem

thanks for the extremely rapid help

HarryT · 07-03-2011, 05:32 PM

What was the cause of the problem, Kovid?

kovidgoyal · 07-03-2011, 05:50 PM

A bug in the db schema upgrade which could cause the db to remain in an inconsistent state if calibre is interrupted (crash/power failure) at just the wrong moment.

HarryT · 07-04-2011, 04:38 AM

Thanks. Sounds like there's no reason to be concerned about it then!

jiffy128 · 07-04-2011, 08:12 AM

I have had the issue about corrupt database which was not able to be recovered but in going from 0.86 to 0.87

Version 0.88 has since been released.

Can I get round this database issue just by installing 0.88 or have I lost all my metadata work?

kovidgoyal · 07-04-2011, 09:31 AM

There weren't any database schema changes between 0.8.6 and 0.8.7, so you cannot have had this issue.

jiffy128 · 07-05-2011, 07:32 AM

Then it must have been from 0.8.7 to 0.8.8 then sorry.

There have been so many recent amendments I have lost track I suppose.

kovidgoyal · 07-05-2011, 11:23 AM

Post the error message you get.

Mickey330 · 07-05-2011, 04:37 PM

Hi, Kovid -

I have just received this error. I did it to myself - forgot to close Calibre 0.8.7 before I started running the installation of 0.8.8. Stoooopid me!

Anyway, I got the same results as the prior poster - corrupted, can't fix, open with blank library. So, I go to Calibre and try to change libraries (mine's in Dropbox). I get this:

calibre, version 0.8.8
ERROR: Unhandled exception: <b>DatabaseException</b>:duplicate column name: link
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 268, in run
OperationalError: duplicate column name: link

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\choose_library.py", line 106, in accept
File "site-packages\calibre\gui2\dialogs\choose_library.py", line 81, in perform_action
File "site-packages\calibre\gui2\actions\choose_library.py", line 406, in choose_library_callback
File "site-packages\calibre\gui2\ui.py", line 478, in library_moved
File "site-packages\calibre\library\database2.py", line 194, in __init__
File "site-packages\calibre\library\schema_upgrades.py", line 24, in __init__
File "site-packages\calibre\library\schema_upgrades.py", line 611, in upgrade_version_20
File "site-packages\calibre\library\sqlite.py", line 308, in run
DatabaseException: duplicate column name: link
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 268, in run
OperationalError: duplicate column name: link

I see you provided a .db file to the OP. Can I use that? If so, where do I put it (and, I assume I just remove the .zip part, cause it won't UNzip).

If my assumptions above are wrong - please help me fix my idiotic error?

Thanks.

Marilyn

07-03-2011, 12:14 PM	#1
ElizabethN reader, ebook junkie Posts: 110 Karma: 436806 Join Date: Dec 2007 Location: western nebraska Device: in use kindle oasis 2nd and 3rd gen, kobo forma, boox poke5	problem after upgrading from 0.8.7 to 0.8.8 I upgraded calibre to 0.8.8 today and am now having difficulty opening my main library. 3 out of 4 libraries switch with no problems but I get the following message when I try to access my main library. calibre, version 0.8.8 ERROR: Unhandled exception: <b>DatabaseException</b>:duplicate column name: link RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 268, in run OperationalError: duplicate column name: link Traceback (most recent call last): File "site-packages\calibre\gui2\__init__.py", line 300, in dispatch File "site-packages\calibre\gui2\actions\choose_library.py", line 362, in switch_requested File "site-packages\calibre\gui2\ui.py", line 478, in library_moved File "site-packages\calibre\library\database2.py", line 194, in __init__ File "site-packages\calibre\library\schema_upgrades.py", line 24, in __init__ File "site-packages\calibre\library\schema_upgrades.py", line 611, in upgrade_version_20 File "site-packages\calibre\library\sqlite.py", line 308, in run DatabaseException: duplicate column name: link RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 268, in run OperationalError: duplicate column name: link Something I can fix or do I need to un-install & re-install calibre? Thanks for your help

07-04-2011, 08:12 AM	#11
jiffy128 Junior Member Posts: 3 Karma: 10 Join Date: Jul 2011 Device: Kindle	Corrupt database I have had the issue about corrupt database which was not able to be recovered but in going from 0.86 to 0.87 Version 0.88 has since been released. Can I get round this database issue just by installing 0.88 or have I lost all my metadata work?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem upgrading to 7.51 or 7.52	speakingtohe	Calibre	13	03-28-2011 01:38 PM
Opus Problem Upgrading Opus	Adri	Bookeen	18	02-20-2011 06:15 AM
problem upgrading	GA Russell	Calibre	4	09-29-2010 05:22 PM
Problem upgrading to last version	trustno12003	Calibre	0	12-26-2008 07:36 AM
Problem upgrading	capinredbeard	iRex	4	02-12-2008 02:02 AM

07-03-2011, 12:16 PM	#2
kovidgoyal creator of calibre Posts: 43,881 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Attach the metadata.db file from your main library.

07-03-2011, 12:36 PM	#3
ElizabethN reader, ebook junkie Posts: 110 Karma: 436806 Join Date: Dec 2007 Location: western nebraska Device: in use kindle oasis 2nd and 3rd gen, kobo forma, boox poke5	I just tried to attach the .db file and was informed that it was an invalid attachment. Do I need to temporarily change the file type in order to upload it? Plus that library now has a .db and an .db.tmp , latter probably created when calibre informed me that my database was corrupt after upgrading.

07-03-2011, 01:21 PM	#7
ElizabethN reader, ebook junkie Posts: 110 Karma: 436806 Join Date: Dec 2007 Location: western nebraska Device: in use kindle oasis 2nd and 3rd gen, kobo forma, boox poke5	worked, opened that library with no problem thanks for the extremely rapid help

07-03-2011, 05:32 PM	#8
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383043 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	What was the cause of the problem, Kovid?

07-03-2011, 05:50 PM	#9
kovidgoyal creator of calibre Posts: 43,881 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	A bug in the db schema upgrade which could cause the db to remain in an inconsistent state if calibre is interrupted (crash/power failure) at just the wrong moment.

07-04-2011, 04:38 AM	#10
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383043 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	Thanks. Sounds like there's no reason to be concerned about it then!

07-04-2011, 09:31 AM	#12
kovidgoyal creator of calibre Posts: 43,881 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	There weren't any database schema changes between 0.8.6 and 0.8.7, so you cannot have had this issue.

07-05-2011, 07:32 AM	#13
jiffy128 Junior Member Posts: 3 Karma: 10 Join Date: Jul 2011 Device: Kindle	Then it must have been from 0.8.7 to 0.8.8 then sorry. There have been so many recent amendments I have lost track I suppose.

07-05-2011, 11:23 AM	#14
kovidgoyal creator of calibre Posts: 43,881 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Post the error message you get.

07-05-2011, 04:37 PM	#15
Mickey330 Addict Posts: 378 Karma: 1107420 Join Date: Dec 2009 Location: Western New York state (USA) Device: Kindle Oasis & the Kindle app on iDevices	Hi, Kovid - I have just received this error. I did it to myself - forgot to close Calibre 0.8.7 before I started running the installation of 0.8.8. Stoooopid me! Anyway, I got the same results as the prior poster - corrupted, can't fix, open with blank library. So, I go to Calibre and try to change libraries (mine's in Dropbox). I get this: calibre, version 0.8.8 ERROR: Unhandled exception: <b>DatabaseException</b>:duplicate column name: link RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 268, in run OperationalError: duplicate column name: link Traceback (most recent call last): File "site-packages\calibre\gui2\dialogs\choose_library.py", line 106, in accept File "site-packages\calibre\gui2\dialogs\choose_library.py", line 81, in perform_action File "site-packages\calibre\gui2\actions\choose_library.py", line 406, in choose_library_callback File "site-packages\calibre\gui2\ui.py", line 478, in library_moved File "site-packages\calibre\library\database2.py", line 194, in __init__ File "site-packages\calibre\library\schema_upgrades.py", line 24, in __init__ File "site-packages\calibre\library\schema_upgrades.py", line 611, in upgrade_version_20 File "site-packages\calibre\library\sqlite.py", line 308, in run DatabaseException: duplicate column name: link RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 268, in run OperationalError: duplicate column name: link I see you provided a .db file to the OP. Can I use that? If so, where do I put it (and, I assume I just remove the .zip part, cause it won't UNzip). If my assumptions above are wrong - please help me fix my idiotic error? Thanks. Marilyn

Advert

Advert