Kbase P7867: 2 phase commit error 2038
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/01/2003 |
|
Status: Unverified
SYMPTOM(s):
What does 2 phase commit error 2038 mean?
CAUSE:
Connection to one of the servers in the configuration has been lost.
FIX:
The error message "2 phase commit error 2038 - limbo transaction" is an
informational message that one of the two servers where you have databases
running had gone down and that the databases are now out of sync. You must take
action to resolve the limbo transactions to put the databases back in sync.
The two-phase commit process will leave "limbo" (uncommitted) transactions
around if one or more of the servers involved in the two-phase process crashes.
Two-phase commit involves transactions across multiple databases, therefore the
server can't tell whether or not to rollback the transaction in one database (it
only knows about one database) because the pending transaction might get
committed in the other database, making them out of sync. Limbo transactions can
either be resolved online or offline. See chapter 10 in the V9 System
Administration Guide for a discussion of the two-phase commit process.