https://bugs.kde.org/show_bug.cgi?id=448585
Bug ID: 448585
Summary: REPLACE INTO UniqueHashes blocks all Thumbnail related
activities including loading
Product: digikam
Version: 7.1.0
Platform: Appimage
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Thumbs-Maintenance
Assignee: digikam-bugs-n...@kde.org
Reporter: cornelius.m...@gmail.com
Target Milestone: ---
SUMMARY
***
After loading a new batch of photos I noticed that thumbnail loading and
metadata writing would hang repeatedly, sometimes for several minutes. I looked
a the debug log messages but they would just stop when the processing would
hang.
I had a hunch that it was a database issue (I'm using MySQL) so I looked at
that. Turns out that whenever the thumbnail loading hangs a "REPLACE INTO
UniqueHashes" process is running for 30-60 seconds. Sometime there is several
of them which causes thumbnail loading to not work for several minutes.
I cleared the Thumbnails, UniqueHashes and FilePath tables and tried the
rebuild the thumbnail db via the corresponding maintenance option but that
didn't work and produces strange results. The process finishes but running it
again with the scan option still finds plenty of pictures with no thumbnails.
Rerunning it multiple times reduces (?!?) the number of entries in the
Thumbnails table but increases the number of entries in the other tables.
It seems like some background process tries to update the thumbnails and causes
this but I have no idea how to get more info on this.
Any ideas or help?
***
STEPS TO REPRODUCE
1. Open digikam
2. Wait a couple of seconds
OBSERVED RESULT
Thumbnails stop loading
EXPECTED RESULT
Thumbnails should load normally
SOFTWARE/OS VERSIONS
This is on Ubuntu 20.4.3
with the 7.1.0 digikam AppImage
ADDITIONAL INFORMATION
Not sure if this is the right product. If not please tell me where to post
this.
--
You are receiving this mail because:
You are watching all bug changes.
