Re: Mysql time out?
Re: Mysql time out?
- Subject: Re: Mysql time out?
- From: Kieran Kelleher <email@hidden>
- Date: Fri, 09 Nov 2012 08:32:59 -0500
Yes, just add autoReconnect to the URL, for example:
MyModel.URL=jdbc:mysql://myhost/mydatabase?capitalizeTypenames=true&useBundledJdbcInfo=true&autoReconnect=true
On Nov 9, 2012, at 6:00 AM, Jean Pierre Malrieu <email@hidden> wrote:
> Hi,
>
> I am authenticating a user from another application. I receive the login from the other app, and let the user in.
>
> I am seing this error in my logs:
>
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:254) DEBUG org.apache.http.impl.conn.DefaultClientConnection - Receiving response: HTTP/1.1 200 OK
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:257) DEBUG org.apache.http.headers - << HTTP/1.1 200 OK
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Date: Fri, 09 Nov 2012 09:18:20 GMT
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Server: Apache/2.2.14 (Ubuntu)
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << X-Powered-By: PHP/5.3.2-1ubuntu4.17
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Set-Cookie: symfony=eip1msbqf1tut82mtmkjgue527; path=/
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Expires: Thu, 19 Nov 1981 08:52:00 GMT
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Pragma: no-cache
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Content-Length: 50
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Keep-Alive: timeout=15, max=100
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Connection: Keep-Alive
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG org.apache.http.headers - << Content-Type: application/json
> Nov 09 10:17:53 grf[2001] (ResponseProcessCookies.java:122) DEBUG org.apache.http.client.protocol.ResponseProcessCookies - Cookie accepted: "[version: 0][name: symfony][value: eip1msbqf1tut82mtmkjgue527][domain: api.iepei.com][path: /][expiry: null]".
> Nov 09 10:17:53 grf[2001] (DefaultRequestDirector.java:540) DEBUG org.apache.http.impl.client.DefaultHttpClient - Connection can be kept alive for 15000 MILLISECONDS
> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << "{[\n]"
> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << " "user" : [\n]"
> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << "[0x9][0x9]{[\n]"
> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << "[0x9][0x9][0x9]"login": [0x9][0x9]"ehernand"[\n]"
> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << "[0x9] }[\n]"
> Nov 09 10:17:53 grf[2001] (Wire.java:77) DEBUG org.apache.http.wire - << "}"
> Nov 09 10:17:53 grf[2001] (BasicClientConnectionManager.java:189) DEBUG org.apache.http.impl.conn.BasicClientConnectionManager - Releasing connection org.apache.http.impl.conn.ManagedClientConnectionImpl@1110b542
> Nov 09 10:17:53 grf[2001] (BasicClientConnectionManager.java:219) DEBUG org.apache.http.impl.conn.BasicClientConnectionManager - Connection can be kept alive for 15000 MILLISECONDS
> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:169) DEBUG org.apache.http.impl.conn.DefaultClientConnection - Connection 0.0.0.0:58398<->91.121.57.9:80 closed
> Nov 09 10:17:53 grf[2001] (ERXDatabaseContextDelegate.java:184) INFO er.transaction.adaptor.Exceptions - Database Exception occured: No operations allowed after connection closed.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 41,690,527 milliseconds ago. The last packet sent successfully to the server was 41,690,527 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>
> I don't understand why I get this error...
> Should I set JConnector property as advised? If the answer is yes, do I do this in the database url?
>
> Thanks in advance for your help.
>
> JPM
>
>
>
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden