Hi Team,mysql restart.txt (3.6 KB) show_engine.txt (12.3 KB) conf-mysql.txt (930 Bytes)
Mysql production db restarting frequently thrice in week .
i checked but didn’t get much info. why it is restarting every time
OS : Ubuntu 18.04.5 LTS
mysql:8.0.23
Please find attachment
1 Like
Just a tought, have you tried disabling apparmor? The syslog points to that.
Apr 9 16:55:39 ip-10-50-0-120 kernel: [1449603.389015] audit: type=1400 audit(1617967539.158:82): apparmor=“DENIED”
operation=“open” profile=“/usr/sbin/mysqld” name=“/proc/15808/task/16324/mem” pid=15808 comm=“mysqld” requested_mask=“r”
denied_mask=“r” fsuid=111 ouid=111
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: mysql.service: Failed with result ‘exit-code’.
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: Stopped MySQL Community Server.
Apr 9 16:55:39 ip-10-50-0-120 systemd[1]: Starting MySQL Community Server…
Apr 9 16:55:39 ip-10-50-0-120 kernel: [1449604.068026] audit: type=1400 audit(1617967539.838:83):
apparmor=“STATUS” operation=“profile_replace” info=“same as current profile, skipping” profile=“unconfined”
name=“/usr/sbin/mysqld” pid=2814 comm=“apparmor_parser”
1 Like