Bug 406228

Summary:	getting random unextpected 'Database is locked' events
Product:	[Applications] digikam	Reporter:	Ben <ben.huber>
Component:	Database-Engine	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	caulier.gilles, metzpinguin
Priority:	NOR
Version First Reported In:	6.0.0
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:	7.0.0
Sentry Crash Report:

Description Ben 2019-04-04 17:54:14 UTC

SUMMARY


STEPS TO REPRODUCE
1. this can happen at any time
2. 
3. 

OBSERVED RESULT

UI locks while in the shell the below goes on endless repeat, requiring force-quitting.


Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 6500
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 6750
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 7000
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 7250
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 7500
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 7750
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 8000
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 8250
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 8500
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 8750
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 9000
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 9250
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 9500
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 9750
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Database is locked. Waited 10000
Digikam::BdEngineBackendPrivate::checkRetrySQLiteLockError: Detected locked database file. There is an active transaction. Waited but giving up now.
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing query:
 "SELECT latitude, latitudeNumber, longitude, longitudeNumber, altitude, orientation, tilt, roll, accuracy, description FROM ImagePositions WHERE imageid=?;" 
Error messages: "Unable to fetch row" "database table is locked: ImagePositions" 6 1 
Bound values:  (QVariant(qlonglong, 128130))


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: scientific linux release 6.8 (Carbon), Gnome 2.28.2
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION

Comment 1 Maik Qualmann 2019-04-04 18:05:19 UTC


*** This bug has been marked as a duplicate of bug 396559 ***

Comment 2 caulier.gilles 2019-12-25 10:16:33 UTC

Not reproducible using digiKam 7.0.0 beta1.