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

[David M. <dav...@fi...>]

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