Subject Re: [firebird-support] Re: Firebird 1.5.1 oten crashes on our RedHat 9 server
Author Helen Borrie
At 08:45 AM 21/12/2004 +0000, you wrote:


>Hi All,
>
>So I implemented the updates to both /etc/init.d/firebird
>and /ets/profile to include the LD_ASSUME_KERNEL stuff as mentioned
>in the 1.5 release notes,
>and it looked promising ...
>executing the same scripts that caused problems before, now runs
>smoothly !
>But backing up the DB on my XP machine (also FB 1.5.1) (transportable)
>and restoring it on the RH9 server still results in this :
>
>...
>gbak: restoring index FK_MINPRIJS
>gbak: finishing, closing, and going home

Do you get a complete log preceding this, though? If so, these messages
mean the restore was successful.

>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: 00:02:28
>
>Anyone any ideas as how to interpret/solve this ?
>
>The restore is done from my XP machine using IBExpert 2004.08.05
>both trying replace database and create new database, both results in
>same problem.

*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 lost the
connection. Try "disconnecting" (even though you know it's disconnected)
and then reconnecting. Do you try to connect to the restored database
yourself, e.g locally with isql?

./hb