Ubuntu
mysql-5.7 package

mysql-server-5.7.postinst fails with "Unknown database 'performance_schema'"

Bug #1574040 reported by Didier David-Boudet on 2016-04-23

This bug report is a duplicate of: Bug #1577712: mysql_upgrade is called twice concurrently on upgrade from 14.04. Edit Remove

This bug affects 10 people

Affects		Status	Importance	Assigned to	Milestone
	mysql-5.7 (Ubuntu)	Triaged	High	Lars Tangvald	Ubuntu ubuntu-16.05

Bug Description

problems after installing 16.04

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.11-0ubuntu6
ProcVersionSignature: Ubuntu 4.4.0-21.37-generic 4.4.6
Uname: Linux 4.4.0-21-generic i686
NonfreeKernelModules: nvidia_uvm nvidia
ApportVersion: 2.20.1-0ubuntu2
Architecture: i386
Date: Sat Apr 23 16:32:33 2016
ErrorMessage: le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1
InstallationDate: Installed on 2012-04-23 (1461 days ago)
InstallationMedia: Ubuntu 11.10 "Oneiric" - Build i386 LIVE Binary 20111013-11:02
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['mysql', 'ibtmp1', 'debian-5.5.flag', 'auto.cnf', 'ibdata1', 'mysql_upgrade_info', 'debian-5.7.flag', 'ib_logfile0', 'ib_buffer_pool', 'ib_logfile1', 'performance_schema', 'sys']
ProcCmdline: BOOT_IMAGE=/vmlinuz-4.4.0-21-generic root=UUID=72b6b1ba-9553-47a8-8a54-0e50850cd0ea ro quiet splash
RelatedPackageVersions:
dpkg 1.18.4ubuntu1
apt 1.2.10ubuntu1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.11-0ubuntu6 failed to install/upgrade: le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1
UpgradeStatus: Upgraded to xenial on 2016-04-23 (0 days ago)

Tags:

Revision history for this message

Didier David-Boudet (didierdavidboudet) wrote on 2016-04-23:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (1.5 KiB, text/plain; charset="utf-8")
AptOrdering.txt Edit (153.7 KiB, text/plain; charset="utf-8")
Dependencies.txt Edit (3.4 KiB, text/plain; charset="utf-8")
Df.txt Edit (901 bytes, text/plain; charset="utf-8")
Dmesg.txt Edit (66.2 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (166.8 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.gz Edit (129.6 KiB, application/x-gzip)
HookError_ubuntu.txt Edit (783 bytes, text/plain; charset="utf-8")
JournalErrors.txt Edit (52.4 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (2.6 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (31.9 KiB, text/plain; charset="utf-8")
MySQLConf.etc.mysql.my.cnf.txt Edit (682 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.cnf.txt Edit (682 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysqld.cnf.txt Edit (3.0 KiB, text/plain; charset="utf-8")

Revision history for this message

Xavier de La Garanderie (cxgaranderie) wrote on 2016-04-23:

Also affected during installation of Ubuntu 16.04

Revision history for this message

Launchpad Janitor (janitor) wrote on 2016-04-24:

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in mysql-5.7 (Ubuntu):
status:	New → Confirmed

Revision history for this message

Robie Basak (racb) wrote on 2016-04-24:

From log:

Paramétrage de mysql-server-5.7 (5.7.11-0ubuntu6) ...
Installation de la nouvelle version du fichier de configuration /etc/apparmor.d/usr.sbin.mysqld ...
Installation de la nouvelle version du fichier de configuration /etc/init.d/mysql ...
Installation de la nouvelle version du fichier de configuration /etc/init/mysql.conf ...
Installation de la nouvelle version du fichier de configuration /etc/logrotate.d/mysql-server ...
Installation de la nouvelle version du fichier de configuration /etc/mysql/debian-start ...
update-alternatives: utilisation de « /etc/mysql/mysql.cnf » pour fournir « /etc/mysql/my.cnf » (my.cnf) en mode automatique
insserv: warning: script 'binfmt-support' missing LSB tags and overrides
insserv: Default-Start undefined, assuming empty start runlevel(s) for script `binfmt-support'
insserv: Default-Stop undefined, assuming empty stop runlevel(s) for script `binfmt-support'
mysql start/running, process 3675
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1049: Unknown database 'performance_schema'
mysql_upgrade failed with exit status 5
dpkg: erreur de traitement du paquet mysql-server-5.7 (--configure) :
le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1

summary:	- package mysql-server-5.7 5.7.11-0ubuntu6 failed to install/upgrade: le - sous-processus script post-installation installé a retourné une erreur - de sortie d'état 1 + mysql-server-5.7.postinst fails with "Unknown database + 'performance_schema'"
Changed in mysql-5.7 (Ubuntu):
status:	Confirmed → Triaged
importance:	Undecided → High

Robie Basak (racb) on 2016-04-29

Changed in mysql-5.7 (Ubuntu):
milestone:	none → ubuntu-16.05
assignee:	nobody → Lars Tangvald (lars-tangvald)

Revision history for this message

Robie Basak (racb) wrote on 2016-09-22:

I believe that the root cause of this bug was actually bug 1577712 that we fixed in June (Yakkety) and July (Xenial, 16.04), so am marking this bug as a duplicate of that one. See bug 1577712 for details.

For others subscribed to this bug, or otherwise believe they're affected by this issue: I see many comments above that I think are clearly due to unrelated issues, so this bug is probably not the one you want.