Subject | firebird c api issues |
---|---|
Author | Stan |
Post date | 2006-08-04T22:42:06Z |
Hi,
I have re-written a part of my application (from PHP) to use the C
firebird library.
This was done because I ran into:
STAN (Server) Tue Aug 01 15:00:47 2006
Database: E:\SERVER\DATA\NF5.FDB
internal gds software consistency check (invalid SEND request (167))
And people here and on the bug-track suggested that the PHP interbase
library is buggy.
I still get these errors, even with the C api.
Background:
Both server and client are on the same Windows XP SP2 machine.
I am using Firebird 1.5.3 SS (same problem happens in 1.5.2, and 2.0 RC3)
Each client is its own single-threaded process (CGI) written in C++,
linked statically with fbclient.dll (from Firebird 1.5.3).
I get these errors under heavy load (60+ simultaneous clients)
I am NOT doing any "schema changing" statements.
The error always happens in the same place in the code:
Each client is inserting 1 record into 8 tables followed
by an update on 2 of the records that were just inserted.
This operation is done in a single transaction. I have tried
separate transactions, but had the same result.
At the same time other clients are selecting from these tables.
I am using the default transaction settings (snapshot, write I think).
Also I have a second issue:
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
these occur very ofter under load. I did not get these errors with PHP.
thanks,
stan
I have re-written a part of my application (from PHP) to use the C
firebird library.
This was done because I ran into:
STAN (Server) Tue Aug 01 15:00:47 2006
Database: E:\SERVER\DATA\NF5.FDB
internal gds software consistency check (invalid SEND request (167))
And people here and on the bug-track suggested that the PHP interbase
library is buggy.
I still get these errors, even with the C api.
Background:
Both server and client are on the same Windows XP SP2 machine.
I am using Firebird 1.5.3 SS (same problem happens in 1.5.2, and 2.0 RC3)
Each client is its own single-threaded process (CGI) written in C++,
linked statically with fbclient.dll (from Firebird 1.5.3).
I get these errors under heavy load (60+ simultaneous clients)
I am NOT doing any "schema changing" statements.
The error always happens in the same place in the code:
Each client is inserting 1 record into 8 tables followed
by an update on 2 of the records that were just inserted.
This operation is done in a single transaction. I have tried
separate transactions, but had the same result.
At the same time other clients are selecting from these tables.
I am using the default transaction settings (snapshot, write I think).
Also I have a second issue:
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
PDD-STANK (Client) Tue Aug 01 14:31:07 2006
INET/inet_error: connect errno = 10061
these occur very ofter under load. I did not get these errors with PHP.
thanks,
stan