16.04 upgrade broke mysql-server

1

Your error message contains this line:

subprocess installed post-installation script returned error exit status 1

However, this installed post-installation script is not mentioned by name. After much tinkering, I found out that its name is (in my case) /var/lib/dpkg/info/mysql-server-5.7.postinst.

Open this file with sudo vi /var/lib/dpkg/info/mysql-server-5.7.postinst, or your preferred editor.

At the top, change line 3 (or so): set -e to set -x, save the file. (option -e is "exit on errors", -x means "explicitly show command executed", presumably)

Run sudo dpkg --configure -a --log /tmp/dpkg.log (the --log option is optional). You can also simply run apt upgrade if you know it'll be the only package that will be upgraded.

Now you get verbose output of the mysql-server-5.7.postinst bash script, and you can figure out what's wrong.

In my case it unsuccessfully tried to (re-)run mysql_upgrade, but that was not needed for my customized mysql...

0 0
2

by

TheGremlyn

Last Updated April 25, 2016 09:00 AM

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work.

This is the error I see when trying to install/reinstall it:

Setting up mysql-server-5.7 (5.7.11-0ubuntu6) ... 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. dpkg: error processing package mysql-server-5.7 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.7; however: Package mysql-server-5.7 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured No apport report written...
0 0
3

16.04 upgrade broke mysql-server

By | April 22, 2016 | Category Uncategorized

By TheGremlyn

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work.

This is the error I see when trying to install/reinstall it:

Setting up mysql-server-5.7 (5.7.11-0ubuntu6) ... 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. dpkg: error processing package mysql-server-5.7 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.7; however: Package mysql-server-5.7 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems -...
0 0
4
Description: I upgraded my Ubuntu server from ver 14.04 LTS to 16.04 LTS. The MySQL server on ver 14.04 was 5.5. As part of the upgrade to 16.04 the Ubuntu upgrade process attempted to move to 5.7....which didn't work. So I instead researched the web and found this : http://askubuntu.com/questions/760724/16-04-upgrade-broke-mysql-server I then tried to apply the 'accepted answer' for the above. When I tried the apt install part I got the following output: ============ nexargi@server-02:/$ sudo apt install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: aptitude-common g++-4.8 gcc-4.9-base libboost-iostreams1.54.0 libboost-iostreams1.58.0 libc-ares2 libck-connector0 libcwidget3 libdbd-mysql-perl libdbi-perl libept1.4.12 libgcrypt11-dev libgcrypt20-dev libgnutlsxx27 libgpg-error-dev libisl10 libprocps3 libsigc++-2.0-0c2a libstdc++-4.8-dev...
0 0
5

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work.

This is the error I see when trying to install/reinstall it:

Setting up mysql-server-5.7 (5.7.11-0ubuntu6) ... 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. dpkg: error processing package mysql-server-5.7 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.7; however: Package mysql-server-5.7 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a...
0 0
6

I have Ubuntu 16.04 running (clean install - no upgrade). MySQL is running fine - but I get this error when I try to update MySQL:

apt-get install Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Setting up mysql-server-5.7 (5.7.16-0ubuntu0.16.04.1) ... Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK...
0 0
7
I did upgrade to 16.04 from 14.04.

This is a MythTV Backend, but the problem is MYSQL.

MYSQL is not running.

I ran:
mythuser@amethi:~$ sudo apt-get install -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
libterm-readkey-perl mariadb-common
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
mysql-server-5.7
Suggested packages:
mailx tinyca
The following NEW packages will be installed:
mysql-server-5.7
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
5 not fully installed or removed.
Need to get 0 B/2,722 kB of archives.
After this operation, 48.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
...

0 0
8

While MySql 5.5 is the default for Ubuntu 14.04, MySql 5.6 is available in the default repositories. It can be installed simply using:

sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server-5.6

If you have existing data in a MySql 5.5 database, it should be migrated automatically. Though it is always a good idea to make a backup before doing a major upgrade.

