At 03:24 PM 28-01-02 +0000, Douglas Tosi wrote:

>Hi,
>
>I made some tests on an issue i've posted some weeks ago and I believe it
>has something to do with multiple transactions on the same connection.
>My FB log file reads like this in the exact moment that the error occurs:
>
>DESENV_05 (Client) Mon Jan 28 15:03:17 2002
> INET/inet_error: send errno = 10054
>
>DESENV_05 (Client) Mon Jan 28 15:03:17 2002
> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
> Uncommitted work may have been lost

..etc...

>The client gets a "error reading data from the connection" message and is
>disconnected from the server.
>My search showed me about a bug related to views and joins that caused this,
>but there is no view in my app. There are a lot of triggers and selectable
>stored procs and many of them use udfs i wrote to work with dates. These
>udfs are not the problem for they are in production environments since
>ib5.1.

Is your database Dialect 3? If so, any date udfs that worked with ib5.1 won't work with IB/Firebird. When udfs fail, they crash the server. Do you find the server still running after the client gets the error message?

>What I did is open a connection (IBX602, Delphi6, NT4w+SP6, FB RC2) to a
>local database, using server:path, open a transaction, open another one,
>when I try to open the fourth or fifth transaction, the error happens. Note
>that I only opened the transactions.

Meaning you just opened five transactions and did nothing with them? Why?

>My network is setup as a pure TCP/IP windows lan and i have no other network
>related problems.
>
>Someone help me, please?!?

If a client causes the server to crash, it's necessary to know what the client was attempting to do at the time. Clients don't crash the server by simply starting transactions. Have you tried watching the API activity with a SQL Monitor? If you can get an idea of what is happening at this interface, and it seems anomalous, you should post your problem in the borland.public.interbase.interbasexpress newsgroup (news://forums.inprise.com).

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________