Bug 406228 - getting random unextpected 'Database is locked' events
Summary: getting random unextpected 'Database is locked' events
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Engine (other bugs)
Version First Reported In: 6.0.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-04 17:54 UTC by Ben
Modified: 2019-12-25 10:16 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed/Implemented In: 7.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.