https://bugs.kde.org/show_bug.cgi?id=519992
Bug ID: 519992
Summary: database schema upgrade failure in 9.1.0 snapshot
Classification: Applications
Product: digikam
Version First 9.1.0
Reported In:
Platform: Mint (Ubuntu based)
OS: Linux
Status: REPORTED
Severity: crash
Priority: NOR
Component: Database-Migration
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
DESCRIPTION
database upgrade fails. error message requests bug report with logging.
STEPS TO REPRODUCE
1. open album with earlier version (as recent as the
digiKam-9.1.0-20260421T180052-Qt6-x86-64.appimage)
2. open album with latest snapshot
digiKam-9.1.0-20260509T140113-Qt6-x86-64-debug.appimage
3. open fails with db schema upgrade failure
4. repeat with debug appimage to try to capture output.
5. enable debug logging with environment variable
OBSERVED RESULT
open fails with schema upgrade error popup.
EXPECTED RESULT
application opens successfully
SOFTWARE/OS VERSIONS
Operating System (available in the Info Center app, or by running `kinfo` in a
terminal window): linux mint 22
KDE Plasma Version: appimage
KDE Frameworks Version: appimage
Qt Version: qt6
digiKam-9.1.0-20260509T140113-Qt6-x86-64-debug.appimage
ADDITIONAL INFORMATION
db is set to sqlite
Digikam::DbEngineConfigSettingsLoader::readConfig: Loading SQL code from config
file "/tmp/.mount_digiKaWPYs90/usr/share/digikam/database/dbconfig.xml"
Digikam::DbEngineConfigSettingsLoader::readConfig: Checking XML version ID =>
expected: 3 found: 3
Digikam::BdEngineBackend::checkOrSetWALMode: WAL mode is disabled for
"digikam4.db"
Digikam::CoreDbSchemaUpdater::update: Core database: running schema update
Digikam::CoreDbSchemaUpdater::startUpdates: Core database: have a structure
version 16
Digikam::CoreDbSchemaUpdater::makeUpdates: Core database: makeUpdates 16 to
17
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
""
Error messages: "Unable to execute statement" "duplicate column name: timeZone"
"1" 2
Bound values: QList()
Digikam::BdEngineBackend::execDBAction: Error while executing DBAction [
"UpdateSchemaFromV16ToV17" ] Statement [ "ALTER TABLE ImageInformation ADD
timeZone INTEGER;" ]
Digikam::CoreDbSchemaUpdater::performUpdateToVersion: Core database: schema
update to V 17 failed!
Digikam::CoreDbAccess::checkReadyForUse: Core database: cannot process schema
initialization
--
You are receiving this mail because:
You are watching all bug changes.
