From: "Bandi, Venkataramana - Dell Team" <Venkataramana.Bandi@dellteam.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>,
        Greg Sabino Mullane
	<htamfids@gmail.com>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>,
        "Kishore, Nanda - Dell Team" <Nanda.Kishore@Dellteam.com>,
        "Alampalli,
 Kishore" <Kishoreravishankar.Alampalli@dellteam.com>
Subject: RE: Query on Postgres SQL transaction
Thread-Topic: Query on Postgres SQL transaction
Thread-Index: 
 Adp2nqC5qNFI/g9IRy6LkDeqRdh1pgAaRngAALVD1fAADopVgAEawL/wABEfDoAATrMwIAAN35IgAAnTOAAAioIb8A==
Date: Sat, 30 Mar 2024 10:14:29 +0000
Message-ID: 
 <PH7PR19MB687615662E5AEF0D8938A6FD95392@PH7PR19MB6876.namprd19.prod.outlook.com>
References: 
 <PH7PR19MB6876D9AB33CFF7160C4097D295282@PH7PR19MB6876.namprd19.prod.outlook.com>
 <CAKAnmmJcMTxoD2ao8z8YXiU-9FspXZc9L+VKGrAYuig8mN3XSQ@mail.gmail.com>
 <PH7PR19MB68765E8CBFF8AEA19B8C3560952C2@PH7PR19MB6876.namprd19.prod.outlook.com>
 <e97e4d5f-e019-4957-b722-bc50a7fbcac2@aklaver.com>
 <PH7PR19MB68760581162B8D7053FA643695362@PH7PR19MB6876.namprd19.prod.outlook.com>
 <84eae005-beb8-4f0b-a940-464fa4cab55b@aklaver.com>
 <PH7PR19MB6876E894EB056D206906CC8E95342@PH7PR19MB6876.namprd19.prod.outlook.com>
 <PH7PR19MB68766F0C803EE8568B8D9B0995342@PH7PR19MB6876.namprd19.prod.outlook.com>
 <0927c6dc-2f64-4ca0-96e5-554ac1f14fed@aklaver.com>
In-Reply-To: <0927c6dc-2f64-4ca0-96e5-554ac1f14fed@aklaver.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
 MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_ActionId=ce09a4fa-dddc-4298-8127-7cc3c8b8978a;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-30T10:07:29Z;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_SiteId=945c199a-83a2-4e80-9f8c-5a91be5752dd;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: PH7PR19MB6876:EE_|SJ0PR19MB6656:EE_
