Stack Overflow
Stack Overflow

Questions tagged [2phase-commit]

algorithm that coordinates all the processes that participate in a distributed transaction on whether to commit or rollback the transaction

70 questions
1
vote
0 answers

Atomikos - Working with two databases and single repository

I'm playing around with Atomikos. Using this as a starting point: https://www.fabiomaffioletti.me/blog/2014/04/15/distributed-transactions-multiple-databases-spring-boot-spring-data-jpa-atomikos/ In my use case, I'm going to have essentially two…
Haris Hajdarevic
  • 1,535
  • 2
  • 25
  • 39
1
vote
0 answers

2 phase commit data consistency when one node crashes or is slow during commit phase

In 2 phase commit, lets say one of the nodes crashes or is slow during the commit phase and the other nodes have already successfully committed their changes. Now if a query is issued to one of those successful nodes, what will be its data…
jittrfunc
  • 103
  • 6
1
vote
0 answers

How to perform an async distributed transaction among multiple SQL Server instances

In the .NET ,where we have the flexibility to call multiple services at the same time with Task parallels concept. Considering a scenario where I have three different tasks , each task call different services. For Example, Task 1 service - post…
swap_Pg
  • 11
  • 2
1
vote
1 answer

Atomikos with Spring Boot gives atomikos.icatch.SysException: No Assembler Service found - please make sure that the right jars are in your class path

I am trying to use Atomikos with Spring Boot to try a distributed transaction across two databases. I have followed the documentation but no matter what I do I get the error below: com.atomikos.icatch.SysException: No Assembler Service found -…
shrap7
  • 79
  • 1
  • 5
1
vote
1 answer

Distributed Transaction across two EJB server

I was reading an article about 2-PC and distributed transaction in EJB server. It says: A 2-PC allows transactions to be managed across different servers and resources (e.g., databases and JMS providers). The details of a 2-PC are beyond the …
Vicky
  • 5,380
  • 18
  • 60
  • 83
1
vote
1 answer

Oracle ALTER SESSION ADVISE COMMIT?

My app to recovers automatically from failures. I test it as follows: Start app In the middle of processing, kill the application server host (shutdown -r -f) On host reboot, application server restarts (as a windows service) Application…
Synesso
  • 37,610
  • 35
  • 136
  • 207
1
vote
1 answer

Distributed transactions + Strong consistency : Feasibility?

Background: I know of quite a few large scale systems, especially in e-commerce domain where distributed transactions are used along with eventual consistency. Question: Is it possible to have a distributed transaction (over two networked resources)…
Harshit
  • 1,174
  • 1
  • 9
  • 24
1
vote
0 answers

How do 2PC prevent commit failure?

I am new to distributed transaction thing, studying how two-phase commit works across a distributed transaction in micro-services architecture. As per my understanding, in the last part of the phase the transaction coordinator asks each node whether…
PIYUSH PASARI
  • 401
  • 4
  • 6
1
vote
2 answers

Two Phase commit-How to test

We are trying to implement two phase commit on a Java/Jboss/Apache environment. However we have difficulty understanding how we can test that it actually works? are there any gui tools that can help us test it? Thanks
andreas
  • 223
  • 1
  • 2
  • 6
1
vote
2 answers

MQ - How to guarantee message delivery in a non-transacted, lightweight environment?

How to guarantee message delivery in a non-transacted, lightweight environment? For example: Normal situation: Write to database, commit, send message to ZeroMQ|Redis|OtherMQ, consumer pulls the message to continue processing... 0,05% situation:…
ethanxyz_0
  • 713
  • 12
  • 37
1
vote
1 answer

An explanation of DRBD Protocol C

What protocol does DRBD employ to guarantee that it can maintain 2 disks in sync with each other? Does it use 2-phase commits (or a variant similar to 2PC)? Does DRBD have an asynchronous/offline reconciler that is constantly checking to see if…
skittish
  • 121
  • 10
1
vote
2 answers

Why is Two-Phase Commit (2PC) blocking?

Can anyone let me know, why 2PC is blocking when coordinator fails? Is it because the cohorts don't employ timeout concept in 2PC? Good reference: Analysis and Verification of Two-Phase Commit & Three-Phase Commit Protocols, by Muhammad Atif,
KGhatak
  • 6,995
  • 1
  • 27
  • 24
1
vote
1 answer

TransactionScope with Linux

I am trying to have WebAPI 2.2 self hosted on Linux enviroment which can be done with Mono, the catch is i am using transaction scope for distributed transactions, so is it (DTC) supported on non windows platforms? also if not is there any…
Vimalshah26
  • 23
  • 6
1
vote
1 answer

Groovy, How to do 2 phase commit? Is Sql.withTransaction can manage transaction scope accross multiple databases?

Well, I think my question says it all. I need to know if Groovy SQL supports two phase commits. I'm actually programming a Grails Service where I want to define a method which does the following: Get SQL instance for Database 1, Get SQL instance for…
ask-dev
  • 606
  • 2
  • 13
  • 30
1
vote
0 answers

MQ Queue transaction not rolled back in a 2 phase transaction

I have an EJB timer (EJB 2.1) which has bean managed transaction. The timer code calls a business method which deals with 2 resources in a single transaction. One is database and other one is MQ queue server. Application server used is Websphere…
Gaurav Goel
  • 11
  • 1
1 2
3
4 5