Ubuntu
mysql-8.0 package

package mysql-server-8.0 8.0.28-0ubuntu0.20.04.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

Bug #1964910 reported by Lal Singh Bhadoria on 2022-03-15

This bug report is a duplicate of: Bug #1960971: mysql crashes after purge and reinstall with error: "Database files are locked. Daemon already running?". Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	mysql-8.0 (Ubuntu)	Incomplete	Undecided	Unassigned

Bug Description

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: exit-code) since Tue 2022-03-15 13:59:20 IST; 8ms ago
    Process: 13775 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 13783 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 13783 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"

Mar 15 13:59:20 rails-HP-250-G8-Notebook-PC systemd[1]: mysql.service: Failed with result 'exit-code'.
Mar 15 13:59:20 rails-HP-250-G8-Notebook-PC systemd[1]: Failed to start MySQL Community Server.
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-8.0; however:
Package mysql-server-8.0 is not configured yet.

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.28-0ubuntu0.20.04.3
ProcVersionSignature: Ubuntu 5.13.0-35.40~20.04.1-generic 5.13.19
Uname: Linux 5.13.0-35-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.21
Architecture: amd64
CasperMD5CheckResult: skip
Date: Tue Mar 15 13:59:20 2022
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-03-14 (0 days ago)
InstallationMedia: Ubuntu 20.04.4 LTS "Focal Fossa" - Release amd64 (20220223)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'
MySQLVarLibDirListing: ['binlog.index', 'binlog.000016', 'auto.cnf', 'debian-5.7.flag', 'ca.pem', 'sys', 'undo_002', 'mysql.ibd', 'binlog.000014', '#ib_16384_0.dblwr', 'server-key.pem', 'ibtmp1', 'binlog.000018', 'server-cert.pem', '#innodb_temp', 'binlog.000013', 'binlog.000015', 'binlog.000012', 'rails-HP-250-G8-Notebook-PC.pid', 'undo_001', 'binlog.000001', 'performance_schema', 'binlog.000004', 'client-cert.pem', 'private_key.pem', 'ib_logfile0', 'ibdata1', 'mysql', '#ib_16384_1.dblwr', 'binlog.000009', 'binlog.000008', 'binlog.000010', 'client-key.pem', 'binlog.000007', 'binlog.000011', 'ib_buffer_pool', 'binlog.000005', 'binlog.000017', 'binlog.000002', 'binlog.000006', 'ib_logfile1', 'ca-key.pem', 'public_key.pem', 'binlog.000003']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.13.0-35-generic root=UUID=e4dd80b9-f5c2-47e5-b44f-4aa0e9023047 ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.8, Python 3.8.10, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
dpkg 1.19.7ubuntu3
apt 2.0.6
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.28-0ubuntu0.20.04.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

Tags:

Revision history for this message

Lal Singh Bhadoria (lalsingh1992) wrote on 2022-03-15:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (2.0 KiB, text/plain; charset="utf-8")
AptOrdering.txt Edit (583 bytes, text/plain; charset="utf-8")
Dependencies.txt Edit (2.5 KiB, text/plain; charset="utf-8")
Df.txt Edit (522 bytes, text/plain; charset="utf-8")
Dmesg.txt Edit (83.0 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (130.2 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.txt Edit (38.7 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (8.0 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (36.6 KiB, 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.mysql.cnf.txt Edit (132 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysqld.cnf.txt Edit (2.2 KiB, text/plain; charset="utf-8")
ProcCpuinfoMinimal.txt Edit (1.7 KiB, text/plain; charset="utf-8")

Revision history for this message

Lena Voytek (lvoytek) wrote on 2022-03-16:

Thank you for taking the time to report this bug and helping to make Ubuntu better.

Looking into the error: "ERROR: Database files are locked. Daemon already running?" and the statement in mysql's error.log "[InnoDB] Unable to lock ./ibdata1 error: 11" leads me to believe that this is a duplicate of LP #1960971. I will mark it as such. If you have any additional information or think this is incorrect please let me know.

This may have been caused by uninstalling and reinstalling mysql. In the dpkg history it shows the following commands:

apt install mysql-server
apt-get purge mysql*
apt-get install mysql-server
apt-get purge mysql*
apt install mysql-server
apt-get purge mysql*
apt upgrade
apt-get install mysql-server
apt-get purge mysql*
apt-get install mysql-server
apt-get purge mysql*
apt-get autoremove
apt install mysql-server

The previous installs may have blocked the new ones from completing. Did you receive an error message every time you installed, or only the last time? Was there a specific reason for uninstalling and reinstalling?

Thanks

Changed in mysql-8.0 (Ubuntu):
status:	New → Incomplete

Report a bug

This report contains Public information

Everyone can see this information.

Duplicate of bug #1960971 Remove

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.

Ubuntumysql-8.0 package