Bug 482354 – =app-office/akonadi-server-1.10.2-r1 - QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use - ... - Can't connect to local MySQL server through socket '/home/tfoerste/.local/share/akonadi/socket-n22/mysql.socket' (2)

• Status: RESOLVED INVALID
• Product: Gentoo Linux

[Description Toralf Förster 2013-08-24 19:41:40 UTC]

I disabled desktop search completely but nevertheless :
I'm just curious if this is Gentoo specific or should be reported to KDE.
In my .xsession-errors I found a lot of the following lines:


krunner(13379)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/tfoerste/.kde4/share/apps/kabc" 
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/i686-pc-linux-gnu/gcc-bin/4.6.3", "/usr/games/bin", "/home/tfoerste/workspace/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/tfoerste/.local/share/akonadi/socket-n22/mysql.socket' (2)"
QSqlQuery::exec: database not open
Unable to open database "Can't connect to local MySQL server through socket '/home/tfoerste/.local/share/akonadi/socket-n22/mysql.socket' (2) QMYSQL: Unable to connect"
"[
0: akonadiserver(_Z11akBacktracev+0x36) [0x80948a6]
1: akonadiserver() [0x8094b61]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb77e3400]
3: linux-gate.so.1(__kernel_vsyscall+0x10) [0xb77e3424]
4: /lib/libc.so.6(gsignal+0x4f) [0x469ad55f]
5: /lib/libc.so.6(abort+0x175) [0x469aee25]
6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8a) [0xb7557c1a]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8096c78]
8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb7601929]
9: /usr/lib/qt4/libQtCore.so.4(+0x11992d) [0xb760e92d]
10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb761861e]
11: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5e4) [0x8099004]
12: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x36) [0x809a2e6]
13: akonadiserver(main+0x1f0) [0x808df80]
14: /lib/libc.so.6(__libc_start_main+0xf3) [0x46998943]
15: akonadiserver() [0x808e801]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/i686-pc-linux-gnu/gcc-bin/4.6.3", "/usr/games/bin", "/home/tfoerste/workspace/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QMYSQL: Unable to connect"
Last database error: "Can't connect to local MySQL server through socket '/home/tfoerste/.local/share/akonadi/socket-n22/mysql.socket' (2)"
QSqlQuery::exec: database not open
Unable to open database "Can't connect to local MySQL server through socket '/home/tfoerste/.local/s







And this is the file which is there instead :

tfoerste@n22 ~ $ la -l /home/tfoerste/.local/share/akonadi/socket-n22/
total 16
drwx------  2 tfoerste users  4096 Aug 24 16:52 .
drwxrwxrwt 14 root     root  12288 Aug 24 21:38 ..
srwxr-xr-x  1 tfoerste users     0 Aug 24 16:52 akonadiserver.socket


I'm running a stable x86 Gentoo with 4.11.0 KDE.


tfoerste@n22 ~ $ cat /home/tfoerste/.config/akonadi/akonadiserverrc
[%General]
Driver=QMYSQL

[QMYSQL]
Name=akonadi
Host=
Options="UNIX_SOCKET=/home/tfoerste/.local/share/akonadi/socket-n22/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=false

[Debug]
Tracer=null

[Comment 1 Johannes Huber (RETIRED) 2013-09-14 19:37:47 UTC]

Please check if your configured mysql server is running.

[Comment 2 Toralf Förster 2013-09-15 12:04:15 UTC]

(In reply to Johannes Huber from comment #1)
> Please check if your configured mysql server is running.

oh, I do not have a mysqld running, and b/c I disabled desktop search I thought that I do not need it.

[Comment 3 Johannes Huber (RETIRED) 2013-09-15 12:26:09 UTC]

(In reply to Toralf Förster from comment #2)
> (In reply to Johannes Huber from comment #1)
> > Please check if your configured mysql server is running.
> 
> oh, I do not have a mysqld running, and b/c I disabled desktop search I
> thought that I do not need it.

Akonadi is NOT used for desktop search, its the storage for PIM meta data. So disabling doesnt help in this case. Please check if your configuration is valid.

[Comment 4 Toralf Förster 2013-09-15 20:16:03 UTC]

(In reply to Johannes Huber from comment #3)
> Akonadi is NOT used for desktop search, its the storage for PIM meta data.
Ough - sry.

>Please check if your configuration is valid.
Yep - ~/.config/akonadi/akonadiserverrc contained an outdated path name - PEBKAC.