Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
On 3/27/24 04:29, Bandi, Venkataramana - Dell Team wrote:
Hi,
As l already mentioned, for this specific node also data is persisting but
sometimes(randomly) data is not persisting.
How do you know which data is not persisting?
As you men
Subject: Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
On 3/27/24 04:29, Bandi, Venkataramana - Dell Team wrote:
> Hi,
>
> As l already mentioned, for this specific node also data is persisting but
> sometimes(randomly) data is not persisting.
How do you kno
That log snippet shows two different PIDs. Check the logs to see the
complete path that process 1876 took after it did the insert at 2024-02-19
15:21:54.850 +08
Make sure you are not using prepared transactions. This should return 0:
select current_setting('max_prepared_transactions');
Cheers,
On 3/27/24 04:29, Bandi, Venkataramana - Dell Team wrote:
Hi,
As l already mentioned, for this specific node also data is persisting but
sometimes(randomly) data is not persisting.
How do you know which data is not persisting?
As you mentioned our application doesn't have any restrictions
Team
; Alampalli, Kishore
Subject: 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
Team
; Alampalli, Kishore
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 - Confid
Sabino
Mullane
Cc: pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
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
, Nanda - Dell Team
; Alampalli, Kishore
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 an
*Sent:* Saturday, March 16, 2024 12:07 AM
*To:* Bandi, Venkataramana - Dell Team
*Cc:* pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
*Subject:* Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
That's a very vague question, but you can trace exactly
: Saturday, March 16, 2024 12:07 AM
To: Bandi, Venkataramana - Dell Team
Cc: pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
Subject: Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
That's a very vague question, but you can trace exactly what
That's a very vague question, but you can trace exactly what is happening
by issuing
SET log_statement = 'all';
Ideally at the session level by your application, but can also set it at
the database and user level. If all else fails, set it globally (i.e.
postgresql.conf). Turn it off again as
On 3/14/24 11:04 PM, Bandi, Venkataramana - Dell Team wrote:
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 and it’s not giving any DB related errors/exception. We
just want to
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 and it's
not giving any DB related errors/exception. We just want to trace out this
scenario on transaction level whether transaction is
13 matches
Mail list logo
