** Description changed:

  [Impact]
  
  A common cause of upgrade failures are invalid configuration directives
  due to deprecation. In this kind of case, apport does not currently tell
  us the failure reason, and even if it did print a service start failure,
  the actual reason has to be dug out of the logs. Further, some users
  have a very old conffile that did not log output to the current
  location, so the real reason isn't always submitted in a bug report.
  
  We can ask if mysqld will start by using: "mysqld --verbose --help
  --innodb-read-only 2>&1 > /dev/null". The postinst should do this so
  that it can fail early with a more useful error message.
  
  This is fixed in Yakkety already (http://anonscm.debian.org/cgit/pkg-
  mysql/mysql.git/commit/?id=7897042ea6c65aeb608fb28b4b54639d3dbf3352) but
  should also be SRU'd to Xenial.
  
  Also see bug 1596056 and bug 1571865. Fixing each of these will improve
  the situation in a different way. Fixing all three bugs would catch the
  most failure cases and be the most helpful.
+ 
+ mysqld --verbose --help doesn't currently catch all such issues (it
+ returns 0 if datadir doesn't exist, for instance), but should be a help
+ 
+ [Test Case]
+ * Install previous version of MySQL (e.g. 5.5. in Trusty)
+ * Add something like 'invalid_mysql_option=foo' to the server config file
+ * Upgrade to Xenial and MySQL 5.7
+ 
+ Expected behavior:
+ A helpful error pointing to invalid_mysql_option
+ 
+ Actual behavior:
+ 'subprocess installed post-installation script returned error exit status 1'
+ 
+ [Regression Potential]
+ Should there be any non-fatal issue that actually causes mysqld --verbose 
--help to fail but not the normal server startup to fail, the check will 
incorrectly cause installation to fail.

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

Title:
  postinst does not print a helpful message when the server will fail to
  start

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

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

Reply via email to