Solved

"Out of locks" not shown in errorlog

Posted on 2004-03-29
2
5,820 Views
Last Modified: 2007-12-19
Hi all....

I'm working on Sybase 11.9.2.4 on HP-UX.
Now we've had this situation where, in an applicationlog an error 'Out of locks' is shown but when I look in the Sybase-errorlog I do not see this message...

In my understanding the errormessage, with severity 17, should be presented in the errorlog.

Can anyone think of a reason why it isn't?

Here's a few copies from the logs.
The names have changed to protect the innocent :) The message 'disconnection failed' is from an errorfunction in the application which disconnects all connections from that application. The application itself is a serverprocess.

First the applicationlog:

26/03/04 15:09:12: (cv_sqlprt.c:720) sql failed :select <columns> from <tablename>
26/03/04 15:09:12: Error: failed to process 13, <procedurename>
26/03/04 15:09:12: Disconnection failed: Server message:
      number(5701) severity(10) state(2) line(1)
      Changed database context to 'db_namel'.

Server message:
      number(1204) severity(17) state(2) line(1)
      SQL Server has run out of LOCKS.  Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.

Client Library error:
      severity(0) number(49) origin(1) layer(1)
      ct_close(): user api layer: external error: This routine cannot be called because another command structure has results pending.
(cv_sbs.c:676) ct_close failed
<next messsage>

Then the Sybase errorlog:

01:00000:00034:2004/03/26 15:08:11.97 kernel  Cannot send, host process disconnected:  00002dac spid: 34
01:00000:00034:2004/03/26 15:08:11.97 server  Error: 1608, Severity: 18, State: 3
01:00000:00034:2004/03/26 15:08:11.97 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00186:2004/03/26 15:09:27.59 kernel  Cannot send, host process disconnected:  00002104 spid: 186
01:00000:00186:2004/03/26 15:09:27.59 server  Error: 1608, Severity: 18, State: 3
01:00000:00186:2004/03/26 15:09:27.59 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

You can see at the times that the 1204 message is not in the errolog.
0
Comment
Question by:ahoor
2 Comments
 
LVL 10

Accepted Solution

by:
bret earned 250 total points
ID: 10704515
In general, errors that affect only the client process are reported only to the client.  You do sometimes see "out of locks" errors in the errorlog, but it is for cases where the situation was encountered by a system process.

If you would like to have this message reported in the log, you can use the sp_altermessage procedure to add the "with_log" attribute.
0
 
LVL 3

Author Comment

by:ahoor
ID: 11180420
Ok, I suppose so.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sybase license issue 6 517
Sybase memory in corresponds to sybase pagesize 4 1,304
Sybase SQL Syntax 2 275
Sybase conversion 2 63
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
Knowledge base software has turned out to be a quite reliable method for storing information, promoting collaborative work and for sharing valuable input and solutions.However, some organizations are trying to develop a knowledge base that works wit…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now