Bug 361485 - crash on initial start with mysql 5.7 on ubuntu 16.04
Summary: crash on initial start with mysql 5.7 on ubuntu 16.04
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: unspecified
Platform: Kubuntu Linux
: NOR grave
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-04-07 07:00 UTC by Jan
Modified: 2016-05-22 13:43 UTC (History)
3 users (show)

See Also:
Latest Commit: http://commits.kde.org/akonadi/213e7f9d97e4f072615555563abfebfe932e39a1
Version Fixed In: 16.04.2

Attachments
Updated mysql_install_db options for MySQL 5.7 (969 bytes, patch)
2016-04-19 11:43 UTC, Lars Tangvald 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Jan 2016-04-07 07:00:45 UTC 
On a clean installation of kubuntu 16.04 akonadi won't start.
The initial creation of the mysql database fails.

Reproducible: Always

Steps to Reproduce:
1. Clean install of kubuntu 16.04 beta release
2. Start akonadi from the cli using 'akonadictl start'

Actual Results:  
initial start fails
akonadi is not usable at all

Expected Results:  
initial start of akonadi and be able to set up ressources

janmalte@ubuntu:~$ akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/home/janmalte/.composer/vendor/bin", "/home/janmalte/.bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/opt/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
mysql_install_db: [ERROR] unknown option '--force'
2016-04-07 08:51:57 [ERROR]   Unrecognized options
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/janmalte/.local/share/akonadi/mysql.conf", "--datadir=/home/janmalte/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-janmalte.ddv6eY/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
terminating service threads
terminating connection threads
stopping db process
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/akonadi-janmalte.ddv6eY/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/akonadi-janmalte.ddv6eY/mysql.socket' exists!
Failed to remove Unix socket
Failed to remove runtime connection config file
Application 'akonadiserver' exited normally...
Comment 1 Luis Silva 2016-04-08 09:56:01 UTC 
Confirmed.

Starting by hand with a verbose option gives-me this:
> /usr/sbin/mysqld-akonadi --verbose --defaults-file=/home/luis/.local/share/akonadi/mysql.conf --datadir=/home/luis/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-luis.kRcy3v/mysql.socket 
2016-04-08T09:31:41.254604Z 0 [ERROR] --verbose is for use with --help; did you mean --log-error-verbosity?
2016-04-08T09:31:41.254654Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-08T09:31:41.255134Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu5) starting as process 10263 ...
2016-04-08T09:31:41.258579Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-04-08T09:31:41.259286Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-08T09:31:41.259302Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-08T09:31:41.259310Z 0 [Note] InnoDB: Uses event mutexes
2016-04-08T09:31:41.259315Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-04-08T09:31:41.259321Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-08T09:31:41.259326Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-08T09:31:41.259571Z 0 [Note] InnoDB: Number of pools: 1
2016-04-08T09:31:41.259667Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-04-08T09:31:41.267429Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-08T09:31:41.276014Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-08T09:31:41.277624Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-04-08T09:31:41.289501Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-08T09:31:41.381807Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-08T09:31:41.381983Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-08T09:31:41.587942Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-08T09:31:41.589716Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-08T09:31:41.589742Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-08T09:31:41.590643Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 5549599
2016-04-08T09:31:41.591076Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/luis/.local/share/akonadi/db_data/ib_buffer_pool
2016-04-08T09:31:41.591486Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-08T09:31:41.592210Z 0 [Warning] System table 'plugin' is expected to be transactional.
2016-04-08T09:31:41.592540Z 0 [ERROR] unknown variable 'defaults-file=/home/luis/.local/share/akonadi/mysql.conf'
2016-04-08T09:31:41.592563Z 0 [ERROR] Aborting

2016-04-08T09:31:41.592581Z 0 [Note] Binlog end
2016-04-08T09:31:41.592670Z 0 [Note] Shutting down plugin 'ngram'
2016-04-08T09:31:41.592685Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-04-08T09:31:41.592698Z 0 [Note] Shutting down plugin 'partition'
2016-04-08T09:31:41.592710Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-08T09:31:41.592728Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-04-08T09:31:41.592747Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-08T09:31:41.592757Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-08T09:31:41.592777Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-08T09:31:41.592788Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-08T09:31:41.592798Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-08T09:31:41.592807Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-08T09:31:41.592816Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-08T09:31:41.592825Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-08T09:31:41.592834Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-08T09:31:41.592843Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-08T09:31:41.592852Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-08T09:31:41.592863Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-08T09:31:41.592873Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-08T09:31:41.592882Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-08T09:31:41.592892Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-08T09:31:41.592901Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-08T09:31:41.592909Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-04-08T09:31:41.592918Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-04-08T09:31:41.592928Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-04-08T09:31:41.592938Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-08T09:31:41.592947Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-04-08T09:31:41.592957Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-08T09:31:41.592966Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-08T09:31:41.592975Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-08T09:31:41.592983Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-08T09:31:41.592992Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-08T09:31:41.593001Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-08T09:31:41.593011Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-08T09:31:41.593021Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-08T09:31:41.593031Z 0 [Note] Shutting down plugin 'InnoDB'
2016-04-08T09:31:41.593495Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160408 10:31:41
2016-04-08T09:31:41.594151Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-04-08T09:31:41.594357Z 0 [Note] InnoDB: Starting shutdown...
2016-04-08T09:31:41.694654Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/luis/.local/share/akonadi/db_data/ib_buffer_pool
2016-04-08T09:31:41.694975Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160408 10:31:41
2016-04-08T09:31:43.468025Z 0 [Note] InnoDB: Shutdown completed; log sequence number 5549618
2016-04-08T09:31:43.472847Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-04-08T09:31:43.472881Z 0 [Note] Shutting down plugin 'MEMORY'
2016-04-08T09:31:43.472893Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-08T09:31:43.473025Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-08T09:31:43.473049Z 0 [Note] Shutting down plugin 'MyISAM'
2016-04-08T09:31:43.473068Z 0 [Note] Shutting down plugin 'CSV'
2016-04-08T09:31:43.473084Z 0 [Note] Shutting down plugin 'sha256_password'
2016-04-08T09:31:43.473104Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-04-08T09:31:43.473119Z 0 [Note] Shutting down plugin 'keyring_file'
2016-04-08T09:31:43.473617Z 0 [Note] Shutting down plugin 'binlog'
2016-04-08T09:31:43.473950Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Comment 2 Luis Silva 2016-04-08 13:50:16 UTC 
The --verbose flag was not the appropriate one. Here is the true result of trying to start the mysqld instance by hand. The problem is clear, akonadi is not handling the update correctly and mysql.plugin is not either created or ignored.

/usr/sbin/mysqld-akonadi --log-error-verbosity 3 --defaults-file=/home/luis/.local/share/akonadi/mysql.conf --datadir=/home/luis/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-luis.kRcy3v/mysql.socket
2016-04-08T10:01:35.514463Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-08T10:01:35.514918Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu5) starting as process 11593 ...
2016-04-08T10:01:35.518123Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-04-08T10:01:35.518707Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-08T10:01:35.518720Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-08T10:01:35.518725Z 0 [Note] InnoDB: Uses event mutexes
2016-04-08T10:01:35.518730Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-04-08T10:01:35.518737Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-08T10:01:35.518741Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-08T10:01:35.518953Z 0 [Note] InnoDB: Number of pools: 1
2016-04-08T10:01:35.519066Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-04-08T10:01:35.525746Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-08T10:01:35.535867Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-08T10:01:35.537356Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-04-08T10:01:35.548783Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-08T10:01:35.613938Z 0 [Warning] InnoDB: Resizing redo log from 2*4096 to 2*3072 pages, LSN=1210920
2016-04-08T10:01:35.824327Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-04-08T10:01:35.873786Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-04-08T10:01:36.525040Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-04-08T10:01:37.292231Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-04-08T10:01:37.292473Z 0 [Warning] InnoDB: New log files created, LSN=1210920
2016-04-08T10:01:37.293068Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-08T10:01:37.293240Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-08T10:01:37.503690Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-08T10:01:37.506101Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-08T10:01:37.506136Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-08T10:01:37.526904Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 1210911
2016-04-08T10:01:37.527275Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/luis/.local/share/akonadi/db_data/ib_buffer_pool
2016-04-08T10:01:37.527517Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-04-08T10:01:37.527786Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-04-08T10:01:37.528092Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160408 11:01:37
2016-04-08T10:01:37.528105Z 0 [ERROR] unknown variable 'defaults-file=/home/luis/.local/share/akonadi/mysql.conf'
2016-04-08T10:01:37.528171Z 0 [ERROR] Aborting

