Re: [Sqlrelay-discussion] Why the Opened Server Connections keep increasing?

[Zhuguo S. <blu...@gm...>]

I am using MySQL. And recently we found out it might because we didn't free
the variables. We use stored procedure in our project, and at first we did
not use 'sqlrcur_free' or 'sqlrcon_endSession' to release the resources.
When we added them to our code, it is much better. Could you please give me
some more details on 'sqlrcur_free' and 'sqlrcon_endSession' or any related
functions?

On 9/8/07, David Muse <dav...@fi...> wrote:
>
> That's very strange.  The opened server connections should only increase
> if sqlrelay has decided that it needs to open new connections to handle
> a flood of incoming client requests.  Sounds like a bug.
>
> What db are you using?  I'll see if I can figure out what's going on.
>
> Actually, are you using MS SQL Server?  If so, you may find that the
> issue is really a missing stored procedure sp_version.  In the newest
> version of SQL relay, it tries to run that procedure to get the version
> of the database at startup.  Sybase has that procedure, but MS SQL
> Server doesn't and it causes problems.  There are 2 workarounds:
>
>
> * add a sp_version stored procedure to the db which returns some bogus
> string of data.
> * comment out lines 409-424 in src/connections/freetds/freetds.C and
> replace them with:
>         freetdsconn->dbversion=charstring::duplicate("unknown");
>
> I'm going to fix that problem and get an update out soon.
>
> Let me know if that turns out to be the issue or not.
>
> David Muse
> dav...@fi...
>
> On Fri, 2007-08-31 at 21:42 +0800, Zhuguo Shi wrote:
> > When I use the SQL 'set names utf8' through sqlrealy, sometimes
> > sqlrelay doesn't response. I use 'sqlr-status' command to check what's
> > going on, the Opened Server Connections are keeping incrsasing. Some
> > one can help me?
> >
> > and I use 'sqlrcon_ping' to test if the connection is established, is
> > that right?
> >
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________ Sqlrelay-discussion
> mailing list Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>