RE: Query on Postgres SQL transaction

Hi Adrian,

I will check with the customer on below info for that node and will share you.

For instance different OS or OS version, different encoding, different location 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 <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Monday, March 25, 2024 8:40 PM
To: Bandi, Venkataramana - Dell Team <Venkataramana(dot)Bandi(at)dellteam(dot)com>; Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org; Kishore, Nanda - Dell Team <Nanda(dot)Kishore(at)Dellteam(dot)com>; Alampalli, Kishore <Kishoreravishankar(dot)Alampalli(at)dellteam(dot)com>
Subject: Re: Query on Postgres SQL transaction

[EXTERNAL EMAIL]

On 3/25/24 00:18, Bandi, Venkataramana - Dell Team wrote:
> Hi,
>
> Please find my inline comments for your questions.
>
>
> Regards,
> Venkat
>
>
> Internal Use - Confidential
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Tuesday, March 19, 2024 9:33 PM
> To: Bandi, Venkataramana - Dell Team
> <Venkataramana(dot)Bandi(at)dellteam(dot)com>; Greg Sabino Mullane
> <htamfids(at)gmail(dot)com>
> Cc: pgsql-general(at)lists(dot)postgresql(dot)org; Kishore, Nanda - Dell Team
> <Nanda(dot)Kishore(at)Dellteam(dot)com>; Alampalli, Kishore
> <Kishoreravishankar(dot)Alampalli(at)dellteam(dot)com>
> Subject: Re: Query on Postgres SQL transaction
>
>
> [EXTERNAL EMAIL]
>
> On 3/19/24 02:18, Bandi, Venkataramana - Dell Team wrote:
>> Hi Greg,
>>
>> We are using hibernate framework to persist the data into Postgres
>> SQL DB and data is persisting and committing for all the clients but
>> one of the client data is not inserted into DB.
>
> What is different about that client?
> 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 have 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 instance different OS or OS version, different encoding, different location on the network, different data it is working, etc.

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

> Are all the clients passing data through the same instance of the framework?
> Ans: Since it is a monolithic architecture application, it is running on same instance.
> Are you sure that the client is pointed at the correct database?
> Ans: Yes, its pointed to correct database and with same database connection, data is persisting for other nodes.
> Is the log entry below from that client?
> Ans: Yes
>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com