Error: Unhandled Exception & Can't add books.

[Reader47]

Hello
I was consolidating libraries from several different computers onto my portable external hard drive. I haven't cleaned out doubles yet, so it's about 200K books. Now, when I try to add books from a file or folder, the process starts then just hangs at 0%. Also, when i try to click on any author, series, etc., i get the following:

calibre, version 5.34.0
ERROR: Unhandled exception: <b>MemoryError</b>:

Spoiler:

calibre 5.34 Portable embedded-python: True is64bit: False
Windows-10-10.0.18362 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '10', '10.0.18362')
Python 3.8.5
Windows: ('10', '10.0.18362', '', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Category Tags (0, 1, 3) && Clipboard Search (1, 3, 1) && EpubCheck (0, 2, 4) && EpubMerge (2, 11, 0) && EpubSplit (3, 1, 0) && Find Duplicates (1, 8, 10) && Kindle Collections (1, 7, 29) && Manage Series (1, 2, 11) && Reading List (1, 7, 6)
Traceback (most recent call last):
File "calibre\gui2\library\views.py", line 1357, in search_proxy
File "calibre\gui2\library\models.py", line 495, in search
File "calibre\db\view.py", line 273, in search
File "calibre\db\view.py", line 308, in search_getting_ids
File "calibre\db\cache.py", line 75, in call_func_with_lock
File "calibre\db\cache.py", line 1123, in search
File "calibre\db\search.py", line 932, in __call__
File "calibre\db\search.py", line 994, in _do_search
File "calibre\db\search.py", line 496, in parse
File "calibre\utils\search_query_parser.py", line 365, in parse
File "calibre\utils\search_query_parser.py", line 392, in _parse
File "calibre\utils\search_query_parser.py", line 400, in evaluate
File "calibre\utils\search_query_parser.py", line 449, in evaluate_token
File "calibre\utils\search_query_parser.py", line 453, in _get_matches
File "calibre\db\search.py", line 697, in get_matches
MemoryError

When I tried to run the library repair function, i got this:
calibre, version 5.34.0

Spoiler:

ERROR: Unhandled exception: <b>MemoryError</b>:

calibre 5.34 Portable embedded-python: True is64bit: False
Windows-10-10.0.18362 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '10', '10.0.18362')
Python 3.8.5
Windows: ('10', '10.0.18362', '', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Category Tags (0, 1, 3) && Clipboard Search (1, 3, 1) && EpubCheck (0, 2, 4) && EpubMerge (2, 11, 0) && EpubSplit (3, 1, 0) && Find Duplicates (1, 8, 10) && Kindle Collections (1, 7, 29) && Manage Series (1, 2, 11) && Reading List (1, 7, 6)
Traceback (most recent call last):
File "calibre\gui2\actions\choose_library.py", line 653, in check_library
File "calibre\gui2\ui.py", line 854, in library_moved
File "calibre\db\legacy.py", line 193, in __init__
File "calibre\db\cache.py", line 395, in init
File "calibre\db\backend.py", line 1339, in read_tables
File "calibre\db\tables.py", line 110, in read
MemoryError

I tried copying the entire library into a new folder and opening that one instead, as suggested in a prior post. That produced a separate error.

Any help would be appreciated.
Thank you

[kovidgoyal]

You are running out of ram use the 64bit version of calibre.

[Reader47]

Hello. First, thank you very much for your help.
Second, I really need to run this as portable, off of my external hard drive.
So going off a reply of yours on another question, I replaced the calibre folder in the calibre portable file with the calibre folder from a normal 64 bit version. It opens, but crashed when i tried to click on an author. When I ran "find duplicates", I got this error message:

calibre 5.34 Portable embedded-python: True is64bit: False
Windows-10-10.0.18362 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '10', '10.0.18362')
Python 3.8.5
Windows: ('10', '10.0.18362', '', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Category Tags (0, 1, 3) && Clipboard Search (1, 3, 1) && EpubCheck (0, 2, 4) && EpubMerge (2, 11, 0) && EpubSplit (3, 1, 0) && Find Duplicates (1, 8, 10) && Kindle Collections (1, 7, 29) && Manage Series (1, 2, 11) && Reading List (1, 7, 6)
Traceback (most recent call last):
File "calibre_plugins.find_duplicates.action", line 277, in toolbar_button_clicked
File "calibre_plugins.find_duplicates.action", line 238, in find_book_duplicates
File "calibre_plugins.find_duplicates.duplicates", line 166, in run_book_duplicates_check
File "calibre_plugins.find_duplicates.duplicates", line 184, in _display_run_duplicate_results
File "calibre_plugins.find_duplicates.duplicates", line 303, in show_next_result
File "calibre_plugins.find_duplicates.advanced.__init__ ", line 240, in _update_marked_books
File "calibre\db\view.py", line 382, in set_marked_ids
MemoryError

Is there anything else i can do? Again, thank you for the help.

[theducks]

Originally Posted by Reader47

Hello. First, thank you very much for your help.
Second, I really need to run this as portable, off of my external hard drive.
So going off a reply of yours on another question, I replaced the calibre folder in the calibre portable file with the calibre folder from a normal 64 bit version. It opens, but crashed when i tried to click on an author. When I ran "find duplicates", I got this error message:

calibre 5.34 Portable embedded-python: True is64bit: False
Windows-10-10.0.18362 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '10', '10.0.18362')
Python 3.8.5
Windows: ('10', '10.0.18362', '', 'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Category Tags (0, 1, 3) && Clipboard Search (1, 3, 1) && EpubCheck (0, 2, 4) && EpubMerge (2, 11, 0) && EpubSplit (3, 1, 0) && Find Duplicates (1, 8, 10) && Kindle Collections (1, 7, 29) && Manage Series (1, 2, 11) && Reading List (1, 7, 6)
Traceback (most recent call last):
File "calibre_plugins.find_duplicates.action", line 277, in toolbar_button_clicked
File "calibre_plugins.find_duplicates.action", line 238, in find_book_duplicates
File "calibre_plugins.find_duplicates.duplicates", line 166, in run_book_duplicates_check
File "calibre_plugins.find_duplicates.duplicates", line 184, in _display_run_duplicate_results
File "calibre_plugins.find_duplicates.duplicates", line 303, in show_next_result
File "calibre_plugins.find_duplicates.advanced.__init__ ", line 240, in _update_marked_books
File "calibre\db\view.py", line 382, in set_marked_ids
MemoryError

Is there anything else i can do? Again, thank you for the help.

READ the log (red highlight)
You either have 32 bit installed on the PC or you failed part of the copy . Calibre must NOT be running

[Reader47]

So I had another portable calibre on a USB drive that was linked to the same computer. When I pulled that out, everything started working great. Thanks again for the help!