First make a backup of the data in your existing database:

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql

Then after installing the newer version, you can restore if needed by running:

mysql -u root -p < dump.sql

For more info on migrating MySql databases, check...

0 0
9

MySQL is an open-source relational database management system. This tutorial will help you to install MySQL server on your Ubuntu and Debian systems. This version has various security improvements than the previous versions.

Step 1 – Configure Apt Repository

Download the MySQL apt configuration Debian package officially provided by MySQL team and install it on your system. For Ubuntu 16.04 and later version’s MySQL 5.7 is available under default apt repositories, so you don’t need to enable additional repository that.

wget http://repo.mysql.com/mysql-apt-config_0.8.9-1_all.deb sudo dpkg -i mysql-apt-config_0.8.9-1_all.deb

This will prompt you to select MySQL version to be install. so that dpkg configure the apt repository accordingly.

Step 2 – Install MySQL Server

Use the following commands to install MySQL server on your Ubuntu 16.04 and 14.04 systems. Currently, this is the most popular version used by the among users.

sudo...
0 0
10

One of routine tasks for system admins is to update installed programs with the latest patches and hotfixes, as well as upgrade software to a more recent release with new bells and whistles. The latest MySQL 5.6 was released early this year, targeting better performance and scalability. For those of you wanting to try out the latest bleeding edge MySQL, I will describe how to upgrade MySQL server on Debian or Ubuntu.

In this tutorial, I assume that you have already set up MySQL with apt-get. As of this writing, MySQL that ships with major Linux distros is version 5.5. Here I am going to demonstrate how to upgrade MySQL 5.5 to 5.6.

1. Back up your MySQL config files.

$ sudo mkdir /backup
$ sudo tar cvfvz /backup/mysql_conf.tgz /etc/mysql

2. Export all databases to a .sql file, and back up MySQL data directory.

$ sudo sh -c 'mysqldump -u root -p -A --events > /backup/backup_db.sql'
$ sudo tar cvfvz /backup/mysql_data.tgz...

0 0
11

If you updated to a 16.04 Ubuntu server, and are using 5.7.12, you are encountering--at least in part--a bug eating up RAM, and some dynamic optimizations/default settings that are based off the server's available RAM and are set less than ideally. This has been problematic for lots of people, but especially for smaller server/vps with low RAM.

Search laracasts.com for MySQL 5.7 memory leak

https://www.reddit.com/r/mysql/comments/4gnj93/mysql_5712_ubuntu_1604_ridiculous_memory/

There are other issues, some of which 5.7.13 fixed of course...

http://mysqlentomologist.blogspot.com/2016/06/fun-with-bugs-43-bugs-fixed-in-mysql.html

There were also some different optimizations/changes made that will have an impact, depending on whether or not you use InnoDB or MyISAM. To give you an example, a recently installed VPS with 2 GB RAM that consumes around 320 MB RAM if you restart MySQL will slowly rise until consuming 1 GB on an idling app, in maintenance...

0 0
12

I’ve been rebuilding my lab recently, most notably breaking down my LXD stack into individual Ubuntu virtual machines for each service. One thing I always meant to do but never got around to figuring out was the initial setup of phpMyAdmin with a remote MySQL server. If you’ve ever wanted to do something similar, today is your lucky day.

This guide assumes you have already deployed separate MySQL and Nginx (with php 7) servers on Ubuntu 16.04. Here are guides for Nginx and MySQL Server.

MySQL Setup

So much sudo. Let’s just launch a root shell

sudo -i

To allow remote access to the MySQL, open the following file in a text editor

nano /etc/mysql/mysql.conf.d/mysqld.cnf

Find the following line

bind-address = 127.0.0.1

Either comment it out like so

#bind-address = 127.0.0.1

Or change to the server’s local IP address

bind-address = 192.168.0.100

Restart MySQL to apply changes

service mysql restart

