Error: Connection is busy in another thread

[Metapath]

Is there a problem with creating an Export of the library in Calibre 9.8?

I've done this for many years, making an Export of my library from my Windows 11 machine and importing it to my Linux Mint machine. Today I'm getting a failure to import after just a few seconds:

calibre, version 9.8.0*ERROR: Failed: Failed to import data. Click "Show details" for more information.
Traceback (most recent call last):*File "calibre\gui2\dialogs\exim.py", line 156, in run_action*File "calibre\utils\exim.py", line 478, in import_data*File "calibre\db\cache.py", line 3804, in import_library*File "calibre\db\cache.py", line 1863, in update_path*File "calibre\db\backend.py", line 2076, in update_path*File "calibre\db\backend.py", line 2008, in update_paths_in_db*apsw.ThreadingViolationError: Connection is busy in another thread

The reason I suspect the creation of the Export files is that I have an older version of Calibre (version 9.6) and I get the same error on import. I've tried re-exporting the data and making sure Calibre is closed before coping the files to a flash drive. I've tried importing the files to Linux Mint as well as several Windows 11 machines and i always get the error message.

Any ideas?

[kovidgoyal]

There are no changes to export/import in 9.8 or 9.7 or 9.6. You likely have a third party plugin installed causing issues. Run as calibre --ignore-plugins

[Metapath]

Originally Posted by kovidgoyal

There are no changes to export/import in 9.8 or 9.7 or 9.6. You likely have a third party plugin installed causing issues. Run as calibre --ignore-plugins

Thanks Kovid, i'll give that a try.
There was a new plugin i tried out week, but I removed it before doing the export.

[Metapath]

Originally Posted by Metapath

Thanks Kovid, i'll give that a try.
There was a new plugin i tried out week, but I removed it before doing the export.

The --ignore-plugins argument took care of the issue. Thanks again.
Still a mystery why the problem persisted after removal of the offending plugin (Count Pages).
I'll spend some time rebuilding a new library and test after each new plugin, just in case it was a different plug-in.

[JSWolf]

Originally Posted by Metapath

The --ignore-plugins argument took care of the issue. Thanks again.
Still a mystery why the problem persisted after removal of the offending plugin (Count Pages).
I'll spend some time rebuilding a new library and test after each new plugin, just in case it was a different plug-in.

It's not Count Pages. I've been using that for a very long time with no issues.

[theducks]

If it is as you say. Count pages is running into a BAD BOOK while running that is tripping things.

If you did not start a count job, then it is not running. It needs to open each (selected) book, to do the count. No job, no counting.

[Metapath]

Thanks for the input guys. I've installed Count Pages again. However, I have one remaining issue, if you don't mind helping...(should this be posted in the Plugins section?)

When I click Download from selected (or all) sources, I get the following error:
Could not analyze some statistics – No identifiers for selected download sources

I have tried adding additional sources but still get the error. I even recreated the custom columns in Calibre using floating point numbers instead of integers.

Any ideas what causes the error?
Thanks again.

[theducks]

Originally Posted by Metapath

Thanks for the input guys. I've installed Count Pages again. However, I have one remaining issue, if you don't mind helping...(should this be posted in the Plugins section?)

When I click Download from selected (or all) sources, I get the following error:
Could not analyze some statistics – No identifiers for selected download sources

I have tried adding additional sources but still get the error. I even recreated the custom columns in Calibre using floating point numbers instead of integers.

Any ideas what causes the error?
Thanks again.

{identifiers} is a standard column. ISBN:1234567890123 is an EXAMPLE entry.There are others that may do better depending on country

[Metapath]

Originally Posted by theducks

{identifiers} is a standard column. ISBN:1234567890123 is an EXAMPLE entry.There are others that may do better depending on country

Thank you, but I don't understand how that helps me get rid of the error message. I notice there is an Identifiers column on the Other page of the Customize Plugin window, but no clue what to do. It's checked for the sources I'm interested in (as is the Display source column)...

[thiago.eec]

Originally Posted by Metapath

Thank you, but I don't understand how that helps me get rid of the error message. I notice there is an Identifiers column on the Other page of the Customize Plugin window, but no clue what to do. It's checked for the sources I'm interested in (as is the Display source column)...

To be able to find the page count for a given book, the plugin checks the identifiers field and look for the corresponding one. Let's say you want to use Goodreads as a source for you page count: then you need to have a Goodreads identifier in your indentifiers field (you can have multiple values there, like mobi-asin, amazon.com, ISBN, etc).

The Goodreads identifier will be something like this: 'goodreads:52968035'. To obtain this identifier, you need to have Goodreads configured as a metadata source, and download the metadata for that book. The identifier will be filled automatically.

After that, the Count Page plugin can fetch the page count correctly.

[JSWolf]

However, Goodreads is rather wonky with their metadata. So I would not accept the page numbers it gives.

[theducks]

Originally Posted by Metapath

Thank you, but I don't understand how that helps me get rid of the error message. I notice there is an Identifiers column on the Other page of the Customize Plugin window, but no clue what to do. It's checked for the sources I'm interested in (as is the Display source column)...

Because the message said you did not have one SET for that book. AKA Blank or non-standard. (yes you can have your own in that field. MyLib:shelf3 is a valid identifier but no one else has a clue

If it could not find pages for the one set, the message would be different (if at all): none found

[Metapath]

Thanks all. I'll just stick to letting CP do its own thing without reference to other sources.

Finally figured out that "Identifiers" refers to what Calibre calls "Ids" in the metadata. Why I would need to add one specifically for Goodreads other than the isbn I don't understand (but don't need to).

Thanks again for the help.

[DNSB]

Originally Posted by Metapath

Thanks all. I'll just stick to letting CP do its own thing without reference to other sources.

Finally figured out that "Identifiers" refers to what Calibre calls "Ids" in the metadata. Why I would need to add one specifically for Goodreads other than the isbn I don't understand (but don't need to).

There are quite a few books on Goodreads which are Amazon specific ebook only. Those do not have an ISBN. Either a Goodreads ID or an Amazon ASIN are needed to allow easily locating any information.