SAP Knowledge Base Article - Preview

2323410 - Getting stacktrace with signal 11 on altdb__clear_chunk function when altering the database using alter database with "off" commad - SAP ASE

Symptom

Under rare condition, the alter database may fail with signal 11 on altdb__clear_chunk while shrink the db using "off" option.

Getting below error in the errorlog
00:0008:00000:00061:2016/04/21 08:31:56.01 kernel  Current process (0xb5005b) infected with signal 11 (SIGSEGV)
00:0008:00000:00061:2016/04/21 08:31:56.01 kernel  Address 0x0x00000000013e8938 (altdb__clear_chunk+0x244), siginfo (code, address)= (1, 0x0x0000000000000098)
00:0008:00000:00061:2016/04/21 08:31:56.04 kernel  **** Saved signal context (0x0x000000015486c680): ****
....
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  ************************************
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  SQL causing error : alter database AS9 off AS9_data_005

00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  ************************************
00:0012:00000:00061:2016/04/21 08:32:57.88 server  SQL Text: alter database AS9 off AS9_data_005
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  curdb = 4 tempdb = 8 pstat = 0x10000 p2stat = 0x40101100
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x0 p7stat = 0x10000
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  lasterror = 0 preverror = 0 transtate = 1
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  curcmd = 305 program = isql
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  extended error information: hostname: ls5393 login: sapsa
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  pc: 0x0000000001765fbb pcstkwalk+0x3a3()
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  pc: 0x0000000001765a93 ucstkgentrace+0x263()
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  pc: 0x00000000017619ff ucbacktrace+0x51()
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  pc: 0x00000000007a4def terminate_process+0xaff()
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  pc: 0x00000000017b6f14 kisignal+0x32b()
00:0012:00000:00061:2016/04/21 08:32:57.88 kernel  [Handler pc: 0x0x0000000001369a23 hdl_backout_msg installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000013e8938 altdb__clear_chunk+0x244()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x0000000001369a23 hdl_backout_msg installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000013e850f altdb__clear_lpages+0x177()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x0000000001369a23 hdl_backout_msg installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000013e6e99 altdb__do_shrinkdb+0x8c6()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x0000000001369a23 hdl_backout_msg installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000013e356b altdb_shrink+0x6fd()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000013deda7 alterdb+0x1f7()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000012bfaa1 s_execute+0xb7a1()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x0000000001368cf0 hdl_stack installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000012fa650 s_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000012ffcc8 sequencer+0x2958()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x00000000007ea159 tdsrecv_language+0x1e9()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  [Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  pc: 0x000000000080bfa0 conn_hdlr+0x1100()
00:0012:00000:00061:2016/04/21 08:32:57.89 kernel  end of stack trace, spid 61, kpid 11862107, suid


Read more...

Environment

SAP Adaptive Server Enterprise 16.x

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Signal 11, altdb__clear_chunk, alter database, shrink database, Sybase, ASE, CR 799240 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.