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

[<ni...@sk...>]

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
>