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

[Patricio A. Bruna]

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 
Fono : (+56-2) 333 0578 
Móvil: (+56-9) 8899 6618 

----- Mensaje original -----

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120109/8d682fea/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: zimbra_gold_partner.png
Type: image/png
Size: 2893 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120109/8d682fea/attachment.png>