Arch Linux

cappuccino

Member

Registered: 2012-12-26

Posts: 116

Digikam - Detected locked database file

Hello!

I have problem with Digikam. Konsole reports this:

digikam(1153)/digikam (core) Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Detected locked database file. There is an active transaction. Waited but giving up now. 

Digikam opens normally, I can see my albums, but when I click on one of them, nothing happens. Path to my Pictures is /data/Pictures [on my second hdd]. I tried everything what I could think of, but no success.

My system:
- KDE 5
- Kernel  4.0.4-2-ARCH x86_64
- digikam 4.9.0-2
- kipi-plugins 4.9.0-2
- fully updated

My digikamrc:

[Database Settings]
Database Connectoptions=
Database Hostname=
Database Name=/data/Pictures/
Database Name Thumbnails=/data/Pictures/
Database Password=
Database Port=-1
Database Type=QSQLITE
Database Username=
Internal Database Server=false

What is locking the database? Any thoughts?

bh4017

Member

Registered: 2015-12-27

Posts: 1

Re: Digikam - Detected locked database file

I understand that this is an old thread now but I have just encountered this problem and I was able to resolve it with some help from another source, so I thought I would post the information here in case someone else comes looking.

In order to resolve the locked database issue, I had to dump the database and then rebuild it.  Apparently dumping the database does not include the lock information, so in this way the lock is removed.

First, make sure you have sqlite3 installed.  Then backup your digikam4.db file to somewhere safe in case something goes wrong and you need to restore it to the current state.  Then use the following commands:

sqlite3 digikam4.db '.dump' > db.dump
rm digikam4.db
sqlite3 digikam4.db < db.dump

This information was adapted from this page: https://mail.kde.org/pipermail/digikam- … 16627.html