Re: [Sqlrelay-discussion] Unknown prepared statement handler?
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Unknown prepared statement handler?
|
From: <ni...@sk...> - 2009-04-16 21:58:30
|
Hi Dave, Thanks for the info. I haven't managed to run the tests yet, but I'll let you know what I find. I've got another couple of questions... Possible string length issue? ----------------------------- I know it seems unlikely, but there isn't a 100 character limit for paths is there? I'm seeing the listener fail to start up when the path to the .../tmp/sockets directory exceeds 99 chars (presumably there's a null terminator). Unfortunately the error has scrolled off my screen, but it was along the lines of: 'could not listen on unix socket : trscxpool-handoff' followed by a gripe about a double free operation from glibc. NB - 'trscxpool' is the ID from the configuration file. When I looked into the tmp/sockets directory I saw the file was present, but truncated so it looked like this: trscxpool-= instead of : trscxpool-handoff= I then moved to a shorter path and recompiled and things went fine. The file was created and the tool worked just fine. I've taken a look through the code and I can't see an obvious string length issue (it's great to see that you've put a lot of effort into avoiding the coredump magnet of string.h :-) ) but I might be missing something. Parameterizing the /tmp directory --------------------------------- I can see in the code that it appears to be possible to parameterize where the /tmp directory lives. How would I do that, assuming that I'm using the sqlr-start utility? Thanks again for your help, Nick > SQL Relay does have a list of error codes, where if a query returns that > error, then SQL Relay says "oh, the connection must be down". Then it > reconnects and runs the query again. > > Every now and then, when a new version of the database comes out, there > are new error conditions that SQL Relay isn't aware of. This could be > one of those. > > If you can figure out exactly how to reproduce it, I can fix it and get > you a patch. > > Dave > > On Thu, 2009-04-16 at 11:09 -0400, ni...@sk... wrote: >> Hi Folks, >> >> I have an idea what the problem may be... The database engine itself is >> disconnecting the connections to SqlRelay. >> >> MySQL has a connection life timeout (I think it's 4 hours, by default). >> Once that time expires the connections are killed from the server side. >> >> Do you know if SqlRelay knows about behaviour and tries to re-animate >> connections? >> >> I'll try to do a few tests and see if I can reproduce the issue by >> tweaking the timeout on the server side. >> >> Thanks, >> >> >> Nick >> >> >> >> > We had this problem (although different error message as we were >> talking >> > to DB2) and the Cisco FWSM timing out TCP sessions was the culprit. I >> > think we set something up on the OS to twiddle the TCP keepalives so >> that >> > the FWSM saw enough traffic to keep the things going. If this sounds >> like >> > what might be causing your problem I can get the firewall and OS folks >> to >> > give me the details of exactly what they did... >> > >> > -----Original Message----- >> > From: David Muse [mailto:dav...@fi...] >> > Sent: Tuesday, April 14, 2009 1:06 PM >> > To: Discussion of topics related to SQL Relay >> > Subject: Re: [Sqlrelay-discussion] Unknown prepared statement handler? >> > >> > It sounds like something between SQL Relay and the DB is disconnecting >> > the 2 of them from each other if they've been idle. A common culprit >> is >> > a Cisco PIX firewall. Is there a Cisco PIX firewall between SQL Relay >> > and the DB? >> > http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang >> > >> > Aside from that, I can't think of anything that could cause that to >> > happen. >> > >> > Dave Muse >> > dav...@fi... >> > >> > >> > ------------------------------------------------------------------------------ >> > This SF.net email is sponsored by: >> > High Quality Requirements in a Collaborative Environment. >> > Download a free trial of Rational Requirements Composer Now! >> > http://p.sf.net/sfu/www-ibm-com >> > _______________________________________________ >> > Sqlrelay-discussion mailing list >> > Sql...@li... >> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> > >> >> >> >> ------------------------------------------------------------------------------ >> Stay on top of everything new and different, both inside and >> around Java (TM) technology - register by April 22, and save >> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. >> 300 plus technical and hands-on sessions. Register today. >> Use priority code J9JMT32. http://p.sf.net/sfu/p >> _______________________________________________ >> Sqlrelay-discussion mailing list >> Sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> __________________________________________________ >> D O T E A S Y - "Join the web hosting revolution!" >> http://www.doteasy.com > > > __________________________________________________ > D O T E A S Y - "Join the web hosting revolution!" > http://www.doteasy.com > > ------------------------------------------------------------------------------ > Stay on top of everything new and different, both inside and > around Java (TM) technology - register by April 22, and save > $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. > 300 plus technical and hands-on sessions. Register today. > Use priority code J9JMT32. http://p.sf.net/sfu/p > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
