Sybase ASE Failover Instance

Issues related to applications and software problems
Post Reply
asifkhosa
Posts: 1
Joined: 2018/07/16 21:32:26

Sybase ASE Failover Instance

Post by asifkhosa » 2018/07/16 21:46:01

Hello,,
I am using CentOS 6.9 x64 on VMware. I am trying to configure HA for Sybase ASE 15.7, i had added resources/resource group, but service is not coming up. Can somebody help please.

Interestingly, if i manually start Sybase instance, it works fine.
hosts ---
192.168.20.190 sybnode1
192.168.20.191 sybnode2
192.168.20.192 sybcluster



drwxrwxrwt. 14 root root 4096 Jul 17 01:29 /tmp/
IP = 192.168.20.192 --> Virtual IP
rg_test test /etc/cluster/cluster.conf start service sybcluster
Jul 17 01:14:44 rgmanager Reconfiguring
Jul 17 01:14:44 rgmanager Loading Service Data
Jul 17 01:14:46 rgmanager Stopping changed resources.
Jul 17 01:14:46 rgmanager Restarting changed resources.
Jul 17 01:14:46 rgmanager Starting changed resources.
Jul 17 01:15:22 rgmanager Reconfiguring
Jul 17 01:15:22 rgmanager Loading Service Data
Jul 17 01:15:24 rgmanager Stopping changed resources.
Jul 17 01:15:24 rgmanager Restarting changed resources.
Jul 17 01:15:24 rgmanager Starting changed resources.
Jul 17 01:15:24 rgmanager Initializing service:sybcluster
Jul 17 01:15:24 rgmanager [clusterfs] Not umounting /dev/dm-0 (clustered file system)
Jul 17 01:15:24 rgmanager [ip] 192.168.20.192/255.255.255.0 is not configured
Jul 17 01:15:24 rgmanager [ASEHAagent] ASEHAagent: Start 'verify_all'
Jul 17 01:15:24 rgmanager [ASEHAagent] ASEHAagent: End 'verify_all' successfully.
Jul 17 01:15:24 rgmanager [ASEHAagent] ASEHAagent: Start 'ase_stop'
Jul 17 01:15:24 rgmanager [ASEHAagent] ASEHAagent: The dataserver sybcluster is not running.
Jul 17 01:15:24 rgmanager Starting stopped service service:sybcluster
Jul 17 01:15:24 rgmanager [ASEHAagent] ASEHAagent: Start 'verify_all'
Jul 17 01:15:25 rgmanager [ASEHAagent] ASEHAagent: End 'verify_all' successfully.
Jul 17 01:15:25 rgmanager [ASEHAagent] ASEHAagent: Start 'ase_start'
Jul 17 01:15:25 rgmanager [ASEHAagent] ASEHAagent: Starting 'sybcluster'...
Jul 17 01:15:44 rgmanager [ASEHAagent] ASEHAagent: Start 'verify_all'
Jul 17 01:15:44 rgmanager [ASEHAagent] ASEHAagent: End 'verify_all' successfully.
Jul 17 01:15:44 rgmanager [ASEHAagent] ASEHAagent: Start 'ase_start'
Jul 17 01:15:44 rgmanager [ASEHAagent] ASEHAagent: Starting 'sybcluster'...
Jul 17 01:18:47 rgmanager [ASEHAagent] ASEHAagent: Failed to start ASE server 'sybcluster'. Please check the server error log /sw/sybase/ASE-15_0/instalJul 17 01:18:47 rgmanager start on ASEHAagent "srv_sybcluster" returned 1 (generic error)
Jul 17 01:18:47 rgmanager #68: Failed to start service:sybcluster; return value: 1
Jul 17 01:18:47 rgmanager Stopping service service:sybcluster
Jul 17 01:18:47 rgmanager [clusterfs] Not umounting /dev/dm-0 (clustered file system)
Jul 17 01:18:47 rgmanager [ip] 192.168.20.192/255.255.255.0 is not configured
Jul 17 01:18:47 rgmanager [ASEHAagent] ASEHAagent: Start 'verify_all'
Jul 17 01:18:48 rgmanager [ASEHAagent] ASEHAagent: End 'verify_all' successfully.
Jul 17 01:18:48 rgmanager [ASEHAagent] ASEHAagent: Start 'ase_stop'
Jul 17 01:18:48 rgmanager [ASEHAagent] ASEHAagent: The dataserver sybcluster is not running.
Jul 17 01:18:48 rgmanager Service service:sybcluster is recovering
Jul 17 01:18:48 rgmanager #71: Relocating failed service service:sybcluster
Jul 17 01:19:06 rgmanager [ASEHAagent] ASEHAagent: Failed to start ASE server 'sybcluster'. Please check the server error log /sw/sybase/ASE-15_0/instalJul 17 01:22:11 rgmanager Service service:sybcluster is stopped

Following is my clsuetr.conf.
<?xml version="1.0"?>
<cluster config_version="13" name="cluster">
<clusternodes>
<clusternode name="sybnode1" nodeid="1">
<fence>
<method name="fence_vmware_soap">
<device name="vmfence" port="RHEL_6.9_CLUSTER_SYBDB_190" ssl="on" uuid="42307306-c317-2029-50b3-4a94e9c2f444"/>
</method>
</fence>
</clusternode>
<clusternode name="sybnode2" nodeid="2">
<fence>
<method name="fence_vmware_soap">
<device name="vmfence" port="RHEL_6.9_CLUSTER_SYBDB_191" ssl="on" uuid="4230bec2-1508-13a1-6688-a8997ae2cc9d"/>
</method>
</fence>
</clusternode>
</clusternodes>
<cman expected_votes="1" two_node="1"/>
<fencedevices>
<fencedevice agent="fence_vmware_soap" ipaddr="192.168.20.20" login="xxxxxxxxx" name="vmfence" passwd="xxxxx"/>
</fencedevices>
<rm>
<failoverdomains>
<failoverdomain name="failover" ordered="1" restricted="1">
<failoverdomainnode name="sybnode1"/>
<failoverdomainnode name="sybnode2"/>
</failoverdomain>
</failoverdomains>
<resources>
<ip address="192.168.20.192/255.255.255.0" sleeptime="10"/>
<clusterfs device="/dev/mapper/vg_sap-lv_sap" fsid="18998" fstype="gfs2" mountpoint="/sw" name="StorageHA"/>
<ASEHAagent deep_probe_timeout="300" interfaces_file="/sw/sybase/interfaces" login_file="/sw/sybase/login_file" name="srv_sybcluster" server_name="sybcluster" shutdown_timeout="200" start_timeout="200" sybase_ase="ASE-15_0" sybase_home="/sw/sybase" sybase_ocs="OCS-15_0" sybase_user="sybase"/>
</resources>
<service domain="failover" name="sybcluster" recovery="relocate">
<ASEHAagent ref="srv_sybcluster">
<ip ref="192.168.20.192/255.255.255.0">
<clusterfs ref="StorageHA"/>
</ip>
</ASEHAagent>
</service>
</rm>
</cluster>

Post Reply