CAS - DataAccessResourceFailureException

[Mihai]

Hi,

I have a problem using the CAS server(tested under glassfish):

<exception>

typeException report 
message
descriptionThe 
server encountered an internal error () that prevented it from fulfilling this 
request. 
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction at 862dc1 targetAction = org.jasig.cas.web.flow.AuthenticationViaFormAction at 4e3801, attributes = map['method' -> 'submit']] in state 'submit' of flow 'login-webflow' -- action execution attributes were 'map['method' -> 'submit']'; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [Select count('x') from user Where username = ? And passwd = ?]; The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.; nested exception is com.mysql.jdbc.CommunicationsException: The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.
root 
cause
org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction at 862dc1 targetAction = org.jasig.cas.web.flow.AuthenticationViaFormAction at 4e3801, attributes = map['method' -> 'submit']] in state 'submit' of flow 'login-webflow' -- action execution attributes were 'map['method' -> 'submit']'; nested exception is org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [Select count('x') from user Where username = ? And passwd = ?]; The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.; nested exception is com.mysql.jdbc.CommunicationsException: The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.
root 
cause
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [Select count('x') from user Where username = ? And passwd = ?]; The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.; nested exception is com.mysql.jdbc.CommunicationsException: The last packet successfully received from
 the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.
root 
cause
com.mysql.jdbc.CommunicationsException: The last packet successfully received from the server was56636 milliseconds ago.The last packet sent successfully to the server was 56636 milliseconds ago, which  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.
root 
cause
java.net.SocketException: Software caused connection abort: socket write error
noteThe 
full stack traces of the exception and its root causes are available in the 
GlassFish/v3 logs. 
</exception>

This happens most frequently but not always while the user trying to login.
Thanks.


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://tp.its.yale.edu/pipermail/cas/attachments/20090122/c48e556b/attachment.html