Menu
▾
▴
firebird-devel
|
From: <no...@so...> - 2001-02-18 23:56:53
|
Bug #133025, was updated on 2001-Feb-18 15:58 Here is a current snapshot of the bug. Project: Firebird Category: Core Engine Status: Open Resolution: None Bug Group: Confirmed Bug Priority: 5 Submitted by: helebor Assigned to : nobody Summary: Server hangs when executing Stored Proc more than once Details: When executing a SP inside a loop that accepts input parameters, the server hangs on the second iteration if the statement is not unprepared and re-prepared between iterations. This is an old bug which goes back to v. 5.x as well. Note that, if you add a SUSPEND statement at the end of the SP and return a dummy parameter, you can multi-call the SP with SELECT instead of EXECUTE without the need to do the unprepare/prepare when passing subsequent sets of inputs. For detailed info, follow this link: http://sourceforge.net/bugs/?func=detailbug&bug_id=133025&group_id=9028 |
|
From: <no...@so...> - 2001-02-18 23:59:52
|
Bug #133025, was updated on 2001-Feb-18 15:58 Here is a current snapshot of the bug. Project: Firebird Category: Core Engine Status: Open Resolution: None Bug Group: Confirmed Bug Priority: 9 Submitted by: helebor Assigned to : nobody Summary: Server hangs when executing Stored Proc more than once Details: When executing a SP inside a loop that accepts input parameters, the server hangs on the second iteration if the statement is not unprepared and re-prepared between iterations. This is an old bug which goes back to v. 5.x as well. Note that, if you add a SUSPEND statement at the end of the SP and return a dummy parameter, you can multi-call the SP with SELECT instead of EXECUTE without the need to do the unprepare/prepare when passing subsequent sets of inputs. For detailed info, follow this link: http://sourceforge.net/bugs/?func=detailbug&bug_id=133025&group_id=9028 |
|
From: Kloo <PBa...@ho...> - 2001-09-12 06:31:24
|
Hi, We have a test case that reproduces the following bug : http://sourceforge.net/tracker/index.php?func=detail&aid=233025&group_id=902 8&atid=109028 there is the descritpion of a bug of priority 9 : "This is an old bug which goes back to v. 5.x as well" We have a gdb, a program written in C and another in delphi that reproduces the bug: For this, you can downlad the gdb sample on : http://www.vienneinfo.org/delphi/zip/3.gdbIBBug.zip (50 Ko) and the source of the sample in C : http://www.vienneinfo.org/delphi/zip/tstc.cpp (8 Ko) This is a translation of my Delphi sample that uses IBX 4.62 : http://www.vienneinfo.org/delphi/zip/bugib.zip (52 Ko : Delphi 5 source + gdb sample) What we know today : in 3.gdb, there are two stored procedures: SP 002 and SP 011 if we start with SP 002 it works since the last input parameter is an integer. if we start with SP 011 where there is only one VARCHAR input parameter, then we alternate with SP 002 then SP 011 again => crash. if we only run SP 011 N times : it works well... with IB local (without TCP/IP) : no trouble in all cases with IB Server AND Client on the same computer, with TCP/IP => trouble The C Sample has got the same trouble on Windows or Linux... More strange : With one computer as Server (under Windows) and another computer as Client (under Linux) : No trouble ! :-( It also works with Linux as server and Windows as client. Summarry : client server protocol result --------------------------------------- windows windows tcp/ip crash linux linux tpc/ip crash windows linux tcp/ip ok linux windows tcp/ip ok windows windows local ok linux linux local ok if you need more information, you can contact me on pba...@ho... kloo Jean Lacoste, the author of the C sample comments : When debugging in Linux, when the error happens, the debugger displays an error of typesegmentation fault at line 61 of memcopy.c (found in sysdeps/generic). It seems that memcpy is called with its 2nd parameter, sources, set to NULL. |
|
From: Kloo <PBa...@ho...> - 2001-09-25 08:00:44
|
Hi, Nobody is interested by this bug that run since five years ? kloo ""Kloo"" <PBa...@ho...> a écrit dans le message news: 9nmhq1$buk$1...@ne...... > Hi, > > We have a test case that reproduces the following bug : > http://sourceforge.net/tracker/index.php?func=detail&aid=233025&group_id=902 > 8&atid=109028 > there is the descritpion of a bug of priority 9 : > "This is an old bug which goes back to v. 5.x as well" > > We have a gdb, a program written in C and another in delphi that reproduces > the bug: > > For this, you can downlad the gdb sample on : > http://www.vienneinfo.org/delphi/zip/3.gdbIBBug.zip > (50 Ko) > and the source of the sample in C : > http://www.vienneinfo.org/delphi/zip/tstc.cpp > (8 Ko) > This is a translation of my Delphi sample that uses IBX 4.62 : > http://www.vienneinfo.org/delphi/zip/bugib.zip > (52 Ko : Delphi 5 source + gdb sample) > > > What we know today : > > in 3.gdb, there are two stored procedures: SP 002 and SP 011 > > if we start with SP 002 it works since the last input parameter is an > integer. > if we start with SP 011 where there is only one VARCHAR input parameter, > then we alternate with SP 002 then SP 011 again => crash. > if we only run SP 011 N times : it works well... > > with IB local (without TCP/IP) : no trouble in all cases > > with IB Server AND Client on the same computer, with TCP/IP => trouble > The C Sample has got the same trouble on Windows or Linux... > > More strange : > > With one computer as Server (under Windows) and another computer as Client > (under Linux) : No trouble ! :-( > It also works with Linux as server and Windows as client. > > Summarry : > > client server protocol result > --------------------------------------- > windows windows tcp/ip crash > linux linux tpc/ip crash > windows linux tcp/ip ok > linux windows tcp/ip ok > windows windows local ok > linux linux local ok > > > if you need more information, you can contact me on pba...@ho... > > > kloo > > > Jean Lacoste, the author of the C sample comments : > When debugging in Linux, when the error happens, the debugger displays an > error of > typesegmentation fault at line 61 of memcopy.c (found in sysdeps/generic). > It seems that memcpy > is called with its 2nd parameter, sources, set to NULL. > > > > > > _______________________________________________ > Firebird-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-devel > |
|
From: <sch...@t-...> - 2001-09-25 17:55:56
|
On Tue, 25 Sep 2001 04:27:37 +0000 (UTC), PBa...@ho...
("Kloo") wrote:
>Hi,
>
>Nobody is interested by this bug that run since five years ?
>
>kloo
You should submit your information at the bug tracker at
http://sourceforge.net/tracker/?func=add&group_id=9028&atid=109028
this will ensure that it is recognized. News messages are floating by
when nobody has the time to react properly (Ok. this may be my problem
only).
Frank
"Fascinating creatures, phoenixes. They can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
http://firebirdsql.org
|
|
From: Kloo <PBa...@ho...> - 2001-09-25 18:33:22
|
"Frank Schlottmann-Goedde" <sch...@t-...> a écrit dans le message news: 3bb...@ne...... Hi, > You should submit your information at the bug tracker at > http://sourceforge.net/tracker/?func=add&group_id=9028&atid=109028 > > this will ensure that it is recognized. News messages are floating by > when nobody has the time to react properly (Ok. this may be my problem > only). ok for the news messages... But I don't understand why put again et description since there is already one by Helen Borrie on : http://sourceforge.net/tracker/?group_id=9028&atid=109028&func=detail&aid=23 3025 what's new now : A sample that show this strange bug download on : http://www.vienneinfo.org/delphi/zip/?M=D I can't track it since C is to hard for my little brain ;-)) but I would like to help... kloo |
|
From: <sch...@t-...> - 2001-09-26 05:44:53
|
On Tue, 25 Sep 2001 14:42:03 +0000 (UTC), PBa...@ho...
("Kloo") wrote:
>But I don't understand why put again et description since there is already
>one by Helen Borrie on :
>http://sourceforge.net/tracker/?group_id=9028&atid=109028&func=detail&aid=23
>3025
I have added your description and links to this bug entry at sf, so
that the test cases will be available for the one who will work on
this bug.
Frank
"Fascinating creatures, phoenixes. They can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
http://firebirdsql.org
|
|
From: <no...@so...> - 2001-09-26 05:39:22
|
Bugs item #233025, was opened at 2001-02-18 15:58 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=233025&group_id=9028 Category: Core Engine Group: Confirmed Bug Status: Open Resolution: None Priority: 9 Submitted By: Helen Borrie (helebor) Assigned to: Nobody/Anonymous (nobody) Summary: Server hangs when executing Stored Proc more than once Initial Comment: When executing a SP inside a loop that accepts input parameters, the server hangs on the second iteration if the statement is not unprepared and re-prepared between iterations. This is an old bug which goes back to v. 5.x as well. Note that, if you add a SUSPEND statement at the end of the SP and return a dummy parameter, you can multi-call the SP with SELECT instead of EXECUTE without the need to do the unprepare/prepare when passing subsequent sets of inputs. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2001-09-25 22:39 Message: Logged In: NO pba...@ho... provided the following testcase for this bug in 9nmhq1$buk$1...@ne... Hi, We have a test case that reproduces the following bug : http://sourceforge.net/tracker/index.php? func=detail&aid=233025&group_id=902 8&atid=109028 there is the descritpion of a bug of priority 9 : "This is an old bug which goes back to v. 5.x as well" We have a gdb, a program written in C and another in delphi that reproduces the bug: For this, you can downlad the gdb sample on : http://www.vienneinfo.org/delphi/zip/3.gdbIBBug.zip (50 Ko) and the source of the sample in C : http://www.vienneinfo.org/delphi/zip/tstc.cpp (8 Ko) This is a translation of my Delphi sample that uses IBX 4.62 : http://www.vienneinfo.org/delphi/zip/bugib.zip (52 Ko : Delphi 5 source + gdb sample) What we know today : in 3.gdb, there are two stored procedures: SP 002 and SP 011 if we start with SP 002 it works since the last input parameter is an integer. if we start with SP 011 where there is only one VARCHAR input parameter, then we alternate with SP 002 then SP 011 again => crash. if we only run SP 011 N times : it works well... with IB local (without TCP/IP) : no trouble in all cases with IB Server AND Client on the same computer, with TCP/IP => trouble The C Sample has got the same trouble on Windows or Linux... More strange : With one computer as Server (under Windows) and another computer as Client (under Linux) : No trouble ! :-( It also works with Linux as server and Windows as client. Summarry : client server protocol result --------------------------------------- windows windows tcp/ip crash linux linux tpc/ip crash windows linux tcp/ip ok linux windows tcp/ip ok windows windows local ok linux linux local ok if you need more information, you can contact me on pba...@ho... kloo Jean Lacoste, the author of the C sample comments : When debugging in Linux, when the error happens, the debugger displays an error of typesegmentation fault at line 61 of memcopy.c (found in sysdeps/generic). It seems that memcpy is called with its 2nd parameter, sources, set to NULL. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=233025&group_id=9028 |
|
From: <no...@so...> - 2001-12-10 07:13:44
|
Bugs item #233025, was opened at 2001-02-18 15:58 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=233025&group_id=9028 >Category: DSQL >Group: Fixed v1.0 >Status: Closed >Resolution: Fixed Priority: 9 Submitted By: Helen Borrie (helebor) >Assigned to: Ann W. Harrison (awharrison) Summary: Server hangs when executing Stored Proc more than once Initial Comment: When executing a SP inside a loop that accepts input parameters, the server hangs on the second iteration if the statement is not unprepared and re-prepared between iterations. This is an old bug which goes back to v. 5.x as well. Note that, if you add a SUSPEND statement at the end of the SP and return a dummy parameter, you can multi-call the SP with SELECT instead of EXECUTE without the need to do the unprepare/prepare when passing subsequent sets of inputs. ---------------------------------------------------------------------- >Comment By: Claudio Valderrama C. (robocop) Date: 2001-12-09 23:13 Message: Logged In: YES user_id=62823 Ann posted a temporary fix that stops the confusion in the DSQL layer regarding the correct statement to be executed with the "immed" API calls. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2001-09-25 22:39 Message: Logged In: NO pba...@ho... provided the following testcase for this bug in 9nmhq1$buk$1...@ne... Hi, We have a test case that reproduces the following bug : http://sourceforge.net/tracker/index.php? func=detail&aid=233025&group_id=902 8&atid=109028 there is the descritpion of a bug of priority 9 : "This is an old bug which goes back to v. 5.x as well" We have a gdb, a program written in C and another in delphi that reproduces the bug: For this, you can downlad the gdb sample on : http://www.vienneinfo.org/delphi/zip/3.gdbIBBug.zip (50 Ko) and the source of the sample in C : http://www.vienneinfo.org/delphi/zip/tstc.cpp (8 Ko) This is a translation of my Delphi sample that uses IBX 4.62 : http://www.vienneinfo.org/delphi/zip/bugib.zip (52 Ko : Delphi 5 source + gdb sample) What we know today : in 3.gdb, there are two stored procedures: SP 002 and SP 011 if we start with SP 002 it works since the last input parameter is an integer. if we start with SP 011 where there is only one VARCHAR input parameter, then we alternate with SP 002 then SP 011 again => crash. if we only run SP 011 N times : it works well... with IB local (without TCP/IP) : no trouble in all cases with IB Server AND Client on the same computer, with TCP/IP => trouble The C Sample has got the same trouble on Windows or Linux... More strange : With one computer as Server (under Windows) and another computer as Client (under Linux) : No trouble ! :-( It also works with Linux as server and Windows as client. Summarry : client server protocol result --------------------------------------- windows windows tcp/ip crash linux linux tpc/ip crash windows linux tcp/ip ok linux windows tcp/ip ok windows windows local ok linux linux local ok if you need more information, you can contact me on pba...@ho... kloo Jean Lacoste, the author of the C sample comments : When debugging in Linux, when the error happens, the debugger displays an error of typesegmentation fault at line 61 of memcopy.c (found in sysdeps/generic). It seems that memcpy is called with its 2nd parameter, sources, set to NULL. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=109028&aid=233025&group_id=9028 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X