Subject | Re: Firebird hangs for a while blocking all DB operations periodically. |
---|---|
Author | anthonyjang2012 |
Post date | 2012-05-30T14:28:56Z |
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.
Regards,
Anthony
Regards,
Anthony
> 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.
>
> Set
>