Subject | Re: Firebird 1.5.1 oten crashes on our RedHat 9 server |
---|---|
Author | dirknaudts |
Post date | 2004-12-21T11:00:58Z |
> >...messages
> >gbak: restoring index FK_MINPRIJS
> >gbak: finishing, closing, and going home
>
> Do you get a complete log preceding this, though? If so, these
> mean the restore was successful.Yep, DB looks ok, but where does the errormessages comes from after
the "going home" message ?
As an extra test I did the restore using GBAK directly in a terminal
window, and there it all seems to be ok as well.
Nevertheless I'm a bit worried as to what the cause is for the
reported error, and wether this will also occur when my software
accesses the DB :-(
Further checking firebird.log I See :
luelx1.nbvuga.lan (Client) Tue Dec 21 09:27:14 2004
/opt/firebird/bin/fbguard: bin/fbserver terminated abnormally
(-1)
luelx1.nbvuga.lan (Client) Tue Dec 21 09:27:14 2004
/opt/firebird/bin/fbguard: guardian starting bin/fbserver
luelx1.nbvuga.lan (Client) Tue Dec 21 11:43:36 2004
/opt/firebird/bin/fbguard: bin/fbserver terminated abnormally
(-1)
luelx1.nbvuga.lan (Client) Tue Dec 21 11:43:36 2004
/opt/firebird/bin/fbguard: guardian starting bin/fbserver
So this happens every time when I restored the DB using IBExpert.
I don't see this behaviour when using GBAK directly within the
terminal window.
>00:02:28
> >IBE: Unsuccessful execution caused by a system error that precludes
> >successful execution of subsequent statements.
> >Unable to complete network request to host "192.168.0.144".
> >Error reading data from the connection.
> >
> >IBE: Restore completed. Current time: 9:31:30. Elapsed time:
> >Ok, I'll keep that in mind :)
> *Never* use -replace_database - it should be bulldozed off a cliff.
> It looks to me as if IBE is trying to connect remotely but has lostthe
> connection. Try "disconnecting" (even though you know it'sdisconnected)
> and then reconnecting. Do you try to connect to the restoreddatabase
> yourself, e.g locally with isql?I'm not connected to a DB at the moment I start the Restore from
within IBE. (So disconnect is greyed out)
Connecting to the newly created DB after the restore is not a
problem, but FB has restarted after the restore ! Obviously I can't
have this behaviour in a production env. Since this would mean all my
client apps would loose connection. when a DB (even another one than
the one those apps use) gets restored.
And as said, I've seen this "restarting" thing also as a result of a
normal sql action, but wasn't sure at that moment that it wasn't just
my bug or a faulty UDF. Therefore I started trying to simulate it
using FB-tools only. (by executing scripts and restoring db)
Dirk Naudts.