** 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
