Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443

    Unanswered: DBCC stacktrace (need help)

    Hi,

    We had a spid just doing no i/o and seems to yield on dol_bt_getnext() and sitting there forever. We first tot, mebbe in the dol table, its traversing too many pages, since the table wasn't reindexed for a while. But even after doing a rebuild of the indexes its not shown any improvements. Any help is appreciated. Also, is there any notes in public where theres more info on dbcc stacktrace?


    1> dbcc stacktrace(45)
    2> go
    pc: 0x0065eea4 upyield+0x128(0x00bf9800, 0x00becc00, 0x00bec800,
    0x00c05c00, 0x118f1540)
    pc: 0x0027e6c4 dol_bt_getnext+0x5a8(0x00000000, 0x120351f4, 0x00000000,
    0x120352c0, 0x00000000)
    pc: 0x0028e108 getnext+0x8c(0x120351f4, 0x00bf7400, 0x00bec800,
    0x00040000, 0x00000001)
    pc: 0x0043b0a4 exec_eop+0x4c8(0x00002000, 0x129929b0, 0x00000000,
    0x00000000, 0x00000000)
    pc: 0x0043b260 exec_eop+0x684(0x00002000, 0x129929b0, 0x2d336f38,
    0x00000000, 0x00000001)
    pc: 0x0043b260 exec_eop+0x684(0x00002000, 0x129929b0, 0x2c63c6e0,
    0x00000000, 0x0001293a)
    pc: 0x0043b378 exec_eop+0x79c(0x00007000, 0x129929b0, 0x2c63c458,
    0x00000000, 0x00000000)
    [Handler pc: 0x00440194 execerr installed by the following
    function:-][Handler pc: 0x00584888 jcsExHandler installed by the following
    function:-][Handler pc: 0x003f1d20 sortmerr installed by the
    following function:-][Handler pc: 0x00440194 execerr installed by the
    following function:-][Handler pc: 0x00440194 execerr installed by the
    following function:-][Handler pc: 0x00373c50 aritherr
    installed by the following function:-]pc: 0x0043a52c
    execute+0xb3c(0x2b746060, 0x0000702c, 0x2b
    746060, 0x129929b0, 0x00005000)
    [Handler pc: 0x0013ee88 hdl_backout installed by the following
    function:-]pc: 0x00399548 s_execute+0x24e0(0x80000000, 0x000000c3, 0x2b746060,
    0x00005393, 0x00001000)
    [Handler pc: 0x003b44bc s_handle installed by the following
    function:-]pc: 0x003b1394 sequencer+0x10e8(0x00bf7400, 0x00c05c00, 0x0ec1a200,
    0x00005388, 0x129929b0)
    pc: 0x003a0bb0 execproc+0x79c(0x00005388, 0x00007000, 0x129929b0,
    0x00005000, 0x0000000f)
    pc: 0x00399a60 s_execute+0x29f8(0x00c05c00, 0x00bf9800, 0x0ec1a200,
    0x00000004, 0x00000000)
    [Handler pc: 0x003b44bc s_handle installed by the following
    function:-]pc: 0x003b1394 sequencer+0x10e8(0x00bf7400, 0x00c05c00, 0x0ec1a200,
    0x00005388, 0x129929b0)
    pc: 0x003a0bb0 execproc+0x79c(0x00005388, 0x00007000, 0x129929b0,
    0x00005000, 0x0000000a)
    pc: 0x00399a60 s_execute+0x29f8(0x00c05c00, 0x00bf9800, 0x0ec1a200,
    0x00000004, 0x00000000)
    [Handler pc: 0x003b44bc s_handle installed by the following
    function:-]pc: 0x003b1394 sequencer+0x10e8(0x00bf7400, 0x00c05c00, 0x0ec1a200,
    0x00005388, 0x129929b0)
    pc: 0x0011e064 tdsrecv_language+0xb4(0x00bf7400, 0x00c06c00,
    0x00000001, 0x00005000, 0x00005400)
    [Handler pc: 0x0013ee88 hdl_backout installed by the following
    function:-][Handler pc: 0x0034cfa8 ut_handle installed by the following
    function:-][Handler pc: 0x0034cfa8 ut_handle installed by the
    following function:-]pc: 0x0012d8f0 conn_hdlr+0x2120(0x00c06c00,
    0x00bf7400, 0x00000001, 0x00000001, 0x00007000)
    pc: 0x0067b5e4 _coldstart(0x0000002f, 0x0012b7d0, 0x00000000,
    0x00000000, 0x00000000)
    DBCC execution completed. If DBCC printed error messages, contact a
    user with System Administrator (SA) role.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    may sound obivous but have you looked at if you are waiting on locks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •