Re: Missing data in a particular table

On 10/12/26 2:17 AM, Shankar Reddy 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 going to need more information:

Postgres version.
JDBC driver and version
Hibernate version.

The log snippet showing the INSERT and COMMIT.

A detailed description of the process involved in '...reflecting in the
2 tables and not reflecting in the third table.'.

Where there any upgrades to the software involved between 01-OCT-2026
and 06-OCT-2026?

>
> Thanks & Regards
> Shankar

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