** Description changed:

+ The systemd service script for MySQL will report an error if it doesn't
+ find a database in the default datadir, /var/lib/mysql
+ 
+ [Impact]
+ For users with custom datadir, this means they have to keep the default 
database in /var/lib/mysql as well, or the systemd service will refuse to start.
+ 
+ We change the systemd service script to check that a database exists in
+ the directory found in the config, rather than the default.
+ 
+ [Test case]
+ * Install the mysql-server package, then stop the service
+ * Edit /etc/mysql/mysql.conf.d/mysqld.cnf and change datadir
+ * Make sure the custom datadir exists, and run mysqld --initialize
+ * Try to start the service
+ 
+ [Regression Potential]
+ This change has been in Yakkety for some time (5.7.15-0ubuntu2).
+ 
+ Should the commands to fetch the value from the config not work right,
+ it could break the systemd script whether the user has a proper database
+ or not.
+ 
+ 
+ [Original description]
  mysql upgrade fails if datadir (mysqld.cnf) is not /var/lib/mysql
  
  ProblemType: Package
  DistroRelease: Ubuntu 16.04
  Package: mysql-server-5.7 5.7.12-0ubuntu1
  ProcVersionSignature: Ubuntu 4.4.0-21.37-generic 4.4.6
  Uname: Linux 4.4.0-21-generic x86_64
  ApportVersion: 2.20.1-0ubuntu2
  Architecture: amd64
  Date: Mon Apr 25 19:31:55 2016
  ErrorMessage: subprocess installed post-installation script returned error 
exit status 1
  InstallationDate: Installed on 2015-11-30 (146 days ago)
  InstallationMedia: Ubuntu 15.10 "Wily Werewolf" - Release amd64 (20151021)
  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
+  [mysqldump]
+  quick
+  quote-names
+  max_allowed_packet   = 16M
  MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
-  [mysqld_safe]
-  syslog
+  [mysqld_safe]
+  syslog
  MySQLVarLibDirListing: ['debian-5.7.flag']
  ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.4.0-21-generic 
root=UUID=402be1c6-5faf-4404-9598-4ec21d975aa8 ro quiet splash vt.handoff=7
  RelatedPackageVersions:
-  dpkg 1.18.4ubuntu1
-  apt  1.2.10ubuntu1
+  dpkg 1.18.4ubuntu1
+  apt  1.2.10ubuntu1
  SourcePackage: mysql-5.7
  Title: package mysql-server-5.7 5.7.12-0ubuntu1 failed to install/upgrade: 
subprocess installed post-installation script returned error exit status 1
  UpgradeStatus: Upgraded to xenial on 2016-04-22 (3 days ago)
  modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
  modified.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: [modified]
  mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2016-04-24T12:43:49.748706
  mtime.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: 2016-04-24T12:45:04.992172

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

Title:
  mysql-server-5.7.postinst fails on upgrade if the datadir has been
  changed from default

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

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

Reply via email to