[
https://issues.apache.org/jira/browse/CLOUDSTACK-9595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16298170#comment-16298170
]
ASF GitHub Bot commented on CLOUDSTACK-9595:
--------------------------------------------
rhtyd commented on issue #1762: CLOUDSTACK-9595 Transactions are not getting
retried in case of datab…
URL: https://github.com/apache/cloudstack/pull/1762#issuecomment-353012327
@yvsubhash given this has introduced a regressions in snat IP allocation I'm
consider this for a revert unless you can help with a quick fix to unblock
other PRs being merged.
The failure found was:
```
test_01_vpc_remote_access_vpn
(integration.smoke.test_vpc_vpn.TestVpcRemoteAccessVpn): DEBUG: ========Sending
GET Cmd : createRemoteAccessVpn=======
urllib3.connectionpool: DEBUG: Starting new HTTP connection (1): localhost
urllib3.connectionpool: DEBUG: http://localhost:8080 "GET
/client/api?account=test-TestRVPCSite2SiteVpn-CRVT35&domainid=838a592d-e4dc-11e7-9c0d-a434d91cd37e&fordisplay=true&publicipid=2df812b1-57a6-470a-a4db-472afed287df&response=json&apiKey=nG25osQQTwT630F9niTxS9j5qX4cVRv8PKQ80jXskQ2BmMPvTulGySL0H2sh4OjNX0SOZWcEVyMN2vkUw5lorQ&command=createRemoteAccessVpn&signature=S6MoFQwy4UKI6CbYTBffqENjVHg%3D&iprange=10.3.2.1-10.3.2.10
HTTP/1.1" 431 155
test_01_vpc_remote_access_vpn
(integration.smoke.test_vpc_vpn.TestVpcRemoteAccessVpn): ERROR:
Exception:['Traceback (most recent call last):\n', ' File
"/usr/local/lib/python2.7/dist-packages/marvin/cloudstackConnection.py", line
308, in __parseAndGetResponse\n response_cls)\n', ' File
"/usr/local/lib/python2.7/dist-packages/marvin/jsonHelper.py", line 150, in
getResultObj\n raise cloudstackException.CloudstackAPIException(respname,
errMsg)\n', 'CloudstackAPIException: Execute cmd: createremoteaccessvpn failed,
due to: errorCode: 431, errorText:The Ip address is not ready to be used yet:
172.20.20.16\n']
```
The issue can be reproduced by creating a VPN and deploying a VM on a tier.
You'll still see the SNAT ip marked as Allocating and this causes creation of
VPN to fail.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Transactions are not getting retried in case of database deadlock errors
> ------------------------------------------------------------------------
>
> Key: CLOUDSTACK-9595
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9595
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.8.0
> Reporter: subhash yedugundla
> Fix For: 4.8.1
>
>
> Customer is seeing occasional error 'Deadlock found when trying to get lock;
> try restarting transaction' messages in their management server logs. It
> happens regularly at least once a day. The following is the error seen
> 2015-12-09 19:23:19,450 ERROR [cloud.api.ApiServer]
> (catalina-exec-3:ctx-f05c58fc ctx-39c17156 ctx-7becdf6e) unhandled exception
> executing api command: [Ljava.lang.String;@230a6e7f
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> com.mysql.jdbc.JDBC4PreparedStatement@74f134e3: DELETE FROM
> instance_group_vm_map WHERE instance_group_vm_map.instance_id = 941374
> at com.cloud.utils.db.GenericDaoBase.expunge(GenericDaoBase.java:1209)
> at sun.reflect.GeneratedMethodAccessor360.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at
> com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
> at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> at com.sun.proxy.$Proxy237.expunge(Unknown Source)
> at
> com.cloud.vm.UserVmManagerImpl$2.doInTransactionWithoutResult(UserVmManagerImpl.java:2593)
> at
> com.cloud.utils.db.TransactionCallbackNoReturn.doInTransaction(TransactionCallbackNoReturn.java:25)
> at com.cloud.utils.db.Transaction$2.doInTransaction(Transaction.java:57)
> at com.cloud.utils.db.Transaction.execute(Transaction.java:45)
> at com.cloud.utils.db.Transaction.execute(Transaction.java:54)
> at
> com.cloud.vm.UserVmManagerImpl.addInstanceToGroup(UserVmManagerImpl.java:2575)
> at
> com.cloud.vm.UserVmManagerImpl.updateVirtualMachine(UserVmManagerImpl.java:2332)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
