|Subject||Re: Firebird hangs for a while blocking all DB operations periodically.|
We don't do anything particularly special in deletes / updates once a month. The last two times we have observed this issue, it occurred during a DB sweep so perhaps it is related to garbage collection. The strange thing is that everything is blocked, even other existing DB connections that all recover on their own after a few minutes.
> Since this happen about once a month, do you happen to do massive monthly deletes or updates, Anthony, and do the blocking occur after such deletes/updates and before or during the next sweep? If so, a possible solution could (in some cases), be to delete/update a bit every hour or day rather than monthly.