SAP Knowledge Base Article - Preview

3437268 - hang occur when performing parallel processing queries

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

SAP Adaptive Server Enterprise 16.0

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.