[chef] Re: mysql recipe error on ubuntu 12.04

[Charles Johnson < >]

Could it be related to this issue?

http://askubuntu.com/questions/127264/cant-start-mysql-mysql-respawning-too-fast-stopped

Thanks,

--Charles

-- 

Charles Johnson

Solutions Engineer - Opscode, Inc.

(510) 545-9485 - Direct Line

From: Boyd Hemphill < "> >
Reply-To: " "> " < "> >
Date: Sunday, November 11, 2012 10:52 AM
To: " "> " < "> >
Subject: [chef] Re: Re: Re: Re: mysql recipe error on ubuntu 12.04

The my.cnf snip seees to have everything commented out.  Usually the log would be /var/log/mysqld.log or /var/log/mysql/error.log.  

I have not seen this issue with MySQL starting before and I am not currently using 5.5 or 12.04.  I am about to migrate.  

An absolute guess on my part is that mysql was installed b/f the recipe ran and something is colliding in terms of the server trying to gain access to a resource.  

Sorry I cannot be more specific.

Boyd

On Sun, Nov 11, 2012 at 11:05 AM, S Ahmed < " target="_blank"> > wrote:

Boyd/Paul,

Thanks for the help.

Boyd, according to my.cnf it seems logging is in syslog, it reads:

# * Logging and Replication

#

# Both location gets rotated by the cronjob.

# Be aware that this log type is a performance killer.

#log            = /var/log/mysql/mysql.log

#

# Error logging goes to syslog. This is a Debian improvement :)

>restart mysql

estart: Rejected send message, 1 matched rules; type="method_call", sender=":1.7" (uid=1000 pid=1128 comm="restart mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Restart" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")

>sudo restart mysql

restart: Unknown instance: 

syslog shows:

Nov 11 16:46:23 removed kernel: [54062688.327783] audit_printk_skb: 9 callbacks suppressed

Nov 11 16:46:23 removed kernel: [54062688.327787] type=1400 audit(1352652383.807:14): apparmor="DENIED" operation="open" parent=1 profile=""/usr/sbin/mysqld"" name="/etc/mysql/mysql/conf.d/" pid=745 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=106

Nov 11 16:46:23 removed kernel: [54062688.329541] init: mysql main process (745) terminated with status 1

Nov 11 16:46:23 removed kernel: [54062688.329586] init: mysql main process ended, respawning

Nov 11 16:46:24 removed kernel: [54062689.210421] init: mysql post-start process (752) terminated with status 1

Nov 11 16:46:24 removed kernel: [54062689.225176] type=1400 audit(1352652384.703:15): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=821 comm="apparmor_parser"

Nov 11 16:46:24 removed kernel: [54062689.244978] type=1400 audit(1352652384.723:16): apparmor="DENIED" operation="open" parent=1 profile=""/usr/sbin/mysqld"" name="/etc/mysql/mysql/conf.d/" pid=825 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=106

Nov 11 16:46:24 removed kernel: [54062689.246024] init: mysql main process (825) terminated with status 1

Nov 11 16:46:24 removed kernel: [54062689.246068] init: mysql main process ended, respawning

Nov 11 16:46:24 removed kernel: [54062689.255999] init: mysql post-start process (826) terminated with status 1

Nov 11 16:46:24 removed kernel: [54062689.272705] type=1400 audit(1352652384.751:17): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=841 comm="apparmor_parser"

Nov 11 16:46:24 removed kernel: [54062689.291636] type=1400 audit(1352652384.771:18): apparmor="DENIED" operation="open" parent=1 profile=""/usr/sbin/mysqld"" name="/etc/mysql/mysql/conf.d/" pid=845 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=106

Nov 11 16:46:24 removed kernel: [54062689.292787] init: mysql main process (845) terminated with status 1

Nov 11 16:46:24 removed kernel: [54062689.292832] init: mysql respawning too fast, stopped

Nov 11 16:46:29 removed ntpdate[470]: adjust time server 91.189.94.4 offset 0.408380 sec

Nov 11 16:46:31 ip-10removed-114-198-63 kernel: [54062696.205953] eth0: no IPv6 routers present

On Sun, Nov 11, 2012 at 7:57 AM, Boyd Hemphill < " target="_blank"> > wrote:

Small error of fact from Paul.  It should be 'restart mysql' on ubuntu because of upstart.

Random Stabs
12.04 uses mysql 5.5 so that might be worth looking at as a cause.

The mysql error lodging is usually pretty helpful.  It will either be in /var/log or where /etc/mysql/ my.cnf says it will be

On Nov 10, 2012 11:38 PM, "Paul Graydon" < " target="_blank"> > wrote:

On 11/10/2012 07:15 PM, S Ahmed wrote:

service[mysql] (mysql::server line 71) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'

This is telling you that the service resource was run but the exit status of the command it ran was 1 instead of 0, which usually indicates an error of some description.
Unfortunately it's impossible to tell what that error is from what chef has provided.
You'll need to run:
# service mysql restart
yourself and see what it returns on the command line.

Paul