2016-04-08T10:01:37.528191Z 0 [Note] Binlog end
2016-04-08T10:01:37.528277Z 0 [Note] Shutting down plugin 'ngram'
2016-04-08T10:01:37.528291Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-04-08T10:01:37.528303Z 0 [Note] Shutting down plugin 'partition'
2016-04-08T10:01:37.528314Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-08T10:01:37.528325Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-04-08T10:01:37.528337Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-08T10:01:37.528347Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-08T10:01:37.528357Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-08T10:01:37.528366Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-08T10:01:37.528376Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-08T10:01:37.528386Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-08T10:01:37.528396Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-08T10:01:37.528406Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-08T10:01:37.528415Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-08T10:01:37.528425Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-08T10:01:37.528434Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-08T10:01:37.528444Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-08T10:01:37.528453Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-08T10:01:37.528463Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-08T10:01:37.528473Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-08T10:01:37.528483Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-08T10:01:37.528492Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-04-08T10:01:37.528501Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-04-08T10:01:37.528511Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-04-08T10:01:37.528520Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-08T10:01:37.528530Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-04-08T10:01:37.528539Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-08T10:01:37.528549Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-08T10:01:37.528558Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-08T10:01:37.528567Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-08T10:01:37.528577Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-08T10:01:37.528587Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-08T10:01:37.528596Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-08T10:01:37.528606Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-08T10:01:37.528615Z 0 [Note] Shutting down plugin 'InnoDB'
2016-04-08T10:01:37.528689Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-04-08T10:01:37.528871Z 0 [Note] InnoDB: Starting shutdown...
2016-04-08T10:01:37.629231Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/luis/.local/share/akonadi/db_data/ib_buffer_pool
2016-04-08T10:01:37.629594Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160408 11:01:37
2016-04-08T10:01:39.404497Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1211423
2016-04-08T10:01:39.409221Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-04-08T10:01:39.409252Z 0 [Note] Shutting down plugin 'MEMORY'
2016-04-08T10:01:39.409264Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-08T10:01:39.409364Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-08T10:01:39.409376Z 0 [Note] Shutting down plugin 'MyISAM'
2016-04-08T10:01:39.409421Z 0 [Note] Shutting down plugin 'CSV'
2016-04-08T10:01:39.409440Z 0 [Note] Shutting down plugin 'sha256_password'
2016-04-08T10:01:39.409457Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-04-08T10:01:39.409471Z 0 [Note] Shutting down plugin 'keyring_file'
2016-04-08T10:01:39.409893Z 0 [Note] Shutting down plugin 'binlog'
2016-04-08T10:01:39.410207Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Comment 3 Lars Tangvald 2016-04-19 11:43:03 UTC 
There are two separate issues that need to be addressed:
mysql_install_db uses removed options:
 It's recommended to start using mysqld --initialize instead of mysql_install_db, but the old behavior can be preserved with some changes to the options (this change will not be compatible with 5.6)
Comment 4 Lars Tangvald 2016-04-19 11:43:57 UTC 
Created attachment 98462 [details]
Updated mysql_install_db options for MySQL 5.7

This patch will update mysql_install_db usage in akonadi to work with MySQL 5.7. The changes are not compatible with 5.6
Comment 5 Lars Tangvald 2016-04-19 11:46:15 UTC 
The other issue is that since MySQL 5.7 is significantly more strict by default than 5.6, the sql scripts used for database init will fail.
Ideally these would be gone through and updated, but a possible workaround is also to simply add 
 sql_mode=NO_ENGINE_SUBSTITUTION to the configuration file, which sets the server in the same mode as the 5.6 default.

For more info: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Comment 6 Lars Tangvald 2016-04-19 11:55:35 UTC 
Launchpad bug report: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1572100
Comment 7 Bernhard Lindner 2016-04-19 21:18:23 UTC 
Seems I am experiencing this an my new Kubuntu 16.04 system too. Is there a workaround that allow my to set up the system correctly soon?
Comment 8 Daniel Vrátil 2016-05-22 13:43:22 UTC 
Git commit 213e7f9d97e4f072615555563abfebfe932e39a1 by Daniel Vrátil.
Committed on 22/05/2016 at 13:21.
Pushed by dvratil into branch 'Applications/16.04'.

Fix MySQL 5.7 support

This implements support for various versions of Oracle MySQL and MariaDB,
adding a special case for MySQL >= 5.7.4 (which removed --force command
line option) and MySQL >= 5.7.6 (which deprecated mysql_db_install and
recommends mysqld --initialize instead)

Also improves debug output during initialization.
FIXED-IN: 16.04.2

M  +7    -0    src/server/storage/dbconfig.cpp
M  +4    -0    src/server/storage/dbconfig.h
M  +91   -22   src/server/storage/dbconfigmysql.cpp
M  +7    -1    src/server/storage/dbconfigmysql.h

http://commits.kde.org/akonadi/213e7f9d97e4f072615555563abfebfe932e39a1