[Firebird-devel] [ firebird-Bugs-1017870 ] FB disconnects when stored proc executed

[SourceForge.net <no...@so...>]

Bugs item #1017870, was opened at 2004-08-27 14:37
Message generated for change (Comment added) made by christotwy
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1017870&group_id=9028

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: TerryC (christotwy)
Assigned to: Nobody/Anonymous (nobody)
Summary: FB disconnects when stored proc executed

Initial Comment:
I created a relatively long stored procedure in my 
database, developing it incrementally.  The first section, 
ending with the first "suspend;", executed fine, as well 
as the second.  When I added the third section, it 
compiled without error, but executing it causes Firebird 
to disconnect everyone!

This causes IB Expert to crash when I'm using it.  IBO 
Console doesn't crash, but reports that it has been 
forcibly disconnected.

The behavior is the same whether the database is on my 
local machine or a server on my network.

In the attached database, the stored procedure at issue 
is "COUNTS_BY_REP".

----------------------------------------------------------------------

>Comment By: TerryC (christotwy)
Date: 2004-08-30 15:58

Message:
Logged In: YES 
user_id=1112288

OK, installed and ran v1.5.1 locally; it crashes (and 
disconnects) with exactly the same code in firebird.log.


----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2004-08-30 11:58

Message:
Logged In: YES 
user_id=71163

Terry,

Please retry your script with the latest FB release v.1.5.1

----------------------------------------------------------------------

Comment By: TerryC (christotwy)
Date: 2004-08-30 11:51

Message:
Logged In: YES 
user_id=1112288

Sorry RE: typo

FB Version is 1.5.0.4306, not .4360


----------------------------------------------------------------------

Comment By: TerryC (christotwy)
Date: 2004-08-30 11:48

Message:
Logged In: YES 
user_id=1112288

...and here's firebird.log capturing a startup, crash and restart

----------------------------------------------------------------------

Comment By: TerryC (christotwy)
Date: 2004-08-30 11:47

Message:
Logged In: YES 
user_id=1112288

...and here's firebird.log capturing a startup, crash and restart

----------------------------------------------------------------------

Comment By: TerryC (christotwy)
Date: 2004-08-30 11:32

Message:
Logged In: YES 
user_id=1112288

The SP is 15-16KB, 506 lines.

ZIPped, the DB is only 618KB.  If I can't upload the DB, will 
the script have more luck?  The DB isn't that large.  I will try 
to attach the script to this response.

FB ver (fbserver.exe) == 1.5.0.4360 on Windows 2000, Server 
and Pro.


----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2004-08-27 16:51

Message:
Logged In: YES 
user_id=71163

How big is the DB information?

How big (bytes) is the SP?

Does the server Firebird.log contains any message?

Can you create a simple script, which shows the problem 
instead of a whole DB?

Also, what version of FB are you using - v1.0.x, v1.5.x?

What platform?


----------------------------------------------------------------------

Comment By: TerryC (christotwy)
Date: 2004-08-27 14:42

Message:
Logged In: YES 
user_id=1112288

Tried to upload DB with submission, but nothing went??

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1017870&group_id=9028