package mysql-server-5.7 5.7.20-0ubuntu0.17.04.1 failed to install/upgrade: sub-processo script post-installation instalado retornou estado de saída de erro 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
Error with package mysql-server-5.7 in ubuntu version upgrade and others cases like dpkg --configure -a
ProblemType: Package
DistroRelease: Ubuntu 17.04
Package: mysql-server-5.7 5.7.20-
ProcVersionSign
Uname: Linux 4.10.0-38-generic x86_64
ApportVersion: 2.20.4-0ubuntu4.5
Architecture: amd64
Date: Thu Nov 2 10:19:52 2017
ErrorMessage: sub-processo script post-installation instalado retornou estado de saída de erro 1
InstallationDate: Installed on 2017-07-09 (115 days ago)
InstallationMedia: Ubuntu 17.04 "Zesty Zapus" - Release amd64 (20170412)
Logs.var.
MySQLConf.
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
ProcCmdline: BOOT_IMAGE=
RelatedPackageV
dpkg 1.18.10ubuntu2
apt 1.4.6~17.04.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.20-
UpgradeStatus: Upgraded to zesty on 2017-11-02 (0 days ago)
Hi Sullyvan,
from your log:
[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 dev.mysql. com/doc/ refman/ 5.7/en/ operating- system- error-codes. html data_file_ path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
[Note] InnoDB: Retrying to lock the first data file
[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
[...]
[Note] InnoDB: Unable to open the first data file
[ERROR] InnoDB: Operating system error number 11 in a file operation.
[ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
[Note] InnoDB: Some operating system error numbers are described at http://
[ERROR] InnoDB: Cannot open datafile './ibdata1'
[ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_
[ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Are there any mysql services still running, like sharing with another version running concurrently.
It also could be a daemon that aborted in a really bad state.
You could start checking if that file is actually open by any process via using "lsof".
Most similar cases [1] also seem to point to still running processes that you have to clean up.
As I suggested lsof is probably the best start tp get this sorted out.
[1]: https:/ /serverfault. com/questions/ 477448/ mysql-keeps- crashing- innodb- unable- to-lock- ibdata1- error-11