Comment 26 for bug 1243551

Revision history for this message
James Lang (sit1way-s) wrote :

@wwadge, good to hear the desire to right the ship.

I'll try to set maxConnectionAge to 0 as suggested.

Should note that prior to launching Play 2.2.1 app with 0.8.1-snapshot, I did not restart MySQL (thought I did), so perhaps there were a couple of idle connections that MySQL was on the verge of (8 hour idle timeout) closing?

After shutting down Play, restarting MySQL, and starting Play with maxConnectionAge set to current Play 60 minute default, have gone nearly 2 hours error free. Going to leave "flawed" config in place for a bit longer and see if/when next transient connection error occurs.

Hopefully 0.8.1 prepared statement fix is the solution in the end.

Will post back results a bit later.

Thanks again for providing a crucial component in our stack.