Solved

Record Lock Threshold exceeded total violation 656

Posted on 1998-11-10
8
298 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
GroupWise attachment 9 526
Novell Netware 5.1 Server IP 3 910
Novell Question 5 477
Problem trying to load a dos netware client 6 583
If you are looking at this article, you have most likely been hit by some version of ransomware and are trying to find out if there is anything you can do, or what way you should react - READ ON!
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

808 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