x-exotenant: 2khUwGVqB6N9v58KS13ncyUmMJd8q4
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 nxU+luEh8qssy33uJRAYu3waYErieiMcbzwgIAB+rHmv7MF5Y4Vzv+ESIz32YZWwxxXshiO+JGE/C/NRlfmoPceqX/2pnS6XsgJETLOLppys96fH37W6T82moUn5FD0XXG3EDE89iK1CVORHYWBx+3aeGapwQ0nRLzUcujXmxTxZahuslTWJG5+NGSnUefNTkLRKkmpDDfxRskzFCBPWqm51mGTEG98JreiyAeVaFqZv2dxm9vlyevmD7ipfUG9wqCkgKcnF+aaBFftIYjO4fQYdzlvji29T25fvD16VT9Z9PWBx3tp9Ya5uxA45Lc6CCt0jiHgx53jth4WSsN/30KA0KL3Mou0PnVOiPyNrCYTOpscIz5CLbu5+CGg8gKmPhipgR4IiC6nZFdv3SPfAaAnyPC9tHnWEkZi5vpSIjcOYXebltwo5hLMffXSnxjKJV+BTsyKHZJXwGytHqDgPkFYGRUDYpxMUBRwickY7xGOJTAuFkPB8MSJFlklKbrezJxIJPuXXgFkX3RBYjguJjFgDCO0ikeigC0XOpjES/HB0XIXNUvP7oJmn6AazF7Uex1UBxOHc2Dm1NecMqduXIJa519nHTTbw7VJwa/RRBws=
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)(1800799015)(366007)(376005);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-7?B?Y3dxWGtuTDhHUFQxa2diY0t6WVBxeHZMMnBidW1hMWJaeG04Z3hIc3BjQW1s?=
 =?utf-7?B?VEhCODBFNEV1elZXcXJaajMyZVl3N1k4Y0Q5N1IycGIxdkE0eHQrLXluUXVp?=
 =?utf-7?B?eDBJOW9jOTZoZHRhRGcyVWdVVlhjTmErLWRpa0szUWQydXU4NG1QS1FITGhD?=
 =?utf-7?B?NTU1NnNOb011VmVHeUQ4TlNuWkthM3grLWxMWjlmb09zNXErLUFYRi9MYTJa?=
 =?utf-7?B?cWV2cXQ4WHFyeG52VVFMd1p6T0daRHVEUUR0Nk9KWlJHZ3VhaXJZNHRsVXRL?=
 =?utf-7?B?bTREOU85Z0NWTkFWV3VKRDJ1Ky1McEhuVi8rLXViMmJOVmVadWhQbUNwY2k5?=
 =?utf-7?B?bE5OYXRPNndzNjVjbFo5STlWNDRtamJycTRKY1BDbjJadFBxUkJRcDBKMHQz?=
 =?utf-7?B?R3ZsY2pyaFAwbkMrLVpzanhhKy00UU9MNTYyQ0ozQ0llS25EdC9TdHZjcUcz?=
 =?utf-7?B?aWhxVHdEY01tVlgzSjl4RGl6MVlrYlFDcDREbHVOTFg3R0g1YjRjQWFaRnRk?=
 =?utf-7?B?bDJVN3ZLMk1GODZ3UnBEL084RElxeTdsOCstdE1RZUkvN1BqUHZLMkNpQ3Jw?=
 =?utf-7?B?Ynl6WEVuTGlRaFdBWG1abTMyYldkd0VwZlN1VWlIWlUxb0txV1hvQTNiYVVt?=
 =?utf-7?B?aHVQS1JSbDdzczNOdEVkSistYTlBZnoyRzVmSWdHMU9SUjJDSjcxdnBLbVhX?=
 =?utf-7?B?dzQ4bjhlMnZUVjNjQUxpVXY3Z091WmEvVTZOWS9qd2RoNXZ3SHpCc1ZFRFM4?=
 =?utf-7?B?SSstY0R6Y3pnUnB2VmIrLXRKd29BVUhhdGJuM3RWZnp1WFQrLXEveXkyZVgz?=
 =?utf-7?B?UjFNSXFUNTRZeXc1bW92Z0wrLXpveURmRlFVcWlIa2xjZVdJVnNOa0RYTm4v?=
 =?utf-7?B?c2Jrd21tMWtoYzlWdkp2NmcybU1MN3NBQ1A5ZmJPQVZGbUtCck9jSTBjSjh6?=
 =?utf-7?B?Ky1wR1hOZXJ2SFJuUWZFaExQVVRYcUFXUGp1MmFpS0Z4dkJ3N0NoeVBFS2du?=
 =?utf-7?B?SkVqazFKc2ttOGdrdURLcGhjdTNDYUhZRCstZkpGYVBMU0htTS9HVGxWSm5N?=
 =?utf-7?B?TWVXdDA2c1QvZTdYRTBKaUpVZ25aRWZIb3NrNVdlUlhKU2ZWSTFHM3ZobEJz?=
 =?utf-7?B?RDVlSVJLMFNad0xIWG5ReGxNKy00T00zUmpVRi9mTzhVUnRyUVY3Mk0rLVZv?=
 =?utf-7?B?eEIyYkxDaC9sdWRpT0tVNWt4S09CSVVkeG8vRHVzMFN6Q0RMRUVHV3V3RjRQ?=
 =?utf-7?B?MzNPWVlkaEs5T3hiZExub254WVlCbTdZczA4WjJhY1h2WlVrSGg5bWZmVDZk?=
 =?utf-7?B?TnFXbUtoZk00OHkrLVZpTHlYTUkrLUxMZzc4Ky1lYmFxVEZqaThiZ2tqWkdv?=
 =?utf-7?B?b3I2YThCR084VWRMVFh2SzdFelBVRTF1emJUaUdraWJyNmNMZzBzdncrLWpD?=
 =?utf-7?B?UDUzTzNubW0zWGpWMzNic200MXF4VDhwRFp1Wmg4d0k4Wlc0TDdQQVlSOXU3?=
 =?utf-7?B?cHJuV1h0a3hrSVRUZXhNbDgwUGtDSzlWd2ZFUGRnaUd2RC9EMVdkUlZJUk9y?=
 =?utf-7?B?ZTlPZVlWQXdyaWFKcGZNZCstdnAzVmcwNWlCTUp2dFp2ZGFKZ1dwZGRWNFhJ?=
 =?utf-7?B?QU1GUHE0dEF5dDY3TW1ZQjFrYjk3elM5L0NCbGMvQVEwbW8yNjhPQystbVF5?=
 =?utf-7?B?dkl4YldyWHY2eFVUckx0aktKU1o0SjdCbkxpMlRNcW1MbElUdzBuVFpHbDBK?=
 =?utf-7?B?ZW1rcVZhcnFRM2JiUzl6Y3kybEFILy9yOUpDWmtOMnhCcTJXUDVOL1UrLUhM?=
 =?utf-7?B?dFVsY09CMEdzKy01ei9sTnprSFQzZystQzBPaystamdLREgzelEzV1dZV3hp?=
 =?utf-7?B?SDBQT1FOZklUSGJqRFIwKy0vZElHR1RNaVVXRXBhalBQZ0Y5UEdJN1BENEQ1?=
 =?utf-7?B?WlBiNTZvcW9COWc1a2xIcUMzZlBqUHNxYXplb1lLREpqd1BIVDRpcTUrLUpr?=
 =?utf-7?B?UHZRMUtJV3JDclV6YU5WWUwvaU9Xd1BJMkZpN2FNSDMyWTM4SW8vTnpNRGZl?=
 =?utf-7?B?UUZkY1FPallqZGtSMG9aQk1qMy9Scm9HNnhsWExCUDdOVzBpbTRaOFVGUG1I?=
 =?utf-7?B?S2FoTFUyRTFIejc2UHlhZlA3MGQ5dWZpZVRRSFgzQnJ2QWpSYUxhT3pKL2Zv?=
 =?utf-7?B?VGhpdVVweVFORnliWTBXd1hyTXJjWDdZajQyT2J0d0ErQUQwQVBRLQ==?=
