https://bugs.kde.org/show_bug.cgi?id=503910
--- Comment #3 from David <ticedo...@hotmail.com> --- I'm collecting log files now. I'm on the 3rd one (using Debug View). The first log took quite a long time before the problem come up (I saved it and can upload it later). I spent about 4 hours on the screen doing things like checking "tags" for duplicates based on misspellings (like one tag for "Hotel" vs. a tag for "Hotle") and moved files from one tag to another, then deleting the old tag - just keeping digiKam loaded continuously to see how long it would last. The whole time I was doing that, I had btop running on the MariaDB server and I could see normal network traffic / memory / CPU traffic ramping up and down as expected. The Windows Task Manager showed the activity on the network, but the 12 CPU were not ramping up to 100%. There was network traffic, but no disk traffic to the local C: drive (c:\digikam\thumbnails-digikam.db). Checking Similarities, the app slowed way down (The "Drag and Drop" of an image took 30 to 40 seconds in some cases), but it kept going and finally showed some results. I started an "Auto-tag Scan" and left it to run overnight. It ran for an unknown period, then failed at some point during the night. There was one last digiKam message before a very long period of no more from digiKam: 00020547 33271.10937500 [47352] digikam.dimg: "J:/MyPix/MyPix/models/Annie_Cruz/Annie_Cruz-Pix/a-file-name.jpg" : "JPEG" file identified Followed by several hundred lines of debug messages from unrelated apps and services, finally a digiKam message: 00021475 72684.45312500 [47352] digikam.dbengine: Failure executing query: 00021476 72684.45312500 [47352] "SELECT imageid FROM ImageTagProperties LEFT JOIN Images ON Images.id=ImageTagProperties.imageid WHERE tagid=? AND property=? AND Images.status=1 LIMIT 1;" 00021477 72684.45312500 [47352] Error messages: "QMYSQL: Unable to prepare statement" "Lost connection to MySQL server during query" "2013" 2 00021478 72684.45312500 [47352] Bound values: QList() 00021479 72684.46093750 [47352] digikam.dbengine: Failure executing query: 00021480 72684.46093750 [47352] "SELECT imageid FROM ImageTagProperties LEFT JOIN Images ON Images.id=ImageTagProperties.imageid WHERE tagid=158 AND property='tagRegion' AND Images.status=1 LIMIT 1;" 00021481 72684.46093750 [47352] Error messages: "QMYSQL: Unable to execute query" "Lost connection to MySQL server during query" "2013" 2 00021482 72684.46093750 [47352] Bound values: QList(QVariant(int, 158), QVariant(QString, "tagRegion")) 00021483 72684.47656250 [47352] digikam.dbengine: Failure executing query: 00021484 72684.47656250 [47352] "SELECT imageid FROM ImageTagProperties LEFT JOIN Images ON Images.id=ImageTagProperties.imageid WHERE tagid=? AND property=? AND Images.status=1 LIMIT 1;" These messages repeated for several 1000 more lines until I closed the log file. The MariaDB was still up, but showing no load on it at all. DigiKam was still up, and the "Image Fingerprints have not been generated" error message was present in Similarities tab. I restarted digiKam and everything was back to normal. This morning, I rebooted the Windows 11 host and shut off all the startup apps (Steam, Evernote, qBtTorrent, discord) and tried to minimize the background chatter on the Debug View. I started a new log and started digiKam. After using digiKam for a few more hours, and started a "Find Duplicates" activity. It's been running now for 7 hours (68% done) with all 12 CPU at 100%, otherwise the app is still functional. But whenever I click on the "Similarities" tab on the left side, it can take up to 45 seconds before the screen changes and all 12 CPU drop to about 1% for 30 seconds before starting back up to 100%. The log is running and I can upload that file tomorrow. -- You are receiving this mail because: You are watching all bug changes.
