package mysql-server-8.0 8.0.19-0ubuntu0.19.10.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Incomplete
|
Undecided
|
Lars Tangvald |
Bug Description
Setting up mysql-server-8.0 (8.0.19-
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/
2020-02-
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/
Active: activating (auto-restart) (Result: exit-code) since Wed 2020-02-26 23:03:56 MST; 13ms ago
Process: 39335 ExecStartPre=
Process: 39356 ExecStart=
Main PID: 39356 (code=exited, status=1/FAILURE)
Status: "Data Dictionary upgrade from MySQL 5.7 in progress"
invoke-rc.d: release upgrade in progress, error is not fatal
Setting up mysql-server (8.0.19-
Upgrade complete
The upgrade has completed but there were errors during the upgrade
process.
ProblemType: Package
DistroRelease: Ubuntu 19.10
Package: mysql-server-8.0 8.0.19-
ProcVersionSign
Uname: Linux 5.0.0-38-generic x86_64
ApportVersion: 2.20.11-0ubuntu8.4
Architecture: amd64
Date: Wed Feb 26 22:57:41 2020
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Logs.var.
MySQLConf.
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
ProcCmdline: BOOT_IMAGE=
Python3Details: /usr/bin/python3.7, Python 3.7.5, python3-minimal, 3.7.5-1
PythonDetails: /usr/bin/python2.7, Python 2.7.17, python-minimal, 2.7.17-1
RelatedPackageV
dpkg 1.19.7ubuntu2
apt 1.9.4
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.19-
UpgradeStatus: Upgraded to eoan on 2020-02-27 (0 days ago)
modified.
mtime.conffile.
tags: | removed: need-duplicate-check |
I tried the usual to fix this bug .....
apt --fix-broken install
apt install mysql-server
and while it did fix a broken dependency it still reported status as Upgrade in Progress 5.7 to 8.0 ...
However in inspecting the SQL error log it seems that the upgrade was stuck on on infinite loop trying
(and failing) to upgrade the same table over and over ......
2020-02- 27T06:33: 22.196147Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19- 0ubuntu0. 19.10.3) starting as process 7625 27T06:33: 22.220027Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 27T06:33: 25.927054Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/ root_group is not found in InnoDB dictionary 27T06:33: 25.927427Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones. root_group 27T06:33: 25.935839Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/ root_contact is not found in InnoDB dictionary 27T06:33: 25.936212Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones. root_contact 27T06:33: 25.942545Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/Company is not found in InnoDB dictionary 27T06:33: 25.942987Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.Company 27T06:33: 33.946118Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 27T06:33: 33.946879Z 0 [ERROR] [MY-010119] [Server] Aborting 27T06:33: 35.557598Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19- 0ubuntu0. 19.10.3) (Ubuntu). 27T06:33: 36.706904Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_ expire_ logs_seconds instead. 27T06:33: 36.711302Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19- 0ubuntu0. 19.10.3) starting as process 7698 27T06:33: 36.734882Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 27T06:33: 39.938288Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/ root_group is not found in InnoDB dictionary 27T06:33: 39.938929Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones. root_group 27T06:33: 39.948222Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/ root_contact is not found in InnoDB dictionary 27T06:33: 39.948637Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones. root_contact 27T06:33: 39.955979Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/Company is not found in InnoDB dictionary 27T06:33: 39.956409Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.Company 27T06:33: 48.102907Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 27T06:33: 48.103689Z 0 [ERROR] [MY-010119] [Server] Aborting 27T06:33: 49.688120Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19- 0ubuntu0. 19.10.3) (Ubuntu). 27T06:33: 50.699200Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_ expire_ logs_seconds instead.
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
2020-02-
and so on ad-infinitum ........