Hi all
I seem to be beating my head against a wall with what appears to be a simple locking problem.
We have an old character system running on Progress 8.3D clients on Windows NT workstation. The code originates way back from Progress V6 (No internal procedures, 63k limit, no 'counters'), and pulls a sequential counter from a database table called 'spf' as a unique ID for a high volume history table called 'tranfile'.
We seem to have the situation where occasionally two clients lock each other out on 'spf' getting the counter (Call them 'a' and 'b'). Computer 'a' says computer 'b' is locking it out of 'spf', whilst computer 'b' says computer 'a' is locking it out of 'spf'. Surely only one of them can have the lock, and already has the lock? So why do they both think the other has?
Once PC's 'a' and 'b' get caught in their deadly embrace, the whole lot grinds to a halt as every other computer on the network waits for a lock on 'spf' to get the next ID.
Any suggestions you guys/gals can give deeply appreciated.
TIA
I seem to be beating my head against a wall with what appears to be a simple locking problem.
We have an old character system running on Progress 8.3D clients on Windows NT workstation. The code originates way back from Progress V6 (No internal procedures, 63k limit, no 'counters'), and pulls a sequential counter from a database table called 'spf' as a unique ID for a high volume history table called 'tranfile'.
We seem to have the situation where occasionally two clients lock each other out on 'spf' getting the counter (Call them 'a' and 'b'). Computer 'a' says computer 'b' is locking it out of 'spf', whilst computer 'b' says computer 'a' is locking it out of 'spf'. Surely only one of them can have the lock, and already has the lock? So why do they both think the other has?
Once PC's 'a' and 'b' get caught in their deadly embrace, the whole lot grinds to a halt as every other computer on the network waits for a lock on 'spf' to get the next ID.
Any suggestions you guys/gals can give deeply appreciated.
TIA