SAP Knowledge Base Article - Preview

3014853 - Database offline after restart - signal 11 during UNDO pass in do__validate_stale_page_ts - SAP ASE

Symptom

  • drop login (due to user who left company) hung with no output
  • unable to kill the drop login spid - it won't go away
  • dump database would hang too
  • able to isql using 'sa'
  • after restart of ASE one database failed to recover and hit a signal 11 during UNDO pass in do__validate_stale_page_ts. Other calls include :

do_needed+0xcaf()
undo_twopage_log_clr+0x5b()
undo_apl_xalloc+0x6c7()
rec_undo_log+0x1825()
recovery+0xbed()
boot__recover_and_online+0xfc()
rec__boot_recover_dbs+0x135()
rec_run_parallel_recovery+0x438()
dorecover+0x155()
ds__recoverdbs+0x6d6()
dsinit+0x15a2()

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL09

Product

SAP Adaptive Server Enterprise 16.0

Keywords

do__validate_stale_page_ts, recovery , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.