** Description changed:

  Due to the old upstart script still being active, mysql_upgrade is
  called both via upstart on daemon start and by mysql-server-5.7.postinst
  when upgrading on a system that is running upstart. This seems to cause
- various mysql_upgrade failures.
+ various mysql_upgrade failures. mysql_upgrade will alter the structure
+ of the system tables, particularly performance_schema, which it will
+ delete and recreate. If one process deletes it, then the other creates
+ it, the first will also try to create it, throwing an error.
  
- Let's use this bug to track this particular root cause, since it isn't
- clear that all the other classes of report will be cleared up by this
- fix although we think that they may be. We can dupe them in as needed as
- we find out.
+ [Impact]
+ 
+ Error causes mysql_upgrade to fail, which in turn makes the package
+ installation fail.
+ 
+ [Test case]
+ 
+ Difficult to test fully since it's a race condition bug with two upgrade 
processes running together.
+ * Install mysql-server in Ubuntu Trusty
+ * Upgrade system to Xenial
+ 
+ Expected behavior:
+ The server installs, and the database is upgraded to support 5.7
+ 
+ Actual behavior:
+ Occasionally fails with errors like 'performance_schema does not exist' or 
'performance_schema already exists'.
+ 
+ [Regression potential]
+ 
+ Debian-start is made a no-op script, so if it did something useful we
+ haven't noticed, that's lost.
+ 
+ ---
+ Let's use this bug to track this particular root cause, since it isn't clear 
that all the other classes of report will be cleared up by this fix although we 
think that they may be. We can dupe them in as needed as we find out.

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

Title:
  mysql_upgrade is called twice concurrently on upgrade from 14.04

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1577712/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to