mivi71dk wrote:

>>
>> How do you know it is corrupted?
>>
>
> All clients get this error until a Backup - Restore has been issued:
>
> Unable to complete network request to host "localhost". Error reading
> data from the connection. En eksisterende forbindelse blev
> tvangsafbrudt af en ekstern vært. (A connection was closed by an
> external host).
>
> "LocalHost" could be a server name !
>

This has nothing to do with corruption. The error message is fairly
explicit here, although it doesn't explain fully what has been/is happening.

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?

>
> 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.

>
>
> 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