Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAsQB-0007KM-50 for pgsql-interfaces@arkaria.postgresql.org; Fri, 21 Jan 2022 11:49:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAsQ9-0006kK-WA for pgsql-interfaces@arkaria.postgresql.org; Fri, 21 Jan 2022 11:49:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAsQ9-0006kA-Ln for pgsql-interfaces@lists.postgresql.org; Fri, 21 Jan 2022 11:49:33 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nAsQ7-0000gf-O5 for pgsql-interfaces@lists.postgresql.org; Fri, 21 Jan 2022 11:49:33 +0000 Received: by mail-oi1-x22c.google.com with SMTP id w188so13092285oiw.13 for ; Fri, 21 Jan 2022 03:49:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=08Nnts6iLdKZPSTE1n5+hqrAvh1YzSfQ6SrD+kgjaME=; b=SNOcGEt1ZGsVuu6cJMLjDFg9HVg1+CtDM52isJvDfOSXer+l7DJ+Ha9d8A4cHXzSyt deqn75vwnx9s60viVerEIkjixW1xR5i0lYgqX6nqE4ZJAtQokzbJKP5utIQQa77Cwh1M A320MivyMH43zl91R65bkDy4n9ZIGSNZ0lY+uUUWmVhQuRm3NiF8ykWPKCGI0nQMazA3 rltFEYeg/fYu7FuzwGu7xWc2a7C4spJneusRMJy2W606w5ruvFopaCOBcBXM9N7DO2J0 YakwdFy3LyLexveWC05DsYXCScD+S0RbonvUw+RsR92JnyEMav4tRAKsSOrcmwFGc9tq AK8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=08Nnts6iLdKZPSTE1n5+hqrAvh1YzSfQ6SrD+kgjaME=; b=aL9ALf1b26YkOsnSi2k6taBlQG108CzBipjRDi4G86QUnCSWJg3RO3cnsmVHvHsa8f iNBN78mFhw9aR4sIinwY3YDxJ56qhjdSW1OGaqRmvVS5Fu4szQ8B5OZsm/cNFJK063Zm AYJHxHCKn0NM41kz50GUswj02DhRLLlniVTwIwi2qe63OfqnAwEnx6xDaWos8Tuo7wKV wuT0EpsvFbN/JV+QCTc7qHBEXO3lHM894snnI/Z69o5bCgL2woAv6mM4BDQCaqkbuHm7 7e1u/trnqKMUK+3XiaM0Ttph4ZFIj/Psh7Ola+DbYmGiZmFc72iWP9KEvlxvpC+mjtxV TkXA== X-Gm-Message-State: AOAM530BtMSB+fIRXfntzgFPoBYLGUskbCO3XtCaqShJrKSHmv2bReM7 /f/nCi6+HYeJFDHtPYnzjBsRnn4f9LFmlEO61UhW2RiS X-Google-Smtp-Source: ABdhPJxK7QTAttYj/l9s/zC8l11255Snxf/L1dHINnVNjrYcyfRtE+b3jp6Sf66vi4EG9Qk3UOa2lsgcQeH/b3uCLuA= X-Received: by 2002:a05:6808:1148:: with SMTP id u8mr244160oiu.19.1642765768718; Fri, 21 Jan 2022 03:49:28 -0800 (PST) MIME-Version: 1.0 From: trn nrjn Date: Fri, 21 Jan 2022 17:19:17 +0530 Message-ID: Subject: PREPARE TRANSACTION for specific transaction branch/session To: pgsql-interfaces@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000017fe0505d6163636" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000017fe0505d6163636 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 ' calls invoked from a transaction manager=E2=80=99s 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 =3D 'test1' where col2 =3D 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. --00000000000017fe0505d6163636 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

Could you kindly assist with the below two queries?=C2=A0<= br>

1) From the below Post= gres logs, we would like to know whether there is a way by which we could m= ake Postgres to attach or execute the 'prepare transaction <gtxnid&g= t;' calls invoked from a transaction manager=E2=80=99s 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?=

=C2=A0

xa_start()<= /u>

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

2022-01-18 17:48:2= 6.076 UTC [21798] LOG:=C2=A0 statement: SELECT COUNT(*) FROM table_1

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

=

2022-01-18 17:48:26.096 UTC [21798] LO= G:=C2=A0 statement: update table_3 set col1 =3D 'test1' where col2 = =3D 123

xa_end()

=C2=A0

xa_prepare()<= u style=3D"border-color:rgb(49,49,49)">

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

2022-01-18 17:48:2= 6.108 UTC [21797] STATEMENT:=C2=A0 PREPARE TRANSACTION 'transaction_nam= e_1'

2022-01-18 17= :48:26.108 UTC [21797] LOG:=C2=A0 statement: PREPARE TRANSACTION 'trans= action_name_1'

202= 2-01-18 17:48:26.108 UTC [21797] WARNING:=C2=A0 there is no transaction in = progress

2022-01-18 17= :48:26.108 UTC [21797] STATEMENT:=C2=A0 PREPARE TRANSACTION 'transactio= n_name_1'

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

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

= =C2=A0

2) We would also like to know whether PostgreS= QL can participate as XA resource manager with Tuxedo as Transaction Manage= r?

=C2=A0

Thank you.

--00000000000017fe0505d6163636--