[digiKam-users] QSqlDatabase: driver not loaded

[Uwe Haider]

Hello together,

since 21-11-01 digikam starts no more with this error:

---------ERROR--------

$ digikam
QCommandLineParser: already having an option named "h"
QCommandLineParser: already having an option named "help-all"
QCommandLineParser: already having an option named "v"
qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 7823, 
resource id: 4205310, major code: 40 (TranslateCoords), minor code: 0
QSqlDatabase:  driver not loaded
QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3
QSqlDatabase:  driver not loaded
QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3
QSqlDatabasePrivate::removeDatabase: connection 
'digikamDatabase-94262302734048' is still in use, all queries will cease 
to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 
'digikamDatabase-94262302734048', old connection removed.
QSqlQuery::prepare: database not open

------Error---------

digikam is (was...) running here with gentoo-sources 5.10.52, now 
updated to 5.10.76-gentoo-r1. All files and the databases are on my NAS 
(QNAP) connected via nfs. works like a charme for the last years....

With the update on 01. November I got an new mariadb-server (10.5.10-r2) 
on the Gentoo box (not on the NAS!). My NAs is running mariadb 5.5.57. 
Both versions differ since several months or years... it was no problem 
up to now. Perhaps there are major changes in mariadb-10.5.10-r2???

Which drivers does digikam use? Are the drivers form mariadb-server 
used? drivers are available but not loaded. So I looked in systemctl and 
found this:

----status mariadb on gentoo box -----

systemctl status mariadb
× mariadb.service - MariaDB 10.5.10 database server
      Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; 
vendor preset: disabled)
      Active: failed (Result: exit-code) since Sun 2021-11-07 15:05:40 
CET; 16min ago
        Docs: man:mariadbd(8)
              https://mariadb.com/kb/en/library/systemd/
     Process: 297 ExecStartPre=/bin/sh -c systemctl unset-environment 
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Process: 300 ExecStartPre=/bin/sh -c [ ! -e 
/usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; 
/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment 
_WSREP_ST>
     Process: 364 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS 
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
    Main PID: 364 (code=exited, status=1/FAILURE)
      Status: "MariaDB server is down"
         CPU: 117ms

Nov 07 15:05:40 After8 systemd[1]: Starting MariaDB 10.5.10 database 
server...
Nov 07 15:05:40 After8 mariadbd[364]: 2021-11-07 15:05:40 0 [Note] 
/usr/sbin/mariadbd (mysqld 10.5.10-MariaDB-log) starting as process 364 ...
Nov 07 15:05:40 After8 mariadbd[364]: 2021-11-07 15:05:40 0 *[Warning] 
Can't create test file /var/lib/mysql/After8.lower-test*
Nov 07 15:05:40 After8 mariadbd[364]: [99B blob data]
Nov 07 15:05:40 After8 mariadbd[364]: 2021-11-07 15:05:40 0 [ERROR] Aborting
Nov 07 15:05:40 After8 systemd[1]: mariadb.service: Main process exited, 
code=exited, status=1/FAILURE
Nov 07 15:05:40 After8 systemd[1]: mariadb.service: Failed with result 
'exit-code'.
Nov 07 15:05:40 After8 systemd[1]: Failed to start MariaDB 10.5.10 
database server.

----status mariadb on gentoo box -----

So my server is not running. No problem, is not used actually.... But 
strange is /var/lib/mysql is "only" a link and the target isn't there:

  917773 lrwxrwxrwx  1 root     root       36  1. Mai 2017  mysql -> 
/run/media/uhai/System/var/lib/mysql

Seemed to be this way since 2017, doesn't matter, digikam was running 
fine.... just confusing me.

So how can I check why the driver QMARIADB isn't loaded? Do I need the 
mariadb-server running on my Gentoo box to load the driver? Is there 
anybody out there who knows this error?

thanks a lot for your help

Uwe

-- 
Uwe Haider
Hauptstr. 60
75031 Eppingen