Odd - maybe this never made it to the list?
---------- Forwarded message ---------- From: Cameron Childress <[email protected]> Date: Wed, Jul 8, 2009 at 1:16 PM Subject: Re: [AFFUG Discuss] ColdFusion and MySQL To: [email protected] Cc: Nicholas Kwiatkowski <[email protected]> On Wed, Jul 8, 2009 at 10:13 AM, Clarke Bishop<[email protected]> wrote: > I am troubleshooting an application that uses ColdFusion 8 and MySQL. > Intermittently, it throws the error below. Clarke - This was recently brought up on another mailing list - here is the most useful reply I found in the thread - along with two potential fixes. -Cameron ---------- Forwarded message ---------- From: Nicholas Kwiatkowski <[email protected]> Date: Wed, Jun 17, 2009 at 2:10 PM Subject: RE: mysql, CF8 and "maintain connections" Mark, This is particular with certain versions of MySQL. MySQL decided to change the way that compression happens within their protocol, which essentially means that if you plan on using compression (which the baked-in connector in CF does), things get broken. In particular, what I’ve found is that if a connection stays idle for more than 30 seconds, the server closes the connection, but doesn’t notify the client (ColdFusion). The result is the connection in ColdFusion tries to push data down a pipe that is closed, and you get the Java error. This can be fixed by one of two ways : - Turn off the maintain connections. This means that a new TCP socket will be connected for each query outside a transaction. This can cause some overhead, but is not a big deal for 95% of the ColdFUsion servers out there. - Install the latest MySQL/J Connector, and use the CFMX7 instructions to connect to mySQL (raw connection to java). This is a good fix for the issue. This effects all mySQL servers over 5.2 I believe (I may be wrong on this one, but I know it was somewhere in mysql 5 that it happened) -Nick -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [email protected] -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [email protected] ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
