Yeah it fails to (re)start in your case.

>From your mysql log:
2018-02-10T17:30:08.421243Z 0 [ERROR] InnoDB: Operating system error number 13 
in a file operation.
2018-02-10T17:30:08.421273Z 0 [ERROR] InnoDB: The error means mysqld does not 
have the access rights to the directory.
2018-02-10T17:30:08.421297Z 0 [ERROR] InnoDB: Operating system error number 13 
in a file operation.
2018-02-10T17:30:08.421319Z 0 [ERROR] InnoDB: The error means mysqld does not 
have the access rights to the directory.
2018-02-10T17:30:08.421340Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
2018-02-10T17:30:08.421364Z 0 [ERROR] InnoDB: Could not open or create the 
system tablespace. If you tried to add new data files to the system tablespace, 
and it failed here, you should now edit innodb_data_file_path in my.cnf back to 
what it was, and remove the new ibdata files InnoDB created in this failed 
attempt. InnoDB only wrote those files full of zeros, but did not yet use them 
in any way. But be careful: do not remove old data files which contain your 
precious data!
2018-02-10T17:30:08.421389Z 0 [ERROR] InnoDB: InnoDB Database creation was 
aborted with error Cannot open a file. You may need to delete the ibdata1 file 
before trying to start up again.

And very very likely related to that apparmor denies:
[17112.114807] audit: type=1400 audit(1518282130.859:38): apparmor="DENIED" 
operation="mknod" profile="/usr/sbin/mysqld" name="/db/mysql/N200.lower-test" 
pid=16095 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=125 ouid=125
[17112.303168] audit: type=1400 audit(1518282131.047:39): apparmor="DENIED" 
operation="mknod" profile="/usr/sbin/mysqld" name="/db/mysql/N200.lower-test" 
pid=16095 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=125 ouid=125
[17112.303241] audit: type=1400 audit(1518282131.047:40): apparmor="DENIED" 
operation="mknod" profile="/usr/sbin/mysqld" name="/db/mysql/N200.lower-test" 
pid=16095 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=125 ouid=125


So your alias file /etc/apparmor.d/tunables/alias should maybe look like:
  alias /var/lib/mysql/ -> /db/mysql/,

It isn't attached, is that your content?

** Changed in: mysql-5.7 (Ubuntu)
       Status: New => Incomplete

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

Title:
  package mysql-server-5.7 5.7.21-0ubuntu0.16.04.1 failed to
  install/upgrade: subprocess installed post-installation script
  returned error exit status 1 - nonstandard location

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

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

Reply via email to