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
On 15 October 2010 09:36, Martial Braem <Martial.Braem@xxxxxxxxx> wrote:
What do you have in logs, any drops, deletes or truncates?
regards
Szymon
