ase crash

[former_member413784]

Dear All

I have two ASE 15.5 server occur the following error , anyone can support me ?

Thanks a lot !

Victor

Sybase IBM MQ interface/15.5/EBF 21266 SMP ESD#5.3/P/RS6000/AIX 5.3/asear155/2613/64-bit/OPT/

Server1:

00:00:00000:00017:2016/01/19 15:28:12.23 kernel  Current process (0x66602af) infected with signal 11 (SIGSEGV)

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  Address 0x00000001003f5424 (s_estmt_loopend+0x278), siginfo (code, address) = (50, 0x00000004000027d0)

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  ************************************

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  SQL causing error :  

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  ************************************

00:00:00000:00017:2016/01/19 15:28:12.24 server  SQL Text:  

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  curdb = 4 tempdb = 5 pstat = 0x10000 p2stat = 0x101000

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  lasterror = 599 preverror = 0 transtate = 1

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  curcmd = 265 program =                              

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  extended error information: hostname:  login: timesdb_owner

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  pc: 0x00000001000469ec pcstkwalk+0x88()

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  pc: 0x0000000100046340 ucstkgentrace+0x1ac()

00:00:00000:00017:2016/01/19 15:28:12.24 kernel  pc: 0x0000000100045540 ucbacktrace+0x90()

00:00:00000:00017:2016/01/19 15:28:12.25 kernel  pc: 0x00000001006ea940 terminate_process__fdpr_3+0x72c()

00:00:00000:00017:2016/01/19 15:28:12.26 kernel  pc: 0x0000000101f62b48 kisignal__fdpr_1+0xc8()

00:00:00000:00017:2016/01/19 15:28:12.26 kernel  pc: 0x00000001003f5424 s_estmt_loopend+0x278()

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  pc: 0x0000000100be28a0 s_execute__fdpr_119+0x1240()

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  [Handler pc: 0x00000001005868f0 hdl_stack+0x0 installed by the following function:-]

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  [Handler pc: 0x00000001005f9ae8 s_handle+0x0 installed by the following function:-]

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  pc: 0x00000001003ca5e8 sequencer+0x2ac()

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  pc: 0x0000000100166b60 tdsrecv_open+0xcc()

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  [Handler pc: 0x0000000100586b00 ut_handle+0x0 installed by the following function:-]

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  pc: 0x0000000100166a70 conn_hdlr__fdpr_6+0x4()

00:00:00000:00017:2016/01/19 15:28:12.27 kernel  end of stack trace, spid 17, kpid 107348655, suid 4

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Server2:

00000:00189:2016/01/19 15:28:25.13 kernel  Current process (0x576e00b7) infected with signal 11 (SIGSEGV)

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  Address 0x00000001004421ec (ubffree+0x100), siginfo (code, address) = (50, 0x000000006b02c1ca)

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  Spinlocks held by  kpid 1466826935

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  Spinlock Resource->rpssmgr_spin at address 0000000160a53580 owned by 1466826935

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  End of spinlock display.

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x00000001000469ec pcstkwalk+0x88()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100046340 ucstkgentrace+0x1ac()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100045540 ucbacktrace+0x90()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x00000001006ea2ac terminate_process__fdpr_3+0x98()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000101f62b48 kisignal__fdpr_1+0xc8()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x00000001004421ec ubffree+0x100()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100d70994 s_result_const_memfree__fdpr_2+0x70()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x00000001003f5548 s_estmt_loopend__fdpr_6+0x8()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100be28a0 s_execute__fdpr_119+0x1240()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  [Handler pc: 0x00000001005868f0 hdl_stack+0x0 installed by the following function:-]

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  [Handler pc: 0x00000001005f9ae8 s_handle+0x0 installed by the following function:-]

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x00000001003ca5e8 sequencer+0x2ac()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100166b60 tdsrecv_open+0xcc()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  [Handler pc: 0x0000000100586b00 ut_handle+0x0 installed by the following function:-]

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  pc: 0x0000000100166a70 conn_hdlr__fdpr_6+0x4()

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  end of stack trace, spid 189, kpid 1466826935, suid 4

00:00:00000:00189:2016/01/19 15:28:25.13 kernel  ueshutdown: exiting

00:00:00000:00189:2016/01/19 15:28:25.14 kernel  SySAM: Checked in license for 1 ASE_CORE (2013.04140/permanent/1A51 DB83 7897 ADC9).

[former_member413784]

ASE is not hosted in IBM-cluster

[former_member216225]

Hi Víctor

ASE is hosted in IBM-cluster??

[former_member188958]

I don't find any good matches for either stacks among the known defect CRs.    I would recommend configuring a shared memory dump for the signal 11 condition to gather more diagnostics should this happen again.

I'd also generally advise upgrading.  ASE 15.5 is no longer supported by engineering.

-bret

[Former Member]

Since the laterrror = 599 you might want to configure a memdump for it as well.

[former_member413784]

ase version : Adaptive Server Enterprise/15.5/EBF 21266 SMP ESD#5.3/P/RS6000/AIX 5.3/asear155/2613/64-bit/FBO/Wed Jul 24 02:08:11 2013