Sybase
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Tutorialized ForumsDatabasesSybase

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old July 1st, 2009, 03:49 AM
lulon_83 lulon_83 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Posts: 2 lulon_83 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 38 m 54 sec
Reputation Power: 0
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.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesSybase > Dbcc checkcatalog error 2513


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.

 
Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.

 
Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.

 
Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.

 
Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2010 by Developer Shed. All rights reserved. DS Cluster 12 Hosted by Hostway
For more Enterprise Application Development news, visit eWeek