Hi Alexander,
on upgrade the server needs to restart and this fails:

>From the log:
invoke-rc.d: initscript mysql, action "start" failed.

There isn't much more to that in the log itself, the following might be 
interesting:
$ systemctl status mysql

Never the less there is more to be found in your logs, I saw:
2018-02-01T18:18:40.003189Z 0 [Note] InnoDB: Initializing buffer pool, total 
size = 128M, instances = 1, chunk size = 128M
2018-02-01T18:18:40.003294Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; 
errno 12
2018-02-01T18:18:40.003334Z 0 [ERROR] InnoDB: Cannot allocate memory for the 
buffer pool
2018-02-01T18:18:40.003365Z 0 [ERROR] InnoDB: Plugin initialization aborted 
with error Generic error
2018-02-01T18:18:40.003456Z 0 [ERROR] Plugin 'InnoDB' init function returned 
error.
2018-02-01T18:18:40.003480Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE 
ENGINE failed.
2018-02-01T18:18:40.003496Z 0 [ERROR] Failed to initialize builtin plugins.
2018-02-01T18:18:40.003511Z 0 [ERROR] Aborting

That appears to me as an issue in the config vs the system size.
Maybe also everything is allocated in other applications.
You could try shrinking the buffer and retry the upgrade:
#/etc/mysql/my.cnf 
innodb_buffer_pool_size = 1M

In that it seems to me like [1] or actually bug 1312936

Could you look into the memory (and concurrent session config) if they
could be reduced for the upgrade. You can afterwards still look if/what
consumes your memory, resolve it and increase again.


P.S. There also is this
[ 1134.054457] type=1400 audit(1517509116.605:24): apparmor="DENIED" 
operation="open" parent=14364 profile="/usr/sbin/mysqld" 
name="/sys/devices/system/node/" pid=14365 comm="mysqld" requested_mask="r" 
denied_mask="r" fsuid=0 ouid=0
But I think it is unrelated (only needed for mysql configuring Numa behavior 
and fixed in later Ubuntu releases afaik)

[1]: https://stackoverflow.com/questions/12114746/mysqld-service-stops-
once-a-day-on-ec2-server/12683951#12683951

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1746786

Title:
  package mysql-server-5.7 5.7.21-0ubuntu0.16.04.1 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/1746786/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to