[Akonadi] [Bug 361485] crash on initial start with mysql 5.7 on ubuntu 16.04

Fri Apr 8 14:50:16 BST 2016

https://bugs.kde.org/show_bug.cgi?id=361485

--- Comment #2 from Luis Silva <lacsilva at gmail.com> ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.