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.