hi everyone,
i got a error while restarting mysql can anyone help me in resolving it,
1
Zabbix systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysql.service has finished shutting down.
Mar 19 10:42:09 Zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysql.service has begun starting up.
Mar 19 10:42:09 Zabbix kernel: audit: type=1400 audit(1521474129.492:29198): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22365/status" pid=22365 comm="mysqld"
Mar 19 10:42:09 Zabbix audit[22365]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22365/status" pid=22365 comm="mysqld" requested_mask="r" denied_mask="r" f
Mar 19 10:42:09 Zabbix audit[22365]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22365 comm="mysqld" requested_mask="r" denied_mas
Mar 19 10:42:09 Zabbix kernel: audit: type=1400 audit(1521474129.508:29199): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22365 comm="m
Mar 19 10:42:09 Zabbix audit[22365]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22365/status" pid=22365 comm="mysqld" requested_mask="r" denied_mask="r" f
Mar 19 10:42:09 Zabbix kernel: audit: type=1400 audit(1521474129.512:29200): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22365/status" pid=22365 comm="mysqld"
Mar 19 10:42:11 Zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
Mar 19 10:42:41 Zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Mar 19 10:42:41 Zabbix systemd[1]: mysql.service: Unit entered failed state.
Mar 19 10:42:41 Zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
Mar 19 10:42:41 Zabbix systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mar 19 10:42:41 Zabbix systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysql.service has finished shutting down.
Mar 19 10:42:41 Zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit mysql.service has begun starting up.
Mar 19 10:42:41 Zabbix audit[22456]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22456/status" pid=22456 comm="mysqld" requested_mask="r" denied_mask="r" f
Mar 19 10:42:41 Zabbix audit[22456]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22456 comm="mysqld" requested_mask="r" denied_mas
Mar 19 10:42:41 Zabbix audit[22456]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22456/status" pid=22456 comm="mysqld" requested_mask="r" denied_mask="r" f
Mar 19 10:42:41 Zabbix kernel: audit: type=1400 audit(1521474161.849:29201): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22456/status" pid=22456 comm="mysqld"
Mar 19 10:42:41 Zabbix kernel: audit: type=1400 audit(1521474161.849:29202): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22456 comm="m
Mar 19 10:42:41 Zabbix kernel: audit: type=1400 audit(1521474161.849:29203): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/22456/status" pid=22456 comm="mysqld"
Mar 19 10:42:43 Zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
cognate@Zabbix:~$ tail -30 /var/log/mysql/error.log
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 76385 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8f29b]
/usr/sbin/mysqld(handle_fatal_signal+0x489)[0x787029]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f109db2e390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f109cee7428]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f109cee902a]
/usr/sbin/mysqld[0x75ca3e]
/usr/sbin/mysqld(_ZN2ib5fatalD1Ev+0x145)[0x10573e5]
/usr/sbin/mysqld(_Z20buf_page_io_completeP10buf_page_tb+0x3b 4)[0x1095a44]
/usr/sbin/mysqld(_Z12fil_aio_waitm+0x11f)[0x110beef]
/usr/sbin/mysqld(io_handler_thread+0xd0)[0xff6fe0]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f109db246ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f109cfb941d]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
can anyone help me in resolving this issue. what might be the error.
Comment