Kbase P53424: sql update query locked database records when it terminated
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2003 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Ran sql-89 query against database on UNIX server
Query updated records and therefore held exclusive locks
4GL users unable to access database locked records.
CAUSE:
Query terminated improperly without completing, leaving records locked
FIX:
Disconnect all users, bring down database server and restart it.