Hi Leonardo,

thats the symptom I'm seeing, intermittently a process will almost stop and
will stay that way for several hours

how did you prove that was the cause?

On 15 January 2013 15:59, Leonardo Carneiro <chesterman86@...> wrote:

> **
>
>
> Hi Nick. I've found that my applications ALMOST hang when sweep is running
> in big databases (100GB+).
>
> I say almost because once in a while the application give a sign of life.
> To "solve" the problem, i disabled the autosweep and run in a scheduled
> task every dawn.
>
> Best regards.
>
>
> On Tue, Jan 15, 2013 at 12:29 PM, Nick Upson nu@...> wrote:
>
> > Hi,
> >
> > (firebird 2.1.5 on centos) 50Gb database
> >
> > Is there any reason why a process, upon noticing the transaction gap is >
> > 20000 & hence a sweep is required, should 'hang' (for hours), as if
> waiting
> > for the sweep to complete.
> >
> > Is there any way I can tell (logging or process monitoring perhaps) when
> an
> > automatic sweep is initiated, running or completed?
> >
> > --
> > Nick Upson, Telensa Ltd
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>



--
Nick Upson, Telensa Ltd


[Non-text portions of this message have been removed]