Re: Missing data in a particular table

On Mon, Oct 12, 2026 at 5:18 AM Shankar Reddy <shankarrdba12(at)gmail(dot)com>
wrote:

> Dear Postgres Community,
>
> Recently I have come across with an issue that the postgresql logs clearly
> showing insert command were executed successfully with a commit followed by
> the disconnection of the session, but the data were reflecting in the 2
> tables and not reflecting in the third table. We are using the java
> application here with hibernate, from the postgres side we have cross
> checked each and every possibility and noticed nothing. The issue started
> exactly on 01-OCT-2026 and ends on 06-OCT-2026.
>
> Please help with this scenario in case we need to change or tne anything
> or it is simply an issue from the application itself.
>

This is almost certainly (but not definitely) a bug in your application,
and *definitely* it's basic program debugging.

Write a small, simple sql script which *only* does what the Hibernate
application is supposed to do.

If that works (writes into all three tables), then write a small, simple
Java JDBC program which *only* does what the Hibernate application is
supposed to do.

If that works (writes into all three tables), then write a small, simple
Hibernate program which *only* does what the main Hibernate application is
supposed to do.

If at any point a script or program fails to do what it's supposed to do,
get back to us with code and log files.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!