Hello,
I've got a problem lately with my main library. From time to time, when I try to check the database, I've got a message like this:
Spoiler:
calibre, version 8.16.0
ERROR: Falló: La comprobación de la integridad de la base de datos falló, pulsar «Mostrar detalles» para más información.
Traceback (most recent call last):
File "calibre\gui2\dialogs\check_library.py", line 114, in vacuum
File "calibre\db\cache.py", line 86, in call_func_with_lock
File "calibre\db\cache.py", line 2828, in vacuum
File "calibre\db\backend.py", line 1451, in vacuum
File "calibre\db\backend.py", line 1174, in execute
File "C:\t\t\apsw-nmn6uadm\src\cursor.c", line 189, in resetcursor
apsw.SQLError: cannot VACUUM from within a transaction
The main problem is that, from time to time, I lose the metadata changes in the library, I guess due to some problem like this. Which can be the issue? We're talking about 17000 books, with composite columns.