<html>

  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">

  </head>

  <body>

    <p>Thanks, Maik !</p>

    <p>That worked, database was converted; and digikam 7.3.0 is

      running.</p>

    <p>Best regards,</p>

    <p>Robert</p>

    <p><br>

    </p>

    <div class="moz-forward-container"><br>

      <meta http-equiv="content-type" content="text/html; charset=UTF-8">

      <pre>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:

><i> Maik,

</i>><i> 

</i>><i> to me it looks like there is a discrepancy in  the mariadb installation

</i>><i> of openSUSE Leap 15.3 :

</i>><i> 

</i>><i> mariadb is version 10.5.8-1.5 while libmysqld19 is version

</i>><i> 10.2.37-3.37.1 ;  obviously the openSUSE repository provides an

> inconsistent library. Unfortunately they don't give you a choice.

</i>><i> 

</i>><i> Do you think completely rebuilding the database instead of converting

</i>><i> could be successful; or should I better use digikam 7.2 until the suse

</i>><i> fixes the mariadb inconsistency ?

</i>><i> 

</i>><i> 

</i>><i> here is the digikam - debug output:

</i>><i> 

</i>><i> <a href="https://mail.kde.org/mailman/listinfo/digikam-users" moz-do-not-send="true">robert at k2-SSDd</a>:~/Applications> ./digiKam-7.3.0-x86-64.appimage

</i>><i> /usr/bin/AppImageLauncher: /usr/lib64/libcurl.so.4: no version

</i>><i> information available (required by

</i>><i> /usr/bin/../lib/x86_64-linux-gnu/appimagelauncher/libappimageupdate.so)

</i>><i> -- digiKam Linux AppImage Bundle

</i>><i> -- Use 'help' as CLI argument to know all available options for digiKam

</i>><i> application.

> -- Notes: to integrate this bundle to your desktop, use AppImageLauncher.

</i>><i> --        to enable all debug messages on the console, use 'export

</i>><i> QT_LOGGING_RULES="digikam*=true"'.

</i>><i> libudev.so.0

</i>><i> libxcb-dri3.so.0

</i>><i> -- Preloading shared libs: :/usr/lib64/libxcb-dri3.so.0

</i>><i> Digikam::DXmlGuiWindow::setupIconTheme: Breeze icons resource file found

</i>><i> Digikam::DXmlGuiWindow::setupIconTheme: Breeze-dark icons resource file

</i>><i> found

</i>><i> unknown: Qt translations path:

</i>><i> "/tmp/.mount_digiKarv6HTm/usr/share/digikam/translations"

</i>><i> unknown: Loaded locale: "en_US" from catalog: "qt"

</i>><i> unknown: Loaded locale: "en_US" from catalog: "qtbase"

</i>><i> unknown: Loaded locale: "en_US" from catalog: "qt_help"

</i>><i> Digikam::ApplicationSettings::setApplicationStyle: Switch to widget

</i>><i> style:  ""

</i>><i> Digikam::ApplicationSettings::setApplicationFont: Switch to application

</i>><i> font:  QFont(Noto Sans,10,-1,5,50,0,0,0,0,0)

</i>><i> Digikam::AlbumWatch::AlbumWatch: AlbumWatch is disabled

</i>><i> Digikam::AlbumManager::setDatabase: Database Parameters:

</i>><i>     Type:                      "QMYSQL"

</i>><i>     DB Core Name:              "digikam"

</i>><i>     DB Thumbs Name:            "digikam"

</i>><i>     DB Face Name:              "digikam"

</i>><i>     DB Similarity Name:        "digikam"

</i>><i>     Connect Options:

</i>><i> "UNIX_SOCKET=/home/robert/.local/share/digikam/db_misc/mysql.socket"

</i>><i>     Host Name:                 ""

</i>><i>     Host port:                 -1

</i>><i>     Internal Server:           true

</i>><i>     Internal Server Path:      "/media/MULTIMEDIA/foto"

</i>><i>     Internal Server Admin Cmd: "mysqladmin"

</i>><i>     Internal Server Serv Cmd:  "mysqld"

</i>><i>     Internal Server Init Cmd:  "mysql_install_db"

</i>><i>     Username:                  "root"

</i>><i>     Password:                  ""

</i>><i> 

</i>><i> Digikam::DatabaseServer::DatabaseServer: Database Parameters:

</i>><i>     Type:                      "QMYSQL"

</i>><i>     DB Core Name:              "digikam"

</i>><i>     DB Thumbs Name:            "digikam"

</i>><i>     DB Face Name:              "digikam"

</i>><i>     DB Similarity Name:        "digikam"

