Symptom
<Process Information>
1> sp_who '971'
2> go
fid spid status loginame origname hostname blk_spid dbname tempdbname cmd block_xloid threadpool
--- ---- ---------- -------- -------- -------- -------- ------ ---------- ------ ----------- ----------------
971 971 sync sleep xxxsa xxxsa xxx51 0 xxxSA tempdb03 SELECT 0 syb_default_pool
(1 row affected)
(return status = 0)
1> select * from syslogshold
2> go
dbid reserved spid page xactid masterxactid starttime name xloid
------ ----------- ------ ---------- -------------- -------------- ------------------------------- ------------------------------------------------------------------- -----------
19 0 971 90673319 0x056790a70015 0x0e898ea70011 Jan 17 2024 9:41AM $upd 1942
9 0 971 58425536 0x037b80c0001e 0x0e898ea70011 Jan 17 2024 9:41AM $ins 1942
17 0 971 243895975 0x0e898ea70011 0x000000000000 Jan 17 2024 9:41AM $chained_transaction 1942
1> dbcc stacktrace(971)
2> go
Start dbcc stacktrace...
pc: 0x40000000029c5d50 kpsuspend+0x2f0(0xc000000100023b18, 0x0000000000000000, 0x0000000000000000, 0xc000000100000000, 0x0000000000000000)
pc: 0x40000000029c6800 upsleepgeneric+0x5c0(0xc00000015aa7c2b0, 0x0000000000070000, 0x0000000000000005, 0x0000000000000001, 0xc00000022d684240)
pc: 0x4000000006b50550 kmrtmsg+0x360(0x0000000000000002, 0x0000000000070000, 0xc00000013b235730, 0x4000000006b85060, 0xc000000000000b19)
pc: 0x4000000006b4f6b0 smget+0x90(0x0000000000070000, 0xc00000000000038c, 0x0000000000000001, 0x60000000008746b8, 0x0000000000000002)
pc: 0x4000000006b85160 uwwait+0x620(0xc00000022d684240, 0xc000000235673ad0, 0x0000000000000002, 0x0000000000010001, 0x0000000000000000)
pc: 0x400000000592b6d0 wt_wait+0x30(0xc000000000000c9f, 0xc0000002307317f0, 0xc00000022d684240, 0x0000000000000002, 0xc000000230731830)
pc: 0x40000000031f69c0 _ZN9LeEmittOp14_preDisconnectEP11LeXchgThMapPiiR7ExeCtxt+0x7a0(0xc0000002b4446a30, 0xc000000230731830, 0x6000000000852110, 0xc000000000000d1c, 0x40000000029584e0)
pc: 0x4000000002976420 _ZN9LeEmittOp12_LeOpReleaseER7ExeCtxt+0x920(0x0000000000000100, 0x6000000000852110, 0xc000000000000f26, 0x4000000002944b20, 0xc000000230731830)
pc: 0x40000000029584e0 LePlanRelease+0x720(0x6000000000830098, 0xc00000013b2359d0, 0x0000000000000001, 0xc000000230731830, 0x0000000000000000)
pc: 0x4000000002944b20 exec_lava+0x2f60(0x40000000028c6a30, 0x6000000000852110, 0xfe4f8ffe1ffb2053, 0xc00000013b235890, 0xc00000013b23585c)
pc: 0x4000000002938230 s_execute+0x3340(0x40000000028c3770, 0x6000000000852110, 0xfe4f8ffe1ffb2b91, 0xc000000000001028, 0xc0000001e9c92430)
pc: 0x40000000028c6a30 sequencer+0xb30(0x000000000000c000, 0x0000000000000091, 0x0000000000000001, 0x000000000000002a, 0x0000000000000091)
pc: 0x40000000028c3770 execproc+0xdd0(0x40000000028c6a30, 0x6000000000852110, 0xfe4f8ffe1ffb6051, 0xc00000013b236760, 0xc00000013b23672c)
pc: 0x400000000293bba0 s_execute+0x6cb0(0x400000000236ed60, 0x6000000000852110, 0xfe4f8ffe1ffbf8c5, 0xc000000000000a9d, 0xc0000001e9c92430)
pc: 0x40000000028c6a30 sequencer+0xb30(0xc0000001e9ca4750, 0x6000000000852110, 0xc0000000000016b5, 0x40000000028c04f0, 0xfe4f8ffe1ffb8001)
pc: 0x400000000236ed60 tdsrecv_language+0x520(0x4000000002f38350, 0x6000000000852110, 0xfe4f8ffe1ffb655b, 0x0000000000000000, 0xc000000000000308)
pc: 0x40000000028c04f0 conn_hdlr+0x38d0(0xc00000010fafaf20, 0xc00000010fafaf20, 0xc000000159106e00, 0x6000000000852110, 0xc00000000000048a)
dbcc stacktrace finished.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- HP-UX on IA64 64bit
- Solaris on SPARC
Product
Keywords
CR#829033, CR829033, 829033 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview