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