LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-19-2018, 02:27 PM   #1
skydiverscott
LQ Newbie
 
Registered: Apr 2008
Posts: 20

Rep: Reputation: 0
MYSQL 5.7.24 Error after Update


This is the second time this has happened. After an auto applied security update of my Ubuntu server running ZoneMinder CCTV software, MYSQL fails to be able to start.

The error when trying to start MYSQL is:
"Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock"

Running a tail on the journal:
Code:
smorgan@zm:/var/run/mysqld$ journalctl -xe
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Dec 19 13:27:54 zm audit[30438]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30438/status" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:27:54 zm audit[30438]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=0
Dec 19 13:27:54 zm audit[30438]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30438/status" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:27:54 zm kernel: audit: type=1400 audit(1545247674.706:100064): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30438/status" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:27:54 zm kernel: audit: type=1400 audit(1545247674.706:100065): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=0
Dec 19 13:27:54 zm kernel: audit: type=1400 audit(1545247674.706:100066): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30438/status" pid=30438 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:27:54 zm systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
Dec 19 13:28:24 zm systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Dec 19 13:28:24 zm systemd[1]: mysql.service: Unit entered failed state.
Dec 19 13:28:24 zm systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 19 13:28:24 zm systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Dec 19 13:28:24 zm systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Dec 19 13:28:24 zm systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Dec 19 13:28:24 zm kernel: audit: type=1400 audit(1545247704.945:100067): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30528/status" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:28:24 zm kernel: audit: type=1400 audit(1545247704.945:100068): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=0
Dec 19 13:28:24 zm kernel: audit: type=1400 audit(1545247704.945:100069): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30528/status" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:28:24 zm audit[30528]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30528/status" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:28:24 zm audit[30528]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=0
Dec 19 13:28:24 zm audit[30528]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/30528/status" pid=30528 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=107 ouid=107
Dec 19 13:28:25 zm systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
I would like to know how I can fix this and also how to prevent it from occurring again in the future.

Last edited by skydiverscott; 12-19-2018 at 02:29 PM.
 
Old 12-20-2018, 03:44 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,589

Rep: Reputation: 145Reputation: 145
I am not sure whether it helps but I found a recommendation to set

innodb_force_recovery = 1

in the my.cnf. Then try to restart the server.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 03:21 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 11:32 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:18 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration