Subject | Re: [ib-support] Corrupted DB and more errors |
---|---|
Author | Helen Borrie |
Post date | 2002-06-20T08:00:06Z |
At 06:48 AM 20-06-02 +0000, you wrote:
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?
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:
DATABASE-SRV:C:\EasyPOS\EasyPOS.Gdb
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...
heLen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________
>HiDo you mean "an update" or do you mean a metadata change? You won't see
>
>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 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.But your log is showing abnormal terminations. The server doesn't know
>I'm sitting on a LAN, with the server besides me.
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:
DATABASE-SRV:C:\EasyPOS\EasyPOS.Gdb
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...
heLen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________