[Linux-cluster] Issue with mysql service in RHEL6.2 cluster

Mon Jan 9 23:09:25 UTC 2012

Yes it has.

drwx--x--x. 3 mysql     root      4096 Jan  9 13:45 cluster

Thanks

From: linux-cluster-bounces at redhat.com [mailto:linux-cluster-bounces at redhat.com] On Behalf Of Patricio A. Bruna
Sent: Tuesday, 10 January 2012 9:34 AM
To: linux clustering
Subject: Re: [Linux-cluster] Issue with mysql service in RHEL6.2 cluster

Has the mysql user the permissions  to write on the /var/run/cluster directory?

------------------------------------
Patricio Bruna V.
IT Linux Ltda.
www.it-linux.cl
Twitter <http://twitter.com/ITLinux> 
Fono : (+56-2) 333 0578
Móvil: (+56-9) 8899 6618

________________________________

	I am having issue with mysql service in RHEL6.2 cluster. While starting service I receive the following error in /var/log/message

	Jan 10 08:47:52 atp-wwdev1 rgmanager[6015]: Starting Service mysql:mysql

	Jan 10 08:47:54 atp-wwdev1 rgmanager[6096]: Starting Service mysql:mysql > Failed - Timeout Error

	Jan 10 08:47:54 atp-wwdev1 rgmanager[1842]: start on mysql "mysql" returned 1 (generic error)

	Jan 10 08:47:54 atp-wwdev1 rgmanager[1842]: #68: Failed to start service:mysql; return value: 1

	Jan 10 08:47:54 atp-wwdev1 rgmanager[1842]: Stopping service service:mysql

	Jan 10 08:47:54 atp-wwdev1 rgmanager[6180]: Stopping Service mysql:mysql

	Jan 10 08:47:55 atp-wwdev1 rgmanager[6202]: Checking Existence Of File /var/run/cluster/mysql.pid [mysql:mysql] > Failed - File Doesn't Exist

	Jan 10 08:47:55 atp-wwdev1 rgmanager[6224]: Stopping Service mysql:mysql > Succeed

	Jan 10 08:47:55 atp-wwdev1 rgmanager[1842]: Service service:mysql is recovering

	Jan 10 08:47:55 atp-wwdev1 rgmanager[1842]: #71: Relocating failed service service:mysql

	Jan 10 08:47:59 atp-wwdev1 rgmanager[1842]: Service service:mysql is stopped

	Can you please help me with the above problem?

	My cluster.conf file is follows:

	<?xml version="1.0"?>

	<cluster config_version="29" name="atp_mysql">

	        <clusternodes>

	                <clusternode name="atp-wwdev1.test1.com.au" nodeid="1">

	                        <fence/>

	                        <multicast addr="239.192.200.1"/>

	                </clusternode>

	                <clusternode name="atp-wwdev2.test1.com.au" nodeid="2" votes="1">

	                        <fence/>

	                        <multicast addr="239.192.200.1"/>

	                </clusternode>

	        </clusternodes>

	        <fencedevices>

	                <fencedevice agent="fence_xvm" name="atp_fance"/>

	        </fencedevices>

	        <rm>

	                <failoverdomains>

	                        <failoverdomain name="atp_failover" nofailback="0" ordered="1" restricted="0">

	                                <failoverdomainnode name="atp-wwdev1.test1.com.au" priority="2"/>

	                                <failoverdomainnode name="atp-wwdev2.test1.com.au" priority="5"/>

	                        </failoverdomain>

	                </failoverdomains>

	                <resources>

	                        <ip address="10.26.240.95/24" monitor_link="on" sleeptime="2"/>

	                        <netfs export="/nfs/mysql" force_unmount="on" fstype="nfs" host="10.26.240.190" mountpoint="/var/lib/mysql" name="filesystem" no_unmount="on"/>

	                        <mysql config_file="/etc/my.cnf" listen_address="10.26.24.95" name="MySQL server" shutdown_wait="2" startup_wait="0"/>

	                </resources>

	                <service autostart="1" domain="atp_failover" exclusive="0" name="access_ip" recovery="relocate">

	                        <ip ref="10.26.240.95/24"/>

	                </service>

	                <service autostart="1" domain="atp_failover" exclusive="0" name="mysql" recovery="relocate">

	                        <mysql config_file="/etc/my.cnf" listen_address="10.26.240.95" name="mysql" shutdown_wait="2" startup_wait="2"/>

	                </service>

	                <service autostart="1" domain="atp_failover" exclusive="0" name="storage" recovery="relocate">

	                        <netfs ref="filesystem"/>

	                </service>

	        </rm>

	        <fence_daemon clean_start="0" post_fail_delay="0" post_join_delay="3"/>

	        <cman expected_votes="1" two_node="1">

	                <multicast addr="239.192.200.1"/>

	        </cman>

	        <totem/>

	        <logging debug="off"/>

	</cluster>

	/etc/my.cnf file is follows:

	[mysqld]

	datadir=/var/lib/mysql

	socket=/var/lib/mysql/mysql.sock

	user=mysql

	# Disabling symbolic-links is recommended to prevent assorted security risks

	symbolic-links=0

	[mysqld_safe]

	log-error=/var/log/mysqld.log

	pid-file=/var/run/cluster/mysql.pid

	Thanks

	Raj

	Important Notice:
	This message and its attachments are confidential and may contain information which is protected by copyright. It is intended solely for the named addressee. If you are not the authorised recipient (or responsible for delivery of the message to the authorised recipient), you must not use, disclose, print, copy or deliver this message or its attachments to anyone. If you receive this email in error, please contact the sender immediately and permanently delete this message and its attachments from your system. 
	Any content of this message and its attachments that does not relate to the official business of Pacific Magazines Pty Limited must be taken not to have been sent or endorsed by it. No representation is made that this email or its attachments are without defect or that the contents express views other than those of the sender.

	Please consider the environment - do you really need to print this email?

	--
	Linux-cluster mailing list
	Linux-cluster at redhat.com
	https://www.redhat.com/mailman/listinfo/linux-cluster

Important Notice:
This message and its attachments are confidential and may contain information which is protected by copyright. It is intended solely for the named addressee. If you are not the authorised recipient (or responsible for delivery of the message to the authorised recipient), you must not use, disclose, print, copy or deliver this message or its attachments to anyone. If you receive this email in error, please contact the sender immediately and permanently delete this message and its attachments from your system. 
Any content of this message and its attachments that does not relate to the official business of Pacific Magazines Pty Limited must be taken not to have been sent or endorsed by it. No representation is made that this email or its attachments are without defect or that the contents express views other than those of the sender.

Please consider the environment - do you really need to print this email?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120110/0054671b/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2893 bytes
Desc: image001.png
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120110/0054671b/attachment.png>