Problem with Calibre library database

[Drugon]

I'm experiencing the same problem in two differend Windows 10 systems with the same library database (a big one actually, about 16k books).

I received the message:

"The library database at *address* appears to be corrupted.
Do you want calibre to try and rebuild it automatically? The rebuilt may not be completely successful"

I tried out many times but didn't work. Always getting back the same message.

I can open other databases with both systems.

Do you have any ideas, how can I restore my database?

Thank you in advance,
D.

[kovidgoyal]

Post the detailed error message (click the show details button). And what happens when you click restore datbase?

[Drugon]

Thanks for your answer.

When I click "yes", to fix it, it goes slowly (with a message with something in three stages if I remember well) and when it finishes it returns the same error message.

Here are the details:

calibre, version 6.29.0

Traceback (most recent call last):
File "calibre\gui2\ui.py", line 890, in library_moved
File "calibre\db\legacy.py", line 199, in __init__
File "calibre\db\cache.py", line 189, in __init__
File "calibre\db\cache.py", line 471, in initialize_fts
File "calibre\db\cache.py", line 482, in start_fts_pool
File "calibre\db\cache.py", line 85, in call_func_with_lock
File "calibre\db\cache.py", line 594, in queue_next_fts_job
File "calibre\db\cache.py", line 497, in _update_fts_indexing_numbers
File "calibre\db\fts\connect.py", line 70, in number_dirtied
File "calibre\db\fts\connect.py", line 59, in get_connection
File "calibre\db\fts\connect.py", line 47, in initialize
File "calibre\db\backend.py", line 377, in get
File "C:\t\t\apsw-j4twq5fs\src\cursor.c", line 240, in resetcursor
apsw.CorruptError: CorruptError: database disk image is malformed

[kovidgoyal]

quit calibre, delete the full-text-search.db file in the calibre library folder and you should be fine.

[Drugon]

It worked!

Thank you so much, for all your efforts and the great job you do all these years!