https://bugs.kde.org/show_bug.cgi?id=486755
Bug ID: 486755
Summary: images.album = NULL without reason (disappearing
images in DK)
Classification: Applications
Product: digikam
Version: 8.3.0
Platform: openSUSE
OS: Linux
Status: REPORTED
Severity: critical
Priority: NOR
Component: Database-Mysql
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
SUMMARY
I'm using mariadb SQL with over 100k images. It seems like Digikam looses
images and albums over time, the images however are still present in the file
system
What I've figured out so far:
- The column "album" of the table "Images" contains sometimes NULL. These
images are not visible anymore in DK (since they don't belong to an album
anymore), however the image still exists on the file system
- Over time, the amount of images with album=NULL increases. In 2021, none of
my images had album=NULL, now in 2024, I count ~1800 rows with
images.album=NULL
STEPS TO REPRODUCE
Unfortunately, I don't know what triggered this issue. However, I have a setup
where I commit an sql dump to git before each launch of DK, so I am (in theory)
helpful to nail down the issue. I just don't know where to start. Happy to
provide my db to devs
EXPECTED RESULTS
- Don't nullify images.album in SQL without a reason
- Have a sanity check in DK to notify user if there is an inconsistency with
regards to images.album
SOFTWARE/OS VERSIONS
Linux/KDE Plasma: recent OpenSuse and DK versions since 2021
--
You are receiving this mail because:
You are watching all bug changes.
