Subject Re: Sweep and corrupted DB
Author mivi71dk
>
> If the database was corrupted gbak wouldn't be able to connect to
the
> database. There is no (or little) trickery with gbak - it connects
to
> the server just like any other client application. How come it can
> connect and yours can't?

Actually I can connect too, but cannot do anything (except Backup -
Restore).


>
>
> >
> > What is "poke Scandinavian alphabet" ?
> >
>
> A chance for us to have a laugh perhaps? What Helen meant to ask was
> whether you were trying to use characters that are not supported by
the
> character set specified for the database (or field). In fact,
CHARSET
> NONE will accept anything.

I think I use standard table construction.
The only thing I have added is NOT NULL, Foreign keys, and some index
of my own.
Thats it !


>
> >
> >
> > Maybe not. But CAN I tell if a DB is sweeping or if it has been
> > sweeped earlier ?
> >
>
> Good question. I don't think you can tell if one is going on ( other
> than a visible performance loss). You can tell if one has happened
by
> regularly comparing the txn stats output from gstat. But that sounds
> like a lot of work.
>
> Sweeping is meant to be a non-intrusive, background operation that
you
> don't need to worry about. All part of the embed, deploy and relax
> thing. Under normal circumstances it shouldn't ever happen because
a
> good application design will ensure that transactions are short
running
> and the OIT pointer always moves along.
>
>
> Paul
>
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase