Mysql Service restarting frequently

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