Re: Strange phenomenon

On 15 October 2010 09:36, Martial Braem <Martial(dot)Braem(at)abboss(dot)be> wrote:

> Hi,
>
>
>
> I am a Java developer, using PostgreSQL as a database.
>
> Recently I observed a strange phenomenon:
>
> 1) The database has some tables where I store my application data. I
> have an additional table, with no relation to any other table, just for
> logging purposes. In the database, a sequence is defined too.
>
> 2) On day one, I store data in my application data tables and in the
> logging table (transactional data). At the end of the day, I extract the
> data from the database for daily reporting (the ultimate proof that the
> transactions are actually committed). No problem there
>
> 3) On day two, three, four and five, similar actions are taken
>
> 4) On day six, there’s no trace of any data from day two to day five,
> except that the sequence, used in the application has not been reset. Except
> for the sequence, it looks like the database was reverted to the state of
> day one.
>
> Does this sound absurd or is this in any way possible? My application does
> not contain any delete statements, and because of the reporting, I know that
> the data was once in the database.
>
> Can anyone explain this phenomenon?
>
> * *
>
> *Thanks*
>

What do you have in logs, any drops, deletes or truncates?

regards
Szymon