Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230

 

 

 

Job for mysql.service failed because the control process exi

New to Debian (Or Linux in general)? Ask your questions here!
Post Reply
Message
Author
ak0071
Posts: 1
Joined: 2018-03-19 15:13

Job for mysql.service failed because the control process exi

#1 Post by ak0071 »

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+0x3b4)[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.

User avatar
debiman
Posts: 3063
Joined: 2013-03-12 07:18

Re: Job for mysql.service failed because the control process

#2 Post by debiman »

ak0071 wrote:apparmor="DENIED"
i can see this at least a dozen times in your output.
looks pretty unambiguous to me.
i don't use apparmor, so i'll just leave it at that.

also please use code tags when posting command output.

Post Reply