Subject Corrupted DB and more errors
Author mivi71dk

Earlier on I have posted several things about DB getting corrupted.
Besides the "Interbase server terminated abnormally (-1)" I also get
these errors:

unsuccessful metadata update
object FARVER is in use

When trying to make a update to TABLE farver.
This although I AM the ONLY USER connected.
I'm sitting on a LAN, with the server besides me.

As mentioned earlier on the LOG on the server says this:

UDVIKLING (Client) Thu Jun 20 08:34:35 2002
C:\Program Files\Firebird\bin\ibserver.exe: terminated
abnormally (-1)

UDVIKLING (Client) Thu Jun 20 08:34:36 2002
Guardian starting: C:\Program Files\Firebird\bin\ibserver.exe

And on the Client side I get this:

MIVIAMD1900 (Client) Thu Jun 20 08:34:39 2002
REMOTE INTERFACE/gds__detach: Unsuccesful detach from
Uncommitted work may have been lost

MIVIAMD1900 (Client) Thu Jun 20 08:34:39 2002
INET/inet_error: send errno = 10054

"Inside" my program I get messages like this:

Unable to complete network request to host "udvikling".
Error reading data from the connection.
En eksisterende forbindelse blev tvangsafbrudt af en ekstern vært.
(An existing connection was cut by force by external host) or

I have been told to check my HW. Everything has been checked and
double checked.

I have checked my SQL statement.
I do not use ANY fancy SQL. Just simple Select, Insert and Update.
I have 3 generators, 12 stored proc. and 8 triggers on 1 table.

My assumption is that the error comes when sweep kicks in.
Now some new qeustions:

When sweep starts, what happens on the client side ?
Do they stop, slow down or do they not notice ?

What happens if the client side do a Update / insert and thereafter a
commit when the sweeps running ?

Will sweep run, when the diff. between transactions reaches exactly
20000 or just shortly after ?

My ONLY solution to continue is to do a Backup - Restore.
Then all works fine again.

I know I have asked this some times, but I think I'm getting closer
to a solution, but need more information about sweep.