|
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 |
