Stack Overflow
Stack Overflow

Questions tagged [distributed-transactions]

An operational bundle which consists of multiple ACID transactions, usually on multiple servers, which must all commit or roll back. A transaction manager coordinates this through two-phase commits.

600 questions
5
votes
2 answers

Distributed transactions between MySQL and MSSQL

I've tried for nearly a week now to get distributed transactions working. I've some procedures on MSSQL which try to select data from MySQL. My need is to do this in one(!) transaction. At the time I've set up ODBC connection on MSSQL with…
rabudde
  • 7,498
  • 6
  • 53
  • 91
5
votes
2 answers

Does 2 phase locking need to keep the order of commands?

For example if we have the schedule S1 : r1[C] r2[A] r1[C] w3[B] w2[B] w1[C] commit1 r2[A] commit2 w3[B] commit3 We know that this schedule is not conflict serializable , so it cannot come from 2 phase locking, but it is view-serializable. However…
vaggelismeklis
  • 53
  • 4
5
votes
1 answer

Connection using enlist=false does not close after being manually enlisted in distributed transaction

I have a distributed transaction context using ServiceDomain. Inside it, I open an SQL connection with connection string specifying Enlist=false, so that it is not automatically enlisted in the transaction. Then, if I manually enlist the connection…
Mormegil
  • 7,955
  • 4
  • 42
  • 77
5
votes
2 answers

What is a transaction boundary?

I've read this article (assumes I already know what a transaction boundary is) and this SO question (can't decipher meaning of transaction boundary from that question). In other words, there are no clear definitions or attempts at definitions for…
Mario Ishac
  • 5,060
  • 3
  • 21
  • 52
5
votes
3 answers

Java: XA Transaction propagation within many threads

How can I use a transaction manager (such as Bitronix, JBoss TS or Atomikos) in a Java SE (not Java EE or Spring) to support the following use case: Let's assume we have the following class: public class Dao { public void updateDatabase(DB db)…
Drew
  • 1,332
  • 3
  • 15
  • 21
5
votes
1 answer

Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package it gives me error. SSIS Data flow on distributed transaction - [Execute SQL Task] Error:…
Pavvy
  • 353
  • 3
  • 6
  • 15
5
votes
2 answers

Spring cloud task's SimpleTaskConfiguration and spring batch's SimpleBatchConfiguration preventing spring boot auto configuration of XA transactions

I am trying to configure XA/distributed transactions for a spring batch / spring cloud task application configured with spring boot. I have added the following dependency hoping to rely on spring boot auto…
balteo
  • 23,602
  • 63
  • 219
  • 412
5
votes
2 answers

Why is two-phase commit considered atomic?

Two phase commit is described as an "atomic commitment protocol". I would expect this to mean that all clients see the state of the world from either before a transaction commits, or after it commits -- with no in-between state. It seems though that…
Gavin Wahl
  • 1,193
  • 8
  • 21
5
votes
3 answers

NServiceBus: Aren't MSMQ Transactions BAD?

I am learning about NServiceBus and MSMQ. I was told that transactional queues in MSMQ are BAD and using them is really bad for performance. Does anyone know why? I am guessing this comes from the notion that it uses DTC and everyone knows that…
skb
  • 30,624
  • 33
  • 94
  • 146
5
votes
1 answer

Event-sourcing and sagas - compensating transactions

First question on SO (really???), so bear with me please :) We're architecting a solution using event sourcing. Some of our business processes will be long-running, thus we're planning on using sagas to orchestrate commands to several aggregate…
tdaliviu
  • 53
  • 5
5
votes
0 answers

MSDTC attempts to enlist client machine in a distributed transaction

We're seeing the following intermittent warning logged by MSDTC: A caller has attempted to propagate a transaction to a remote system, but MSDTC network DTC access is currently disabled on machine 'X'. Please review the MS DTC configuration…
Ken
  • 76
  • 3
5
votes
1 answer

How to implement web service transactions?

Is there a Java tool for choreographing web services that makes it easy to deal with transactions? In my use case I want to chain 2 SOAP web services: the first will perform a debit into a client's bank account and the second will recharge his cell…
dmz73
  • 1,588
  • 4
  • 20
  • 32
5
votes
2 answers

SOA and distributed transactions

When do distributed transactions make sense in a service-oriented architecture?
Bermo
  • 4,921
  • 1
  • 28
  • 31
5
votes
1 answer

Two-phase commit: availability, scalability and performance issues

I have read a number of articles and got confused. Opinion 1: 2PC is very efficient, a minimal number of messages are exchanged and latency is low. Source: http://highscalability.com/paper-consensus-protocols-two-phase-commit Opinion 2: It is very…
Ivan Voroshilin
  • 5,233
  • 3
  • 32
  • 61
5
votes
0 answers

How does the MSDTC log file (MSDTC.LOG) work?

Recently I encountered an error : The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction It was mentioned in one of the replies in a forum , that one of the reasons could possibly be - The maximum…
Vandesh
  • 6,368
  • 1
  • 26
  • 38
1 2 3
…
39 40