Content-Type: text/plain; charset="utf-7"
Content-Transfer-Encoding: quoted-printable
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: 57e507ad-9d1b-4cee-4f83-08dc50a22fce
X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Mar 2024 10:14:29.6360
 (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: GrtybuSpW1zR0Nq4sfoxYKvwZIzvLw9zVY/IcfECT6pzzgJOXL9fA0kd+E5AW9AF3KCv+SIlwNpun19qkb8EQiSE+/DP2w5uaSFV0WZnCL/neH4oorcI23S+0yS8sbAS
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR19MB6656
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-30_06,2024-03-28_01,2023-05-22_02
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 priorityscore=1501 mlxscore=0
 bulkscore=0 impostorscore=0 suspectscore=0 phishscore=0 lowpriorityscore=0
 mlxlogscore=999 spamscore=0 clxscore=1015 adultscore=0 malwarescore=0
 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2403210000
 definitions=main-2403300084
X-Proofpoint-GUID: q0HdXGQqfm_54ibvgCNXyD0IXRPIdBPP
X-Proofpoint-ORIG-GUID: q0HdXGQqfm_54ibvgCNXyD0IXRPIdBPP
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 lowpriorityscore=0 bulkscore=0
 spamscore=0 impostorscore=0 clxscore=1015 malwarescore=0 phishscore=0
 suspectscore=0 mlxlogscore=999 priorityscore=1501 adultscore=0 mlxscore=0
 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2403210000
 definitions=main-2403300083
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/PH7PR19MB687615662E5AEF0D8938A6FD95392%40PH7PR19MB6876.namprd19.prod.outlook.com>
Precedence: bulk

Hi,

Clarifying the problem statement again, Multiple requests are getting to ou=
r application server and using hibernate framework to persist the data into=
 Postgres SQL DB but for one of the request, it is also similar request lik=
e other requests and there are no differences b/w these requests in terms o=
f different OS, different network etc. but data is not persisting few times=
.

We have enabled below properties in postgresql.conf file and verified but d=
idn't get any findings about the transaction and below log statements are w=
riting in our data store logs.

log+AF8-statement +AD0- 'all'
logging+AF8-collector +AD0- on
log+AF8-min+AF8-messages +AD0- debug5
log+AF8-min+AF8-error+AF8-statement +AD0- debug5

2024-02-19 15:21:54.850 +-08 +AFs-1876+AF0- LOG:  execute S+AF8-48: insert =
into xxxxxxx (f+AF8-schedule+AF8-name,f+AF8-id,f+AF8-totaldataredtn,f+AF8-i=
nvalidationtime,f+AF8-statuscode,f+AF8-module,f+AF8-app+AF8-type,f+AF8-dbba=
ckuptype,f+AF8-is+AF8-compressed,f+AF8-proxy,f+AF8-size,f+AF8-sizeprotected=
,f+AF8-groupjobid,f+AF8-status,f+AF8-bytesmodifiednotsent,f+AF8-sizetransfe=
rredboffset,f+AF8-bytesmodifiedsent,f+AF8-errcode,f+AF8-jobid2,f+AF8-media+=
AF8-server,f+AF8-starttime,f+AF8-storageid,f+AF8-pool,f+AF8-queuestart,f+AF=
8-sizescannedboffset,f+AF8-errorcodesummary,f+AF8-ncopies,f+AF8-sizeprotect=
edboffset,f+AF8-snap+AF8-target+AF8-platform,f+AF8-backup+AF8-servername,f+=
AF8-nfiles,f+AF8-expiry,f+AF8-owner,f+AF8-policy+AF8-id,f+AF8-parentjobid,f=
+AF8-sub+AF8-name,f+AF8-completion+AF8-status,f+AF8-endtime,f+AF8-filesscan=
ned,f+AF8-idle+AF8-wait,f+AF8-storage+AF8-unit,f+AF8-group+AF8-id,f+AF8-bac=
kup+AF8-set,f+AF8-ntries,f+AF8-job+AF8-name,f+AF8-level,f+AF8-agent+AF8-nam=
e,f+AF8-failed+AF8-copies,f+AF8-restarted+AF8-job,f+AF8-success+AF8-copies,=
f+AF8-domain+AF8-id,f+AF8-snap+AF8-target,f+AF8-jobid,f+AF8-request+AF8-id,=
f+AF8-pluginname,f+AF8-sizetransferred,f+AF8-is+AF8-snap,f+AF8-node+AF8-id,=
f+AF8-workflow+AF8-id,f+AF8-action+AF8-name,f+AF8-agent+AF8-id,f+AF8-instan=
cename,f+AF8-session,f+AF8-totalobjdedup,f+AF8-changedbytes,f+AF8-sizeboffs=
et,f+AF8-dedupredtn,f+AF8-statuscodesummary,f+AF8-workflow+AF8-jobid,f+AF8-=
snap+AF8-policy,f+AF8-size+AF8-copies,f+AF8-sizescanned,f+AF8-sub+AF8-id,f+=
AF8-archive+AF8-flag,f+AF8-nfilesnot,f+AF8-media+AF8-wait,f+AF8-snap+AF8-cr=
eation,f+AF8-effective+AF8-path) values (+ACQ-1,+ACQ-2,+ACQ-3,+ACQ-4,+ACQ-5=
,+ACQ-6,+ACQ-7,+ACQ-8,+ACQ-9,+ACQ-10,+ACQ-11,+ACQ-12,+ACQ-13,+ACQ-14,+ACQ-1=
5,+ACQ-16,+ACQ-17,+ACQ-18,+ACQ-19,+ACQ-20,+ACQ-21,+ACQ-22,+ACQ-23,+ACQ-24,+=
ACQ-25,+ACQ-26,+ACQ-27,+ACQ-28,+ACQ-29,+ACQ-30,+ACQ-31,+ACQ-32,+ACQ-33,+ACQ=
-34,+ACQ-35,+ACQ-36,+ACQ-37,+ACQ-38,+ACQ-39,+ACQ-40,+ACQ-41,+ACQ-42,+ACQ-43=
,+ACQ-44,+ACQ-45,+ACQ-46,+ACQ-47,+ACQ-48,+ACQ-49,+ACQ-50,+ACQ-51,+ACQ-52,+A=
CQ-53,+ACQ-54,+ACQ-55,+ACQ-56,+ACQ-57,+ACQ-58,+ACQ-59,+ACQ-60,+ACQ-61,+ACQ-=
62,+ACQ-63,+ACQ-64,+ACQ-65,+ACQ-66,+ACQ-67,+ACQ-68,+ACQ-69,+ACQ-70,+ACQ-71,=
+ACQ-72,+ACQ-73,+ACQ-74,+ACQ-75,+ACQ-76,+ACQ-77,+ACQ-78)
2024-02-19 15:21:54.851 +-08 +AFs-10928+AF0- DEBUG:  bind +ADw-unnamed+AD4-=
 to +ADw-unnamed+AD4-
2024-02-19 15:21:54.852 +-08 +AFs-10928+AF0- DEBUG:  CommitTransaction(1) n=
ame: unnamed+ADs- blockState: STARTED+ADs- state: INPROGRESS, xid/subid/cid=
: 0/1/0

Could you let us know any other way to trace out these kind of DB transacti=
ons?


Regards,
Venkat


Internal Use - Confidential
-----Original Message-----
From: Adrian Klaver +ADw-adrian.klaver+AEA-aklaver.com+AD4-
Sent: Wednesday, March 27, 2024 9:32 PM
To: Bandi, Venkataramana - Dell Team +ADw-Venkataramana.Bandi+AEA-dellteam.=
com+AD4AOw- Greg Sabino Mullane +ADw-htamfids+AEA-gmail.com+AD4-
Cc: pgsql-general+AEA-lists.postgresql.org+ADs- Kishore, Nanda - Dell Team =
+ADw-Nanda.Kishore+AEA-Dellteam.com+AD4AOw- Alampalli, Kishore +ADw-Kishore=
ravishankar.Alampalli+AEA-dellteam.com+AD4-
Subject: Re: Query on Postgres SQL transaction


+AFs-EXTERNAL EMAIL+AF0-

On 3/27/24 04:29, Bandi, Venkataramana - Dell Team wrote:
+AD4- Hi,
+AD4-
+AD4- As l already mentioned, for this specific node also data is persistin=
g but sometimes(randomly) data is not persisting.

How do you know which data is not persisting?

+AD4-
+AD4- As you mentioned our application doesn't have any restrictions on OS =
level and on network etc.
+AD4-
+AD4- different OS or OS version, different encoding, different location on=
 the network, different data it is working, etc.

I don't understand what the above is saying. Do you mean there are differen=
ces in these attributes between the nodes or no differences?

Also please do not top post, use either bottom or inline posting per:

https://urldefense.com/v3/+AF8AXw-https://en.wikipedia.org/wiki/Posting+AF8=
-style+AF8AXwA7ACEAIQ-LpKI+ACE-glyl28rP3t6cLe3s9tF3X5+AF8-4YU28-qPJsOaPHUjX=
9F01s4DCAXmZVedjlyKpvXlv-TgG-800u0Drq4lWC2f8CObdQX3ijBWevQ+ACQ- +AFs-en+AFs=
-.+AF0-wikipedia+AFs-.+AF0-org+AF0-

+AD4-
+AD4- Regards,
+AD4- Venkat
+AD4-


--
Adrian Klaver
adrian.klaver+AEA-aklaver.com