https://bugs.kde.org/show_bug.cgi?id=451460
Bug ID: 451460
Summary: Failed to update the database schema from version 10
to version 11.
Product: digikam
Version: 7.5.0
Platform: Debian unstable
OS: Linux
Status: REPORTED
Severity: major
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: vdanjean...@free.fr
Target Milestone: ---
SUMMARY
Last version of digikam in debian unstable fails to start due to a problem in
db upgrade.
STEPS TO REPRODUCE
1. I run "digikam" in a terminal (it has been several months I did not run it)
OBSERVED RESULT
In the terminal :
digikam.coredb: Core database: cannot process schema initialization
In a small window (popup), the classical "Scanning collections, please wait..."
but stuck at 0% with the "Error" message.
In another popup windows, not classical, "Failed to update the database schema
from version 10 to version 11.
Please read the error messages printed on the console and report this error as
a bug at bugs.kde.org."
Clicking to the (only) "OK" button in the second popup makes both popups to
disappear and the "digikam" command to end.
Note:
1) I'm using an external DB (mysql when I started a long time ago, and mariadb
now)
2) in mysql log, I see this :
2022-03-13T17:33:11.477700Z 121 Connect digikamuser@localhost on
digikamdb using Socket
2022-03-13T17:33:11.478373Z 121 Init DB digikamdb
2022-03-13T17:33:11.479252Z 121 Query SET NAMES utf8mb3
2022-03-13T17:33:11.479590Z 121 Prepare SELECT ? + ?
2022-03-13T17:33:11.479629Z 121 Close stmt
2022-03-13T17:33:11.479842Z 121 Quit
2022-03-13T17:33:12.339278Z 122 Connect digikamuser@localhost on
digikamdb using Socket
2022-03-13T17:33:12.339978Z 122 Init DB digikamdb
2022-03-13T17:33:12.342229Z 122 Query SET NAMES utf8mb3
2022-03-13T17:33:12.342731Z 122 Prepare SELECT ? + ?
2022-03-13T17:33:12.342815Z 122 Close stmt
2022-03-13T17:33:12.343555Z 123 Connect digikamuser@localhost on
digikamdb using Socket
2022-03-13T17:33:12.343891Z 123 Init DB digikamdb
2022-03-13T17:33:12.344999Z 123 Query SET NAMES utf8mb3
2022-03-13T17:33:12.345523Z 123 Prepare SELECT ? + ?
2022-03-13T17:33:12.345585Z 123 Close stmt
2022-03-13T17:33:12.345841Z 123 Query DROP TABLE IF EXISTS PrivCheck
2022-03-13T17:33:12.347942Z 123 Query CREATE TABLE IF NOT EXISTS
PrivCheck
(id INT,
name VARCHAR(35))
ENGINE InnoDB
2022-03-13T17:33:12.358940Z 123 Query ALTER TABLE PrivCheck DROP
COLUMN name
2022-03-13T17:33:12.380712Z 123 Query DROP TABLE PrivCheck
2022-03-13T17:33:12.387938Z 123 Query DROP TABLE IF EXISTS PrivCheck
2022-03-13T17:33:12.390167Z 122 Query select table_name from
information_schema.tables where table_schema = 'digikamdb' and table_type =
'BASE TABLE'
2022-03-13T17:33:12.390796Z 123 Quit
2022-03-13T17:33:12.391412Z 122 Prepare SELECT value FROM Settings
WHERE keyword=?
2022-03-13T17:33:12.391509Z 122 Reset stmt
2022-03-13T17:33:12.391574Z 122 Execute SELECT value FROM Settings
WHERE keyword='DBVersion'
2022-03-13T17:33:12.391793Z 122 Close stmt
2022-03-13T17:33:12.391855Z 122 Prepare SELECT value FROM Settings
WHERE keyword=?
2022-03-13T17:33:12.391867Z 122 Reset stmt
2022-03-13T17:33:12.391904Z 122 Execute SELECT value FROM Settings
WHERE keyword='DBVersionRequired'
2022-03-13T17:33:12.392007Z 122 Close stmt
2022-03-13T17:33:12.392061Z 122 Query BEGIN WORK
2022-03-13T17:33:12.392183Z 122 Query DROP TRIGGER IF EXISTS
temp_insert_tagstree
2022-03-13T17:33:12.393283Z 122 Query DROP TRIGGER IF EXISTS
insert_tagstree
2022-03-13T17:33:12.394384Z 122 Query DROP TRIGGER IF EXISTS
delete_tagstree
2022-03-13T17:33:12.395444Z 122 Query DROP TRIGGER IF EXISTS
move_tagstree
2022-03-13T17:33:12.396444Z 122 Query DROP TABLE IF EXISTS temp_Tags
2022-03-13T17:33:12.404139Z 122 Query DROP TABLE IF EXISTS TagsTree
2022-03-13T17:33:12.413945Z 122 Query DROP VIEW IF EXISTS TagsTree
2022-03-13T17:33:12.415528Z 122 Query CREATE TABLE IF NOT EXISTS
temp_Tags
(id INTEGER,
pid INTEGER,
name LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
icon BIGINT,
iconkde LONGTEXT CHARACTER SET utf8 COLLATE
utf8_general_ci,
lft INTEGER,
rgt INTEGER)
ENGINE InnoDB
2022-03-13T17:33:12.431519Z 122 Query CREATE TABLE IF NOT EXISTS
TagsTree
(id INTEGER NOT NULL,
pid INTEGER NOT NULL,
UNIQUE (id, pid))
ENGINE InnoDB
2022-03-13T17:33:12.445760Z 122 Query CREATE TRIGGER
temp_insert_tagstree AFTER INSERT ON temp_Tags
FOR EACH ROW INSERT INTO TagsTree SELECT NEW.id, NEW.pid
UNION SELECT NEW.id, pid FROM TagsTree WHERE id = NEW.pid
2022-03-13T17:33:12.446035Z 122 Query ROLLBACK
2022-03-13T17:33:12.446240Z 122 Prepare REPLACE INTO Settings VALUES
(?,?)
2022-03-13T17:33:12.446315Z 122 Reset stmt
2022-03-13T17:33:12.446372Z 122 Execute REPLACE INTO Settings VALUES
('DBVersion','10')
2022-03-13T17:33:12.447019Z 122 Close stmt
2022-03-13T17:33:12.447064Z 122 Prepare REPLACE INTO Settings VALUES
(?,?)
2022-03-13T17:33:12.447109Z 122 Reset stmt
2022-03-13T17:33:12.447163Z 122 Execute REPLACE INTO Settings VALUES
('DBVersionRequired','5')
2022-03-13T17:33:12.447849Z 122 Close stmt
I do not know how to go futher to debug the problem.
EXPECTED RESULT
digikam does it db upgrade and start
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.
