Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    167

    Unanswered: Stack Trace... Error: 614, Severity: 21, State: 12....

    Currently running ASE 12.5.4

    Stack Trace... Error: 614, Severity: 21, State: 12....

    I currently do not have access to the Sybase Support Site or have access to opening a Case with them. I just joined the team, but have no access to any Sybase services yet (taking HR a million years to get me all the logins).

    I've received the following Stack Trace. Does anyone know the fix for this?

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

    00:00000:00538:2007/04/01 13:15:28.66 server Error: 614, Severity: 21, State: 12
    00:00000:00538:2007/04/01 13:15:28.66 server Adaptive Server accessed a row that has an illegal length of 4691 while in data base 'dbccdb'.
    Page pointer = 0x701758000, pageno = 2347, status = 0x91, objectid = 1600005700, indexid = 0, level = 0. The minimum row length is 3. The pag
    e size is 1024.
    00:00000:00538:2007/04/01 13:15:28.67 kernel ************************************
    00:00000:00538:2007/04/01 13:15:28.67 kernel SQL causing error : use dbccdb setuser "dbo" reorg reclaim_space scan_dbccdb
    00:00000:00538:2007/04/01 13:15:28.67 kernel ************************************
    00:00000:00538:2007/04/01 13:15:28.67 server SQL Text: use dbccdb setuser "dbo" reorg reclaim_space scan_dbccdb
    00:00000:00538:2007/04/01 13:15:28.67 kernel curdb = 31515 tempdb = 2 pstat = 0x10000
    00:00000:00538:2007/04/01 13:15:28.67 kernel lasterror = 614 preverror = 0 transtate = 0
    00:00000:00538:2007/04/01 13:15:28.67 kernel curcmd = 339 program = update_stats.pl
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000809153a4 pcstkwalk+0x28(0x00000000d4803618, 0x00000000d4802d90, 0x000000000000270
    f, 0x0000000000000002, 0x0000000000000000)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008091528c ucstkgentrace+0x1c8(0x000000000000270f, 0x000000001ee302ad, 0x0000000000
    000000, 0x00000000f204f990, 0x00000000eb0a55c0)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000808b57bc ucbacktrace+0xb0(0x0000000000000000, 0x0000000000000001, 0x0000000000000
    01e, 0x00000000eb0b977c, 0x00000000c17ce000)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008022ebdc terminate_process+0x10b8(0x00000000eb0a55c0, 0xffffffffffffffff, 0x00000
    000eb0ad190, 0x000000008028cf08, 0x00000000eb0acf20)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008028cf1c hdl_default+0x58(0x0000000000000006, 0x000000000000000e, 0x0000000000000
    015, 0x000000000000000c, 0x00000000d4803b50)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008028c8ec ex_raise+0x1d8(0x0000000000000015, 0x000000000000000c, 0x00000000eb0ad19
    0, 0x0000000000000000, 0x00000000eb0acf20)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000802c4da8 dol_rowsize+0x11c(0x0000000000001253, 0x0000000701758022, 0x000000000000
    0000, 0x0000000000000000, 0x0000000000000000)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000802c4b7c dol_rowsize_plus_holepad+0x1c(0x0000000701758000, 0x0000000701758022, 0x
    0000000000000000, 0x0000000000000000, 0x00000000817af400)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000803da278 dol__markcommit_log_gc+0x23c(0x00000000eb0b07b0, 0x00000007086ce558, 0x0
    0000000eb0a55c0, 0x0000000000000000, 0x0000000000000000)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000803d9dcc dol_garbage_collect+0x1ec(0x0000000000000000, 0x00000007086ce558, 0x0000
    000000000000, 0x0000000000000000, 0x0000000000000003)
    00:00000:00538:2007/04/01 13:15:28.67 kernel [Handler pc: 0x000000008052e0a8 reorg_handler installed by the following function:-]
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008052bacc reorg__rs+0x498(0x0000000000000003, 0x0000000000000000, 0x00000000000000
    00, 0x0000000000000000, 0x0000000000000000)
    00:00000:00538:2007/04/01 13:15:28.67 kernel [Handler pc: 0x000000008052e0a8 reorg_handler installed by the following function:-]
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x000000008052b510 reorg_main+0x4ec(0x0000000106fb5800, 0x0000000000000000, 0x00000000d4804
    f78, 0x0000000106fb5800, 0x00000000d4804f80)
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000801a4654 s_execute+0x3e44(0x0000000000000153, 0x0000000000000000, 0x00000000eb0af
    f40, 0x0000000000000000, 0x0000000106855800)
    00:00000:00538:2007/04/01 13:15:28.67 kernel [Handler pc: 0x000000008057ad04 s_handle installed by the following function:-]
    00:00000:00538:2007/04/01 13:15:28.67 kernel pc: 0x00000000801f76a8 sequencer+0x11a4(0x00000000000076b8, 0x0000000000001000, 0x00000000eb0ad
    028, 0x00000000eb0acc78, 0x0000000000001800)
    00:00000:00538:2007/04/01 13:15:28.67 kernel end of stack trace, spid 538, kpid 518193837, suid 1

    ------------------------------------------------------
    second stack trace...
    ------------------------------------------------------

    00:00000:00730:2007/04/01 13:15:34.40 server Error: 614, Severity: 21, State: 7
    00:00000:00730:2007/04/01 13:15:34.40 server Adaptive Server accessed a row that has an illegal length of 0 while in data base 'dbccdb'. Pag
    e pointer = 0x7064dd000, pageno = 90168, status = 0x81, objectid = 1632005814, indexid = 0, level = 0. The minimum row length is 7. The page
    size is 4096.
    00:00000:00730:2007/04/01 13:15:34.40 kernel ************************************
    00:00000:00730:2007/04/01 13:15:34.40 kernel SQL causing error : use dbccdb setuser "dbo" update statistics text_dbccdb
    00:00000:00730:2007/04/01 13:15:34.40 kernel ************************************
    00:00000:00730:2007/04/01 13:15:34.40 server SQL Text: use dbccdb setuser "dbo" update statistics text_dbccdb
    00:00000:00730:2007/04/01 13:15:34.40 kernel curdb = 31515 tempdb = 2 pstat = 0x10000
    00:00000:00730:2007/04/01 13:15:34.40 kernel lasterror = 614 preverror = 0 transtate = 1
    00:00000:00730:2007/04/01 13:15:34.40 kernel curcmd = 326 program = update_stats.pl
    00:00000:00730:2007/04/01 13:15:34.40 kernel pc: 0x00000000809153a4 pcstkwalk+0x28(0x00000000d4dd32a8, 0x00000000d4dd2a20, 0x000000000000270
    f, 0x0000000000000002, 0x0000000000000000)
    00:00000:00730:2007/04/01 13:15:34.40 kernel pc: 0x000000008091528c ucstkgentrace+0x1c8(0x000000000000270f, 0x000000001eef02bd, 0x0000000000
    000000, 0x00000000f2055210, 0x00000000ebfe3fc0)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000808b57bc ucbacktrace+0xb0(0x0000000000000000, 0x0000000000000001, 0x0000000000000
    01e, 0x00000000ebff817c, 0x00000000c17ce000)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x000000008022ebdc terminate_process+0x10b8(0x00000000ebfe3fc0, 0xffffffffffffffff, 0x00000
    000ebfebb18, 0x000000008028cf08, 0x00000000ebfeb920)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x000000008028cf1c hdl_default+0x58(0x0000000000000006, 0x000000000000000e, 0x0000000000000
    015, 0x0000000000000007, 0x00000000d4dd37e0)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x000000008028c8ec ex_raise+0x1d8(0x0000000000000015, 0x0000000000000007, 0x00000000ebfebb1
    8, 0x0000000000000000, 0x00000000ebfeb920)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000802b67a4 rowsize+0x16c(0x00000000ebfeec68, 0x0000000000000000, 0x0000000000000007
    , 0x0000000000000002, 0x00000000ebfe3fc0)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000806256f0 subst_rcopy+0x60(0x00000000ebfeec68, 0x0000000000000000, 0x0000000000040
    000, 0x0000000000001000, 0x00000000fffbfc00)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000801da5f8 getnext+0xe4(0x00000000ebfeec68, 0x0000000000009c00, 0x00000000817b9000,
    0x0000000081797800, 0x0000000000000007)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000805fb248 ups_deadlock_getnext+0xc(0x00000000ebfeec68, 0x00000000d4dd4228, 0x00000
    00000016038, 0x0000000000000002, 0x00000007005f0df0)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000805fca60 ups_calctabdata+0xc8(0x00000000ebfeec68, 0x00000000d4dd4208, 0x00000000d
    4dd4228, 0x00000000f38589d0, 0x0000000000000000)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000805f9494 update_statistics+0xf4(0x00000000f385c850, 0x00000000d4dd4220, 0x0000000
    000000000, 0x000000000000000b, 0x000000010e234908)
    00:00000:00730:2007/04/01 13:15:34.41 kernel [Handler pc: 0x00000000804fd5a8 ut_handle installed by the following function:-]
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000805f8974 ups_main+0x33c(0x000000010e234800, 0x0000000000000146, 0x00000000d4dd517
    8, 0x000000010e234800, 0x00000000d4dd5180)
    00:00000:00730:2007/04/01 13:15:34.41 kernel pc: 0x00000000801a4668 s_execute+0x3e58(0x0000000000000146, 0x0000000000000000, 0x00000000ebfee
    940, 0x0000000000000000, 0x0000000111553800)
    00:00000:00730:2007/04/01 13:15:34.41 kernel end of stack trace, spid 730, kpid 518980285, suid 1

  2. #2
    Join Date
    Mar 2007
    Posts
    167

    Found this URL... What are your thoughts? Is this related?

    http://download.sybase.pl/ebf_maint/...2_20050315.txt

    It notes the following....

    List of Fixes for EBF 12452
    ---------------------------

    Following is a list of fixes which are cumulative to this release. Each
    fix is listed along with the EBF in which it was first released and the
    description of the problem. The list is sorted by the EBFID column.

    The list of fixes represent changes included after the 12.0 ASE Release.
    For product changes up to 12.0, please refer to the CPR and SPR files
    included in the /install/SPR directory in the 12.0 release directory.

    EBFID BugID Description
    ----- ------ -------------------------------------------------

    12452 351074 A 614 error, "Adaptive Server accessed a row that
    has an illegal length of <length> while in
    database <dbname> ... The page size is
    <pagesize>." may be reported when a transaction
    doing DELETE and UPDATE operations on a Data Only
    Locked table is rolled back. The session is
    terminated abnormally and may not have its
    resources cleaned up.

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You might have real corruption. See writeup for Error 614
    http://infocenter.sybase.com/help/in.../svrtsg193.htm

    Also see How to Find an Object Name from a Page Number
    http://infocenter.sybase.com/help/in...tsg/X36585.htm

Posting Permissions

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