[ https://issues.apache.org/jira/browse/CLOUDSTACK-9595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280480#comment-16280480 ]
ASF GitHub Bot commented on CLOUDSTACK-9595: -------------------------------------------- blueorangutan commented on issue #1762: CLOUDSTACK-9595 Transactions are not getting retried in case of datab… URL: https://github.com/apache/cloudstack/pull/1762#issuecomment-349701211 <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 seconds 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 87 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 324 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) 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_privategw_acl.py test_03_vpc_privategw_restart_vpc_cleanup | `Failure` | 112.28 | test_privategw_acl.py test_04_rvpc_privategw_static_routes | `Failure` | 238.11 | test_privategw_acl.py test_router_dhcphosts | `Failure` | 57.59 | test_router_dhcphosts.py ContextSuite context=TestRouterDHCPHosts>: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 ---------------------------------------------------------------- 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)