SAP Knowledge Base Article - Preview

3090466 - How to avoid killing Primary ASE when network glitch is detected - SAP ASE 16.0 with HADR

Symptom

  • Fault Manager (FM) kills the primary ASE with a "kill -9" command when FM detects a network breakdown:

    2021 06/06 18:35:30.703 (6506) wait to check heartbeat to heartbeat.
    2021 06/06 18:35:31.203 (6506) no heartbeat received.
    2021 06/06 18:35:31.203 (6506) wait to check heartbeat to heartbeat.
    2021 06/06 18:35:31.703 (6506) no heartbeat received.
    2021 06/06 18:35:31.703 (6506) heartbeat to heartbeat failed.
    2021 06/06 18:35:31.703 (6506) h2h failed -> set this site to inactive.
    2021 06/06 18:35:31.703 (6506) killing database process...
    2021 06/06 18:35:31.717 (6506) maxTime=1623018941
    2021 06/06 18:35:31.743 (6506) user name not found sybase.
    2021 06/06 18:35:31.743 (6506) dataserver process: 15639 sybase   /opt/sybase/syb16/ASE-16_0/bin/dataserver -d/dev/vgsybdbmyASE/MASTER -e/var/opt/sybase/logs/myASE/errorlog_myASE -c/etc/opt/sybase/myASE/myASE.cfg -M/opt/sybase/syb16/ASE-16_0 -N/opt/sybase/syb16/ASE-16_0/sysam/myASE.properties -i/opt/sybase/syb16 -smyASE
    2021 06/06 18:35:31.743 (6506) dataserver pid: 15639
    2021 06/06 18:35:31.743 (6506) user name not found sybase.
    2021 06/06 18:35:31.743 (6506) command to kill dataserver process: kill -9 15639
    2021 06/06 18:35:31.751 (6506) currentTime=1623018931
    2021 06/06 18:35:31.751 (6506) maxTime=1623018941
    2021 06/06 18:35:31.773 (6506) user name not found sybase.
    2021 06/06 18:35:31.774 (6506) user name not found sybase.
    2021 06/06 18:35:31.774 (6506) dataserver process not found.
    2021 06/06 18:35:31.774 (6506) ASE log not found.
    2021 06/06 18:35:41.717 (6506) killing the database server process failed (timeout).

  • Is it possible not to kill the primary ASE but go for a failover or make the standby ASE function as an active ASE?
  • Can FM be configured to wait for some time before taking any actions?
  • The following FM configuration parameters are set to default values:

          ha/syb/hb_fm_timeout   3 sec 
          ha/syb/hb_hb_timeout   3 sec 
          ha/syb/hb_force_db_inactive   1
          ha/syb/hb_stop_db  1 
          ha/syb/hb_shutdown_sys 0

       and three FM configuration parameters are customized:

          ha/syb/failover_if_insync = 1

          ha/syb/waittime_if_unresponsive = 300
          ha/syb/failover_if_unresponsive = 1


Read more...

Environment

  • SAP Adaptive  Server Enterprise (ASE) 16.0 
  • SAP Replication Server (SRS) 16.0 
  • High Availability Disaster Recovery (HADR)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

outage, heartbeat, H2H, H2FM, split, brain , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.