[digiKam-users] QSqlDatabase: driver not loaded

[Maik Qualmann]

Post the log from the start of digiKam with active debug output: 

export QT_LOGGING_RULES="digikam.*=true"

Maik

Am Sonntag, 7. November 2021, 15:44:44 CET schrieb 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