cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-9595) Transactions are not getting retried in case of database deadlock errors
Date Wed, 06 Dec 2017 16:50:00 GMT

    [ 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:
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-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)

Mime
View raw message