Kbase P96644: Failure to acquire share schema lock during Connect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/10/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Using ODBC or JDBC SQL-92 Client
Connecting to Progress Database returns the error:
Failure to acquire share schema lock during Connect
Error occurs with any Transaction Isolation Level
CAUSE:
A concurrent user is currently locking Progress Database Schema
FIX:
This behavior can occur if a user is attempting to connect to the Database while a concurrent user is updating the Progress Database Schema.
Example, if one user is creating / updating or deleting Table without committing the Transaction, the entire Schema will be locked, therefore, any newly connection will be refused, and the error above is returned.
To fix the issue, the user who is updating the Schema should commit his Transaction before a newly user will be able to connect to the Database again.