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