| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Dbcc checkcatalog error 2513
Hi,
I have the following error in a server log with Sybase installed: 03:00000:00016:2009/05/16 00:55:20.49 kernel SQL causing error : dbcc checkcatalog 03:00000:00016:2009/05/16 00:55:20.49 kernel lasterror = 2513 preverror = 0 transtate = 1 I found that this error occurs when dbcc checkcatalog finds that an object exists in one system table but not in another system table where Adaptive Server expected to find it. I tried to run dbcc checkcatalog directly to get more information but I got the following error: 1> dbcc checkcatalog(my_db) 2> go The SQL Server is terminating this process. 1> dbcc checkcatalog(my_db) 2> go CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read. CT-LIBRARY error: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect And in the same log as the first one, I found the following: 02:00000:01009:2009/07/01 01:31:58.11 kernel ************************************ 02:00000:01009:2009/07/01 01:31:58.11 server SQL Text: dbcc checkcatalog(my_db) 02:00000:01009:2009/07/01 01:31:58.11 kernel curdb = 4 tempdb = 2 pstat = 0x10000 02:00000:01009:2009/07/01 01:31:58.11 kernel lasterror = 2513 preverror = 0 transtate = 1 02:00000:01009:2009/07/01 01:31:58.11 kernel curcmd = 317 program = isql 02:00000:01009:2009/07/01 01:31:58.11 kernel pc: 0x00000000808c4554 pcstkwalk+0x28(0x0000000205cc19a8, 0x0000000205cc1120, 0x000000000000270f, 0x0000000000000002, 0x0000000000000000) 02:00000:01009:2009/07/01 01:31:58.11 kernel pc: 0x00000000808c443c ucstkgentrace+0x1c8(0x000000000000270f, 0x0000000054ad02be, 0x0000000000000000, 0x00000002177615e0, 0x0000000215c279c8) 02:00000:01009:2009/07/01 01:31:58.11 kernel pc: 0x0000000080870a9c ucbacktrace+0xb0(0x0000000000000000, 0x0000000000000001, 0x000000000000001e, 0x0000000215c3badc, 0x0000000200000000) 02:00000:01009:2009/07/01 01:31:58.11 kernel pc: 0x000000008024b6ec terminate_process+0xfb0(0x00000000810e4400, 0xffffffffffffffff, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000) 02:00000:01009:2009/07/01 01:31:58.11 kernel pc: 0x000000008088ea8c kisignal+0x1c4(0x0000000081758a00, 0x000000000001ac00, 0x0000000205cc24f0, 0x00000000818d5800, 0x0000000081844000) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0xffffffff7f018478 __sighndlr+0xc(0x000000000000000b, 0x0000000205cc27d0, 0x0000000205cc24f0, 0x000000008088e8c8, 0x0000000000000000) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0xffffffff7f012074 call_user_handler+0x25c(0xffffffff7d100000, 0x0000000205cc27d0, 0x0000000205cc24f0, 0x0000000000000000, 0x0000000000000000) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0xffffffff7f012238 sigacthandler+0x68(0x000000000000000b, 0x0000000205cc27d0, 0x0000000205cc24f0, 0x0000000000000004, 0x0000000000000001) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x0000000080734560 ind_obj_seg_check+0x144(0x0000000000000003, 0x000000000000000b, 0x0000000215c285e0, 0x0000000000000000, 0x0000000215c295b8) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x0000000080733cc0 catcheck+0x6f4(0x0000000000000000, 0x0000000000000006, 0x00000000810e4400, 0x0000000000000000, 0x0000000000000000) 02:00000:01009:2009/07/01 01:31:58.14 kernel [Handler pc: 0x00000000802a439c hdl_backout_msg installed by the following function:-] 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x000000008070b130 exec_dbcc+0x4fc(0x000000022861e800, 0x0000000000000000, 0x0000000205cc3a00, 0x000000022861e8f8, 0x0000000205cc3a08) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x00000000801c4de4 s_execute+0x3eb0(0x0000000080000000, 0x0000000081176188, 0x0000000000000001, 0x0000000000007400, 0x0000000215c2f093) 02:00000:01009:2009/07/01 01:31:58.14 kernel [Handler pc: 0x000000008056d6d4 s_handle installed by the following function:-] 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x0000000080215b68 sequencer+0x11a8(0x00000000000076b8, 0x0000000000001000, 0x0000000215c2f418, 0x0000000215c2f080, 0x0000000000001800) 02:00000:01009:2009/07/01 01:31:58.14 kernel pc: 0x000000008027e674 tdsrecv_language+0xcc(0x0000000000000000, 0x0000000000000001, 0x0000000215c279c8, 0x0000000000000021, 0x0000000215c31708) 02:00000:01009:2009/07/01 01:31:58.14 kernel end of stack trace, spid 1009, kpid 1420624574, suid 1 Does someone have a hint why it can be happening? Hope you can help me. Thanks in advance. BR, Luis. |
![]() |
| Viewing: Tutorialized Forums > Databases > Sybase > Dbcc checkcatalog error 2513 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|