Subject Re: [ib-support] Corrupted DB and more errors
Author Helen Borrie
At 06:48 AM 20-06-02 +0000, you wrote:
>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.

Do you mean "an update" or do you mean a metadata change? You won't see
this message except when trying to do a metadata change on an object that
is involved in an unresolved transaction.

Does your application create and destroy metadata?

>This although I AM the ONLY USER connected.
>I'm sitting on a LAN, with the server besides me.

But your log is showing abnormal terminations. The server doesn't know
that a client crashed and, in any event, the server never completes (rolls
back or commits) client transactions - the client has to do that but it
can't if it crashed. There is a high likelihood therefore that you have
uncommitted work sitting around in the database.

Do you have *no* clue as to which client is causing the server to
crash? Did anyone install an unrelated BDE software around the time the
problems started? It only takes one bad BDE setup to break a system.

In an earlier message you said:

ALL my client uses this connection string:

What is DATABASE-SRV? Is it an actual machine, pointed to by an authentic
IP address? Or, to put it another way, is C:\EasyPOS\EasyPOS.Gdb a direct
path to a directory on the C-drive of the physical machine whose IP address
is pointed to by DATABASE-SRV? In the current log messages your host
machine seems to be called "udvikling".

That will do for this message. This thing is already confused enough...


All for Open and Open for All
Firebird Open SQL Database · ·