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
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
accoured doring ubuntu release upgrade from 14 to 16.3
ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.21-
ProcVersionSign
Uname: Linux 3.8.0-29-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.15
Architecture: amd64
Date: Thu Feb 1 13:18:40 2018
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2013-10-24 (1561 days ago)
InstallationMedia: Ubuntu-Server 12.04.3 LTS "Precise Pangolin" - Release amd64 (20130820.2)
Logs.var.
MySQLConf.
MySQLConf.
[mysqld_safe]
syslog
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
ProcCmdline: root=LABEL=DOROOT ro
RelatedPackageV
dpkg 1.18.4ubuntu1.3
apt 1.2.24
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.21-
UpgradeStatus: Upgraded to xenial on 2018-02-01 (0 days ago)
tags: | removed: need-duplicate-check |
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: 01T18:18: 40.003189Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 01T18:18: 40.003294Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12 01T18:18: 40.003334Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 01T18:18: 40.003365Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 01T18:18: 40.003456Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 01T18:18: 40.003480Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 01T18:18: 40.003496Z 0 [ERROR] Failed to initialize builtin plugins. 01T18:18: 40.003511Z 0 [ERROR] Aborting
2018-02-
2018-02-
2018-02-
2018-02-
2018-02-
2018-02-
2018-02-
2018-02-
That appears to me as an issue in the config vs the system size. buffer_ pool_size = 1M
Maybe also everything is allocated in other applications.
You could try shrinking the buffer and retry the upgrade:
#/etc/mysql/my.cnf
innodb_
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 6.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
[ 1134.054457] type=1400 audit(151750911
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