Kbase P60936: User no longer appeared in the user list, but showed up as locking a record.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2005 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
User no longer appeared in the user list, but showed up as locking a record.
Clients cannot access the record the user has locked.
PID process of the User still exists on System.
A Kill signal was sent to user's pid
No client disconnection or backout transactions has been written to database log file.
CAUSE:
Issuing a 'kill' command against a user that is connected to the database is not allowed as the behavior causes the user to not be disconnected properly for the database.
The watchdog utility will not disconnect the client because the watchdog process checks on the pid of the user and the pid is still valid.
Do not kill client process, as this could cause the database to be shutdown.
FIX:
Shut the database down and restart the database to clear out the users list.
To avoid this behavior in the future use the database promon utility to disconnect a desired user.