Login to MySQL as root

...
0 0
13

In this tutorial we will show you how to install and configuration of MySQL on your Ubuntu 16.04 server. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible with all major operating systems. MySQL can be used for a variety of applications, but is most commonly found on web servers.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation MySQL server in Ubuntu 16.04 LTS (Xenial Xerus) server.

Install MySQL Server on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following...

0 0
14

Table of contents

This article provides instructions about how to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux.

The instructions for upgrading MySQL from 5.1 to 5.5 on Linux see in the KB article:

Warning: Direct upgrade from MySQL 5.1 to MySQL 5.6/5.7 will damage tables.
MariaDB 10.2 is not fully supported by Plesk.

Note: Upgrade can be performed in a command-line interface with the instructions below at your own risk. This task is supposed to be performed by a system administrator.

Note: MySQL will not be upgraded in case it installed from webtatic repository:

# rpm -qa | grep -i mysql
mysql55w-server-5.5.57-1.w6.x86_64

First of all, connect to the server via SSH.

For Ubuntu 12.04 and 14.04, Debian 7:

Ubuntu 14.04 is shipped with MySQL 5.5 by default.

Create a full server backup and a server snapshot.

Create a backup of /etc/mysql/my.cnf:

# cp...

0 0
15
Re: mysql upgrade broke server [solved!]On Sat, Nov 11, 2006 at 12:25:39AM +0100, Florian Kulzer wrote: > On Fri, Nov 10, 2006 at 17:54:10 -0500, Rick Pasotto wrote: > > On Fri, Nov 10, 2006 at 11:20:50PM +0100, Florian Kulzer wrote: > > > On Fri, Nov 10, 2006 at 16:39:23 -0500, Rick Pasotto wrote: > > > > If you still need a "real" 4.1 package to fix some things before the > > > upgrade, then you will have to find an older version, either in your > > > /var/cache/apt/archives/ directory or from snapshot.debian.net. Once you > > > have found the right .deb file you can install it with "dpkg --install". > > > > So I added to /etc/apt/sources.list: > > > > deb http://snapshot.debian.net/archive pool mysql-dfsg-4.1 > > > > and updated. Now what? > > > > 'apt-get install mysql-dfsg-4.1' says it can't find the package. > > apt-get install mysql-server-4.1= > > "apt-cache policy mysql-server-4.1" will tell you which versions are > available. Replace with the number of the > version that you...
0 0
16

OK, so I was chatting about this in another thread which was dealing with a different mysql version, so I thought I'd move the discussion to another one with a more informative title.

The issue is this. Ubuntu 16.04 installs mysql 5.7 by default when you install mysql. There are some rather large changes in between 5.6 and 5.7, particularly in the mysql.user table, which mean that if you want to install mariadb 10.x, which is based on mysql 5.6, then the normal 'drop-in replacement' doesn't work.

During installation it will detect mysql 5.7 and then move the data directory from /var/lib/mysql to /var/lib/mysql5.7 and then install itself in a clean /var/lib/mysql directory. The root password is preserved. However any other data is lost.

You can dump data from mysql before you upgrade and try to import into mariadb, but when you do that, any apps which depend on the database will be unable to authenticate. eg roundcube, any wordpress installations you have...

0 0
17

MySQL is the 2nd most popular database management system commonly used by web applications as backend. It integrates into Web development frameworks like LAMP (Linux, Apache, MySQL, PHP) to enable database and SQL (Structured Query Language) support. Here we are outlining the steps to install MySQL on Ubuntu 16.04 OS.

MySQL support on Ubuntu is unparallel. It is fast and reliable. Also, Ubuntu 16.04 is an LTS version which means it would get regular updates until five years from the date of release. And that’s why we recommend an LTS version for installing and managing servers like MySQL and Apache TomCat.

Debian users who want to install MySQL on Debian OS can also follow this tutorial as the commands and syntax are almost the same. However, do let us know for any variation and we’ll address it.

