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/wABEfDoAATrMwIA==
Date: Wed, 27 Mar 2024 04:48:05 +0000
Message-ID: 
 <PH7PR19MB6876E894EB056D206906CC8E95342@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>
In-Reply-To: <84eae005-beb8-4f0b-a940-464fa4cab55b@aklaver.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
 MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_ActionId=de5ce5de-f959-4da0-8d57-7fe63461b8bf;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-27T04:43:00Z;MSIP_Label_73dd1fcc-24d7-4f55-9dc2-c1518f171327_SiteId=945c199a-83a2-4e80-9f8c-5a91be5752dd;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: PH7PR19MB6876:EE_|MN2PR19MB4110: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: 
 ym9KekJSfZMgOxO68+104GFaAMeUuPHm4RYYbgzUih2p/XgQGxV9yL8EZulWXX1t5j4gGw5P5pHUNFG0qdDXIt9pyIfRH2RXZUo4sBkX2kcKFvA7mCK+VLvhV582AwTihLT0Fl3YUMTZwUdCikZwhy9j86hosybgEwANhMzSxPK43DerqK+UYdaz9bNk+plDkpnqoS156FwDPA9FIHU4/c9WUPZ60JWXGGoxm0XOU6+D2WeAq5zZaK2A8qBkiEea1kzi+hIvITFiwZG/+id8bDMRBu3CrfzFB+ku/54dZOR0gbDe/Jl9HKTDPNqjed/yIPruwu2ljxFhNAL+ViPqiMw8BY9gqfd0D8KWh7Kez/agH7HvNzeimumUdvbADV5Tk22349SOENsZgAnbrQT+81D+d6R0qbQBuoTDroq6NOx7pJtXLFV5bow8bgZamKdiA0gIQkFt6Wbs+6+klmQRzNIA50x2ItvoV2+spm8MDDN5dRKEeW9t2gEejC9ZyJHpMaOwBGh2kuNZ5GDwlPb7D4vEWpD+vrC2E+E/I09gEWkuZHmvqiLkIwJ6RW9AY8gkjyTpLcBbj16LkzZuO8CufAfdaOC50R34/2VcSTmASSARXTl7YHA6ytc8M3mbO7u7S7wTFJBzBuV0xKtv6tUfzeIuNPpAFLZ82ototH4IrAE=
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)(366007)(376005)(1800799015);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-7?B?bDZSaXhIMk0wTUtjM2N3Y1dqNERLRi9Rempyc3J1cXM5VDc5Y2xXaS9OVklQ?=
 =?utf-7?B?MmJMKy1uYXZkLzN4dWFvS21rdDJJZ3VkVHRzTG5RMTk5b0svTWFhMk1SRnBJ?=
 =?utf-7?B?MmEySndTRjZyRzd2NklMS3lzOHdlKy1seFBCUEFvcS9qWjBRdklGd0VTZFZV?=
 =?utf-7?B?NTZoYno4eDhvUUhUbG5zRjhKYzQveExuZW9CM2U4dU1KeHlpdmlkcWo1aE5j?=
 =?utf-7?B?WWMyaE1jREMxSUNZc3o5QVZjRTJ6eDgxbFp2SXhyOHlpNjN2L3huc1V4Ky1q?=
 =?utf-7?B?c3ZjQU1kZTJuc2V0aUViaystWW05ZTY0d2VBMkFGVTFGOTYwd3BjZkkxSGJQ?=
 =?utf-7?B?VTFhTmF6alg4OTVxSFdaMkVQWFRTZzRHUEQ2TWdMRWRwQ0xid041VUJCY09T?=
 =?utf-7?B?NlNhZHVoR0pZQWxlSlgrLWZMNkR5ZmZyNSstUXBNWHk0NEVRVVRYQ2JhQTE4?=
 =?utf-7?B?a0lxSkpnTC9rOGlNelFqSzcrLTJ6bEhsUXNvTERQUkxqQkZpZGVod3NrQW1M?=
 =?utf-7?B?UFNMdk9EZzhwNkZQUXhJbFhLdzZqZDg0dmhqSm9Ha3dtMWZnNEJLTkkrLUtF?=
 =?utf-7?B?SnRyb0JZaUVPbUpJZlk0U3dzZkhvLystUXU2c0txKy1sMExLS3dBN1N2Y3BE?=
 =?utf-7?B?ZVpGb3VCeUtIcHdlSXFUUmd1blB0Ky10Y2s1VngrLTZlQjI0NkF6MUlVTDZ5?=
 =?utf-7?B?TmpyOG9oenlUNnNWcUhabldSNystZzhad2poSUNBM1ovQjhPekl5MngyWnU=?=
 =?utf-7?B?MystdTR2c25XU090UjcxTGtIckkwMklzd2lpa3NIVlBZUGFFUzA5djl1TXNq?=
 =?utf-7?B?aistRkpERUZLWXd2bWlubXBYRUZDc3dyOExXUmJHTTdMeUdTT2VBMUhya0x6?=
 =?utf-7?B?TVFia3BYZjhBOE5tZ2tMaE5JZnBiWistRENIeG5xZHVHQXVieU9obzNMSUR1?=
 =?utf-7?B?WWk3Z0VSOXI1Mm02aml6VUFRb1B4a1pzNWVBNU5Wdk4vRDBERmlJWEZEQXNC?=
 =?utf-7?B?R0ExaGNkUksxaWF6OFQrLVNNRDBQOEtEVjhpTnFJVVM0ZnVzWEZzRjI2MXVa?=
 =?utf-7?B?b3laNUxrbnRpVUdMZC96OTI3Znd1dkFZTFd5b2Mxb1lYVFpKZk5jUGptUjJm?=
 =?utf-7?B?TTlWUFRFdjJXZnNUNlU2cHFJQlREZGVTNjJyU2RIUzdHMksrLTB5cnAyUnlm?=
 =?utf-7?B?eEd3VWJFOFRJWDJ2bGpTZHFnWmw4SG5YanhWT3V3RWJkRVJFenNKTkl6QVBP?=
 =?utf-7?B?Tk5DZHBIN1lhdlE4dTRWQW5YdEFRSFJmMEFSSldrcm1TV1RlSUcrLWhMMllW?=
 =?utf-7?B?OFUvb0Q2VXJGWk9qZmI3dW96SFlLc0JJMENQWS9JTHFZYXJQSDFsaDZyUkw=?=
 =?utf-7?B?Ky1pc1NWZzFjblVHMGhRTFl3SzE2UUIvb29GdXpDZDd1RjdxZGlFS0x2R2hD?=
 =?utf-7?B?NzFUdWd6TzA4RElYKy1QNENyMistamF6Q0RWSENBcTdpUHpMM1R2OVRwRFJL?=
 =?utf-7?B?ZFpsSWEzV2lpcG80UTBoMUZRYnYvdW9BeDhQZlBPOEQvek9haWVMMi9JR0ZE?=
 =?utf-7?B?ZGlLTTZuV3B4dE0xaWM2WUNOaTQ4WVBoQXpOR2xDWVp3M1lBRXJ5b0xrcUhu?=
 =?utf-7?B?MDlaa0ZiMDJGNkRla0IxcXJ4SnY5VXExWkQycGg4ZHJzcjMyUHBoVDYrLWl4?=
 =?utf-7?B?b1k2L1kvOGRCckFsbGhSelUrLUk2SWxkL1NqQmJ1S2d1UE9OKy1qcDFUbyst?=
 =?utf-7?B?NFpOTW0rLWxVc0lpV3N2UlBaOEt6RURRaUxqT0FzV0NaQTcwMXE5d0lYcURI?=
 =?utf-7?B?RGhOaWFoNHBBNFA2dk9lcTJEakxMZUxpekhyM2hjVzRadndHbWxsTmtkUHBo?=
 =?utf-7?B?M2hxNmhXUUhISEJWUjhGL0xVai9NNzVydlNYODFVTDNhSndjbDFtOEgyNzN1?=
 =?utf-7?B?QistWkxpVzdNYWV6SWY4Tk14cE5QdXdoVWE4ZW42UElmUnlDV2ZTNW1oaG12?=
 =?utf-7?B?T1U5SHJtdFovZ0VNeVZLRXhNcFVQSXFER21TdTBybUdBVEtUSHNWOUkrLWZZ?=
 =?utf-7?B?NVROVGVYMndrellteW93Q3dWRk85c255SzBzRm4zc0tSSURTYkxDOUpqZ3Vo?=
 =?utf-7?B?ZDkwMjRDVGd4YUpkWkpMZGVtTU14VEExVystMlk0Y3dCeGpYWUtZOXdnSist?=
 =?utf-7?B?TlJESjdMekhxZWVoRy9kRSstMUt5alJPMEx5NEVBNC90ZDV3K0FEMEFQUS0=?=
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: c5305625-af95-4440-3d7b-08dc4e1917c1
X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Mar 2024 04:48:05.9367
 (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: OZ6FM3YNhuqFdj9oOzGO/dqQfWFt5gVNtnluM4HCdGZAqm0eCaiXBobh2Z2WGJG3ObiutBgR0o2g3gAqrU+nF6wtB/7CaoD7ZTC/Ojiw5VakVy5qHE8i/2fpC715Bdkp
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN2PR19MB4110
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-27_01,2024-03-21_02,2023-05-22_02
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 malwarescore=0 suspectscore=0
 clxscore=1015 spamscore=0 mlxlogscore=999 mlxscore=0 adultscore=0
 bulkscore=0 priorityscore=1501 lowpriorityscore=0 impostorscore=0
 phishscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2403210000 definitions=main-2403270029
X-Proofpoint-GUID: 84LTPJhlEicNeZJtZDzrFF_zo7BY97e0
X-Proofpoint-ORIG-GUID: 84LTPJhlEicNeZJtZDzrFF_zo7BY97e0
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 impostorscore=0 clxscore=1015
 suspectscore=0 malwarescore=0 adultscore=0 lowpriorityscore=0
 mlxlogscore=999 mlxscore=0 priorityscore=1501 spamscore=0 bulkscore=0
 phishscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2403210000 definitions=main-2403270029
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/PH7PR19MB6876E894EB056D206906CC8E95342%40PH7PR19MB6876.namprd19.prod.outlook.com>
Precedence: bulk

Hi Adrian,

I will check with the customer on below info for that node and will share y=
ou.

For instance different OS or OS version, different encoding, different loca=
tion on the network, different data it is working, etc.

As I already mentioned we have enabled Postgres SQL debug logs to trace out=
 this scenario, but it is not helping us.


Regards,
Venkat


Internal Use - Confidential
-----Original Message-----
From: Adrian Klaver +ADw-adrian.klaver+AEA-aklaver.com+AD4-
Sent: Monday, March 25, 2024 8:40 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/25/24 00:18, Bandi, Venkataramana - Dell Team wrote:
+AD4- Hi,
+AD4-
+AD4- Please find my inline comments for your questions.
+AD4-
+AD4-
+AD4- Regards,
+AD4- Venkat
+AD4-
+AD4-
+AD4- Internal Use - Confidential
+AD4- -----Original Message-----
+AD4- From: Adrian Klaver +ADw-adrian.klaver+AEA-aklaver.com+AD4-
+AD4- Sent: Tuesday, March 19, 2024 9:33 PM
+AD4- To: Bandi, Venkataramana - Dell Team
+AD4- +ADw-Venkataramana.Bandi+AEA-dellteam.com+AD4AOw- Greg Sabino Mullane
+AD4- +ADw-htamfids+AEA-gmail.com+AD4-
+AD4- Cc: pgsql-general+AEA-lists.postgresql.org+ADs- Kishore, Nanda - Dell=
 Team
+AD4- +ADw-Nanda.Kishore+AEA-Dellteam.com+AD4AOw- Alampalli, Kishore
+AD4- +ADw-Kishoreravishankar.Alampalli+AEA-dellteam.com+AD4-
+AD4- Subject: Re: Query on Postgres SQL transaction
+AD4-
+AD4-
+AD4- +AFs-EXTERNAL EMAIL+AF0-
+AD4-
+AD4- On 3/19/24 02:18, Bandi, Venkataramana - Dell Team wrote:
+AD4APg- Hi Greg,
+AD4APg-
+AD4APg- We are using hibernate framework to persist the data into Postgres
+AD4APg- SQL DB and data is persisting and committing for all the clients b=
ut
+AD4APg- one of the client data is not inserted into DB.
+AD4-
+AD4- What is different about that client?
+AD4- Ans: In our application data is getting from different nodes(systems)=
 and persisting into Postgres SQL DB but for one of the nodes(system) data =
is not persisting and sometimes data is persisting for this node also. We h=
ave to trace out the transaction why data is not persisting sometimes.

That we knew already. What I was after was whether that particular
node(system) is different in some important way from the others. For instan=
ce different OS or OS version, different encoding, different location on th=
e network, different data it is working, etc.

Define what you have done to trace the path of the transaction.

+AD4- Are all the clients passing data through the same instance of the fra=
mework?
+AD4- Ans: Since it is a monolithic architecture application, it is running=
 on same instance.
+AD4- Are you sure that the client is pointed at the correct database?
+AD4- Ans: Yes, its pointed to correct database and with same database conn=
ection, data is persisting for other nodes.
+AD4- Is the log entry below from that client?
+AD4- Ans: Yes
+AD4APg-

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