Kbase 18826: Microsoft Cluster Service Assumes The DB Server Not Started PCCMD
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
PCCMD is being used to start database
Microsoft Cluster Services is being used for fail safe switch over in the event database server crashes.
Microsoft Cluster Services runs into some problems when PCCMD is used to start their databases. The Microsoft Cluster Service assumes that the database server has not started.
CAUSE:
It appears that the way Micosoft Cluster Services determines a crash is by checking to see if the process that started the database still exists. If the process does not exist, then it will attempt to restart it three times, and if still not active then it will fail over to the next system. ProControl does show the database as active.
FIX:
When a database has been autostarted via ProControl, Microsoft Cluster Services will correctly see the database server as running and only switch over to another system when the database has truly crashed. This works because the service name will not match the Microsoft standard naming convention of matching the display name with the service name.