Kbase P15765: Database shuts down when clients get disconeected.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/30/2003 |
|
Status: Unverified
SYMPTOM(s):
Database shuts down
Database shuts down when clients get disconnected.
Clients are connected through shared memory
CAUSE:
Clients connected through shared memory that get disconnect in the middle of a transaction will cause the database to shut down. The database will go through crash recovery when it is restarted. This is a normal mode of operation to protect the database integrity.
FIX:
Connect clients to the database using client/server. Start the database using the -H -S -N parameters and connect client using the same parameters. This way if a client gets disconnected only the database server may go down and not the entire database.
Investigate why the clients are getting disconnected.