Re: [Sqlrelay-discussion] Unknown prepared statement handler?

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

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