Bug 319016 - Akonadi fails to start with MySQL 5.6 due to use of deprecated system variable
Summary: Akonadi fails to start with MySQL 5.6 due to use of deprecated system variable
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: 1.9.1
Platform: Compiled Sources Linux
: NOR grave
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
: 321484 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-04-28 09:29 UTC by Ragnar Thomsen
Modified: 2013-11-29 13:26 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 1.10


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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)