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

Abhinandan Prateek commented on CLOUDSTACK-9460:
------------------------------------------------

This issue has been intermittently being hit, but due to no easy way to 
reproduce it, it has been closed without a fix.

https://issues.apache.org/jira/browse/CLOUDSTACK-2616
https://issues.apache.org/jira/browse/CLOUDSTACK-4878

The issue is that for a long running transaction like that of a snapshot that 
runs into several hours, cloudstack holds the db connection for all that 
duration.  The operation succeeds on the cloud resource but when MS tries to 
update the db it fails as the mysql connection it was holding has timed out.

estrator.prepare(VolumeOrchestrator.java:1322)
6023 at 
com.cloud.vm.VirtualMachineManagerImpl.orchestrateStart(VirtualMachineManagerImpl.java:988)
6024 at 
com.cloud.vm.VirtualMachineManagerImpl.orchestrateStart(VirtualMachineManagerImpl.java:4481)
6025 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
6044 Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 
Communications link failure
6045 
6046 The last packet successfully received from the server was 2,101,970 
milliseconds ago. The last packet sent successfully to the server was 0 
milliseconds ago.
..
6063 ... 52 more
6064 Caused by: java.io.EOFException: Can not read response from server. 
Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
6065 ... 67 more
...

> Graceful handling of Mysql server connection timeout
> ----------------------------------------------------
>
>                 Key: CLOUDSTACK-9460
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9460
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the 
> default.) 
>          Components: Management Server
>    Affects Versions: 4.9.0
>            Reporter: Abhinandan Prateek
>            Assignee: Abhinandan Prateek
>             Fix For: 4.9.1
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to