https://bugs.kde.org/show_bug.cgi?id=392189
Bug ID: 392189
Summary: Database upgrade fails
Product: digikam
Version: 5.8.0
Platform: Archlinux Packages
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Digikam fails to launch with the following message: " Failed to update the
database schema from version 8 to version 9. Please read the error messages
printed on the console and report this error as a bug at bugs.kde.org. "
Here is the log:
$ digikam
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam_thumbnails"
DB Face Name: "digikam_faces"
Connect Options: ""
Host Name: "p6t"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "digikam"
Password: "XXXXXXXXX"
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" "Cannot load from mysql.proc.
The table is probably corrupted" 1728 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: 6242914304
digikam.general: Allowing a cache size of 200 MB
QThreadStorage: Thread 0x7f9132ff2100 exited after QThreadStorage 11 destroyed
Database system is MariaDB, as provided by ArchLinux packages.
--
You are receiving this mail because:
You are watching all bug changes.
