Problem Reading Library Meta-Data

American_Desi · 03-02-2018, 12:34 AM

All of a sudden I am starting to see library meta data read errors when i access Calibre. Messages that I get include:

ReadOnlyError: Read OnlyError: attempt to write a readonly database

and

Could not set data, click Show Details to see why.

Clicking Show Details gets me this:

Traceback (most recent call last):
File "site-packages/calibre/gui2/library/models.py", line 1091, in setData
File "site-packages/calibre/gui2/library/models.py", line 1166, in _set_data
File "site-packages/calibre/db/legacy.py", line 441, in set
File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock
File "site-packages/calibre/db/cache.py", line 1092, in set_field
File "site-packages/calibre/db/write.py", line 544, in set_books
File "site-packages/calibre/db/write.py", line 208, in set_title
File "site-packages/calibre/db/write.py", line 197, in one_one_in_books
File "site-packages/calibre/db/backend.py", line 856, in executemany
File "src/cursor.c", line 236, in resetcursor
ReadOnlyError: ReadOnlyError: attempt to write a readonly database

Now, the only thing I can think of that I did was, I recently started using Syncplicity to share part of my Calibre library to my laptop. It looked like it worked - I could assess the books on my laptop, but not all of the books (I have 10Gb and my e-book library is 60GB in size) which is what I expected. But now on my host computer, many of my books have ended up in the trash for no explicable reason.

I thought that if I simply did not access the unsynced books and made no changes on the laptop, then both libraries would be fine. But I'm guessing that's not the case. Can anyone suggest a different reason for this issue? If not, how can I rebuild my library? Do I need to manually add each book from trash back into my library?

I've already turned of syncing

theducks · 03-02-2018, 04:29 PM

You are reading the error backwards

You can not write

Sounds like a variation on
https://manual.calibre-ebook.com/faq...n-denied-error

BetterRed · 03-02-2018, 05:38 PM

How did you tell Syncplicity which 'part' of the library to 'share' to the laptop?

BR

American_Desi · 03-03-2018, 12:48 AM

I basically told it to sync the entire E-book folder, but excluded all of the subfolders (sorted based on author) that I did not want synced.

From what I can figure, the file with the metadata somehow go changed, but I didn't think this would happen since I wasn't editing the files on my laptop.

BetterRed · 03-03-2018, 01:32 AM

Was it a one way or a two way (bi-directional) synch, I think every synch tool I've come across defaults to the latter. In which case Syncplicity would have deleted the folders on the desktop to match those on the laptop.

The metadata, as used by calibre, is held in the in the library root in the calibre database (metadata.db), the metadata.opf files in the book folders are there to facilitate restore of the database if it gets corrupted. Did you rebuild the database on the laptop?

I have to ask this - did you backup the library before you used Syncplicity on it?

BR

American_Desi · 03-04-2018, 01:11 AM

I did back up the library and restored it (after turning off syncing) so I'm good now. But I'm still not sure what really happened here. I assume it's bidirectional syncing (via the cloud), but I can't think of anything I did that would cause it to delete lots of e-books. The E-books that were sent to the trash were in the excluded folders.... and strangely enough, their metadata files were still in those excluded folders, but not the source e-book.

American_Desi · 03-04-2018, 01:14 AM

I understand there is a way to sync books via Dropbox but my Dropbox account is only 2 gb whereas Syncplicity gave me 10gb...

I suppose another option is to only sync the 7-8 subfolders of my Calibre library folder, but the problem there is that I would have to create a new Calibre library on my laptop and then move the synced e-books into it.... whereas I would rather prefer a more automatic process that the laptop Calibre automatically understands and accepts that the new books are to be added to its library. I can accept a one-way syncing solution if need be... in retrospect, I think one-way syncing is the default solution unless I tell the laptop calibre to add the destination folder to be synced.

