Ubuntu
mysql-5.7 package

package mysql-server failed to install/upgrade due to insufficient disk space in /var/lib/mysql

Bug #1831548 reported by SHIKHA AGARWAL on 2019-06-04

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	mysql-5.7 (Ubuntu)	Invalid	Undecided	Unassigned

Bug Description

My tab is crashing again and again

ProblemType: Package
DistroRelease: Ubuntu 18.04
Package: mysql-server-5.7 5.7.26-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-45.48-generic 4.15.18
Uname: Linux 4.15.0-45-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.20.9-0ubuntu7.2
AptOrdering:
mysql-server-5.7:amd64: Install
mysql-server-core-5.7:amd64: Install
NULL: ConfigurePending
Architecture: amd64
Date: Mon Jun 3 10:29:16 2019
DpkgTerminalLog:
Preparing to unpack .../mysql-server-5.7_5.7.26-0ubuntu0.18.04.1_amd64.deb ...
ERROR: There's not enough space in /var/lib/mysql/
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.26-0ubuntu0.18.04.1_amd64.deb (--unpack):
new mysql-server-5.7 package pre-installation script subprocess returned error exit status 1
DuplicateSignature:
package:mysql-server-5.7:5.7.26-0ubuntu0.18.04.1
Preparing to unpack .../mysql-server-5.7_5.7.26-0ubuntu0.18.04.1_amd64.deb ...
ERROR: There's not enough space in /var/lib/mysql/
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.26-0ubuntu0.18.04.1_amd64.deb (--unpack):
new mysql-server-5.7 package pre-installation script subprocess returned error exit status 1
ErrorMessage: new mysql-server-5.7 package pre-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2018-09-03 (273 days ago)
InstallationMedia: Ubuntu 18.04.1 LTS "Bionic Beaver" - Release amd64 (20180725)
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.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['ib_buffer_pool', 'mysql_upgrade_info', 'ibtmp1', 'ib_logfile0', 'debian-5.7.flag', 'ibdata1', 'ib_logfile1', 'sys', 'auto.cnf', 'mysql', 'performance_schema']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-45-generic root=UUID=637ce736-a502-400d-977c-8f246109d176 ro quiet splash vt.handoff=1
Python3Details: /usr/bin/python3.6, Python 3.6.5, python3-minimal, 3.6.5-3ubuntu1
PythonDetails: /usr/bin/python2.7, Python 2.7.15rc1, python-minimal, 2.7.15~rc1-1
RelatedPackageVersions:
dpkg 1.19.0.5ubuntu2
apt 1.6.6ubuntu0.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.26-0ubuntu0.18.04.1 failed to install/upgrade: new mysql-server-5.7 package pre-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

Tags:

Revision history for this message

SHIKHA AGARWAL (shikhu1997) wrote on 2019-06-04:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (1.5 KiB, text/plain; charset="utf-8")
Dependencies.txt Edit (2.3 KiB, text/plain; charset="utf-8")
Df.txt Edit (2.6 KiB, text/plain; charset="utf-8")
Dmesg.txt Edit (62.7 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (16.3 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (2.8 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (54.3 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")
ProcCpuinfoMinimal.txt Edit (1.0 KiB, text/plain; charset="utf-8")

Apport retracing service (apport) on 2019-06-04

tags:

removed: need-duplicate-check

Bryce Harrington (bryce) on 2019-06-05

summary:

- package mysql-server-5.7 5.7.26-0ubuntu0.18.04.1 failed to
- install/upgrade: new mysql-server-5.7 package pre-installation script
- subprocess returned error exit status 1
+ package mysql-server failed to install/upgrade due to insufficient disk
+ space in /var/lib/mysql

Revision history for this message

Bryce Harrington (bryce) wrote on 2019-06-05:

Hi Shikha,

It looks like this installation failure was simply due to not enough disk space, looking at your Df.txt (run `df` on the console) you can see:

Filesystem 1K-blocks Used Available Use% Mounted on
udev 3974044 0 3974044 0% /dev
tmpfs 800860 1996 798864 1% /run
/dev/sda2 22435288 21285844 0 100% /
tmpfs 4004296 35368 3968928 1% /dev/shm
tmpfs 5120 4 5116 1% /run/lock
tmpfs 4004296 0 4004296 0% /sys/fs/cgroup

Your root file system on /dev/sda2 is 100% full. Free up some space, and then try the mysql installation again. You'll probably run into other problems while you're out of space.

The Ubuntu Desktop Edition's minimum requirements is 25G, which you're a bit below. You may want to consider either using a larger disk / partition or perhaps using the Ubuntu Server Edition if you just need mysql and server applications, as it should fit inside a few gigabyes of disk space.

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

Revision history for this message

Bryce Harrington (bryce) wrote on 2019-06-05:

Some other troubleshooting suggestions:

* Check if you have large files in /var/log/. If you have an overly large log file, it could indicate some other problem is going on.

* Run `apt-get clean`, to delete cached package data

* Run `service mysql restart`.

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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

Ubuntumysql-5.7 package

package mysql-server failed to install/upgrade due to insufficient disk space in /var/lib/mysql

Bug Description

Other bug subscribers

Bug attachments

Remote bug watches

Ubuntu
mysql-5.7 package