From: "Bandi, Venkataramana - Dell Team" <Venkataramana.Bandi@dellteam.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
CC: "Kishore, Nanda - Dell Team" <Nanda.Kishore@Dellteam.com>,
        "Alampalli,
 Kishore" <Kishoreravishankar.Alampalli@dellteam.com>
Subject: Query on Postgres SQL transaction
Thread-Topic: Query on Postgres SQL transaction
Thread-Index: Adp2nqC5qNFI/g9IRy6LkDeqRdh1pg==
Date: Fri, 15 Mar 2024 06:04:51 +0000
Message-ID: 
 <PH7PR19MB6876D9AB33CFF7160C4097D295282@PH7PR19MB6876.namprd19.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
 MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_ActionId=2d57fd5b-7993-4e41-bfa8-e2fdf98e9515;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_ContentBits=0;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_Enabled=true;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_Method=Standard;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_Name=No
 Protection (Label Only) - Internal
 Use;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_SetDate=2024-03-15T06:03:36Z;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_SiteId=945c199a-83a2-4e80-9f8c-5a91be5752dd;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: PH7PR19MB6876:EE_|SA3PR19MB8011:EE_
x-ms-office365-filtering-correlation-id: 589d2c83-2b4d-41ee-7722-08dc44b5d3f6
x-exotenant: 2khUwGVqB6N9v58KS13ncyUmMJd8q4
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 5LQEu8GT46Sg9215p80Ui9VuWPHiiCln9hLW4hA1f01sdJwTHdLqRlYeRIWKBsk02DSIxEZpWcyYf1I8oLMOEJF8USZiy5c1jVmWfae8rdQwPP2Eyu9NoCnt2Ec1vcB1feQ6ZM4Tj6OIkuWr95ljLpr3IMBhNPsc6nagNwE7QA6NqbaV7nM4eA5/ZPBb0E/pQ2Ce3+X7dLspl+qnxEiEZrtoELdgAb2bxrJRZriSlNvJBIEgYxtEAiHyW7CQTqQYJSkAFe4o0w8KfBYhOL1wYQlrKvBFTG3PoCypblNFTxeThNXbfKY7mpEH9u0yfgvd/gPJvOMonjDfpEjutqeXCTExwr/wTtCQ4En97IAtebeKy5sQUH7zL+W/0ty78s00oNj1oj2Nmq+ThKpEIqjUDo7n8m+3dA1Wh913tIS3jMackJPqaPnGGQUSgHxC6I1VV+AbP+epZecBVvFpDjj+Lp8RdLZ+YWsHNJuBTbDCsRAfeyUSAG19Bz4VCLZklU0GE3xvEP+ueXl963W61X8XBABM5fGnufgnXg6peEVM0g2PyiIrIq+4jLq5GcfmRyEqdCgDDldX/2oNVJcNqCuSW7ShrCII7Nl4ybLbsDf3Ok8AD5Ea5TzwGGk4tbVBl6jooyDwDeQBLSw1OzvSrX1Aq8gjIrITKcxXQcCHsTHCV2r1lleXFtX0ZHJLTHw5jzz2hVqiIYxt7oZxcsPgHBZT+Q==
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH7PR19MB6876.namprd19.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(376005)(366007)(1800799015)(38070700009);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?m4hAUXKScjTia7bTXye8VcTS+7geJudW9f59AgiYT2TTWeFaPvDoiMV/MVjl?=
 =?us-ascii?Q?R4+0kXXgqC5kz5//Kf/P54R2OzVfkA020pZ+FFgz4vDheOhmCyuqpH03/e6s?=
 =?us-ascii?Q?ZfI5K+HMtMOTdmVCh3xhkuvjMLeGXRfKmQD71/EoYSITjmWaQ0eEgP8fWWkS?=
 =?us-ascii?Q?vH3S3rYKq/G8OPr7xweOFz8+b3v9XdYjWnsZ266Y43m6uIrOzNfNxJGsrAsD?=
 =?us-ascii?Q?RU2zR8b9VgJdcYPdG/0BpukYDR5Cxotgy7Zmv/O6ydLmQTGDyl66na6ZP1cB?=
 =?us-ascii?Q?m0iZWXAEHs3T3Myx/VxZS4NwywdzyW6GPMbFh0D7j/H9/Kgt5AzkORoV3sQD?=
 =?us-ascii?Q?xJhe+lTPVGxGPNQnzCjrWvy+c92mZZ58i/VNPpfJX/8qVJfv3hvBVU497bGY?=
 =?us-ascii?Q?XUn6rYhUzk6gUv7xj/dtaJrasqqHk+lm48HMI7nnmY3p8UFHO4XnJd5KO1oJ?=
 =?us-ascii?Q?dE+OBN8PMmK1c4pijQ2GhqrMNwwkPpzxXPuCMAGlt7goX2GGSfs7/0NSBPt+?=
 =?us-ascii?Q?nOsPAJGIeZJU8Pja7x0Q2P4d/Ek3gbvc5wLvatRMnfQ/OQj7eGEN+oPaCU6Y?=
 =?us-ascii?Q?oSze942D25jnA/nAeuaxCJDKBwmlTqdF0YZepH34dqn/Sg/Vdp/F0vo7kNCR?=
 =?us-ascii?Q?qS2ljuL9PJVp0VxG9wntLKZ05grF4tdiOeBhJNZHMhQfCtm2r91j4U60yvv+?=
 =?us-ascii?Q?iL8+R8gskFIxnnmStobrQlvl7CQZEitPZuxs9v/44lBF2LDxf76jizBc6tWk?=
 =?us-ascii?Q?dc+oZFKcBFVdw0zGjx3E2ib3AJUjjnYyKfdF0HFjuhKF+nFOb/FFVXBACWF/?=
 =?us-ascii?Q?J/A3XCJGlFRCyIOcOIlq1zkmPLNia4tY9N/vVmqAH0mMyMoE/jywIlwvtJfS?=
 =?us-ascii?Q?gfOkOz6KslLMwSOysLsEjSjWlLyKouCYM3fu5DOpBw50L+5h47UWp8hZj8jB?=
 =?us-ascii?Q?J1NAcRvC4TqZBXwz0etocZcEHMm68SRFA0MjNrdohQ6FbTs4r8J6JdzDw9x+?=
 =?us-ascii?Q?G8byNUR3/AgseLd33iYz7Aqr5rB8ZHKv12hrsRP1o2fYJ+hDae6p/VCRB169?=
 =?us-ascii?Q?yugSmSL9dNPy06kDZi8glZiFcvFo0f2HwS44HVFp8ShVHJ4Gn/K47MGkhUBK?=
 =?us-ascii?Q?EQcy2Lk3IgR+yDoNLW/XEDP6SWaRbUsD9OVvckti/9gJcmPX9JJrPBCX7MHi?=
 =?us-ascii?Q?I2TxPtPpDMvrA2fchWRHEC+/aAJneR06VgUc6KDSzbUSSZ4oAwwFKf5qi6O2?=
 =?us-ascii?Q?3KjfPH8qZXdCokMabdyBZLeHIW4Vr9Slfj+77QSOlC755dxEZg86rtawHWSP?=
 =?us-ascii?Q?FoHjiEs2Ro7YOo9Hpib/xOOIabh2ah11C1M1gFcYSnd+pIBdbplKd52PL5dY?=
 =?us-ascii?Q?2DRxOoaqX7pCjrGRs690162BEKX5Kc8rhQkHatt1nra4AIC6ZhLN+Ea48FBX?=
 =?us-ascii?Q?RfFW5e3PMesHME24fKubob481GSIa8mTb4wI9WNLHTNJ7UYARPjZcdv1XHkA?=
 =?us-ascii?Q?ZR/iwO+2wHx19993lNHarHozbFi/QJyKpR8kS0Q9JajWEvG2o9uEztj7TIh7?=
 =?us-ascii?Q?Uabhd0AG0jV8EW+zrIcEcneU99LGBcWjqiDzCVYAK8uYihdwm+m6zlaVVTU6?=
 =?us-ascii?Q?wA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH7PR19MB6876D9AB33CFF7160C4097D295282PH7PR19MB6876namp_"
