Submitted by: mkrauti (mkrauti)

SFID: 1249375#⁠
Submitted By: mkrauti

Hello,

we have a big problem:

one of our applications crashes sometimes (up to 5
times a day) without exception. We searched the bug
approximately 1 year, but we never found it.

Now i've seen, that every time when it crashes, there is
the following situation:

1. in Firebird.log is one of the following messages:
PPSSERVER (Client) Mon Jul 18 10:39:04 2005
INET/inet_error: read errno = 10038

PPSSERVER (Client) Mon Jul 18 11:07:09 2005
INET/inet_error: select in packet_receive errno = 10038

PPSSERVER (Client) Tue Jul 26 14:27:29 2005
INET/inet_error: read errno = 10038

PPSSERVER (Client) Mon Aug 01 07:57:55 2005
INET/inet_error: read errno = 10038

2. our application logged this:
01.08.2005 07:57:55 IBErrorCode: 335544726 SqlCode: -
902 ErrorMessage: "Error reading data from the
connection" in SecureExecSTP(stpPacklinieCounter).

the function SecureExecSTP trys 15 times with a delay
of 100ms to execute the StoredProcedure
PROC_UPD_WORDLINIE_PA_COUNT with the following
code:

SET TERM ^ ;

CREATE PROCEDURE
PROC_UPD_WORDLINIE_PA_COUNT (
WOCOD CHAR(10),
WOPPOS CHAR(4),
WOPJAHR SMALLINT,
WOLPOS SMALLINT,
BLID INTEGER,
BLSUBID SMALLINT,
PAFIRST TIMESTAMP,
PALAST TIMESTAMP,
PACOUNT INTEGER,
PALASTNUM INTEGER)
AS
begin
update wordlinie
set wol_pa_dtfirst = :PAFIRST,
wol_pa_dtlast = :PALAST,
wol_pa_count = :PACOUNT,
wol_pa_last_num = :PALASTNUM
where wo_cod = :WOCOD
and wop_pos = :WOPPOS
and wop_jahr = :WOPJAHR
and wol_pos = :WOLPOS
and bl_id = :BLID
and bl_sub_id = :BLSUBID;
end
^

SET TERM ; ^

GRANT SELECT,UPDATE ON WORDLINIE TO
PROCEDURE PROC_UPD_WORDLINIE_PA_COUNT;

GRANT EXECUTE ON PROCEDURE
PROC_UPD_WORDLINIE_PA_COUNT TO SYSDBA;

It seems, that the client crashes, when the function trys
to execute the stored procedure the second time,
because the first time there was an exception.

We use:

Firebird 1.5.2
Windows 2003 Server, Windows XP Professional SP1 +
SP2, ecc. (on every system the same error)
Delphi 5 + IPX 5.03