[Casimiro Notevi]

Otro, indica algo sobre firewall:

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
Description
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

Show »


All Comments Work Log Change History Version Control Sort Order: [ Permlink | « Hide ]
Alice F. Bird - [14/Jun/06 09:37 AM ]
Date: 2005-10-11 13:48
Sender: mikhail_moscow
Logged In: YES
user_id=1359923

Problem resolved. After deinstalling MS firewall client firebird
was accept connection by tcp in classic mode.


[ Show » ]
Alice F. Bird - [14/Jun/06 09:37 AM ] Date: 2005-10-11 13:48 Sender: mikhail_moscow Logged In: YES user_id=1359923 Problem resolved. After deinstalling MS firewall client firebird was accept connection by tcp in classic mode.



[ Permlink | « Hide ]
Alice F. Bird - [14/Jun/06 09:37 AM ]
Date: 2005-10-11 11:47
Sender: mikhail_moscow
Logged In: YES
user_id=1359923

We have same problem after terminate long time executing
processes of classic server Firebird-1.5.2.4731 when server
process was stoped. From client and from local i can connect
using NetBeui, but TCP connection can't connect with
message 'Incorrect parameter of environment'
(russian 'Neverniy parameter sredy'). In firebird log message
FSERVER Tue Oct 11 12:11:30 2005
INET/inet_error: read errno = 10038
Reinstall of firebird is not change situation. In superserver
mode firebird work via TCP/IP. We have this problem at 2
servers with same symptoms.


[ Show » ]
Alice F. Bird - [14/Jun/06 09:37 AM ] Date: 2005-10-11 11:47 Sender: mikhail_moscow Logged In: YES user_id=1359923 We have same problem after terminate long time executing processes of classic server Firebird-1.5.2.4731 when server process was stoped. From client and from local i can connect using NetBeui, but TCP connection can't connect with message 'Incorrect parameter of environment' (russian 'Neverniy parameter sredy'). In firebird log message FSERVER Tue Oct 11 12:11:30 2005 INET/inet_error: read errno = 10038 Reinstall of firebird is not change situation. In superserver mode firebird work via TCP/IP. We have this problem at 2 servers with same symptoms.



[ Permlink | « Hide ]
Alice F. Bird - [14/Jun/06 09:37 AM ]
Date: 2005-08-31 20:05
Sender: dimitr
Logged In: YES
user_id=61270

I'm afraid we cannot help without a reproducable test case,
sorry.


[ Show » ]
Alice F. Bird - [14/Jun/06 09:37 AM ] Date: 2005-08-31 20:05 Sender: dimitr Logged In: YES user_id=61270 I'm afraid we cannot help without a reproducable test case, sorry.