Calibre 2.58 hanging with El Capitan

ursog · 06-11-2016, 01:45 PM

Hi
Calibre has started to hang, no recent upgrades, but I have added about 5000 books. My library is about 28000 books.

I uninstalled Calibre and created an empty library, it worked fine.

Then, I redirected library to where all my books were stored and Calibre started to hang again with spinning wheel.

I noticed that after about 15 -30 minutes, it stops hanging for about 10 seconds which is long enough for me to shut it down.

Any ideas how to fix?
Thanks
ursog

theducks · 06-11-2016, 01:58 PM

Quote:

Originally Posted by ursog

Hi
Calibre has started to hang, no recent upgrades, but I have added about 5000 books. My library is about 28000 books.

I uninstalled Calibre and created an empty library, it worked fine.

Then, I redirected library to where all my books were stored and Calibre started to hang again with spinning wheel.

I noticed that after about 15 -30 minutes, it stops hanging for about 10 seconds which is long enough for me to shut it down.

Any ideas how to fix?
Thanks
ursog

WAIT FOR KOVID. Do not attempt anything until he responds

I suspect the DB is damaged. Kovid will confirm (or deney), but he will have a good idea on a SIMPLE recovery.

If YOU try things without a plan, recovery can be difficult

kovidgoyal · 06-11-2016, 11:06 PM

First disable/uninstall all third party plugins you might have installed in calibre. Make sure your library is on an internal hard disk and not a network share/external harddisk with non-native filesystem.

Use the process monitor in your system to see which process if any is busy/using cpu.

DaltonST · 06-12-2016, 10:18 AM

@ursog:

Your metadata.db could easily be 100 times larger than it needs to be given your statements about numbers of books, and also assuming you updated their metadata frequently.

I suggest that you defragment/compress/vacuum the metadata.db file, and also do a file-system defrag on it.

To vacuum the metadata.db file from a batch file so you do not have to suffer a 30 minute wait for doing a "Library Maintenance > Check Library", try this with changes for OSX path conventions and the true name of your library.

Code:

calibre-debug -c "from calibre.library.database2 import LibraryDatabase2; db = LibraryDatabase2('S:\Calibre\QS\QuarantineAndScrub_Test0');db.conn.execute('VACUUM'); db.conn.close();"

Afterwards, defrag metadata.db in OSX.

DaltonST

06-11-2016, 01:45 PM	#1
ursog Junior Member Posts: 1 Karma: 10 Join Date: Jun 2016 Device: iPad	Calibre 2.58 hanging with El Capitan Hi Calibre has started to hang, no recent upgrades, but I have added about 5000 books. My library is about 28000 books. I uninstalled Calibre and created an empty library, it worked fine. Then, I redirected library to where all my books were stored and Calibre started to hang again with spinning wheel. I noticed that after about 15 -30 minutes, it stops hanging for about 10 seconds which is long enough for me to shut it down. Any ideas how to fix? Thanks ursog

06-12-2016, 10:18 AM	#4
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	@ursog: Your metadata.db could easily be 100 times larger than it needs to be given your statements about numbers of books, and also assuming you updated their metadata frequently. I suggest that you defragment/compress/vacuum the metadata.db file, and also do a file-system defrag on it. To vacuum the metadata.db file from a batch file so you do not have to suffer a 30 minute wait for doing a "Library Maintenance > Check Library", try this with changes for OSX path conventions and the true name of your library. Code: calibre-debug -c "from calibre.library.database2 import LibraryDatabase2; db = LibraryDatabase2('S:\Calibre\QS\QuarantineAndScrub_Test0');db.conn.execute('VACUUM'); db.conn.close();" Afterwards, defrag metadata.db in OSX. DaltonST

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data loss in 0.9.5 on OS X (El Capitan)	Peter Ahlstrom	Sigil	20	06-21-2023 03:06 PM
Kindle Previewer and OS X EL CAPITAN	Macsurfcat	Kindle Formats	8	04-08-2016 07:22 AM
Calibre get & conversion disabled in Win10 & Mac El Capitan	sandysot	Devices	8	01-24-2016 03:52 AM
Calibre: Sony and Nook hanging - related problem?	rickyg103	Devices	4	04-12-2011 01:46 PM
Calibre is hanging while downloading the news	Flint	Recipes	0	03-29-2011 08:14 AM

06-11-2016, 11:06 PM	#3
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	First disable/uninstall all third party plugins you might have installed in calibre. Make sure your library is on an internal hard disk and not a network share/external harddisk with non-native filesystem. Use the process monitor in your system to see which process if any is busy/using cpu.

Advert