Re: [Firebird-devel] [ BUG #233025 ] Server hangs when executing Stored Proc more than once

[Kloo <PBa...@ho...>]

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
>