MIME-Version: 1.0
X-OriginatorOrg: dellteam.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH7PR19MB6876.namprd19.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 589d2c83-2b4d-41ee-7722-08dc44b5d3f6
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Mar 2024 06:04:51.5616
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 945c199a-83a2-4e80-9f8c-5a91be5752dd
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 4vajBivXlsYV5TVArjQWkfZCff1BMTYO07IbWbFr5hpYhYF5+53gIIV2dU2DAIOY8rfc/Wigm6V1QD2QED8uDmPeUHEkGOjPNYjK8DCphYOW0ahwm8mEa7ZbUhSElqqJ
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA3PR19MB8011
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26
 definitions=2024-03-14_13,2024-03-13_01,2023-05-22_02
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 malwarescore=0 adultscore=0
 mlxscore=0 bulkscore=0 suspectscore=0 phishscore=0 priorityscore=1501
 clxscore=1011 impostorscore=0 spamscore=0 mlxlogscore=824
 lowpriorityscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2311290000 definitions=main-2403150048
X-Proofpoint-ORIG-GUID: sb6tEuZkTW1msHPEyp1FlAJcEhefe-Oh
X-Proofpoint-GUID: sb6tEuZkTW1msHPEyp1FlAJcEhefe-Oh
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 clxscore=1015 malwarescore=0
 priorityscore=1501 spamscore=0 suspectscore=0 lowpriorityscore=0
 mlxlogscore=894 mlxscore=0 adultscore=0 phishscore=0 impostorscore=0
 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2311290000 definitions=main-2403150048
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/PH7PR19MB6876D9AB33CFF7160C4097D295282%40PH7PR19MB6876.namprd19.prod.outlook.com>
Precedence: bulk

--_000_PH7PR19MB6876D9AB33CFF7160C4097D295282PH7PR19MB6876namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Team,

We are using JPA entities to persists the records into Postgres SQL DB and =
its working for all the nodes but one of the node data is not persisting an=
d it's not giving any DB related errors/exception. We just want to trace ou=
t this scenario on transaction level whether transaction is committing or n=
ot.

Could you please let us know how we can trace out this scenario and let us =
know how transaction logs enabled in Postgres SQL DB.


Regards,
Venkat


Internal Use - Confidential

--_000_PH7PR19MB6876D9AB33CFF7160C4097D295282PH7PR19MB6876namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:DengXian;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:"\@DengXian";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-IN" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi Team,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">We are using JPA entities to persists the records in=
to Postgres SQL DB and its working for all the nodes but one of the node da=
ta is not persisting and it&#8217;s not giving any DB related errors/except=
ion. We just want to trace out this scenario
 on transaction level whether transaction is committing or not.<o:p></o:p><=
/p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Could you please let us know how we can trace out th=
is scenario and let us know how transaction logs enabled in Postgres SQL DB=
.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Regards,<o:p></o:p></p>
<p class=3D"MsoNormal">Venkat<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<br>
<p style=3D"font-family:Calibri;font-size:7pt;color:#737373;margin:5pt;font=
-style:normal;font-weight:normal;text-decoration:none;" align=3D"Left">
Internal Use - Confidential<br>
</p>
</body>
</html>

--_000_PH7PR19MB6876D9AB33CFF7160C4097D295282PH7PR19MB6876namp_--