Bug 319016

Summary: Akonadi fails to start with MySQL 5.6 due to use of deprecated system variable
Product: [Frameworks and Libraries] Akonadi Reporter: Ragnar Thomsen <rthomsen6>
Component: serverAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED FIXED    
Severity: grave CC: kde.org, nico.kruber
Priority: NOR    
Version: 1.9.1   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: http://commits.kde.org/akonadi/13876b14c5b6791f174918cda9d7fedb826237e6 Version Fixed In: 1.10

Description Ragnar Thomsen 2013-04-28 09:29:59 UTC 
The table_cache system variable used in the mysql-global.conf configuration file in akonadi was deprecated already in MySQL 5.1.3 and replaced by table_cache . However, it seem the old variable name was still supported up to MySQL 5.5. After upgrading to MySQL 5.6, akonadi server fails to start up due to usage of this deprecated variable.

Reproducible: Always

Steps to Reproduce:
1. Upgrade to MySQL 5.6
2. Start Akonadi server
Actual Results:  
Akonadi fails to start.

Expected Results:  
Akonadi should start normally.

See:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_table_cache
and:
http://dev.mysql.com/doc/relnotes/mysql/5.1/en/news-5-1-3.html
Comment 1 Ragnar Thomsen 2013-04-28 09:32:20 UTC 
Errata:
It was replaced by table_open_cache. Sorry.
Comment 2 Christophe Marin 2013-06-07 15:35:50 UTC 
Git commit 13876b14c5b6791f174918cda9d7fedb826237e6 by Christophe Giboudeaux.
Committed on 07/06/2013 at 17:35.
Pushed by cgiboudeaux into branch 'master'.

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

No other change is needed. On the next akonadiserver startup, the existing config file will be replaced with the new one.
FIXED-IN: 1.10

M  +2    -1    INSTALL
M  +2    -1    server/src/storage/mysql-global-mobile.conf
M  +2    -1    server/src/storage/mysql-global.conf

http://commits.kde.org/akonadi/13876b14c5b6791f174918cda9d7fedb826237e6
Comment 3 Daniel Vrátil 2013-06-24 08:14:09 UTC 
*** Bug 321484 has been marked as a duplicate of this bug. ***
Comment 4 Nico Kruber 2013-11-29 13:26:21 UTC 
could we detect this and automatically update user configuration files?
(otherwise, I guess users updating mysql, e.g. through distro upgrade, need to update the (old) config files themselves)