'connection lost to database'

sometimes I am receiving error message 'connection lost to database' - in my case - it appears only when I am initializing the new column (for table with many rows - above 100k or even 1m records) with sp (where is for select...do...begin loop over this table). I have no observed any preconditions to this (some network environment, or server release etc.) error, it is rare - however - nasty when it appears.

I searched a lot - and found that this was an issue before IB 5.6 - but no any other reasosn. Some explanations were - problem with garbage collection/sweep - in can explain unregularity of this...

Any experience?
Thanx in advance.

Sounds like a bug.

well - I discovered some solid situation in which it occurs - when I am executing select (as query or in for loop) which uses some udf around one or more fields - then almost exactly 255 rows are returned and then connection lost appears.

I don't make throughouh tests but - find workaround instead... OK, maybe it helps someone - it is really hard to discover why this occurs.

Did you submit the bug report?

i have similar problem with Firebird 1.5.3.4870 and rfunc 2.1.3

CREATE PROCEDURE BBB1 (Path Varchar(255)) RETURNS (RETID INTEGER)
AS
Declare Variable fh Integer;
Declare Variable bi Integer;
Declare Variable tstr1 Varchar(255);
Declare Variable tstr2 Varchar(255);
Declare Variable S1 Numeric(15,5);
begin
...
bi=fSize(path || 'BBB.Txt');
if (bi>0) then begin
fh=fopen(path || 'BBB.Txt', FO_RDONLY(), 0);
if (fh>0) then begin
while (bi>0 and RetID=0) do begin
tstr1=fRead(fh,220); tstr2=SubStr(tstr1,81,15);
...
S1=cast(tstr2 as Numeric(15,5));
...
bi=bi-1;
end
bi=fclose(fh);
end
end
...
end



CREATE PROCEDURE BBB2 (Path Varchar(255)) RETURNS (RETID INTEGER)
AS
Declare Variable fh Integer;
Declare Variable bi Integer;
Declare Variable tstr1 Varchar(255);
Declare Variable tstr2 Varchar(255);
Declare Variable S1 Numeric(15,5);
begin
...
bi=fSize(path || 'BBB.Txt');
if (bi>0) then begin
fh=fopen(path || 'BBB.Txt', FO_RDONLY(), 0);
if (fh>0) then begin
while (bi>0 and RetID=0) do begin
tstr1=fRead(fh,220); tstr2=SubStr(tstr1,81,15);
...
S1=cast(SubStr(tstr1,81,15) as Numeric(15,5));
...
bi=bi-1;
end
bi=fclose(fh);
end
end
...
end


on PC with Win98 BBB1 & BBB2 work perfectly
on other PC with WinXP BBB1 work but BBB2 rise exception 'connection lost to database' and the server terminates abnormally