| Subject | RES: [firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically. |
|---|---|
| Author | Fabiano |
| Post date | 2012-05-30T16:38:29Z |
The blocking beavior is for SS/SC? The Classic version has an different GC
and maybe it does not occur.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de nathanelrick
Enviada em: quarta-feira, 30 de maio de 2012 12:55
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: Firebird hangs for a while blocking all DB
operations periodically.
it's exactly the same for us :( it's garbage collection !
when the garbage collection start, then any connection that try to load any
row that are in the process of the garbage collection are blocked (freezed)
! in fact all the connection that try to select anything on the table are
freeze ... this from several min, to sometime even hours !! of course it's a
disaster :(
for us the garbage collect start after we do a massive delete.
to emulate it ... simple, delete severals thousands rows, and do a select
AFTER this delete ... you will see that the select is block an ALL OTHER
selects too :(
i m now thinging about mysql to solve this probleme (just to move our
session table to mysql database), but i m not sure that mysql will not have
the same probleme. anyone here can confirm ?
--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "anthonyjang2012"
<anthony@...> wrote:
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.
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.
and maybe it does not occur.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de nathanelrick
Enviada em: quarta-feira, 30 de maio de 2012 12:55
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: Firebird hangs for a while blocking all DB
operations periodically.
it's exactly the same for us :( it's garbage collection !
when the garbage collection start, then any connection that try to load any
row that are in the process of the garbage collection are blocked (freezed)
! in fact all the connection that try to select anything on the table are
freeze ... this from several min, to sometime even hours !! of course it's a
disaster :(
for us the garbage collect start after we do a massive delete.
to emulate it ... simple, delete severals thousands rows, and do a select
AFTER this delete ... you will see that the select is block an ALL OTHER
selects too :(
i m now thinging about mysql to solve this probleme (just to move our
session table to mysql database), but i m not sure that mysql will not have
the same probleme. anyone here can confirm ?
--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "anthonyjang2012"
<anthony@...> wrote:
>month. The last two times we have observed this issue, it occurred during a
> We don't do anything particularly special in deletes / updates once 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.
>monthly deletes or updates, Anthony, and do the blocking occur after such
> Regards,
> Anthony
>
> > Since this happen about once a month, do you happen to do massive
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.
> >[Non-text portions of this message have been removed]
> > Set
> >
>