Calibre Very Slow - Page 2

theducks · 02-16-2020, 10:59 AM

Quote:

Originally Posted by ladyoflorien

@theducks and @betterred - The insanity was a lot of (thousands of) backslashes (\\\\\\\) in the comments field, at least for the comments fields I was able to edit.

That is a new one. I've seen a few Comments (scraped Descriptions) from standard Metadata sources be made of fragments from other stuff (a hacked source or DB failure? I notified the Indy Publisher, and they fixed it)

Do you have a Cat helper ?

ladyoflorien · 02-16-2020, 02:30 PM

Quote:

Originally Posted by theducks

That is a new one. I've seen a few Comments (scraped Descriptions) from standard Metadata sources be made of fragments from other stuff (a hacked source or DB failure? I notified the Indy Publisher, and they fixed it)

Do you have a Cat helper ?

Hmm, well yes, I have two cat helpers, lol, but I do lock my machine when I'm not using it because of their penchant for helping. I don't think I can blame this on the furballs but possibly it's the "Cleaning Comments" plug-in. I haven't found anyone else mentioning thousands of backslashes in their comments field.

BetterRed · 02-16-2020, 05:24 PM

Quote:

Originally Posted by ladyoflorien

@theducks and @betterred - The insanity was a lot of (thousands of) backslashes (\\\\\\\) in the comments field, at least for the comments fields I was able to edit.

Do you use the JobSpy plugin? If so, maybe the backslashes came from here ?

Click image for larger version

Name: Annotation 2020-02-17 091418.jpg
Views: 370
Size: 226.5 KB
ID: 177191

Not sure why JS equates '\' to undefined/empty/null, or whatever a zero length string is called these days.

BR

ladyoflorien · 02-21-2020, 02:14 PM

Quote:

Originally Posted by BetterRed

Do you use the JobSpy plugin? If so, maybe the backslashes came from here ?

Attachment 177191

Not sure why JS equates '\' to undefined/empty/null, or whatever a zero length string is called these days.

BR

No, I don't use JobSpy.

BetterRed · 02-25-2020, 01:53 AM

Another possibility

select a bunch of books;
do whatever you do to get into Bulk metadata edit;
press the Set the comments for all selected books button (last widget);
up pops the Comments editor dialogue;
press and hold backslash for a while;
click OK or press Alt+K

et voila- a bunch of books get a boatload of backslashes in Comments

BR

idwtgyai · 04-28-2020, 07:54 PM

I had very similar slow behavior, but Calibre also freezes completely.

After some more careful observation, it is very clearly related to at least one specific entry/book. I've tried to fix this using the Library Maintenance feature. Checking the library produced no metadata errors, but the second stage found a problem with this particular entry and fixed it. However, the problem still appears. The "Check library" feature doesn't find any more issues.

Calibre works okay until I try to select this title in the list of books, and then it locks up hard. How can I remove or fix this problem if Calibre freezes every time this entry is visible in the list of titles?

kovidgoyal · 04-28-2020, 10:29 PM

Seems odd that a single book would cause this. But you can use the calibredb command line tool to delete the book. https://manual.calibre-ebook.com/gen...calibredb.html

idwtgyai · 04-28-2020, 11:59 PM

Wow, perfect. Thank you. That worked exactly like I hoped. After removing the offending entry, Calibre seems back to normal.

If I can speculate: seems like this document had a bunch of URL encoded data in the metadata. I noticed that, when I scrolled down to this entry, the tags field, which I do not remember setting, was full of %-encoded text. You may have noticed that I changed the symptom in my report. At one point, I thought the freeze occurred as soon as the entry was visible in the table pane. I killed Calibre and restarted with a small window, then removed the tags field from the visible columns. After this, I think it stopped freezing when the entry was visible, but froze immediately when trying to select the entry. When I look at this document in Evince document vewier, it looks fine, but Evince also hangs for a while when I try to view the document properties. Maybe that information will make some sense to you.

Thank you!!!

02-25-2020, 01:53 AM	#20
BetterRed null operator (he/him) Posts: 20,568 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Another possibility select a bunch of books; do whatever you do to get into Bulk metadata edit; press the Set the comments for all selected books button (last widget); up pops the Comments editor dialogue; press and hold backslash for a while; click OK or press Alt+K et voila- a bunch of books get a boatload of backslashes in Comments BR Attached Thumbnails

04-28-2020, 07:54 PM	#21
idwtgyai Member Posts: 21 Karma: 10 Join Date: Aug 2017 Device: kobo	I had very similar slow behavior, but Calibre also freezes completely. After some more careful observation, it is very clearly related to at least one specific entry/book. I've tried to fix this using the Library Maintenance feature. Checking the library produced no metadata errors, but the second stage found a problem with this particular entry and fixed it. However, the problem still appears. The "Check library" feature doesn't find any more issues. Calibre works okay until I try to select this title in the list of books, and then it locks up hard. How can I remove or fix this problem if Calibre freezes every time this entry is visible in the list of titles? Last edited by idwtgyai; 04-28-2020 at 07:56 PM. Reason: Changed the details of the freeze condition

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre had become very slow	jukin	Calibre	11	07-30-2015 01:41 AM
Calibre 2.4 slow to CC	gbm	Calibre Companion	1	09-26-2014 01:05 PM
PRS-600 Calibre - slow to do everything	lemonstar	Sony Reader	5	02-16-2012 02:56 PM
Calibre very slow	shane.hamilton	Calibre	9	07-21-2010 03:10 PM
calibre - very slow conversion, very slow on PRS	cremofix	Calibre	3	06-10-2009 04:21 PM

04-28-2020, 10:29 PM	#22
kovidgoyal creator of calibre Posts: 43,857 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Seems odd that a single book would cause this. But you can use the calibredb command line tool to delete the book. https://manual.calibre-ebook.com/gen...calibredb.html

04-28-2020, 11:59 PM	#23
idwtgyai Member Posts: 21 Karma: 10 Join Date: Aug 2017 Device: kobo	Wow, perfect. Thank you. That worked exactly like I hoped. After removing the offending entry, Calibre seems back to normal. If I can speculate: seems like this document had a bunch of URL encoded data in the metadata. I noticed that, when I scrolled down to this entry, the tags field, which I do not remember setting, was full of %-encoded text. You may have noticed that I changed the symptom in my report. At one point, I thought the freeze occurred as soon as the entry was visible in the table pane. I killed Calibre and restarted with a small window, then removed the tags field from the visible columns. After this, I think it stopped freezing when the entry was visible, but froze immediately when trying to select the entry. When I look at this document in Evince document vewier, it looks fine, but Evince also hangs for a while when I try to view the document properties. Maybe that information will make some sense to you. Thank you!!!