• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Mysql time out?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Mysql time out?

  • Subject: Mysql time out?
  • From: Jean Pierre Malrieu <email@hidden>
  • Date: Fri, 09 Nov 2012 12:00:37 +0100
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
  • Follow-Ups:
    • Re: Mysql time out?
      • From: Kieran Kelleher <email@hidden>
  • Prev by Date: Re: Quick question about custom D2W Pages
  • Next by Date: Re: Mysql time out?
  • Previous by thread: Freeze Panes like Excel
  • Next by thread: Re: Mysql time out?
  • Index(es):
    • Date
    • Thread