[digiKam-users] digikam 7.3.0 problem converting database

[Robert Zeller privat]

Thanks, Maik !

That worked, database was converted; and digikam 7.3.0 is running.

Best regards,

Robert



Right, MariaDB has updated the structure internally and needs an update. You
start digiKam so that the internal server runs. Enter the following commando
on another terminal:

mariadb-upgrade --socket=/home/robert/.local/share/digikam/db_misc/
mysql.socket

I think we will have to install it as maintenance in the future when using the
internal server.

Maik

Am Dienstag, 13. Juli 2021, 10:25:16 CEST schrieb Robert Zeller privat:
>/Maik, />//>/to me it looks like there is a discrepancy in the mariadb installation />/of openSUSE Leap 15.3 : />//>/mariadb is version 10.5.8-1.5 while libmysqld19 is version />/10.2.37-3.37.1 ; obviously the openSUSE repository provides an />/inconsistent library. Unfortunately they don't give you a choice. />//>/Do you think completely rebuilding the database instead of converting />/could be successful; or should I better use digikam 7.2 until the suse />/fixes the mariadb inconsistency ? />//>//>/here is the digikam - debug output: />//>/robert at k2-SSDd 
<https://mail.kde.org/mailman/listinfo/digikam-users>:~/Applications> 
./digiKam-7.3.0-x86-64.appimage />//usr/bin/AppImageLauncher: /usr/lib64/libcurl.so.4: no version />/information available (required by />//usr/bin/../lib/x86_64-linux-gnu/appimagelauncher/libappimageupdate.so) />/-- digiKam Linux AppImage Bundle />/-- Use 'help' as CLI argument to know all available options for digiKam />/application. />/-- Notes: to integrate this bundle to your desktop, use AppImageLauncher. />/-- to enable all debug messages on the console, use 'export />/QT_LOGGING_RULES="digikam*=true"'. />/libudev.so.0 />/libxcb-dri3.so.0 />/-- Preloading shared libs: :/usr/lib64/libxcb-dri3.so.0 />/Digikam::DXmlGuiWindow::setupIconTheme: Breeze icons resource file found />/Digikam::DXmlGuiWindow::setupIconTheme: Breeze-dark icons resource file />/found />/unknown: Qt translations path: />/"/tmp/.mount_digiKarv6HTm/usr/share/digikam/translations" />/unknown: Loaded locale: "en_US" from catalog: "qt" />/unknown: Loaded locale: "en_US" from catalog: "qtbase" />/unknown: Loaded locale: "en_US" from catalog: "qt_help" />/Digikam::ApplicationSettings::setApplicationStyle: Switch to widget />/style: "" />/Digikam::ApplicationSettings::setApplicationFont: Switch to application />/font: QFont(Noto Sans,10,-1,5,50,0,0,0,0,0) />/Digikam::AlbumWatch::AlbumWatch: AlbumWatch is disabled />/Digikam::AlbumManager::setDatabase: 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/robert/.local/share/digikam/db_misc/mysql.socket" />/Host Name: "" />/Host port: -1 />/Internal Server: true />/Internal Server Path: "/media/MULTIMEDIA/foto" />/Internal Server Admin Cmd: "mysqladmin" />/Internal Server Serv Cmd: "mysqld" />/Internal Server Init Cmd: "mysql_install_db" />/Username: "root" />/Password: "" />//>/Digikam::DatabaseServer::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/robert/.local/share/digikam/db_misc/mysql.socket" />/Host Name: "" />/Host port: -1 />/Internal Server: true />/Internal Server Path: "/media/MULTIMEDIA/foto" />/Internal Server Admin Cmd: "mysqladmin" />/Internal Server Serv Cmd: "mysqld" />/Internal Server Init Cmd: "mysql_install_db" />/Username: "root" />/Password: "" />//>/Digikam::DatabaseServer::DatabaseServer: Internal Server data path: />/"/media/MULTIMEDIA/foto/.mysql.digikam/db_data" />/Digikam::DatabaseServer::initMysqlConfig: The mysql configuration was />/already up-to-date: "/home/robert/.local/share/digikam/mysql.conf" />/Digikam::adjustedEnvironmentForAppImage: Adjusting environment variables />/for AppImage bundle />/Digikam::DatabaseServer::startMysqlServer: Database server: "mysqld" />/("--defaults-file=/home/robert/.local/share/digikam/mysql.conf", />/"--datadir=/media/MULTIMEDIA/foto/.mysql.digikam/db_data", />/"--socket=/home/robert/.local/share/digikam/db_misc/mysql.socket") />/Digikam::DatabaseServerStarter::startServerManagerProcess: Internal />/database server started />/Digikam::DatabaseServer::run: Running 0 seconds... />/unknown: QXcbConnection: XCB error: 128 (Unknown), sequence: 415, />/resource id: 0, major code: 130 (Unknown), minor code: 2 />/Digikam::DbEngineConfigSettingsLoader::readConfig: Loading SQL code from />/config file />/"/tmp/.mount_digiKarv6HTm/usr/share/digikam/database/dbconfig.xml" />/Digikam::DbEngineConfigSettingsLoader::readConfig: Checking XML version />/ID => expected: 3 found: 3 />/Digikam::CoreDbSchemaUpdater::update: Core database: running schema update />/Digikam::CoreDbSchemaUpdater::startUpdates: Core database: have a />/structure version 12 />/Digikam::CoreDbSchemaUpdater::makeUpdates: Core database: makeUpdates />/12 to 13 />/Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: 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 100215, now running 100508. Please use mariadb-upgrade to />/fix this error" "1558" 2 />/Bound values: () />/Digikam::BdEngineBackend::execDBAction: Error while executing DBAction [ />/"UpdateSchemaFromV12ToV13" ] Statement [ "\n DROP />/PROCEDURE IF EXISTS create_index_if_not_exists;\n " ] />/Digikam::CoreDbSchemaUpdater::performUpdateToVersion: Core database: />/schema update to V 13 failed! />/Digikam::CoreDbAccess::checkReadyForUse: Core database: cannot process />/schema initialization />/Digikam::KMemoryInfo::update: KMemoryInfo: Platform identified : "LINUX" />/Digikam::KMemoryInfo::bytes: KMemoryInfo: TotalRam: 16777506816 />/Digikam::LoadingCache::setCacheSize: Allowing a cache size of 400 MB />/Digikam::adjustedEnvironmentForAppImage: Adjusting environment variables />/for AppImage bundle />/Digikam::DatabaseServer::run: Shutting down database server />/Digikam::DatabaseServerStarter::stopServerManagerProcess: Internal />/database server stopped />//>/Am 12.07.21 um 18:36 schrieb Maik Qualmann: />/> export QT_LOGGING_RULES="digikam*=true" /

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20210713/fc89426e/attachment-0001.htm>