public inbox for [email protected]  

help / color / mirror / Atom feed

From: trn nrjn <[email protected]>
To: [email protected]
Subject: PREPARE TRANSACTION for specific transaction branch/session
Date: Fri, 21 Jan 2022 17:19:17 +0530
Message-ID: <CAP7o3-jnm-QpCsOOPpcQTM7+r9YCNh9odFPk-N2GkMGEm1=UyA@mail.gmail.com> (raw)

Hi,
Could you kindly assist with the below two queries?

1) From the below Postgres logs, we would like to know whether there is a
way by which we could make Postgres to attach or execute the 'prepare
transaction <gtxnid>' calls invoked from a transaction manager’s
xa_prepare(), to the process or session that started the transaction i.e.
attach it to the session within the 'xa_start()' and 'xa_end()' calls below?



xa_start()

2022-01-18 17:48:26.067 UTC [21798] STATEMENT:  BEGIN

2022-01-18 17:48:26.076 UTC [21798] LOG:  statement: SELECT COUNT(*) FROM
table_1

2022-01-18 17:48:26.086 UTC [21798] LOG:  statement: SELECT COUNT(*) FROM
table_2

2022-01-18 17:48:26.096 UTC [21798] LOG:  statement: update table_3 set
col1 = 'test1' where col2 = 123

xa_end()



xa_prepare()

2022-01-18 17:48:26.108 UTC [21797] DEBUG:  StartTransaction(1) name:
unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0

2022-01-18 17:48:26.108 UTC [21797] STATEMENT:  PREPARE TRANSACTION
'transaction_name_1'

2022-01-18 17:48:26.108 UTC [21797] LOG:  statement: PREPARE TRANSACTION
'transaction_name_1'

2022-01-18 17:48:26.108 UTC [21797] WARNING:  there is no transaction in
progress

2022-01-18 17:48:26.108 UTC [21797] STATEMENT:  PREPARE TRANSACTION
'transaction_name_1'

2022-01-18 17:48:26.108 UTC [21797] DEBUG:  CommitTransaction(1) name:
unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0

2022-01-18 17:48:26.108 UTC [21797] STATEMENT:  PREPARE TRANSACTION
'transaction_name_1'



2) We would also like to know whether PostgreSQL can participate as XA
resource manager with Tuxedo as Transaction Manager?



Thank you.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: PREPARE TRANSACTION for specific transaction branch/session
  In-Reply-To: <CAP7o3-jnm-QpCsOOPpcQTM7+r9YCNh9odFPk-N2GkMGEm1=UyA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox