Re: [Sqlrelay-discussion] sqlr-status and ps aux doesn't show the same number of connections

[BlacKarma <bla...@gm...>]

Great, I'll wait David's reply before try this.

Thanks a lot Martin.


2008/6/4 Martin Fleurke <mar...@po...>:

> BlacKarma schreef:
>
>> Hi everybody,
>>
>> I'm experiencing some problem using SqlRelay (0.39.4) over Oracle 10g.
>> SqlRelay start and after a while the listener fork but the open client
>> connection is less than the open server connection and when a check with a
>> "ps aux" the number of process is less than the open server connection
>> displayed by sqlr-status.
>>
> Probably the same bug we found and reported, but David hasn't responded on
> it yet.
>
> Here is my previous email:
>
> 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
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>