Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 06-11-2016, 01:45 PM   #1
ursog
Junior Member
ursog began at the beginning.
 
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
ursog is offline   Reply With Quote
Old 06-11-2016, 01:58 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 26,648
Karma: 41726679
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Aura2, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by ursog View Post
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
theducks is offline   Reply With Quote
Advert
Old 06-11-2016, 11:06 PM   #3
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 39,778
Karma: 17764952
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.
kovidgoyal is offline   Reply With Quote
Old 06-12-2016, 10:18 AM   #4
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 1,880
Karma: 1804640
Join Date: Aug 2013
Location: Texas
Device: 10" Win10 Tablet w/Calibre64, CalibreSpy & Freda+
@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
DaltonST is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data loss in 0.9.5 on OS X (El Capitan) Peter Ahlstrom Sigil 17 05-17-2016 03:27 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


All times are GMT -4. The time now is 06:09 AM.


MobileRead.com is a privately owned, operated and funded community.