Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Wed, 6 Dec 2017 16:50:00 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.13020087.1478863275000.400023.1512579000384@Atlassian.JIRA>
In-Reply-To: <JIRA.13020087.1478863275000@Atlassian.JIRA>
References: <JIRA.13020087.1478863275000@Atlassian.JIRA> <JIRA.13020087.1478863275122@jira-lw-us.apache.org>
Subject: [jira] [Commented] (CLOUDSTACK-9595) Transactions are not getting
 retried in case of database deadlock errors
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Wed, 06 Dec 2017 16:50:06 -0000


    [ https://issues.apache.org/jira/browse/CLOUDSTACK-9595?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=
=3D16280480#comment-16280480 ]=20

ASF GitHub Bot commented on CLOUDSTACK-9595:
--------------------------------------------

blueorangutan commented on issue #1762: CLOUDSTACK-9595 Transactions are no=
t getting retried in case of datab=E2=80=A6
URL: https://github.com/apache/cloudstack/pull/1762#issuecomment-349701211
=20
=20
   <b>Trillian test result (tid-1738)</b>
   Environment: kvm-centos7 (x2), Advanced Networking with Mgmt server 7
   Total time taken: 28467 seconds
   Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/=
trillian/pr1762-t1738-kvm-centos7.zip
   Test /marvin/tests/smoke/test_accounts.py took 1328 seconds
   Test /marvin/tests/smoke/test_affinity_groups_projects.py took 203 secon=
ds
   Test /marvin/tests/smoke/test_affinity_groups.py took 96 seconds
   Test /marvin/tests/smoke/test_certauthority_root.py took 47 seconds
   Test /marvin/tests/smoke/test_deploy_vgpu_enabled_vm.py took 6 seconds
   Test /marvin/tests/smoke/test_deploy_virtio_scsi_vm.py took 804 seconds
   Test /marvin/tests/smoke/test_deploy_vm_iso.py took 81 seconds
   Test /marvin/tests/smoke/test_deploy_vm_root_resize.py took 107 seconds
   Test /marvin/tests/smoke/test_deploy_vms_with_varied_deploymentplanners.=
py took 213 seconds
   Test /marvin/tests/smoke/test_deploy_vm_with_userdata.py took 92 seconds
   Test /marvin/tests/smoke/test_disk_offerings.py took 5 seconds
   Test /marvin/tests/smoke/test_dynamicroles.py took 109 seconds
   Test /marvin/tests/smoke/test_global_settings.py took 6 seconds
   Test /marvin/tests/smoke/test_guest_vlan_range.py took 26 seconds
   Test /marvin/tests/smoke/test_host_annotations.py took 13 seconds
   Test /marvin/tests/smoke/test_hostha_simulator.py took 6 seconds
   Test /marvin/tests/smoke/test_host_maintenance.py took 323 seconds
   Test /marvin/tests/smoke/test_hosts.py took 5 seconds
   Test /marvin/tests/smoke/test_internal_lb.py took 1246 seconds
   Test /marvin/tests/smoke/test_iso.py took 244 seconds
   Test /marvin/tests/smoke/test_list_ids_parameter.py took 561 seconds
   Test /marvin/tests/smoke/test_loadbalance.py took 653 seconds
   Test /marvin/tests/smoke/test_login.py took 24 seconds
   Test /marvin/tests/smoke/test_metrics_api.py took 79 seconds
   Test /marvin/tests/smoke/test_multipleips_per_nic.py took 103 seconds
   Test /marvin/tests/smoke/test_nested_virtualization.py took 12 seconds
   Test /marvin/tests/smoke/test_network_acl.py took 127 seconds
   Test /marvin/tests/smoke/test_network.py took 1359 seconds
   Test /marvin/tests/smoke/test_nic_adapter_type.py took 11 seconds
   Test /marvin/tests/smoke/test_nic.py took 494 seconds
   Test /marvin/tests/smoke/test_non_contigiousvlan.py took 20 seconds
   Test /marvin/tests/smoke/test_outofbandmanagement_nestedplugin.py took 8=
7 seconds
   Test /marvin/tests/smoke/test_outofbandmanagement.py took 247 seconds
   Test /marvin/tests/smoke/test_over_provisioning.py took 5 seconds
   Test /marvin/tests/smoke/test_password_server.py took 216 seconds
   Test /marvin/tests/smoke/test_portable_publicip.py took 52 seconds
   Test /marvin/tests/smoke/test_portforwardingrules.py took 112 seconds
   Test /marvin/tests/smoke/test_primary_storage.py took 429 seconds
   Test /marvin/tests/smoke/test_privategw_acl.py took 763 seconds
   Test /marvin/tests/smoke/test_projects.py took 513 seconds
   Test /marvin/tests/smoke/test_public_ip_range.py took 11 seconds
   Test /marvin/tests/smoke/test_pvlan.py took 11 seconds
   Test /marvin/tests/smoke/test_regions.py took 6 seconds
   Test /marvin/tests/smoke/test_reset_vm_on_reboot.py took 294 seconds
   Test /marvin/tests/smoke/test_resource_detail.py took 16 seconds
   Test /marvin/tests/smoke/test_router_dhcphosts.py took 331 seconds
   Test /marvin/tests/smoke/test_router_dns.py took 165 seconds
   Test /marvin/tests/smoke/test_router_dnsservice.py took 201 seconds
   Test /marvin/tests/smoke/test_routers_iptables_default_policy.py took 32=
4 seconds
   Test /marvin/tests/smoke/test_routers_network_ops.py took 920 seconds
   Test /marvin/tests/smoke/test_routers.py took 256 seconds
   Test /marvin/tests/smoke/test_scale_vm.py took 5 seconds
   Test /marvin/tests/smoke/test_secondary_storage.py took 5 seconds
   Test /marvin/tests/smoke/test_service_offerings.py took 312 seconds
   Test /marvin/tests/smoke/test_snapshots.py took 235 seconds
   Test /marvin/tests/smoke/test_ssvm.py took 818 seconds
   Test /marvin/tests/smoke/test_staticroles.py took 5 seconds
   Test /marvin/tests/smoke/test_templates.py took 1190 seconds
   Test /marvin/tests/smoke/test_usage_events.py took 5 seconds
   Test /marvin/tests/smoke/test_usage.py took 1523 seconds
   Test /marvin/tests/smoke/test_vm_life_cycle.py took 751 seconds
   Test /marvin/tests/smoke/test_vm_snapshots.py took 632 seconds
   Test /marvin/tests/smoke/test_volumes.py took 2180 seconds
   Test /marvin/tests/smoke/test_vpc_redundant.py took 3155 seconds
   Test /marvin/tests/smoke/test_vpc_router_nics.py took 716 seconds
   Test /marvin/tests/smoke/test_vpc_vpn.py took 684 seconds
   Test /marvin/tests/smoke/test_hostha_kvm.py took 620 seconds
   Test completed. 63 look OK, 4 have error(s)
  =20
  =20
   Test | Result | Time (s) | Test File
   --- | --- | --- | ---
   test_01_vpc_privategw_acl | `Failure` | 56.50 | test_privategw_acl.py
   test_02_vpc_privategw_static_routes | `Failure` | 142.15 | test_privateg=
w_acl.py
   test_03_vpc_privategw_restart_vpc_cleanup | `Failure` | 112.28 | test_pr=
ivategw_acl.py
   test_04_rvpc_privategw_static_routes | `Failure` | 238.11 | test_private=
gw_acl.py
   test_router_dhcphosts | `Failure` | 57.59 | test_router_dhcphosts.py
   ContextSuite context=3DTestRouterDHCPHosts>:teardown | `Error` | 72.83 |=
 test_router_dhcphosts.py
   test_01_vpc_remote_access_vpn | `Error` | 55.60 | test_vpc_vpn.py
   test_hostha_kvm_host_recovering | `Error` | 30.61 | test_hostha_kvm.py
  =20

----------------------------------------------------------------
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.
=20
For queries about this service, please contact Infrastructure at:
users@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-959=
5
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the defa=
ult.)=20
>    Affects Versions: 4.8.0
>            Reporter: subhash yedugundla
>             Fix For: 4.8.1
>
>
> Customer is seeing occasional error 'Deadlock found when trying to get lo=
ck; try restarting transaction' messages in their management server logs.  =
It happens regularly at least once a day.  The following is the error seen=
=20
> 2015-12-09 19:23:19,450 ERROR [cloud.api.ApiServer] (catalina-exec-3:ctx-=
f05c58fc ctx-39c17156 ctx-7becdf6e) unhandled exception executing api comma=
nd: [Ljava.lang.String;@230a6e7f
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mys=
ql.jdbc.JDBC4PreparedStatement@74f134e3: DELETE FROM instance_group_vm_map =
WHERE instance_group_vm_map.instance_id =3D 941374
> =09at com.cloud.utils.db.GenericDaoBase.expunge(GenericDaoBase.java:1209)
> =09at sun.reflect.GeneratedMethodAccessor360.invoke(Unknown Source)
> =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc=
essorImpl.java:43)
> =09at java.lang.reflect.Method.invoke(Method.java:606)
> =09at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflec=
tion(AopUtils.java:317)
> =09at org.springframework.aop.framework.ReflectiveMethodInvocation.invoke=
Joinpoint(ReflectiveMethodInvocation.java:183)
> =09at org.springframework.aop.framework.ReflectiveMethodInvocation.procee=
d(ReflectiveMethodInvocation.java:150)
> =09at com.cloud.utils.db.TransactionContextInterceptor.invoke(Transaction=
ContextInterceptor.java:34)
> =09at org.springframework.aop.framework.ReflectiveMethodInvocation.procee=
d(ReflectiveMethodInvocation.java:161)
> =09at org.springframework.aop.interceptor.ExposeInvocationInterceptor.inv=
oke(ExposeInvocationInterceptor.java:91)
> =09at org.springframework.aop.framework.ReflectiveMethodInvocation.procee=
d(ReflectiveMethodInvocation.java:172)
> =09at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDyna=
micAopProxy.java:204)
> =09at com.sun.proxy.$Proxy237.expunge(Unknown Source)
> =09at com.cloud.vm.UserVmManagerImpl$2.doInTransactionWithoutResult(UserV=
mManagerImpl.java:2593)
> =09at com.cloud.utils.db.TransactionCallbackNoReturn.doInTransaction(Tran=
sactionCallbackNoReturn.java:25)
> =09at com.cloud.utils.db.Transaction$2.doInTransaction(Transaction.java:5=
7)
> =09at com.cloud.utils.db.Transaction.execute(Transaction.java:45)
> =09at com.cloud.utils.db.Transaction.execute(Transaction.java:54)
> =09at com.cloud.vm.UserVmManagerImpl.addInstanceToGroup(UserVmManagerImpl=
.java:2575)
> =09at com.cloud.vm.UserVmManagerImpl.updateVirtualMachine(UserVmManagerIm=
pl.java:2332)


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)