Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

[Martin F. <mar...@po...>]

Hello David,

Just an update for this reported bug: we have commented the line 1658 
(with "OCIHandleFree(def[i],OCI_HTYPE_DEFINE);") and haven't had any 
problems since, we are using the code in production enviroment for 2 
months. So I'd say: you can safely update the sourcecode of sqlrelay, to 
prevent the connection-crash-bug that was bugging us.

Regards,

Martin Fleurke

Ingmar Brouns schreef:
> Hi David,
>
> I have been trying to debug what's going on. The connection process
> crashes on this statement
>
>                 OCIHandleFree(def[i],OCI_HTYPE_DEFINE);
>
> line 1744 of oracle8connection.C with a segmentation fault. I've not
> been able to figer out why this happens. I am new to C++ and GDB and I
> cannot view the contents of the OCIDefine object. However, when I
> looked into the Oracle Call Interface Programmer's Guide
>
> http://www.ewp.rpi.edu/hartford/webgen//appdocs/oracle/doc/appdev.920/a96584/oci02bas.htm
>
> it said the following:
>
> OCI_HTYPE_DEFINE = OCI define handle
>
> and
>
> Bind and define handles are freed when the statement handle is freed
> or when a new statement is prepared on the statement handle.
>
> So my question is, why is it being freed explicitly anyway? I've
> compiled sqlrelay with the statement commented out, and now everything
> seems to be going fine. For what situations is the
> OCIHandleFree(def[i],OCI_HTYPE_DEFINE) statement neccesary?
>
> Anxiously awaiting your reply,
>
> Ingmar
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>