What would cause Calibre to lose database changes on exit?

ownedbycats · 08-29-2021, 02:49 PM

Sometime on Friday, I built from source and launched Calibre. I've had it running since then I think.

Today, I closed Calibre in order to pull some new fixes. Upon restarting I found that all the database changes I made since Friday had disappeared (including several new books that were still in the library files).

I don't run on NAS or cloud storage. I checked the database and there were no errors. I'm currently running a restore database from the OPFs in the hopes that it'll put things back.

No changes to my security software; if this month's Windows Update changed anything security-wise, I would have expected I'd see the issue before now.

Also no indications that it's a drive issue, but I'll have to do a proper scan later.

georgemk · 08-29-2021, 02:58 PM

After closing Calibre, did you immediately shutdown the OS too? If so it may not have had time to write out changes from memory to disk.

ownedbycats · 08-29-2021, 03:06 PM

No. I don't reboot very often.

I did notice that the OPFs seem to have the correct last modified dates. So hoping restore database fixes things. It's taking a while.

I'll test to see if it happens again once that's done.

jhowell · 08-29-2021, 04:13 PM

Have you used the Last Modified plugin?

Perhaps this is relevant: apsw.ThreadingViolationError and cache.write_lock

ownedbycats · 08-29-2021, 04:16 PM

I do use it. I think I updated to the fixed version but I'll have to double-check.

EDIT: Database restoration finished; it did fix my metadata. As for Last Modified, I downloaded the new version but forgot to install it. I wonder if that has anything to do with it.

SECOND EDIT: I asked.

ownedbycats · 08-29-2021, 05:38 PM

Another possibility, though it does feel a bit far-fetched to me:

Could accidentally unplugging a device* while sending metadata to it break the Calibre database? I checked my Kobo's db and it was fine so I didn't think much of it.

*I've been having a few connectivity issues, and I had a brain-fart and didn't realize it had connected. I'm an idiot sometimes.

kovidgoyal · 08-29-2021, 09:59 PM

No device issues can possibly affect the calibre database.

ownedbycats · 08-29-2021, 11:03 PM

OK so I can rule that out.

08-29-2021, 02:49 PM	#1
ownedbycats Custom User Title Posts: 10,973 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	What would cause Calibre to lose database changes on exit? Sometime on Friday, I built from source and launched Calibre. I've had it running since then I think. Today, I closed Calibre in order to pull some new fixes. Upon restarting I found that all the database changes I made since Friday had disappeared (including several new books that were still in the library files). I don't run on NAS or cloud storage. I checked the database and there were no errors. I'm currently running a restore database from the OPFs in the hopes that it'll put things back. No changes to my security software; if this month's Windows Update changed anything security-wise, I would have expected I'd see the issue before now. Also no indications that it's a drive issue, but I'll have to do a proper scan later.

08-29-2021, 03:06 PM	#3
ownedbycats Custom User Title Posts: 10,973 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	No. I don't reboot very often. I did notice that the OPFs seem to have the correct last modified dates. So hoping restore database fixes things. It's taking a while. I'll test to see if it happens again once that's done. Last edited by ownedbycats; 08-29-2021 at 03:11 PM.

08-29-2021, 04:16 PM	#5
ownedbycats Custom User Title Posts: 10,973 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I do use it. I think I updated to the fixed version but I'll have to double-check. EDIT: Database restoration finished; it did fix my metadata. As for Last Modified, I downloaded the new version but forgot to install it. I wonder if that has anything to do with it. SECOND EDIT: I asked. Last edited by ownedbycats; 08-29-2021 at 04:41 PM.

08-29-2021, 05:38 PM	#6
ownedbycats Custom User Title Posts: 10,973 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Another possibility, though it does feel a bit far-fetched to me: Could accidentally unplugging a device* while sending metadata to it break the Calibre database? I checked my Kobo's db and it was fine so I didn't think much of it. I've been having a few connectivity issues, and I had a brain-fart and didn't realize it had* connected. I'm an idiot sometimes. Last edited by ownedbycats; 08-29-2021 at 05:47 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to exit Calibre reader	sse450	Calibre	7	11-19-2019 09:33 AM
How to exit calibre?	SvenLotus	Calibre	4	09-17-2019 09:49 AM
how to exit calibre-debug	botmtl	Development	4	08-26-2018 01:15 AM
How to properly exit Calibre	wahoo123	Calibre	4	11-26-2012 11:07 AM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM

08-29-2021, 02:58 PM	#2
georgemk Addict Posts: 243 Karma: 291844 Join Date: Oct 2019 Device: Kobo Nia	After closing Calibre, did you immediately shutdown the OS too? If so it may not have had time to write out changes from memory to disk.

08-29-2021, 04:13 PM	#4
jhowell Grand Sorcerer Posts: 7,071 Karma: 91577715 Join Date: Nov 2011 Location: Charlottesville, VA Device: Kindles	Have you used the Last Modified plugin? Perhaps this is relevant: apsw.ThreadingViolationError and cache.write_lock

08-29-2021, 09:59 PM	#7
kovidgoyal creator of calibre Posts: 45,347 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No device issues can possibly affect the calibre database.

08-29-2021, 11:03 PM	#8
ownedbycats Custom User Title Posts: 10,973 Karma: 75337983 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	OK so I can rule that out.

Advert

Advert