-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Tables Topic   Print This     

locking and table corruption problems

locking and table corruption problems in Paradox Tables topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: locking   corruption   problems   locking table   locking table corruption  
biondean
-- UNK

I have Paradox 8 and BDE patch 5.1.1

My problem is that two or more different users from differt PC can acces to same record and modify it wihtout any lock. Almost always this corrupts indexes and headers requiring a rebuild.

Now we can work only one at time....and it is almast tragedy in office....

Same .net directory path for all users.

Local share true or false seems not affect even since we all use only paradox.

Looking in directory I noted that .lck file are not creatred anymore. Oldest one is few months ago. I'm not sure this can affect but this could be the reason. I excpected to find in same directory where tables are.....and expected paradox to give an error message if there is not .lck file or could not create it.

Please help since company is "down" !

Thanks,
Dean

Reply With Quote

 Posted 17 years ago (Thread Starter)
Comment Quote
About biondean
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13799, 2 replies
Thread Started 12/4/2009 1:39:13 AM
View Counter=3049
Last Reply Posted 12/5/2009 1:15:08 AM)
Location=-- UNK 
Joined=17 years ago   MB Posts=2  
AIBreveleri

You say, "Same .net directory path for all users."   Did you check it with the BDE admin utility?

Are you sure the users' Paradoxes are using the correct configuration file?

Do you get an error when you start the user's Paradox?

The network lock file may be corrupted.  Go to the .net directory and delete the file "PDOXUSRS.NET".  (The first Paradox to start will re-create this file.)

-Al.

 Posted 17 years ago
Comment Quote
About AIBreveleri
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13801 (Level 1.1)  Reply to 13799
Thread Started 12/4/2009 2:00:51 PM
Location= 
Joined=25 years ago   MB Posts=286   KB Comments=8  
Most Recent Post
biondean
-- UNK

Thanks for answer Al.

The updated my situation is following :

- I reinstalled paradox and BDE 5.11 

- form BDE tool i confirm that all .net are the same even the case

- i deletetd all .net and .lck files

- local share is set to true

- i managed to disable oplocks on all pc-s

- imanaged to disable write caching on pc without raid controller

- i'm not able to remove write caching on server (i think  most important) that has raid controller NVIDIA ....if you know some hints i would appraciate a lot

After this things goes better but not complteley ok. 

- paradox creates again lck files and locks records

- there is not refresh for changes made from another user unless you close or F5 lock again record

- in few hours no more corruption but only two users ...on monday more relevant test

So if you have ideas or know how to remove wrtie caching with raid thanks a lot,

Dean

 Posted 17 years ago (Thread Starter)
Comment Quote
About biondean
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13802 (Level 1.2)  Reply to 13799
Reply Posted 12/5/2009 12:47:08 AM
Location=-- UNK 
Joined=17 years ago   MB Posts=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1141A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #13799 Counter
3049
Since 12/4/2009
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]