[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 caulier.gil...@gmail.com changed: What|Removed |Added Version Fixed In||7.6.0 -- You are receiving this

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 Cornelius changed: What|Removed |Added Resolution|--- |NOT A BUG Status|REPORTED

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #22 from Maik Qualmann --- Ignore my request for DebugView, you are under Linux and can read the log directly in the terminal after setting the debug variable. I thought you were on Windows. Maik -- You are receiving this mail because:

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #21 from caulier.gil...@gmail.com --- DebugView is a small application from Microsoft to catch debug message from Windows kernel and applications. Download it and run before to start digiKam as explained here :

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #20 from Cornelius --- I'm happy to do that. Are you refering to anything specific when you say "DebugView" or just running digikam with > export QT_LOGGING_RULES="digikam*=true" ? -- You are receiving this mail because: You are watching

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #19 from Maik Qualmann --- But the problem with REPLACE INTO must be in your system/database. In digiKam, a thread can hang if the database isn't ready, but a hanging thread can never block another thread that wants to use the database. We

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-18 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 Cornelius changed: What|Removed |Added Version|7.1.0 |7.5.0 -- You are receiving this mail because: You

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #18 from Maik Qualmann --- Git commit b633b3dd412d26660bb0ed94cdc4f8d316b029f9 by Maik Qualmann. Committed on 17/01/2022 at 22:04. Pushed by mqualmann into branch 'master'. check for absolute path for thumbnail name M +1-1

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #17 from Cornelius --- As the upgrade to 7.5.0 has not resolved the original issue, I was thinking: Is there a possibility that the thread which creates the thumbnail, gets hung up somewhere between the PREPARE and the EXECUTE statement?

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #16 from Cornelius --- ah, thanks for catching that. That would also explain, why on my account the thumbnails are currently working fine while on my wife's account I'm still running into the same issues as with 7.1.0. I.e., REPLACE INTO

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #15 from Maik Qualmann --- Ok, you are currently using a local SQLite DB as thumbnail database. We need to fix that. I'm amazed that QFileInfo maps the "photos" entry to your mount path "photos" as the local database path. Although it's not

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Cornelius
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #14 from Cornelius --- Created attachment 145582 --> https://bugs.kde.org/attachment.cgi?id=145582=edit Database settings Sure. Added the screenshot as an attachment. -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #13 from Maik Qualmann --- Please take a screenshot of the digiKam settings on the database settings page. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #12 from cornelius.m...@gmail.com --- This is what I thought, but as I've written above, this is not what I'm seeing with 7.5.0. Instead the db tables remain permanently empty. This was not the case with 7.1.0. Hence I assume that there is

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #11 from Maik Qualmann --- Why should the tables remain empty? As soon as thumbnails are requested, e.g. from the Item View Model and they are not available in the DB, they are created immediately and stored in the DB. So even when viewing

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-17 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #10 from cornelius.m...@gmail.com --- So does that mean that the fact that the Thumbnails, UniqueHashes and FilePath remain empty after the thumbnails db has been rebuild is expected behavior? -- You are receiving this mail because: You

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #9 from Maik Qualmann --- In your log file do not see any errors, normal behavior when creating thumbnails. There is definitely no problem with the thumbnail database in digiKam, also the maintenance tool creates new thumbnails without any

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #8 from cornelius.m...@gmail.com --- Okay, I'm done regenerating the thumbnails. What I did: Truncate humbnails, UniqueHashes and FilePath tables Started to rebuild the thumbnail db via the corresponding maintenance option and waited till

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #7 from cornelius.m...@gmail.com --- (In reply to Maik Qualmann from comment #6) > Which database and which version do you use? digiKam is currently not > compatible with MariaDB-10.6.x. As of MariaDB-10.6.x, certain changes are > needed in

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #6 from Maik Qualmann --- Which database and which version do you use? digiKam is currently not compatible with MariaDB-10.6.x. As of MariaDB-10.6.x, certain changes are needed in Qt that are not present in the AppImage. Maik -- You are

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #5 from cornelius.m...@gmail.com --- (In reply to Maik Qualmann from comment #4) > Such a problem has not been reported before. The database discards the > preparation. Either your database is broken or you have a drive error. The > long

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=448585 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #4 from Maik

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #3 from cornelius.m...@gmail.com --- FYI: On 7.1.0 I saw the following on the db log: 2022-01-16 09:46:04.522313 digikam[digikam] @ [192.168.0.197] 4234 1 Prepare REPLACE INTO UniqueHashes (uniqueHash, fileSize, thumbId)

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 --- Comment #2 from cornelius.m...@gmail.com --- 7.5.0 doesn't seem to automatically rebuild the thumbnails in the background which definitely fixed the issue. Thanks for that. I'll now manually rebuild the thumbnail db and report what happens. -- You

[digikam] [Bug 448585] REPLACE INTO UniqueHashes blocks all Thumbnail related activities including loading

2022-01-16 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=448585 caulier.gil...@gmail.com changed: What|Removed |Added CC||caulier.gil...@gmail.com --- Comment