algorithm that coordinates all the processes that participate in a distributed transaction on whether to commit or rollback the transaction
Questions tagged [2phase-commit]
70 questions
0
votes
1 answer
Narayana/2PC/XA - Unlock resources after prepare message propagation failure
Consider this scenario.
Coordinator sends prepare messages to 2 participants, and crashes
Participants lock resources successfully, and then wait for the coordinator to recover
Coordinator recovers, but did not receive messages from participants…
skittish
- 121
- 10
0
votes
1 answer
How do Narayana/XA recover from TM failures?
I was trying to reason about failure recovery actions that can be taken by systems/frameworks which guarantee synchronous data sources. I've been unable to find a clear explanation of Narayana's recovery mechanism.
Q1: Does Narayana essentially…
skittish
- 121
- 10
0
votes
1 answer
Distributed transaction agreement
Imagine we have 2 nodes that perform money transfer. Node A initiate a money transfer from one account to another and node B is responsible for completing this transaction. So to complete this transaction node A has to send some TRANSFER request to…
maks
- 5,911
- 17
- 79
- 123
0
votes
1 answer
How can I enlist an ODBC connection in an XA 2PC transaction?
Our application uses ODBC to communicate with a database (Both DB2 and Oracle, if it makes a difference), and delegates business logic to Java by way of JNI (So it uses Java and C).
What I'd like to know is what tools / software / libraries are…
Chris R
- 17,546
- 23
- 105
- 172
0
votes
1 answer
Oracle DML with 2 phase commit not materialized
Today I was hit by a successful 2pc that wasn't materialized in Oracle. The other participant was MSMQ which materialized fine.
The problem is that I did not get an Exception in the application (using c# odp.net). Later I found the In-Doubt…
Stig
- 1,974
- 2
- 23
- 50
0
votes
1 answer
2 Phase Commit Global Transaction Status after 2nd Phase failure
My question is this:
Say I have a Transaction Manager and 2 Resource Managers.
TM tells RMs to prepare.
RMs acknowledge they are prepared/vote yes.
TM tells RMs to commit.
RM 1 commits and acknowledges commit.
RM 2 never gets the commit message…
MattG
- 103
- 2
- 5
0
votes
2 answers
2 Phase commit in tomcat using JPA
I have an application deployed in Tomcat with backend oracle and JPA as persistence manager. Now we are introducing an intermediate database (most probably SolidDB or TimesTen) which will bring an additional requirement of 2 phase commit. Since…
Kailas J C
- 139
- 3
- 8
0
votes
1 answer
weblogic ejb3 two-phase commit
can anyone point me to a good two-phase commit on weblogic with ejb3 tutorial?
I've looked around and found only one, but it doesnt use XA.
Coelhone
- 310
- 1
- 11
-1
votes
1 answer
Stored Procedure and REST API call as a transaction
Imagen that you have a stored procedure in a database that you call from PHP. That procedure works like a transaction and selects/inserts data into the database. If it succeeds it commits, if it fails it rollbacks.
Now imagen that you need to store…
odjuret
- 19
- 2
-1
votes
1 answer
Spring boot+ 2 phaase commit+ atomikos is not starting
Error Log pasted below:
[http-nio-8080-exec-1] ERROR c.r.r.c.e.CustomRestExceptionHandler - Exception Occured org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.AbstractMethodError:…
Shivam
- 1
- 1