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 ONE Support launchpad (Login required).

Search for additional results

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