I'm posting this bug here, although the upgrade process in my case did
finish (upgraded from 5.6 to 5.7 on Xenial) but left it in a failed
state
<...SNIP...>
Installing new version of config file /etc/mysql/mysql.conf.d/mysqld.cnf ...
Job for mysql.service failed because the control process exited with error
code. See "systemctl stat
us mysql.service" and
"journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for systemd (229-4ubuntu1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Logs say:
2016-04-12T17:12:04.333194Z 0 [ERROR] unknown variable 'key_buffer=16M'
2016-04-12T17:12:04.333206Z 0 [ERROR] Aborting
Commenting out the line 'key_buffer=16M' and running 'apt-get install -f'
appeared to continue successfully, reporting upgrading the databases too.
However, looking in the log again, I saw this:
2016-04-12T17:18:17.643847Z 0 [Warning] Changed limits: max_open_files: 1024
(requested 5000)
2016-04-12T17:18:17.643990Z 0 [Warning] Changed limits: table_open_cache: 431
(requested 2000)
2016-04-12T17:18:17.814693Z 0 [Warning] TIMESTAMP with implicit DEFAULT value
is deprecated. Please use --explicit_defaults_for_timestamp server option (see
documentation for more details).
2016-04-12T17:18:17.815303Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu5)
starting as process 14227 ...
2016-04-12T17:18:17.820389Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-12T17:18:17.820440Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2016-04-12T17:18:17.820462Z 0 [Note] InnoDB: Uses event mutexes
2016-04-12T17:18:17.820494Z 0 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2016-04-12T17:18:17.820501Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-12T17:18:17.820511Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-12T17:18:17.820783Z 0 [Note] InnoDB: Number of pools: 1
2016-04-12T17:18:17.820911Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-04-12T17:18:17.832665Z 0 [Note] InnoDB: Initializing buffer pool, total
size = 128M, instances = 1, chunk size = 128M
2016-04-12T17:18:17.842499Z 0 [Note] InnoDB: Completed initialization of buffer
pool
2016-04-12T17:18:17.845028Z 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-12T17:18:17.857904Z 0 [Note] InnoDB: Highest supported file format is
Barracuda.
2016-04-12T17:18:17.897639Z 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2016-04-12T17:18:17.897896Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2016-04-12T17:18:17.915828Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-12T17:18:17.917207Z 0 [Note] InnoDB: 96 redo rollback segment(s) found.
96 redo rollback segment(s) are active.
2016-04-12T17:18:17.917243Z 0 [Note] InnoDB: 32 non-redo rollback segment(s)
are active.
2016-04-12T17:18:17.917712Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-12T17:18:17.970631Z 0 [Note] InnoDB: 5.7.11 started; log sequence
number 5501485
2016-04-12T17:18:17.971034Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-12T17:18:17.971681Z 0 [Warning] System table 'plugin' is expected to be
transactional.
2016-04-12T17:18:17.972924Z 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2016-04-12T17:18:17.973183Z 0 [Note] InnoDB: Buffer pool(s) load completed at
160412 18:18:17
2016-04-12T17:18:17.973509Z 0 [Warning] Gtid table is not ready to be used.
Table 'mysql.gtid_executed' cannot be opened.
2016-04-12T17:18:17.973813Z 0 [Warning] Failed to set up SSL because of the
following SSL library error: SSL context is not usable without certificate and
private key
2016-04-12T17:18:17.973832Z 0 [Note] Server hostname (bind-address):
'127.0.0.1'; port: 3306
2016-04-12T17:18:17.973847Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2016-04-12T17:18:17.973878Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2016-04-12T17:18:17.974131Z 0 [Warning] Failed to open optimizer cost constant
tables
2016-04-12T17:18:17.987727Z 0 [Warning] System table 'time_zone_leap_second' is
expected to be transactional.
2016-04-12T17:18:17.987788Z 0 [Warning] System table 'time_zone_name' is
expected to be transactional.
2016-04-12T17:18:17.987799Z 0 [Warning] System table 'time_zone' is expected to
be transactional.
2016-04-12T17:18:17.987810Z 0 [Warning] System table
'time_zone_transition_type' is expected to be transactional.
2016-04-12T17:18:17.987817Z 0 [Warning] System table 'time_zone_transition' is
expected to be transactional.
2016-04-12T17:18:18.010690Z 0 [Warning] System table 'servers' is expected to
be transactional.
2016-04-12T17:18:18.013140Z 0 [ERROR] Incorrect definition of table
performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE'
at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT',
found type enum('STATEMENT','STAGE','WAIT').
2016-04-12T17:18:18.013560Z 0 [ERROR] Incorrect definition of table
performance_schema.events_waits_history: expected column 'NESTING_EVENT_TYPE'
at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT',
found type enum('STATEMENT','STAGE','WAIT').
2016-04-12T17:18:18.013897Z 0 [ERROR] Incorrect definition of table
performance_schema.events_waits_history_long: expected column
'NESTING_EVENT_TYPE' at position 15 to have type
enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type
enum('STATEMENT','STAGE','WAIT').
2016-04-12T17:18:18.015277Z 0 [ERROR] Incorrect definition of table
performance_schema.events_waits_summary_by_user_by_event_name: expected column
'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.015544Z 0 [ERROR] Incorrect definition of table
performance_schema.events_waits_summary_by_account_by_event_name: expected
column 'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.018313Z 0 [ERROR] Column count of
performance_schema.setup_actors is wrong. Expected 5, found 3. Created with
MySQL 50628, now running 50711. Please use mysql_upgrade to fix this error.
2016-04-12T17:18:18.019123Z 0 [ERROR] Incorrect definition of table
performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0
to have type enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER', found type
enum('TABLE').
2016-04-12T17:18:18.020601Z 0 [ERROR] Column count of
performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68,
found 73. Created with MySQL 50628, now running 50711. Please use mysql_upgrade
to fix this error.
2016-04-12T17:18:18.020866Z 0 [ERROR] Column count of
performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL
50628, now running 50711. Please use mysql_upgrade to fix this error.
2016-04-12T17:18:18.021176Z 0 [ERROR] Column count of
performance_schema.events_stages_current is wrong. Expected 12, found 10.
Created with MySQL 50628, now running 50711. Please use mysql_upgrade to fix
this error.
2016-04-12T17:18:18.021408Z 0 [ERROR] Column count of
performance_schema.events_stages_history is wrong. Expected 12, found 10.
Created with MySQL 50628, now running 50711. Please use mysql_upgrade to fix
this error.
2016-04-12T17:18:18.023312Z 0 [ERROR] Column count of
performance_schema.events_stages_history_long is wrong. Expected 12, found 10.
Created with MySQL 50628, now running 50711. Please use mysql_upgrade to fix
this error.
2016-04-12T17:18:18.023879Z 0 [ERROR] Incorrect definition of table
performance_schema.events_stages_summary_by_account_by_event_name: expected
column 'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.024136Z 0 [ERROR] Incorrect definition of table
performance_schema.events_stages_summary_by_user_by_event_name: expected column
'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.024905Z 0 [ERROR] Column count of
performance_schema.events_statements_current is wrong. Expected 41, found 40.
Created with MySQL 50628, now running 50711. Please use mysql_upgrade to fix
this error.
2016-04-12T17:18:18.025231Z 0 [ERROR] Column count of
performance_schema.events_statements_history is wrong. Expected 41, found 40.
Created with MySQL 50628, now running 50711. Please use mysql_upgrade to fix
this error.
2016-04-12T17:18:18.025742Z 0 [ERROR] Column count of
performance_schema.events_statements_history_long is wrong. Expected 41, found
40. Created with MySQL 50628, now running 50711. Please use mysql_upgrade to
fix this error.
2016-04-12T17:18:18.026272Z 0 [ERROR] Incorrect definition of table
performance_schema.events_statements_summary_by_account_by_event_name: expected
column 'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.026517Z 0 [ERROR] Incorrect definition of table
performance_schema.events_statements_summary_by_user_by_event_name: expected
column 'USER' at position 0 to have type char(32), found type char(16).
2016-04-12T17:18:18.028505Z 0 [ERROR] Native table
'performance_schema'.'events_statements_summary_by_program' has the wrong
structure
2016-04-12T17:18:18.028566Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_current' has the wrong structure
2016-04-12T17:18:18.028607Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_history' has the wrong structure
2016-04-12T17:18:18.028641Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_history_long' has the wrong structure
2016-04-12T17:18:18.028687Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has
the wrong structure
2016-04-12T17:18:18.028736Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_summary_by_account_by_event_name' has
the wrong structure
2016-04-12T17:18:18.028774Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_summary_by_user_by_event_name' has
the wrong structure
2016-04-12T17:18:18.028810Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_summary_by_host_by_event_name' has
the wrong structure
2016-04-12T17:18:18.028846Z 0 [ERROR] Native table
'performance_schema'.'events_transactions_summary_global_by_event_name' has the
wrong structure
2016-04-12T17:18:18.029148Z 0 [ERROR] Incorrect definition of table
performance_schema.users: expected column 'USER' at position 0 to have type
char(32), found type char(16).
2016-04-12T17:18:18.029432Z 0 [ERROR] Incorrect definition of table
performance_schema.accounts: expected column 'USER' at position 0 to have type
char(32), found type char(16).
2016-04-12T17:18:18.031390Z 0 [ERROR] Native table
'performance_schema'.'memory_summary_global_by_event_name' has the wrong
structure
2016-04-12T17:18:18.031471Z 0 [ERROR] Native table
'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong
structure
2016-04-12T17:18:18.031533Z 0 [ERROR] Native table
'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong
structure
2016-04-12T17:18:18.031601Z 0 [ERROR] Native table
'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong
structure
2016-04-12T17:18:18.031671Z 0 [ERROR] Native table
'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong
structure
2016-04-12T17:18:18.031732Z 0 [ERROR] Native table
'performance_schema'.'table_handles' has the wrong structure
2016-04-12T17:18:18.031788Z 0 [ERROR] Native table
'performance_schema'.'metadata_locks' has the wrong structure
2016-04-12T17:18:18.031847Z 0 [ERROR] Native table
'performance_schema'.'replication_connection_configuration' has the wrong
structure
2016-04-12T17:18:18.031911Z 0 [ERROR] Native table
'performance_schema'.'replication_group_members' has the wrong structure
2016-04-12T17:18:18.031983Z 0 [ERROR] Native table
'performance_schema'.'replication_connection_status' has the wrong structure
2016-04-12T17:18:18.032051Z 0 [ERROR] Native table
'performance_schema'.'replication_applier_configuration' has the wrong structure
2016-04-12T17:18:18.032100Z 0 [ERROR] Native table
'performance_schema'.'replication_applier_status' has the wrong structure
2016-04-12T17:18:18.032154Z 0 [ERROR] Native table
'performance_schema'.'replication_applier_status_by_coordinator' has the wrong
structure
2016-04-12T17:18:18.032201Z 0 [ERROR] Native table
'performance_schema'.'replication_applier_status_by_worker' has the wrong
structure
2016-04-12T17:18:18.032260Z 0 [ERROR] Native table
'performance_schema'.'replication_group_member_stats' has the wrong structure
2016-04-12T17:18:18.032318Z 0 [ERROR] Native table
'performance_schema'.'prepared_statements_instances' has the wrong structure
2016-04-12T17:18:18.032370Z 0 [ERROR] Native table
'performance_schema'.'user_variables_by_thread' has the wrong structure
2016-04-12T17:18:18.032458Z 0 [ERROR] Native table
'performance_schema'.'status_by_account' has the wrong structure
2016-04-12T17:18:18.032504Z 0 [ERROR] Native table
'performance_schema'.'status_by_host' has the wrong structure
2016-04-12T17:18:18.032551Z 0 [ERROR] Native table
'performance_schema'.'status_by_thread' has the wrong structure
2016-04-12T17:18:18.032604Z 0 [ERROR] Native table
'performance_schema'.'status_by_user' has the wrong structure
2016-04-12T17:18:18.032647Z 0 [ERROR] Native table
'performance_schema'.'global_status' has the wrong structure
2016-04-12T17:18:18.032712Z 0 [ERROR] Native table
'performance_schema'.'session_status' has the wrong structure
2016-04-12T17:18:18.032755Z 0 [ERROR] Native table
'performance_schema'.'variables_by_thread' has the wrong structure
2016-04-12T17:18:18.032815Z 0 [ERROR] Native table
'performance_schema'.'global_variables' has the wrong structure
2016-04-12T17:18:18.032966Z 0 [ERROR] Native table
'performance_schema'.'session_variables' has the wrong structure
2016-04-12T17:18:18.033283Z 0 [ERROR] Incorrect definition of table mysql.db:
expected column 'User' at position 2 to have type char(32), found type char(16).
2016-04-12T17:18:18.033411Z 0 [ERROR] mysql.user has no `Event_priv` column at
position 28
2016-04-12T17:18:18.034667Z 0 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
2016-04-12T17:18:18.034896Z 0 [Note] /usr/sbin/mysqld: ready for connections.
2016-04-12T17:18:18.661266Z 2 [Note] Access denied for user 'root'@'localhost'
(using password: NO)
2016-04-12T17:18:19.309965Z 4 [Warning] System table 'servers' is expected to
be transactional.
2016-04-12T17:18:20.467804Z 5 [Note] Access denied for user 'root'@'localhost'
(using password: NO)
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1567884
Title:
package mysql-server-5.7 5.7.11-0ubuntu5 failed to install/upgrade:
subprocess installed post-installation script returned error exit
status 1
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1567884/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
