On 15 October 2010 09:36, Martial Braem <martial.br...@abboss.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
