[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added CC||li...@drmartinus.de --- Comment #12 from Maik Qualmann --- *** Bug 79 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added Resolution|--- |FIXED Latest Commit|https://invent.kde.org/grap |https://invent.kde.org/grap |hics/digikam/commit/49ee18f |hics/digikam/commit/fb89a81 |bf2220baedbc015f51b74f67930 |a60da6a37ddb23ddcd316b95254 |115287 |52b3e9 Status|REOPENED|RESOLVED Version Fixed In||7.4.0 --- Comment #11 from Maik Qualmann --- Git commit fb89a81a60da6a37ddb23ddcd316b9525452b3e9 by Maik Qualmann. Committed on 06/08/2021 at 21:08. Pushed by mqualmann into branch 'master'. check mysql.err file for a database upgrade FIXED-IN: 7.4.0 M +18 -5core/libs/database/coredb/coredbschemaupdater.cpp M +31 -69 core/libs/database/server/databaseserver.cpp M +8-3core/libs/database/server/databaseserver.h https://invent.kde.org/graphics/digikam/commit/fb89a81a60da6a37ddb23ddcd316b9525452b3e9 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added Version Fixed In|7.4.0 | -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED |--- Ever confirmed|0 |1 --- Comment #10 from Maik Qualmann --- We do not yet receive the correct database version in the current patch ... Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added CC||karsten.defre...@posteo.de --- Comment #9 from Maik Qualmann --- *** Bug 440590 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added Version Fixed In|7.3.0 |7.4.0 Latest Commit||https://invent.kde.org/grap ||hics/digikam/commit/49ee18f ||bf2220baedbc015f51b74f67930 ||115287 --- Comment #8 from Maik Qualmann --- Git commit 49ee18fbf2220baedbc015f51b74f67930115287 by Maik Qualmann. Committed on 25/07/2021 at 13:44. Pushed by mqualmann into branch 'master'. perform a database upgrade if the server / database version is different Related: bug 440212 FIXED-IN: 7.4.0 M +2-0NEWS M +126 -3core/libs/database/server/databaseserver.cpp M +5-0core/libs/database/server/databaseserver.h https://invent.kde.org/graphics/digikam/commit/49ee18fbf2220baedbc015f51b74f67930115287 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Michal Kec (MiK) changed: What|Removed |Added CC||k...@kecnet.cz -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 caulier.gil...@gmail.com changed: What|Removed |Added Version Fixed In||7.3.0 CC||caulier.gil...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 --- Comment #7 from Jens Westemeier --- Thanks! -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Jens Westemeier changed: What|Removed |Added Resolution|--- |FIXED Status|REPORTED|RESOLVED -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 --- Comment #6 from Jens Westemeier --- Started old version digikam 7.2. With that the database server existed. Run mariadb-upgrade --socket=/home/jens/.local/share/digikam/db_misc/mysql.socket After that digikam 7.3 worked. Problem solved -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 --- Comment #5 from Jens Westemeier --- rpm -qa | grep mariadb mariadb-10.5.10-1.1.x86_64 mariadb-client-10.5.10-1.1.x86_64 libmariadb3-3.1.13-2.1.x86_64 mariadb-errormessages-10.5.10-1.1.noarch -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 --- Comment #4 from Jens Westemeier --- (In reply to Maik Qualmann from comment #2) > If you are using an internal MySQL database read this thread: > > https://mail.kde.org/pipermail/digikam-users/2021-July/032471.html > > Maik mariadb-upgrade --socket=/home/jens/.local/share/digikam/db_misc/ Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/jens/.local/share/digikam/db_misc/' (111) FATAL ERROR: Upgrade failed -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030
--- Comment #3 from Jens Westemeier ---
(In reply to Jens Westemeier from comment #0)
> SUMMARY
> After update from 7.2 to 7.3 digikam fails to start.
> Error message (in my own words): Database migration from version 12 to 13
> fails.
> Console output:
> digikam.coredb: Core database: cannot process schema initialization
> QThreadStorage: Thread 0x7f48800722c0 exited after QThreadStorage 13
> destroyed
>
> STEPS TO REPRODUCE
> 1. start digikam 7.3 with a database from 7.2
>
> OBSERVED RESULT
> digikam does not start
>
> EXPECTED RESULT
>
>
> SOFTWARE/OS VERSIONS
> Windows:
> macOS:
> Linux/KDE Plasma:
> (available in About System)
> KDE Plasma Version:
> KDE Frameworks Version:
> Qt Version:
>
> ADDITIONAL INFORMATION
digikam.widgets: Use installed icons
digikam.general: Switch to application font: QFont(Noto
Sans,10,-1,5,50,0,0,0,0,0)
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name:"digikam"
DB Face Name: "digikam"
DB Similarity Name:"digikam"
Connect Options:
"UNIX_SOCKET=/home/jens/.local/share/digikam/db_misc/mysql.socket"
Host Name: ""
Host port: -1
Internal Server: true
Internal Server Path: "/home/jens"
Internal Server Admin Cmd: "mysqladmin"
Internal Server Serv Cmd: "/usr/sbin/mysqld"
Internal Server Init Cmd: "mysql_install_db"
Username: "root"
Password: ""
digikam.databaseserver: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name:"digikam"
DB Face Name: "digikam"
DB Similarity Name:"digikam"
Connect Options:
"UNIX_SOCKET=/home/jens/.local/share/digikam/db_misc/mysql.socket"
Host Name: ""
Host port: -1
Internal Server: true
Internal Server Path: "/home/jens"
Internal Server Admin Cmd: "mysqladmin"
Internal Server Serv Cmd: "/usr/sbin/mysqld"
Internal Server Init Cmd: "mysql_install_db"
Username: "root"
Password: ""
digikam.databaseserver: Internal Server data path:
"/home/jens/.mysql.digikam/db_data"
digikam.databaseserver: The mysql configuration was already up-to-date:
"/home/jens/.local/share/digikam/mysql.conf"
digikam.databaseserver: Database server: "/usr/sbin/mysqld"
("--defaults-file=/home/jens/.local/share/digikam/mysql.conf",
"--datadir=/home/jens/.mysql.digikam/db_data",
"--socket=/home/jens/.local/share/digikam/db_misc/mysql.socket")
digikam.databaseserver: Internal database server started
digikam.databaseserver: Running 0 seconds...
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 12
digikam.coredb: Core database: makeUpdates 12 to 13
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Die Abfrage konnte nicht ausgeführt werden" "Column
count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB
100229, now running 100510. Please use mariadb-upgrade to fix this error"
"1558" 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV12ToV13" ]
Statement [ "\nDROP PROCEDURE IF EXISTS
create_index_if_not_exists;\n" ]
digikam.coredb: Core database: schema update to V 13 failed!
digikam.coredb: Core database: cannot process schema initialization
digikam.general: KMemoryInfo: Platform identified : "LINUX"
digikam.general: KMemoryInfo: TotalRam: 16628625408
digikam.general: Allowing a cache size of 400 MB
digikam.databaseserver: Shutting down database server
digikam.databaseserver: Internal database server stopped
QThreadStorage: Thread 0x7f151c77a2c0 exited after QThreadStorage 13 destroyed
--
You are receiving this mail because:
You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 --- Comment #2 from Maik Qualmann --- If you are using an internal MySQL database read this thread: https://mail.kde.org/pipermail/digikam-users/2021-July/032471.html Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 440030] Database migration 7.2 -> 7.3 fails
https://bugs.kde.org/show_bug.cgi?id=440030 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #1 from Maik Qualmann --- Do you use an internal MySQL or an external MySQL database? Set the debug variable and post the output in the terminal as described here: https://www.digikam.org/contribute/ Maik -- You are receiving this mail because: You are watching all bug changes.