</i>><i>     Connect Options:

</i>><i> "UNIX_SOCKET=/home/robert/.local/share/digikam/db_misc/mysql.socket"

</i>><i>     Host Name:                 ""

</i>><i>     Host port:                 -1

</i>><i>     Internal Server:           true

</i>><i>     Internal Server Path:      "/media/MULTIMEDIA/foto"

</i>><i>     Internal Server Admin Cmd: "mysqladmin"

</i>><i>     Internal Server Serv Cmd:  "mysqld"

</i>><i>     Internal Server Init Cmd:  "mysql_install_db"

</i>><i>     Username:                  "root"

</i>><i>     Password:                  ""

</i>><i> 

</i>><i> Digikam::DatabaseServer::DatabaseServer: Internal Server data path:

</i>><i> "/media/MULTIMEDIA/foto/.mysql.digikam/db_data"

</i>><i> Digikam::DatabaseServer::initMysqlConfig: The mysql configuration was

</i>><i> already up-to-date: "/home/robert/.local/share/digikam/mysql.conf"

</i>><i> Digikam::adjustedEnvironmentForAppImage: Adjusting environment variables

</i>><i> for AppImage bundle

</i>><i> Digikam::DatabaseServer::startMysqlServer: Database server: "mysqld"

</i>><i> ("--defaults-file=/home/robert/.local/share/digikam/mysql.conf",

</i>><i> "--datadir=/media/MULTIMEDIA/foto/.mysql.digikam/db_data",

</i>><i> "--socket=/home/robert/.local/share/digikam/db_misc/mysql.socket")

</i>><i> Digikam::DatabaseServerStarter::startServerManagerProcess: Internal

</i>><i> database server started

</i>><i> Digikam::DatabaseServer::run: Running 0 seconds...

</i>><i> unknown: QXcbConnection: XCB error: 128 (Unknown), sequence: 415,

</i>><i> resource id: 0, major code: 130 (Unknown), minor code: 2

</i>><i> Digikam::DbEngineConfigSettingsLoader::readConfig: Loading SQL code from

</i>><i> config file

</i>><i> "/tmp/.mount_digiKarv6HTm/usr/share/digikam/database/dbconfig.xml"

</i>><i> Digikam::DbEngineConfigSettingsLoader::readConfig: Checking XML version

</i>><i> ID => expected:  3  found:  3

</i>><i> Digikam::CoreDbSchemaUpdater::update: Core database: running schema update

</i>><i> Digikam::CoreDbSchemaUpdater::startUpdates: Core database: have a

</i>><i> structure version  12

</i>><i> Digikam::CoreDbSchemaUpdater::makeUpdates: Core database: makeUpdates 

</i>><i> 12  to  13

</i>><i> Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure

</i>><i> executing query:

</i>><i>   ""

</i>><i> Error messages: "QMYSQL: Die Abfrage konnte nicht ausgeführt werden"

</i>><i> "Column count of mysql.proc is wrong. Expected 21, found 20. Created

</i>><i> with MariaDB 100215, now running 100508. Please use mariadb-upgrade to

</i>><i> fix this error" "1558" 2

</i>><i> Bound values:  ()

</i>><i> Digikam::BdEngineBackend::execDBAction: Error while executing DBAction [

</i>><i> "UpdateSchemaFromV12ToV13" ] Statement [ "\n                    DROP

</i>><i> PROCEDURE IF EXISTS create_index_if_not_exists;\n                " ]

</i>><i> Digikam::CoreDbSchemaUpdater::performUpdateToVersion: Core database:

> schema update to V 13 failed!

</i>><i> Digikam::CoreDbAccess::checkReadyForUse: Core database: cannot process

</i>><i> schema initialization

</i>><i> Digikam::KMemoryInfo::update: KMemoryInfo: Platform identified : "LINUX"

</i>><i> Digikam::KMemoryInfo::bytes: KMemoryInfo: TotalRam:  16777506816

</i>><i> Digikam::LoadingCache::setCacheSize: Allowing a cache size of 400 MB

</i>><i> Digikam::adjustedEnvironmentForAppImage: Adjusting environment variables

</i>><i> for AppImage bundle

</i>><i> Digikam::DatabaseServer::run: Shutting down database server

</i>><i> Digikam::DatabaseServerStarter::stopServerManagerProcess: Internal

</i>><i> database server stopped

</i>><i> 

</i>><i> Am 12.07.21 um 18:36 schrieb Maik Qualmann:

</i>><i> > export QT_LOGGING_RULES="digikam*=true"

</i></pre>

    </div>

  </body>

</html>