03-02-2018, 12:34 AM	#1
American_Desi Connoisseur Posts: 72 Karma: 10 Join Date: Oct 2016 Device: iPad Pro 12.9"	Problem Reading Library Meta-Data All of a sudden I am starting to see library meta data read errors when i access Calibre. Messages that I get include: ReadOnlyError: Read OnlyError: attempt to write a readonly database and Could not set data, click Show Details to see why. Clicking Show Details gets me this: Traceback (most recent call last): File "site-packages/calibre/gui2/library/models.py", line 1091, in setData File "site-packages/calibre/gui2/library/models.py", line 1166, in _set_data File "site-packages/calibre/db/legacy.py", line 441, in set File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock File "site-packages/calibre/db/cache.py", line 1092, in set_field File "site-packages/calibre/db/write.py", line 544, in set_books File "site-packages/calibre/db/write.py", line 208, in set_title File "site-packages/calibre/db/write.py", line 197, in one_one_in_books File "site-packages/calibre/db/backend.py", line 856, in executemany File "src/cursor.c", line 236, in resetcursor ReadOnlyError: ReadOnlyError: attempt to write a readonly database Now, the only thing I can think of that I did was, I recently started using Syncplicity to share part of my Calibre library to my laptop. It looked like it worked - I could assess the books on my laptop, but not all of the books (I have 10Gb and my e-book library is 60GB in size) which is what I expected. But now on my host computer, many of my books have ended up in the trash for no explicable reason. I thought that if I simply did not access the unsynced books and made no changes on the laptop, then both libraries would be fine. But I'm guessing that's not the case. Can anyone suggest a different reason for this issue? If not, how can I rebuild my library? Do I need to manually add each book from trash back into my library? I've already turned of syncing

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Any way to rebuild meta data for library?	JeremyR	Library Management	2	07-08-2011 05:35 AM
Importing meta data from xml file exported from Google "My Library"	net-buoy	Library Management	0	03-14-2011 06:17 PM
Problem with title meta data	mje1975	Sony Reader	2	02-09-2010 09:30 AM
Order or reading meta data.	krischik	Calibre	3	02-03-2010 02:35 AM
set meta data with ebook-meta and ebook-convert	krischik	Calibre	6	01-19-2010 11:40 AM

03-02-2018, 04:29 PM	#2
theducks Well trained by Cats Posts: 31,047 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	You are reading the error backwards You can not write Sounds like a variation on https://manual.calibre-ebook.com/faq...n-denied-error

03-02-2018, 05:38 PM	#3
BetterRed null operator (he/him) Posts: 21,718 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	How did you tell Syncplicity which 'part' of the library to 'share' to the laptop? BR

03-03-2018, 12:48 AM	#4
American_Desi Connoisseur Posts: 72 Karma: 10 Join Date: Oct 2016 Device: iPad Pro 12.9"	I basically told it to sync the entire E-book folder, but excluded all of the subfolders (sorted based on author) that I did not want synced. From what I can figure, the file with the metadata somehow go changed, but I didn't think this would happen since I wasn't editing the files on my laptop.

03-03-2018, 01:32 AM	#5
BetterRed null operator (he/him) Posts: 21,718 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	Was it a one way or a two way (bi-directional) synch, I think every synch tool I've come across defaults to the latter. In which case Syncplicity would have deleted the folders on the desktop to match those on the laptop. The metadata, as used by calibre, is held in the in the library root in the calibre database (metadata.db), the metadata.opf files in the book folders are there to facilitate restore of the database if it gets corrupted. Did you rebuild the database on the laptop? I have to ask this - did you backup the library before you used Syncplicity on it? BR

03-04-2018, 01:11 AM	#6
American_Desi Connoisseur Posts: 72 Karma: 10 Join Date: Oct 2016 Device: iPad Pro 12.9"	I did back up the library and restored it (after turning off syncing) so I'm good now. But I'm still not sure what really happened here. I assume it's bidirectional syncing (via the cloud), but I can't think of anything I did that would cause it to delete lots of e-books. The E-books that were sent to the trash were in the excluded folders.... and strangely enough, their metadata files were still in those excluded folders, but not the source e-book.

03-04-2018, 01:14 AM	#7
American_Desi Connoisseur Posts: 72 Karma: 10 Join Date: Oct 2016 Device: iPad Pro 12.9"	I understand there is a way to sync books via Dropbox but my Dropbox account is only 2 gb whereas Syncplicity gave me 10gb... I suppose another option is to only sync the 7-8 subfolders of my Calibre library folder, but the problem there is that I would have to create a new Calibre library on my laptop and then move the synced e-books into it.... whereas I would rather prefer a more automatic process that the laptop Calibre automatically understands and accepts that the new books are to be added to its library. I can accept a one-way syncing solution if need be... in retrospect, I think one-way syncing is the default solution unless I tell the laptop calibre to add the destination folder to be synced.

Advert

Advert