Solved

Record Lock Threshold exceeded total violation 656

Posted on 1998-11-10
8
290 Views
Last Modified: 2008-02-01
Hi, I'm currently running an foxpro application in novell 3.12 version.  While run a particular option in the application I would get an error message from the application. "Record in used by another".  I then checked the console of the novell server and got the above "error message"  Pls help ...
0
Comment
Question by:salconen
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 12

Expert Comment

by:mark2150
ID: 1594068
Your foxpro app is in runaway mode. It's recursively locking records in database until the lock manager gets wound around the peg. Check your code and make sure that you're releasing the locks prior to asserting a new one.

M

0
 

Author Comment

by:salconen
ID: 1594069
Yes I did release it before getting new ones.  Would it be the network sides ??
0
 
LVL 1

Expert Comment

by:michelandre
ID: 1594070
At what time???
Is there backups being done?
Is there a  batch file waiting to be process then executed at night???
I think the max for locked is 10,000 locks.
0
 
LVL 12

Expert Comment

by:mark2150
ID: 1594071
You've got to have a logical error somewhere. If you monitor the task from RCONSOLE/MONITOR I think you'll see it locking and locking and locking...

Sometimes you need to wait a bit tween lock release and new requests. Give the server time to digest. Try setting TRUE COMMIT ON in the NET.CFG file. This will prevent the server from pre-acknowledging writes until the disk has really written them.

M

0
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.

 

Accepted Solution

by:
jsyring earned 10 total points
ID: 1594072
Here are the SET-parameters you need to modify:

     (the default values are for NW4.11)
     Maximum Record Locks Per Connection (default: 500, range 10 - 100000)
     Maximum File Locks Per Connection (default :250, range 10 - 1000)
     Maximum Record Locks (default :20000, range 100 - 400000)
     Maximum File Locks (default: 10000, range 100-100000)

     A rule of thumb is to double the parameters and monitor if the problem persists.

0
 

Author Comment

by:salconen
ID: 1594073
Hi jsyring got your setting, where do I have to set it and what is the syntax to set them...  Pls reply as soon as possible

Thanks
0
 

Expert Comment

by:jsyring
ID: 1594074
Salconen

All of the settings can be set in the startup.ncf file and the syntax to set them is as follows

Set Maximum Record Locks Per Connection 1000
Set Maximum File Locks Per Connection 500

I have doubled the default in each setting and would then monitor the problem. You can then set the paramaters higher if you need to. Each of these setting may effect performance so I would not go any higher thean you need to.
0
 

Author Comment

by:salconen
ID: 1594075
yeah... you're right.   but the lines need to entered in the autoexec.ncf
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
Groupwise Web Access 4 847
Restoring old tapes - Arcserve for Netware 11 1,996
Corrupt CA on Novell OES2 SLES10 3 157
Xenapp 7.6 integration with Novell OES 11 sp2 4 110
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
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 …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

21 Experts available now in Live!

Get 1:1 Help Now