5.30: Hang when sharpening some images using Batch Mgr

Oliver Schwabedissen oliver at schwabedissen.name
Fri Nov 11 17:52:18 GMT 2016


Am 10.11.2016 um 07:42 schrieb Gilles Caulier:
> Database is locked.
>
> Please try with official digiKam 5.3.0 AppImage bundle instead Gentoo
> package.

Where can I find this? There's no download link for the AppImage bundle
in the download section. All I found was a link to a 5.3.0 Beta AppImage
bundle
(https://medium.com/@dmpop/digikam-recipes-5-0-1-released-and-digikam-appimage-package-coming-d803d00c4079).

I downloaded and ran it. When I try to sharpen eight images using Batch
Manager it also freezes.

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: 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: "Der Datensatz konnte nicht abgeholt werden" "database
table is locked" 6 1
Bound values:  (QVariant(int, 1), QVariant(QString, ""),
QVariant(qlonglong, 0), QVariant(QString, ""), QVariant(qlonglong, 8130))
digikam.dbengine: Database is locked. Waited 0
digikam.dbengine: Database is locked. Waited 10000
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:
 "UPDATE Images SET category=?, modificationDate=?, fileSize=?,
uniqueHash=? WHERE id=?;"
Error messages: "Der Datensatz konnte nicht abgeholt werden" "database
table is locked" 6 1
Bound values:  (QVariant(int, 1), QVariant(QString, ""),
QVariant(qlonglong, 0), QVariant(QString, ""), QVariant(qlonglong, 8135))
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:


> 2016-11-10 7:31 GMT+01:00 Oliver Schwabedissen
> <oliver at schwabedissen.name <mailto:oliver at schwabedissen.name>>:
>
>     Hello,
>
>     I updated from 5.20 to 5.30 yesterday and noticed a problem when
>     sharpening images using the Batch Manager.
>
>     Processing 4 images usually works, but when trying more images (eg. 8)
>     Digikam hangs. Starting Digikam from command line I can see that I
>     often
>     get "digikam.dbengine: Database is locked." messages. After some
>     minutes
>     I then get
>
>     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))
>
>
>     At this point all I can do is to kill Digikam and restore the images I
>     tried to sharpen from my backup.
>
>     I'm using Gentoo Linux, mainly stable, but Digikam 5.x is currently
>     still in the unstable branch. HW is a HP system with Intel Core
>     i7-2600
>     CPU @ 3.40GHz and 14 GB RAM. System is running on a 500 GB Samsung
>     SSD.
>
>     Kind regards,
>
>     Oliver
>
>     --
>     GPG Public Key available at http://wwwkeys.de.pgp.net
>     Key fingerprint = 3264 280C 05B1 572F 3F0B 42B8 1E7B 2D9D 063B D507
>
>

Ciao,

Oliver

-- 
GPG Public Key available at http://wwwkeys.de.pgp.net
Key fingerprint = 3264 280C 05B1 572F 3F0B 42B8 1E7B 2D9D 063B D507
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20161111/f54bea24/attachment.html>


More information about the Digikam-users mailing list