Created attachment 455820 [details] emerge --info output Hello, with the now stable Digikam 5.3.0 I found a problem with the Batch Queue Manager. When processing a batch of images (eg. sharpening more than a handful images) BQM hangs. When starting Digikam from command line I can see a lot of "Database is locked" messages: digikam.dbengine: Database is locked. Waited 9250 digikam.dbengine: Database is locked. Waited 9250 digikam.dbengine: Database is locked. Waited 9250 digikam.dbengine: Database is locked. Waited 9500 digikam.dbengine: Database is locked. Waited 9500 digikam.dbengine: Database is locked. Waited 9500 digikam.dbengine: Database is locked. Waited 9500 digikam.dbengine: Database is locked. Waited 9750 digikam.dbengine: Database is locked. Waited 9750 digikam.dbengine: Database is locked. Waited 9750 digikam.dbengine: Database is locked. Waited 9750 digikam.dbengine: Database is locked. Waited 10000 digikam.dbengine: Database is locked. Waited 10000 digikam.dbengine: Database is locked. Waited 10000 digikam.dbengine: Detected locked database file. There is an active transaction. Waited but giving up now. digikam.dbengine: Failure executing query: "SELECT value FROM ImageProperties WHERE imageid=? and property=?;" Error messages: "Unable to fetch row" "database table is locked" 6 1 Bound values: (QVariant(qlonglong, 8094), QVariant(QString, "country")) digikam.dbengine: Database is locked. Waited 0 digikam.dbengine: Detected locked database file. There is an active transaction. Waited but giving up now. digikam.dbengine: Failure executing query: "UPDATE Images SET category=?, modificationDate=?, fileSize=?, uniqueHash=? WHERE id=?;" Error messages: "Unable to fetch row" "database table is locked" 6 1 Bound values: (QVariant(int, 1), QVariant(QString, ""), QVariant(qlonglong, 0), QVariant(QString, ""), QVariant(qlonglong, 8096)) digikam.dbengine: Database is locked. Waited 0 digikam.dbengine: Database is locked. Waited 10000 digikam.dbengine: Detected locked database file. There is an active transaction. Waited but giving up now. digikam.dbengine: Failure executing query: "UPDATE Images SET category=?, modificationDate=?, fileSize=?, uniqueHash=? WHERE id=?;" Error messages: "Unable to fetch row" "database table is locked: Images" 6 1 Bound values: (QVariant(int, 4), QVariant(QString, ""), QVariant(qlonglong, 0), QVariant(QString, ""), QVariant(qlonglong, 8108)) I also tried the AppImage builds for Digikam 5.3.0 and 5.4.0, both showed the same problem. I subscribed to the digikam mailing list and yesterday I received the solution. Maik Qualmann from the digikam team published a patch to fix locked database in BQM: https://commits.kde.org/digikam/f37ef2c195b61a43a40e9cbb7f119fdc8e9d38f4 I applied the patch to digikam-5.3.0 and it indeed fixed the problem with the locked database in BQM. I'm attaching my emerge --info and the patch in case somebody has the same problem.
Created attachment 455822 [details, diff] Patch for digikam-5.3.0 to fix locked database Patch to fix locked database in BQM
Thanks. https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=cd2f2c655d00e87504cd6ecbf0410ffc802f2930
