Re: [Sqlrelay-discussion] Unknown prepared statement handler?
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Unknown prepared statement handler?
|
From: David M. <dav...@fi...> - 2009-04-29 15:43:02
|
Hello Nick, I'm not aware of a 100 character limit for paths. It's possible that somewhere up inside of glibc there is. Is it the socket that the listener is listening on that's giving you trouble? The default temp directory is /usr/local/firstworks/var/sqlrelay/tmp, but you can override the /usr/local/firstworks/var part of it using the -localstatedir option of sqlr-start. For example: sqlr-start -id myinstance -localstatedir /home/myinstance will cause the various temp files to be created under /home/myinstance/sqlrelay/tmp I don't remember whether the sqlrelay/tmp part will be created or whether you have to create it yourself though :) Dave dav...@fi... On Thu, 2009-04-16 at 17:58 -0400, ni...@sk... wrote: > 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 > > > > > > ------------------------------------------------------------------------------ > 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 |
