https://bugs.kde.org/show_bug.cgi?id=411480
Bug ID: 411480
Summary: Problems with database migration on remote host
Product: digikam
Version: 5.9.0
Platform: Debian stable
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: kje...@kjernsmo.net
Target Milestone: ---
SUMMARY
STEPS TO REPRODUCE
1. Have a version 8 database on a different host than the desktop where Digikam
reside
2. Launch digikam 5.9.0
3. Observe console output
OBSERVED RESULT
Digikam opens a dialog saying database migration failed, and that I should file
a bug report with the output from the console. Here it is:
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "thumbnails_digikam"
DB Face Name: "face_digikam"
Connect Options: ""
Host Name: "robin"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "kjetil"
Password: "XXXXXXX"
digikam.dbengine: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected: 3 found: 3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: have a structure version 8
digikam.coredb: Core database: makeUpdates 8 to 9
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "Column count of mysql.proc
is wrong. Expected 21, found 20. The table is probably corrupted" 1805 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ]
Statement [ "\n DROP PROCEDURE IF EXISTS drop_foreign_key;\n
" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
KMemoryInfo: Platform identified : "LINUX"
KMemoryInfo: TotalRam: 8291205120
digikam.general: Allowing a cache size of 200 MB
QThreadStorage: Thread 0x7fec65146bc0 exited after QThreadStorage 10 destroyed
EXPECTED RESULT
That Digikam would start and migrate the database.
SOFTWARE/OS VERSIONS
Windows:
macOS:
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
