Subject Re: [IBO] weird exception from IBO
Author Zach Saw
Thanks for the reply. I looked into the firebird log file and it was indeed a firebird server crash.

I was running a test program that runs in a loop - insert a record and then delete that record. After the insert, I did a commit, and reopened the table. After which I delete the record, and reopen the table, and restart the loop. A few cycles into that, I ran into that error. However, after firebird crashed and got restarted by guardian, everything was fine again (i.e. the test program hasn't failed since then). Any ideas how to prevent this from happening?

No statement has been assigned to the dataset at this point. Do you get an
AV message at all? What's the corresponding message in the log (if any)?
specifically, an INET error, or an indication of Guardian trying to restart
the server.

HP27375281801 (Client) Mon Oct 03 14:15:15 2005
C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated abnormally (4294967295)

HP27375281801 (Client) Mon Oct 03 14:15:15 2005
INET/inet_error: read errno = 10054

HP27375281801 (Client) Mon Oct 03 14:15:15 2005
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost

HP27375281801 (Client) Mon Oct 03 14:15:15 2005
INET/inet_error: send errno = 10054

HP27375281801 (Client) Mon Oct 03 14:15:16 2005
Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe

>Connection is TCP/IP to localhost. Exception is intermittent. There
>are 2 database connections to firebird.

Can you explain what you mean by that? The application is connected to 2
databases? Two programs are connected to one database? One program has 2
connections to one database?

The application is multithreaded and has 2 threads running concurrently. Both are connected to the same database.

>Hardware specs:
>P4 3Ghz HT
>512Mb RAM

Consider the various reasons why an application that was connected to a
database lost its connection --

Did the server crash? Look in the log file. If it crashed, why? A bad UDF?
Trying to access localhost through terminal services? Host server machine
being overloaded? Too many uncommitted transactions? etc. etc.

The server did crash but the only clue I have to the reason it crashed is "INET/inet_error: read errno = 10054". My app is connected to firebird through localhost loopback connection. At any given time, there's only 1 uncommitted transaction. I tried to reproduce it, but have not been able to do so for nearly 4 hours now.

Thanks again.

Do you Yahoo!?
The New Yahoo! Movies: Check out the Latest Trailers, Premiere Photos and full Actor Database.

[Non-text portions of this message have been removed]