Certain books repeatedly disappear from library

[Josh Meares]

I'm using Windows 7 64-bit, fully patched.
I'm using Calibre 2.27 [64-bit]

Here is the problem. For some reason, 40 books (or so) repeatedly disappear from my library. I don't change anything. The ebook files and folders are still in the My Library location. But they are lost to the Calibre database / display.

I have added them again using the Restore Database several times. This finds almost all of them (except for 20 or so that failed with the following error, "ConstraintError: ConstraintError: UNIQUE constraint failed: [name of constraint violated]" ... none of these books exist at all in the calibre database. For those, I have to go to go through the Add Books process)

The database restore adds "re-finds" 35 books. Though it doesn't find any more ID's or UUID's (according to a catalog created before and after the restore). I'm not sure what happens. It's almost like the database is corrupt somehow.

I have tried upgrading Calibre a few times. issue still occurs. I have tried uninstalling Calibre and re-installing it. I have moved the library to a different location. I didn't notice at first, so I can't tell you exactly what version, but this has been a problem for at least 6 months for me.

[Kovid Goyal (kovid)]

Make sure nothing is accessing your calibre library folder at the same
time as calibre. Common culprits are file sync programs like dropbox and
antivirus programs (try excluding your calibre library folder from the
antivirus).

Make sure your library folder is not on a network drive or a non-native
filesystem.

If you have installed any third party plugins in calibre,
disable/uninstall them.

If I'm reading your bug report right you're saying that after you
restore the missing books they disappear again, repeatedly? If so, try
to pin down what operation is causing calibre to lose track of them.

[Josh Meares (josh-meares)]

I read some more, which led me to believe that the opf files might be the
issue.

I deleted all the .opf files and re-added all the books and I got all the
books and no errors.
I will be paying attention and I will reply when and if these books
disappear again.

Thanks,
sjoh

On Sun, Jul 19, 2015 at 11:38 AM, Kovid Goyal <email address hidden>
wrote:

> Make sure nothing is accessing your calibre library folder at the same
> time as calibre. Common culprits are file sync programs like dropbox and
> antivirus programs (try excluding your calibre library folder from the
> antivirus).
>
> Make sure your library folder is not on a network drive or a non-native
> filesystem.
>
> If you have installed any third party plugins in calibre,
> disable/uninstall them.
>
> If I'm reading your bug report right you're saying that after you
> restore the missing books they disappear again, repeatedly? If so, try
> to pin down what operation is causing calibre to lose track of them.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1475939
>
> Title:
> Certain books repeatedly disappear from library
>
> Status in calibre:
> New
>
> Bug description:
> I'm using Windows 7 64-bit, fully patched.
> I'm using Calibre 2.27 [64-bit]
>
> Here is the problem. For some reason, 40 books (or so) repeatedly
> disappear from my library. I don't change anything. The ebook files
> and folders are still in the My Library location. But they are lost to
> the Calibre database / display.
>
> I have added them again using the Restore Database several times. This
> finds almost all of them (except for 20 or so that failed with the
> following error, "ConstraintError: ConstraintError: UNIQUE constraint
> failed: [name of constraint violated]" ... none of these books exist
> at all in the calibre database. For those, I have to go to go through
> the Add Books process)
>
> The database restore adds "re-finds" 35 books. Though it doesn't find
> any more ID's or UUID's (according to a catalog created before and
> after the restore). I'm not sure what happens. It's almost like the
> database is corrupt somehow.
>
> I have tried upgrading Calibre a few times. issue still occurs. I
> have tried uninstalling Calibre and re-installing it. I have moved the
> library to a different location. I didn't notice at first, so I can't
> tell you exactly what version, but this has been a problem for at
> least 6 months for me.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/calibre/+bug/1475939/+subscriptions
>