[jira] [Commented] (OPENMEETINGS-488) MySQL timeouts

["Mikael Kurula (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENMEETINGS-488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13528809#comment-13528809 ] 

Mikael Kurula commented on OPENMEETINGS-488:
--------------------------------------------

How do you propose I set the timeout? Did you notice the following sentence? " The last packet successfully received from the server was 90,881,924 milliseconds ago." That's quite a long time.
                
> MySQL timeouts
> --------------
>
>                 Key: OPENMEETINGS-488
>                 URL: https://issues.apache.org/jira/browse/OPENMEETINGS-488
>             Project: Openmeetings
>          Issue Type: Bug
>    Affects Versions: 2.0 Apache Incubator Release
>            Reporter: Mikael Kurula
>
> I sometimes run into problems with MySQL timeouts because of inactivity overnight, getting the following error message in the openmeetings.log:
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 90,881,924 milliseconds ago.  The last packet sent successfully to the server was 90,881,924 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.
> I don't know if it is related or not, but these errors showed up when I finished a test recording. Then when I tried to go and watch the recording, I only get "The recording is not yet ready for watching" and it seems the recording didn't consume any disk space.
> I posted this to the openmeetings-user list, and got the following response from another user: "There is a connection between this error (or info) and recording and sharing of the OM (or I guess like that). I have the same problem on recordings and I am taking same response about com.mysql.jdbc... kind of reports from the system. I have also checked that  "autoReconnect=true" option is already given on the connection string and also checked the permission or the connection of mysql server but could not find a proper solution.  Is there a bit more specific information about error message?"
> By googling I found these discussions:
> http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+MySQL
> http://www.coderanch.com/t/564390/Tomcat/CommunicationsException-tomcat-mysql
> I would assume this is the problem. Can the solution outlined in the first link solve the problem for OM as well?
> After a while Solomax chimed in with: "We are using OpenJPA (not Hibernate)
> and already have "TestOnBorrow=true" and DB connection pool :(
> not sure what else can be done ... Never saw such exception on my machines :("
> If it's of any help, then I'm using a CentOS 6 server with the following version of mysql:
> mysql  Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using readline 5.1
> My version of openmeetings is this:
> apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz
> ... and the version of the J connector is mysql-connector-java-5.1.22.tar.gz.
> For the time being I'll try to work around this by switching back to Derby. I don't expect a very heavy load and I don't need to query the database while OM is running.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira