Comment 2 for bug 1829753

Hello, I noticed several problems in the logs:

First, it appears the filesystems may have problems:

[86759.038651] EXT4-fs (dm-0): error count: 13
[86759.038661] EXT4-fs (dm-0): initial error at 1504970654: ext4_journal_start_sb:327
[86759.038665] EXT4-fs (dm-0): last error at 1505132213: ext4_put_super:819
[173218.112237] EXT4-fs (dm-0): error count: 13
[173218.112241] EXT4-fs (dm-0): initial error at 1504970654: ext4_journal_start_sb:327
[173218.112244] EXT4-fs (dm-0): last error at 1505132213: ext4_put_super:819

Second, it appears that your mysql database has been moved and perhaps the AppArmor policy hasn't been updated to reflect the changed location.

Can you double-check your /etc/apparmor.d/local/usr.sbin.mysqld file and make sure you've added appropriate policy lines for the new mysql data locations?

[252337.085739] type=1400 audit(1558357939.928:45): apparmor="DENIED" operation="open" parent=1558 profile="/usr/sbin/mysqld" name="/proc/1559/status" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[252337.085796] type=1400 audit(1558357939.928:46): apparmor="DENIED" operation="open" parent=1558 profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[252337.085859] type=1400 audit(1558357939.928:47): apparmor="DENIED" operation="open" parent=1558 profile="/usr/sbin/mysqld" name="/proc/1559/status" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[252337.147250] type=1400 audit(1558357939.988:48): apparmor="DENIED" operation="mknod" parent=1558 profile="/usr/sbin/mysqld" name="/data/mysql/testflweb32.lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0
[252337.205848] type=1400 audit(1558357940.048:49): apparmor="DENIED" operation="mknod" parent=1558 profile="/usr/sbin/mysqld" name="/data/mysql/testflweb32.lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0
[252337.205869] type=1400 audit(1558357940.048:50): apparmor="DENIED" operation="mknod" parent=1558 profile="/usr/sbin/mysqld" name="/data/mysql/testflweb32.lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0
[252337.465182] type=1400 audit(1558357940.308:51): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=1573 comm="apparmor_parser"
[252337.854376] type=1400 audit(1558357940.696:52): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=1624 comm="apparmor_parser"
[252337.859040] type=1400 audit(1558357940.704:53): apparmor="DENIED" operation="open" parent=1625 profile="/usr/sbin/mysqld" name="/proc/1626/status" pid=1626 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0

Third, it appears your ntp daemon is being prevented from accessing the network:

[17901.858164] type=1400 audit(1558123373.318:26): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0
[17901.858205] type=1400 audit(1558123373.318:27): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0
[17901.858215] type=1400 audit(1558123373.318:28): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0
[17901.858224] type=1400 audit(1558123373.318:29): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0
[17901.858234] type=1400 audit(1558123373.318:30): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0

Does this sound familiar?

I hope this helps.

Thanks