Commented by: Rajesh H Thampi (rthampi)

Using Firebird 2.0.1 and 2.0.3 Classic Server
I have a table with 1,30,000 rows. With 3 fields as Primary key (group_id (int), po_wd(int),word(varchar(50))) and the Index is created on one of those fields (namely Word).
The DB is blazing fast for SELECT queries.
In one portion of my code I'm connecting to the DB, doing a select query and disconnecting. This is being done 80,000 times from my code in a loop. The speed at which it gets the results back are really great.
BUT out of 80,000 when it hits (vaguely) around 300. The code crashes giving this error.
_______________________________________________________
terminate called after throwing an instance of 'ibpp_internals::SQLExceptionImpl'
what(): *** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Failed to establish a connection.
Connection refused
_______________________________________________________

This error happens when it tries to open a new connection to the Database.
When encountered with this error what I did was catch the error from the connect command (with try catch) and let it sleep for 50 seconds. Then attempting to open another connection is successful. But after a few rows more (30 or so) it will fail again and go into the sleep before trying another time.

I'm thinking cause it didn't flush the earlier data about the connections even though I have disconnected the connection. I tried using forcedwrite = ON. But then I found the bug CORE1476 (ForcedWrites do not work on Linux) and I'm on a Linux machine. So this is kind of a dead lock situation. Any solution to this???

Commented by: @AlexPeshkoff

Server crashed. Getting core dump and providing here backtrace for it can help to fix the bug.

In order to avoid problems with non-working FW, mount filesystem with your database in sync mode.

Commented by: Rajesh H Thampi (rthampi)

I'm using a release version and not the debug version Hence my log file is not too descriptive. Sorry about that. Here is what I got.

firebird.log
----------------------------------
<system name> (Client) Thu Nov 29 20:49:20 2007
INET/inet_error: read errno = 104

<system name> (Client) Thu Nov 29 20:49:22 2007
INET/inet_error: connect errno = 111
----------------------------------

I tried setting ForcedWrite=On in firebird.conf and mounted the HDD as sync. No luck. Its still failing.

Commented by: @AlexPeshkoff

Rajesh, if you are using standard SF binaries, it's not required to have DEV_BUILD version of firebird to get rather useful core dump. Please pay attention - this is NOT firebird.log, this is dump of fbserver process which may be done by OS in case of fault happening in the process.

Please also download debugger symbols from SF and untar them. After getting core dumps do:
gdb /opt/firebird/bin/.debug/fb_inet_server /tmp/core
(or how would it be called on your linux). In gdb do backtrace
(gdb) bt
and send all gdb output to me. Be ready to do some more tests in gdb - keep your core file!

If you are not familiar with getting core dumps, please contact me provately, peshkoff at mail dot ru.

Commented by: @AlexPeshkoff

Rajesh, can you continue working on an issue?
In case of no reply I'll have to mark it as non-reproduced.

Commented by: @AlexPeshkoff

No reply from the author of an item for 2 weeks.