Prior installing MySQL on Ubuntu, you’ll have to decide the version of MySQL package for the installation. Its latest version is v5.7, but the older versions like v5.5...

0 0
18

mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.

If mysql_upgrade finds that a table has a possible incompatibility, it performs a table check and, if problems are found, attempts a table repair. If the table cannot be repaired, see Section 2.13.4, “Rebuilding or Repairing Tables or Indexes” for manual table repair strategies.

You should execute mysql_upgrade each time you upgrade MySQL. It supersedes the older mysql_fix_privilege_tables script, which should no longer be used.

If you install MySQL from RPM packages on Linux, you must install the server and client RPMs. mysql_upgrade is included in the server RPM but requires the client RPM because the latter includes mysqlcheck....

0 0
19

We’ll show you how to install MySQL on Ubuntu 16.04. MySQL is the world’s most popular open-source relational database management system (RDBMS). It is widely used for building web applications and is an important part of the LAMP open-source web application software stack. Installing MySQL on Ubuntu 16.04 is really not so complicated to install, just follow the steps bellow and you should have MySQL installed on Ubuntu 16.04, in few minutes.

1. Connect to your server and update system software

The first thing you need to do is to connect to your server via SSH and update all your system software to the latest version available. Go ahead and run the following command:

sudo apt-get update && sudo apt-get -y upgrade

Once your system is updated, you can proceed with the other steps of this tutorial.

2. Install MySQL on Ubuntu 16.04

The installation of MySQL database server on Ubuntu 16.04 is very easy. All you need to do is to run...

0 0
20
...
0 0
21

I don't understand

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.19-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.10.0-32.36~16.04.1-generic 4.10.17
Uname: Linux 4.10.0-32-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.10
Architecture: amd64
Date: Sat Nov 4 21:38:00 2017
DpkgTerminalLog:
Preparing to unpack .../mysql-server-5.7_5.7.20-0ubuntu0.16.04.1_amd64.deb ...
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.20-0ubuntu0.16.04.1_amd64.deb (--unpack):
subprocess new pre-installation script was killed by signal (Broken pipe)
DuplicateSignature:
package:mysql-server-5.7:5.7.19-0ubuntu0.16.04.1
Preparing to unpack .../mysql-server-5.7_5.7.20-0ubuntu0.16.04.1_amd64.deb ...
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.20-0ubuntu0.16.04.1_amd64.deb (--unpack):
subprocess new pre-installation script was...

0 0
22

Installing MySQL 5.5/6 on Ubuntu 16.06

You might be hosting your site on something like Acquia and they have recently upgraded to Ubuntu 16 Xenial.

However, you (as an awesome developer) still want to duplicate the environment as much as possible so you want to configure a local or staging server using Ubuntu, etc.

Here’s how to install MySQL 5.5/6 on Xenial.

First, a couple items:

This and other methods of installation will not work. You will need to do the install manually.

UPDATED 7-21-17 – Scroll to the bottom

Find the correct install for MySQL 5.5/6

Go to www.mysql.com > downloads > you will see links for older versions.

When you get to the dropdowns for OS, you will see Ubuntu. Note that these only go up to 14. Instead, select Linux/Generic. Scroll to the bottom to get the TAR Archive – select 32 or 64 bit.

Click download

On the following page look for “No thanks, just start my download.” Right...

0 0
23

Change

It wasn't trendy, funny, nor was it coined on Twitter, but we thought change told a real story about how our users defined 2010. Unlike in 2008, change was no longer a campaign slogan. But, the term still held a lot of weight. Here's an excerpt from our Word of the Year announcement in 2010:

The national debate can arguably be summarized by the question: In the past two years, has there been enough change? Has there been too much? Meanwhile, many Americans continue to face change in their homes, bank accounts and jobs. Only time will tell if the latest wave of change Americans voted for in the midterm elections will result in a negative or positive...

0 0