Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unhappy Unanswered: Help!!! sybase12.0.0.7 2622 error

    recently,I encounter 2622 Error frequently.The error message list as below:
    09:00000:00046:2004/10/07 10:42:17.32 server Error: 2622, Severity: 21, State: 4
    09:00000:00046:2004/10/07 10:42:17.32 server Insufficient room on this page to insert a row of length 173. Page pointer = 0x9c77dd8
    00, pageno = 3077488, status = 0x811, objectid = 1947778642, indexid = 0, level = 0.
    09:00000:00046:2004/10/07 10:42:17.33 kernel ************************************
    09:00000:00046:2004/10/07 10:42:17.33 kernel SQL causing error : ','%') and zldm<>'%' order by zlxh
    09:00000:00046:2004/10/07 10:42:17.33 kernel ************************************
    09:00000:00046:2004/10/07 10:42:17.33 server SQL Text: ','%') and zldm<>'%' order by zlxh
    09:00000:00046:2004/10/07 10:42:17.33 kernel curdb = 4 pstat = 0x10108 lasterror = 2622
    09:00000:00046:2004/10/07 10:42:17.33 kernel preverror = 0 transtate = 0
    09:00000:00046:2004/10/07 10:42:17.33 kernel curcmd = 195 program =
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000806e3aa0 pcstkwalk+0x20(0x000000021ef5d608, 0x000000000000270f, 0x000000
    0000000000, 0x0000000000000002, 0xfffffffffffffff8)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000806e3998 ucstkgentrace+0x190(0x00000000592804a0, 0x0000000233b03a98, 0x0
    00000000000270f, 0x0000000000000000, 0x0000000233b03a98)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000806adbb8 ucbacktrace+0xb0(0x00000000592804a0, 0x0000000000000001, 0x0000
    00022cd6a710, 0x0000000000000200, 0x0000000233b03a98)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x000000008011aff0 terminate_process+0xf58(0x0000000080e3e1d0, 0x0000000000009770,
    0x0000000000009400, 0x0000000000009770, 0x0000000233b0ad10)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x000000008016885c hdl_default+0x4c(0x000000000000001a, 0x0000000000000016, 0x0000
    000000000015, 0x0000000000000004, 0x000000021ef5dbf0)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000804084d4 s_handle+0x13b4(0x0000000233b0d0b4, 0x0000000233b0aa88, 0x00000
    00000000004, 0x0000000233b03a98, 0x000000000000001a)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x0000000080168378 ex_raise+0x1c8(0x0000000000000074, 0x0000000233b0ad10, 0x000000
    0233b0b0e8, 0x0000000000000000, 0x00000000000000ad)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000802c7bb8 dol_putdrow+0x7e0(0x000000036175fe60, 0x0000000000000002, 0x000
    0000000000010, 0x0000000000000000, 0x0000000233b03a98)
    09:00000:00046:2004/10/07 10:42:17.33 kernel pc: 0x00000000802c6cc8 dol_data_insert+0x228(0x0000000000000000, 0x0000000000000010, 0
    x00000009f7adb318, 0x0000000000000000, 0x0000000000000001)
    09:00000:00046:2004/10/07 10:42:17.37 kernel pc: 0x00000000802c67cc dol_insert+0x12c(0x000000022fb973a0, 0x0000000000008000, 0x0000
    0000000000ad, 0x0000000000020000, 0x000000022fb973a0)
    09:00000:00046:2004/10/07 10:42:17.37 kernel pc: 0x00000000802dd4fc insert+0xe4(0x0000000000000003, 0x0000000000002000, 0x000000000
    00000ad, 0x000000022fb973a0, 0x000000036175fe60)
    09:00000:00046:2004/10/07 10:42:17.37 kernel pc: 0x00000000802dd3cc insert_all+0xac(0x000000036175fe60, 0x00000002e0737800, 0x00000
    0022fb973a0, 0x000000036175fe60, 0x00000000000000ad)
    09:00000:00046:2004/10/07 10:42:17.37 kernel pc: 0x00000000804e2048
    after execute DBCC ,I find the table has corrupt(data page and index page all have corrupt).
    Can anyone tell me what's happened?How to deal with?Thanks.By the way,my OS is SUN OS 5.8 ,the user table lock is datarows

  2. #2
    Join Date
    Jan 2003
    Location
    France - Nancy
    Posts
    26
    Have you make a "reorg rebuild" of this table ?

Posting Permissions

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