Subject Re: [firebird-support] sweep database
Author Ann W. Harrison
On 9/20/2010 5:53 AM, majstor wrote:
> Hi,
> I have some strange situation with firebird database and I think that sweep can be problem. I have n-tier application which is using oracle, mssql and firebird database for backend storage. For oracle and mssql all works fine, but some users who use firebird for database storage have problem that after few days of working some data (eves server is shutdown) under strange condition return some old data into some tables.
> For example, I have table aricles, and when user made documet who change price in table articles all works fine for a week in some cases, but after few days (week in some cases) prices are returned to old values even there are no new documents.
> Is this sweep problem or something else???

No, it's certainly not a sweep problem. Are you absolutely sure
that all changes are being committed?

Good luck,