Kbase P76165: Error 121 received when the records are locked by -RO user
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/13/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 121 received when the records are locked by -RO user
<file-name> in use by <user> on <tty>. Wait or press <STOP> to stop. (121)
-RO connection with client server (-H -S -N -RO) in one session and exclusively lock the table
Error received from another session when the -RO session locks the table
No errors if the first session is a -RO with shared memory connection
No errors if running in 9.1C
CAUSE:
Even there is difference in behavior between -RO client server and -RO shared memory, the -RO connection running against server is never supported. Progress manual states:
Use Read-only (-RO) to open a database for read-only access. Use -RO to access a
database stored on read-only media (a read-only optical disk, for example).
NOTE: Do not run servers for a read-only database. Progress does not support
servers for read-only users.
FIX:
Never run -RO against server.