[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Yes because no one know that. Without such patch, system upgrades cannot
be automated and will be relegated to experienced users.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Seems they identified the issue causing the upgrade to fail:
https://support.plesk.com/hc/en-us/articles/115003430813#_=_

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Other issues I faced are:

- issues with DATETIME fields with '-00-00 00:00:00' default value;
- Event scheduler disabled after the upgrade.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

@racb I really had many failed mysql upgrades and the title of my report
hypothesizes the root cause of the issue, but I may be wrong, in fact
seems bug #1577712 is back, @gunnarhj @racb see the last comment.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Re: [Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Yes I still experience the issue.

The problem described in #1577712 is not the only problem I experienced.
Upgrading from 14.04 to 16.04.1 with do-release-upgrade break MySQL, we
reproduced the same issue every time on many clean 14.04 installations.
do-release-upgrade hangs on the post installation script for MySQL.

It seems the issue is upgrading directly from 5.5 to 5.7 is not supported, 
doing that (even manually) will hang on mysql_upgrade in many cases. Official 
MySQL documentation says: “Upgrade that skips versions is not supported. For 
example, upgrading directly from MySQL 5.5 to 5.7 is not supported.” - 
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html#upgrade-paths
It may *seems* to work if you have only empty databases, but when we used it on 
production databases, with many data, it hung when it encountered features 
removed in 5.7, and you will have corrupted data (for example DATETIME fields 
with 0 default value, or the default SYS schema is missing version information).

MM

_
From: Gunnar Hjalmarsson 
<1725...@bugs.launchpad.net>
Sent: martedì, ottobre 24, 2017 1:51 PM
Subject: [Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 
performs unsupported upgrade from MySQL 5.5 to 5.7
To: mailto:marco.mars...@live.it>>


I see that bug #1577712 is marked "Fix Released". @Marco, did you
actually encounter problems when upgrading from 14.04 to 16.04? If so,
can you please elaborate on the nature of the problems?

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1725222

Title:
do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
upgrade from MySQL 5.5 to 5.7

Status in Ubuntu Server Guide:
Invalid
Status in mysql-5.7 package in Ubuntu:
New
Status in ubuntu-release-upgrader package in Ubuntu:
New

Bug description:
Updating from Ubuntu 14.04 to Ubuntu 16.04.1 using do-release-upgrade
will cause troubles because MySQL is upgraded from 5.5 to 5.7, that is
an unsupported update path, as per MySQL official documentation.

Your script should do these pre-checks and prevent upgrade, or
automatically solve the issue before applying upgrade.

PS: the solution is to upgrade MySQL in two steps, first from 5.5 to
5.6 then from 5.6 to 5.7.

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Related to
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1573279

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1725222] Re: do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported upgrade from MySQL 5.5 to 5.7

[Marco Marsala]

Such maintainer script should perform the upgrade as recommended by
MySQL developers, so stepping one version a time; so, upgrading for
example, from Ubuntu 14 to 16, it should upgrade MySQL 5.5 to 5.6, then
5.6 to 5.7.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1725222

Title:
  do-release-upgrade from Ubuntu 14.04 to 16.04.1 performs unsupported
  upgrade from MySQL 5.5 to 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/serverguide/+bug/1725222/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs