Bug 474964 – app-office/akonadi-server: didnt start with dev-db/mysql-5.5.32

• Product: Gentoo Linux
• Status: RESOLVED DUPLICATE

[Description vylaern 2013-06-27 10:32:51 UTC]

After Today's update (emerge -uDN world) I am not able to start kmail, and other related to Akonadi programs.

Error: The akonadi personal management service is not running

I am not sure if is related to Akonadi or Gentoo as:
1. Today morning kmail was working fine. 
2. Later I did emerge -uDN world, emerge --depclean, revdep-rebuild. 
3. After this reboot (I think) kmail stopped work 

More information is here:
http://forums.gentoo.org/viewtopic-t-962966-highlight-.html

So far I reemerged glibc and openssl (as read somwhere it may be related) - but it did not help.

Test 15:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can be found in <a href='/home/ryszard/.local/share/akonadi/akonadiserver.error'>/home/ryszard/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/ryszard/.local/share/akonadi/akonadiserver.error':
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x458804]
1: akonadiserver() [0x458c31]
2: /lib64/libc.so.6(+0x38540) [0x7fe9b1f30540]
3: /lib64/libc.so.6(gsignal+0x35) [0x7fe9b1f304c5]
4: /lib64/libc.so.6(abort+0x148) [0x7fe9b1f31948]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fe9b39e96c4]
6: /usr/lib64/qt4/libQtCore.so.4(+0x77838) [0x7fe9b39e9838]
7: /usr/lib64/qt4/libQtCore.so.4(_Z6qFatalPKcz+0x9c) [0x7fe9b39e99cc]
8: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0xf5d) [0x4c68ed]
9: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xc7) [0x45b7c7]
10: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xa5) [0x45d575]
11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x45eb97]
12: akonadiserver(main+0x10a) [0x4522fa]
13: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fe9b1f1cbf5]
14: akonadiserver() [0x452ad1]
]
" 

Reproducible: Always

[Comment 1 Michael Palimaka (kensington) 2013-06-27 13:08:25 UTC]

Did you resolve the MySQL problems mentioned in the forum thread yet? It looks like that's why akonadi fails to start.

I order to access you mail you could try temporarily disabling akonadi (it is only a cache and does not store the actual mail).

[Comment 2 vylaern 2013-06-27 18:13:37 UTC]

(In reply to Michael Palimaka (kensington) from comment #1)
> Did you resolve the MySQL problems mentioned in the forum thread yet? It
> looks like that's why akonadi fails to start.

I have no idea what to do now.

I did downgrade mysql to 5.5.31 and reemerged QtCore and Akonadi Server - still problem. I did the same for mysql to 5.5.32 and reemerged QtCore and Akonadi Server - the same. 

I did remove entire Akonadi configuration, but did not help. 
 ~/.local/share/akonadi/ 
 ~/.config/akonadi/ 
 ~/.kde4/share/config/akonadi*

> I order to access you mail you could try temporarily disabling akonadi (it
> is only a cache and does not store the actual mail).
How to do this?

[Comment 3 Michael Palimaka (kensington) 2013-06-28 07:49:49 UTC]

I am not certain if this is the same issue, but in bug #474952 a fix was committed[1]. Could you please try syncing the tree and rebuilding mysql?

[1]: http://sources.gentoo.org/cgi-bin/viewvc.cgi/gentoo-x86/eclass/mysql-cmake.eclass?r1=1.16&r2=1.17

[Comment 4 vylaern 2013-06-28 08:28:23 UTC]

(In reply to Michael Palimaka (kensington) from comment #3)
> I am not certain if this is the same issue, but in bug #474952 a fix was
> committed[1]. Could you please try syncing the tree and rebuilding mysql?
> 
> [1]:
> http://sources.gentoo.org/cgi-bin/viewvc.cgi/gentoo-x86/eclass/mysql-cmake.
> eclass?r1=1.16&r2=1.17

Many thanks!

I have found a sollution on our forum:

Rename table_cache to table_open_cache 

table_cache is deprecated since MySQL 5.1.3 (released in Nov. 2005) and was completely removed in MySQL >= 5.6 


https://bugs.kde.org/show_bug.cgi?id=319016#c2

[Comment 5 vylaern 2013-06-28 08:41:34 UTC]

I forgot to add, those changes above I did in file:
~/.local/share/akonadi/mysql.conf.

[Comment 6 Johannes Huber (RETIRED) 2013-06-28 15:57:16 UTC]

Re-opened, this is fixed with version =app-office/akonadi-server-1.10 which is not released yet.

[Comment 7 Johannes Huber (RETIRED) 2013-06-28 17:06:20 UTC]

(In reply to Johannes Huber from comment #6)
> Re-opened, this is fixed with version =app-office/akonadi-server-1.10 which
> is not released yet.

Ignore my last commet, its a bug in the eclass

*** This bug has been marked as a duplicate of bug 474952 ***

[Comment 8 Franz Trischberger 2013-06-29 06:35:11 UTC]

(In reply to Johannes Huber from comment #7)
> (In reply to Johannes Huber from comment #6)
> > Re-opened, this is fixed with version =app-office/akonadi-server-1.10 which
> > is not released yet.
> 
> Ignore my last commet, its a bug in the eclass
> 
> *** This bug has been marked as a duplicate of bug 474952 ***

The forum thread suggests that it is NOT due to the missing symbolic link, but due to the deprecated mysql function.

[Comment 9 Johannes Huber (RETIRED) 2013-06-29 08:27:34 UTC]

(In reply to Franz Fellner from comment #8)
> (In reply to Johannes Huber from comment #7)
> > (In reply to Johannes Huber from comment #6)
> > > Re-opened, this is fixed with version =app-office/akonadi-server-1.10 which
> > > is not released yet.
> > 
> > Ignore my last commet, its a bug in the eclass
> > 
> > *** This bug has been marked as a duplicate of bug 474952 ***
> 
> The forum thread suggests that it is NOT due to the missing symbolic link,
> but due to the deprecated mysql function.

I hit the same issue and a tree sync and mysql rebuild helped. I didnt change anything about configuration or rebuild akonadi-server. So i assume akonadi-server upstream has a internal check which mysql version is used and use the appropiate mysql function, which in my theory leads to the confusing output when the mysql server cant be started.