Re: [Sqlrelay-discussion] =?GB2312?Q?=BB=D8=B8=B4: [Spam] =BB=D8=B8=B4=A3=BA I got the following er
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] =?GB2312?Q?=BB=D8=B8=B4: [Spam] =BB=D8=B8=B4=A3=BA I got the following error, any idea??=
|
From: David M. <dav...@fi...> - 2007-09-05 14:44:01
|
Aaah, I recently added a call to that stored procedure to get the version of the db server at startup. Looks like sp_version is only valid in sybase db's, not in MS SQL Server. Odd that not finding it causes the connection to eat up a bunch of memory. I'll fix that though and put out an update. This looks like a good workaround though. Dave dav...@fi... On Fri, 2007-08-31 at 23:47 +0800, wmins wrote: > I got same problem as u, my solution is write 'sp_version' myself. The create sql is: > > CREATE proc [dbo].[sp_version] > @script varchar(50)=null, > @type varchar(50)=null > as > select 'TopView' > > return > > By the way, please tell me the Memory use status when ur 'sqlr-connection-freetds ' started successfully > > > > > -----Original message----- > From: "邱 承" cnm...@ya... > Date: Sat, 1 Sep 2007 12:38:45 +0800 > To: sqlrelay sql...@li... > Subject: [Spam] [Sqlrelay-discussion]回复： I got the following error, any idea? > > > The problem has been worked around. I add a stored procedure named sp_versi> on in the DB connected. That's all. I don't know why the sqlr-connect keeps> try to call this stored procedure. I guess 'sp_version' is a stored proce> dure in Sybase, but don't exist in SQL2k. > > any idea? > > > ----- ?gt; 始邮?---- > 发件人： "邱 承" <cnma> rk...@ya...> > 收件人： sql...@li...> eforge.net; cnm...@ya...; 邱 承 <qiu...@cs...> > ?gt; 逊⑺停?2007/8/28(周二), 下午6:17:52 > 主> 题： I got the following error, any idea? > > > I used sql-relay > 0.39.2 to connect to a sql server 2k server. The following is my sqlrelay.> conf: > <instances> > <!-- Regular SQL Relay Instance --> > > <instance id="example" port="9000" socket="/tmp/example.socket" dbas> e="f > reetds" connections="3" maxconnections="15" maxqueuelength="> 5" growby="1" ttl="6 > 0" endofsession="commit" sessiontimeout="600> " runasuser="nobody" runasgroup="nob > ody" cursors="5" authtier="l> istener" handoff="pass" deniedips="" allowedips="" d > ebug="connec> tion" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbin > > dvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listene> rtimeout="0 > " reloginatstart="false"> > <users> > > <user user="user1" password="password1"/> > > <user user="user2" password="password2"/> > > <user user="user3" password="password3"/> > > </users> > <connections> > <con> nection connectionid="db1" string="sybase=/etc/freet > ds;user=sa;p> assword=***;server=MyServer2k;db=run;" metric="1" behindloadbalan> > cer="no"/> > </connections> > </instance> > > > Then, after started by "sqlr-start -id example", I got the following err> ors: > Server Name: > JF-WEBJY-TEST2 > Procedure Name: > Error: Could not > find stored procedure 'sp_version'. > Couldn't create cursors. > *** glibc > detected *** free(): invalid pointer: 0xb7fd0000 *** > sqlr-connection-fr> eetds -id example -connectionid db1 -config /usr/local/fi > works/etc/sqlre> lay.conf > Server message: > severity(10) > number(252) > > state(62) > line(1) > > Could anybody help me? > > > > > 雅虎免费邮箱，全球第一邮?gt; 淦放疲? > > _______________________________________> ____________________ > 雅虎免费邮箱，全?gt; 虻谝挥氏淦放疲? > http://mail.yahoo.com.cn/ > > > ------------------------------------------------------------------------- > 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 |
