SQL Server System Exception
Kris
Have Sybase ASE 12.5.0.1 running on W2K SP4 server. Couple of weeks
ago activated auditing and since restart then, client app making use
of Sybase is becoming slower and slower. There's also a maintenance
app that transfers data from production db to warehouse db and
sometimes this cause freaky stack traces in sybase error log.
Anybody any idea on what to do?
Much obliged
Kaviar
00:00000:00330:2004/10/05 08:50:27.02 kernel SQL Server system
exception (0xc0000005) generated by a storage access violation.
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0019D325 ct_init+
0xe13 (0x01601CE8, 0x00000000, 0xB402D8E0, 0x0026FD9D)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0019D325 ct_init+
0xe13 (0x0160BEF0, 0x00000000, 0x00000000, 0x00000001)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0019CF23 ct_init+
0xa11 (0x0160BEF0, 0x01601CE8, 0x001ACFA0, 0x00000003)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0019D55F
ct__utl_validate_key+ 0xcf (0x0160BEF0, 0x01600DB8, 0x015FF280,
0x00000001)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x001ACE5E ds_error+
0xae (0x0160BEF0, 0x00000000, 0x015D6000, 0xB402D980)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00212D33
comn_moneytoi8+ 0xd3 (0x015FF248, 0x0160BEF0, 0x00000005, 0xFFFFFFFF)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00212BAF
comn_moneytoi4+ 0x53 (0x015FF248, 0x0160BEF0, 0x00000005, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x002129C4
comn_moneytoi1+ 0xc4 (0x015FF248, 0x0160BEF0, 0xFFFFD8F1, 0x00000005)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00212297
comn_mny4tomny4+ 0x82 (0x01600DB8, 0x0159EEC8, 0x0160BEF0, 0xFFFFD8F1)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x001710E0
connabort_poll+ 0x40 (0x01600DB8, 0x015FF280, 0x00173720, 0x00000004)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00171A15
ct__apicont_comp_cb+ 0x125 (0x01600DB8, 0x015FF280, 0x00001771,
0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00173F72
ct_br_table+ 0x1cc (0x00000000, 0x015FF280, 0x00001771, 0xB402DC34)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00173B1A
ct_br_column+ 0x453 (0xB402DC18, 0x00CEE7C4, 0x00000000, 0xB402DF40)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00B06AEC
astc__h_ase_sendrpc+ 0x4a4 (0xB402DC18, 0xB402DF80, 0x00000046,
0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00B065BA
astc_h_ase_beginrpc+ 0x13 (0xB402DF64, 0xB402E6FC, 0x00000000,
0x00000001)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0046A74B
hdl_backout_msg installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x005175F9
astc__h_ase_dorpc+ 0x4d3 (0x0749B288, 0x01600DB8, 0x00000006,
0xB402DFD8)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0051218F
astc_sync_participant+ 0x2cf (0x01600DB8, 0x00000006, 0x00000001,
0x0566BE70)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x004C6183
xact_sync+ 0x1d (0x05673E28, 0x12FA6A98, 0xB402E1F0, 0x00807C37)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x00B4BDB0
omni_backout installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00B16143
omni_dynexec+ 0xa3 (0x05673E28, 0x12FA6A98, 0xB402E6FC, 0x00000020)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00418305
dso_dynexec+ 0x1e (0x12FA6A98, 0x12FA6EBC, 0xB402E7DC, 0x00000004)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00807C37 exec_eop+
0x18f9 (0x12FA6A08, 0x12FA6A98, 0x000000C5, 0xB402E7DC)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0080CABB
execerr installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x009ADCD8
jcsExHandler installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x007F1797
sortmerr installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0080CABB
execerr installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0080CABB
execerr installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x00769082
aritherr installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00805DAA execute+
0xa5a (0x0566C300, 0x6172656E, 0x7461646C, 0x5F776461)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00739410
s_execute+ 0x2e90 (0x12FE0000, 0x004ECEA1, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0076F0F3
s_handle installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0076BB8D
sequencer+ 0x17fd (0x13C3B390, 0x13C3B420, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00742CF3 execproc+
0x7e8 (0x0566C300, 0x6574656C, 0x69746170, 0xB4746E65)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0046A737
hdl_backout installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00739B16
s_execute+ 0x3596 (0x11925800, 0x00000006, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel [Handler pc: 0x0076F0F3
s_handle installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x0076BB8D
sequencer+ 0x17fd (0x12122D20, 0x12122DB0, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.24 kernel pc: 0x00742CF3 execproc+
0x7e8 (0xB402F92C, 0x00ACC6E4, 0x00000000, 0x7C58DAC2)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00739B16
s_execute+ 0x3596 (0x11D86000, 0x0044AA55, 0xB402FF40, 0x00FA7F64)
00:00000:00330:2004/10/05 08:50:27.26 kernel [Handler pc: 0x0076F0F3
s_handle installed by the following function:-]
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x0076BB8D
sequencer+ 0x17fd (0x0566BE00, 0xB3FEF8D4, 0x045E55B4, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00445CC4
tdsrecv_language+ 0x540 (0x00000283, 0xB3FEF8D4, 0x045E55B4,
0x06EE26C8)
00:00000:00330:2004/10/05 08:50:27.26 kernel end of stack trace, spid
330, kpid 1185743275, suid 21
00:00000:00330:2004/10/05 08:50:27.26 kernel
************************************
00:00000:00330:2004/10/05 08:50:27.26 kernel SQL causing error : EXEC
P_DeletePatient 2300
00:00000:00330:2004/10/05 08:50:27.26 kernel
************************************
00:00000:00330:2004/10/05 08:50:27.26 server SQL Text: EXEC
P_DeletePatient 2300
00:00000:00330:2004/10/05 08:50:27.26 kernel curdb = 4 pstat =
0x10100 lasterror = 0
00:00000:00330:2004/10/05 08:50:27.26 kernel preverror = 0 transtate
= 0
00:00000:00330:2004/10/05 08:50:27.26 kernel curcmd = 197 program =
Clinisoft CIMS
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00B002FD
os_get_cur_stk_desc+ 0x13a (0xB402D150, 0x7C57E597, 0x7C574E58,
0xFFFFFFFF)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00B002FD
os_get_cur_stk_desc+ 0x13a (0xB402D150, 0xB402CF08, 0x0000270F,
0x00000002)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00AD955A
pcstkwalk+ 0x204 (0x46AD01AB, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00AD91E4
ucstkgentrace+ 0x224 (0x46AD01AB, 0x00000001, 0x00C59910, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.26 kernel pc: 0x00A9305B
ucbacktrace+ 0xab (0x46AD01AB, 0xFFFFFFFF, 0xC0000005, 0x0566BE70)
00:00000:00330:2004/10/05 08:50:27.27 kernel pc: 0x00407322
terminate_process+ 0xbdc (0xC0000005, 0x7800BDB5, 0xB402D4E4,
0x00000000)
00:00000:00330:2004/10/05 08:50:27.27 kernel pc: 0x00A872EB
kiexception+ 0x2e0 (0x06EE26C8, 0xB3FEF8D4, 0x045E55B4, 0x06EE26C8)
00:00000:00330:2004/10/05 08:50:27.27 kernel pc: 0x00A87E17
kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.27 kernel pc: 0x7C57438B
KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00330:2004/10/05 08:50:27.27 kernel end of stack trace, spid
330, kpid 1185743275, suid 21
00:00000:00330:2004/10/05 08:50:27.38 server Error: 8013, Severity:
16, State: 4
00:00000:00330:2004/10/05 08:50:27.38 server A CTLIB operation failed
during an RPC.
00:00000:00330:2004/10/05 08:50:27.44 server Ct-library: Msg
0x01010131:ct_send(): user api layer: external error: This routine
cannot be called because another command structure has results
pending.