Missing data in a particular table

Поиск
Список
Период
Сортировка
Искать

Missing data in a particular table

От:
Shankar Reddy <shankarrdba12@gmail.com>
Дата:
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.

Thanks & Regards
Shankar

Re: Missing data in a particular table

От:
Ron Johnson <ronljohnsonjr@gmail.com>
Дата:
On Mon, Oct 12, 2026 at 5:18 AM Shankar Reddy <shankarrdba12@gmail.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!

Re: Missing data in a particular table

От:
Adrian Klaver <adrian.klaver@aklaver.com>
Дата:
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.klaver@aklaver.com


Re: Missing data in a particular table

От:
Rob Sargent <robjsargent@gmail.com>
Дата:


> On Oct 12, 2026, at 08:12, Adrian Klaver  wrote:
> 
> On 10/12/26 2:17 AM, Shankar Reddy wrote:
> 
> 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?

Or any system/environment changes on either or both of those dates? Somebody changed something then reverted that change is my bet. 
> 
>> Thanks & Regards
>> Shankar
> 
> 
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
> 
> 


FAQ