2151976 - After fencing is enabled an instance startup raised sddone and 823 errors on the master device and fails to start - ASE CE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2151976 - After fencing is enabled an instance startup raised sddone and 823 errors on the master device and fails to start - ASE CE

Symptom

  • ASE 15.0.3 was migrated to ASE 15.7 SP131 CE with a two node, two instance configuration
  • The second instance was shutdown and remained down except when doing functional the ASE CE configuration for the running ASE instance on Node1
  • The instance was shutdown and the restart failed with sddone error on the master device

 Opening Master Database ...
 Loading ASE's default sort order and character set
 sddone: write error on virtual disk 0 block 164:
 sddone: Device busy

  • A 823 error was also reported in the error log along with a stack trace


 Error: 823, Severity: 24, State: 2
 I/O error detected during wait for ...

************************************

 SQL Text: [no text]
 curdb = 1 tempdb = 0 pstat = 0x0 p2stat = 0x100000
 p3stat = 0x4800 p4stat = 0x0 p5stat = 0x0 p6stat = 0x200000 p7stat = 0x10000
 lasterror = 823 preverror = 0 transtate = 1
 curcmd = 0 program =
 buf__writewait.fdpr.chunk()
 bufwrite()
 ptn_update_row.fdpr.chunk()
 ptn_updlogroot()
 des__flushlogroot()
 des_discardall()
 des_refreshall()
 dsinit.fdpr.chunk()
 dsinit.fdpr.chunk()
...

 end of stack trace, spid 1, kpid 26673356, suid 0

  • A timeslice was reported on the function text.fdpr.chunk() holding a spinlock


 timeslice -501, current process infected at 100036000 (text.fdpr.chunk.1+0x14)

 **** Saved signal context (0x000000016d7b4620): ****
...

 **** end of signal context ****
 timeslice error: spid 1 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 500 ticks (50000 milliseconds). It has been marked for termination.
 This Adaptive Server process has had 24 major and 3158535 minor page faults since boot.
 Spinlocks held by  kpid 26673356
 Spinlock Resource->rdbt_spin at address 000000016168f380 owned by 26673356
 End of spinlock display.
...
 Main thread performing final shutdown.

  • A later fencing error was reported

 iof_init_fdevice: Error(-1) while getting fence device(/dev/hdiskpower26) capabilities for virtual device(0)
 udactivate: error -3 while fencing specific initialization of virtual device 0
 No such message: 48
 ueshutdown: exiting
 Main thread performing final shutdown.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) Cluster Edition (CE) 15.7 SP131 (reported release)
  • Aix Power 7 platform
  • oslevel -s
    7100-03-03-1415
  • lslpp -L | grep EMC
    EMC.Symmetrix.aix.rte 6.0.0.3 C F EMC Symmetrix AIX Support
    EMC.Symmetrix.fcp.rte 6.0.0.3 C F EMC Symmetrix FCP Support
    EMCpower.base 5.5.0.1 C F PowerPath Base Driver and
    EMCpower.encryption 5.5.0.1 C F PowerPath Encryption with RSA
    EMCpower.migration_enabler
    EMCpower.mpx 5.5.0.1 C F PowerPath
    Multi_Pathing
    SYMCLI.JNI.rte 7.2.1.0 C F JNI Interface for EMC SYMCLI.SYMRECOVER.rte 7.2.1.0 C F EMC Solutions Enabler

Product

SAP Adaptive Server Enterprise 15.7 Cluster Edition

Keywords

KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

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.