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

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

Github user blueorangutan commented on the issue:

    https://github.com/apache/cloudstack/pull/1762
  
    <b>Trillian test result (tid-347)</b>
    Environment: kvm-centos7 (x2), Advanced Networking with Mgmt server 7
    Total time taken: 26094 seconds
    Marvin logs: 
https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr1762-t347-kvm-centos7.zip
    Test completed. 47 look ok, 1 have error(s)
    
    
    Test | Result | Time (s) | Test File
    --- | --- | --- | ---
    test_01_create_redundant_VPC_2tiers_4VMs_4IPs_4PF_ACL | `Failure` | 369.46 
| test_vpc_redundant.py
    test_01_vpc_site2site_vpn | Success | 154.87 | test_vpc_vpn.py
    test_01_vpc_remote_access_vpn | Success | 66.24 | test_vpc_vpn.py
    test_01_redundant_vpc_site2site_vpn | Success | 255.75 | test_vpc_vpn.py
    test_02_VPC_default_routes | Success | 273.12 | test_vpc_router_nics.py
    test_01_VPC_nics_after_destroy | Success | 534.12 | test_vpc_router_nics.py
    test_05_rvpc_multi_tiers | Success | 513.09 | test_vpc_redundant.py
    test_04_rvpc_network_garbage_collector_nics | Success | 1408.56 | 
test_vpc_redundant.py
    test_03_create_redundant_VPC_1tier_2VMs_2IPs_2PF_ACL_reboot_routers | 
Success | 553.46 | test_vpc_redundant.py
    test_02_redundant_VPC_default_routes | Success | 753.12 | 
test_vpc_redundant.py
    test_09_delete_detached_volume | Success | 15.44 | test_volumes.py
    test_08_resize_volume | Success | 15.36 | test_volumes.py
    test_07_resize_fail | Success | 20.45 | test_volumes.py
    test_06_download_detached_volume | Success | 15.29 | test_volumes.py
    test_05_detach_volume | Success | 100.25 | test_volumes.py
    test_04_delete_attached_volume | Success | 10.18 | test_volumes.py
    test_03_download_attached_volume | Success | 15.30 | test_volumes.py
    test_02_attach_volume | Success | 73.79 | test_volumes.py
    test_01_create_volume | Success | 712.21 | test_volumes.py
    test_deploy_vm_multiple | Success | 278.61 | test_vm_life_cycle.py
    test_deploy_vm | Success | 0.03 | test_vm_life_cycle.py
    test_advZoneVirtualRouter | Success | 0.02 | test_vm_life_cycle.py
    test_10_attachAndDetach_iso | Success | 26.47 | test_vm_life_cycle.py
    test_09_expunge_vm | Success | 125.19 | test_vm_life_cycle.py
    test_08_migrate_vm | Success | 35.86 | test_vm_life_cycle.py
    test_07_restore_vm | Success | 0.10 | test_vm_life_cycle.py
    test_06_destroy_vm | Success | 125.83 | test_vm_life_cycle.py
    test_03_reboot_vm | Success | 125.82 | test_vm_life_cycle.py
    test_02_start_vm | Success | 10.16 | test_vm_life_cycle.py
    test_01_stop_vm | Success | 40.30 | test_vm_life_cycle.py
    test_CreateTemplateWithDuplicateName | Success | 75.58 | test_templates.py
    test_08_list_system_templates | Success | 0.04 | test_templates.py
    test_07_list_public_templates | Success | 0.04 | test_templates.py
    test_05_template_permissions | Success | 0.06 | test_templates.py
    test_04_extract_template | Success | 5.18 | test_templates.py
    test_03_delete_template | Success | 5.10 | test_templates.py
    test_02_edit_template | Success | 90.17 | test_templates.py
    test_01_create_template | Success | 70.57 | test_templates.py
    test_10_destroy_cpvm | Success | 131.62 | test_ssvm.py
    test_09_destroy_ssvm | Success | 163.18 | test_ssvm.py
    test_08_reboot_cpvm | Success | 101.42 | test_ssvm.py
    test_07_reboot_ssvm | Success | 133.53 | test_ssvm.py
    test_06_stop_cpvm | Success | 166.54 | test_ssvm.py
    test_05_stop_ssvm | Success | 133.56 | test_ssvm.py
    test_04_cpvm_internals | Success | 0.95 | test_ssvm.py
    test_03_ssvm_internals | Success | 3.27 | test_ssvm.py
    test_02_list_cpvm_vm | Success | 0.11 | test_ssvm.py
    test_01_list_sec_storage_vm | Success | 0.12 | test_ssvm.py
    test_01_snapshot_root_disk | Success | 16.20 | test_snapshots.py
    test_04_change_offering_small | Success | 209.44 | test_service_offerings.py
    test_03_delete_service_offering | Success | 0.03 | test_service_offerings.py
    test_02_edit_service_offering | Success | 0.05 | test_service_offerings.py
    test_01_create_service_offering | Success | 0.10 | test_service_offerings.py
    test_02_sys_template_ready | Success | 0.12 | test_secondary_storage.py
    test_01_sys_vm_start | Success | 0.17 | test_secondary_storage.py
    test_09_reboot_router | Success | 30.26 | test_routers.py
    test_08_start_router | Success | 25.25 | test_routers.py
    test_07_stop_router | Success | 10.15 | test_routers.py
    test_06_router_advanced | Success | 0.05 | test_routers.py
    test_05_router_basic | Success | 0.04 | test_routers.py
    test_04_restart_network_wo_cleanup | Success | 5.59 | test_routers.py
    test_03_restart_network_cleanup | Success | 50.47 | test_routers.py
    test_02_router_internal_adv | Success | 1.09 | test_routers.py
    test_01_router_internal_basic | Success | 0.58 | test_routers.py
    test_router_dns_guestipquery | Success | 76.67 | test_router_dns.py
    test_router_dns_externalipquery | Success | 0.08 | test_router_dns.py
    test_router_dhcphosts | Success | 271.73 | test_router_dhcphosts.py
    test_01_updatevolumedetail | Success | 0.07 | test_resource_detail.py
    test_01_reset_vm_on_reboot | Success | 156.00 | test_reset_vm_on_reboot.py
    test_createRegion | Success | 0.04 | test_regions.py
    test_create_pvlan_network | Success | 5.22 | test_pvlan.py
    test_dedicatePublicIpRange | Success | 0.42 | test_public_ip_range.py
    test_04_rvpc_privategw_static_routes | Success | 476.67 | 
test_privategw_acl.py
    test_03_vpc_privategw_restart_vpc_cleanup | Success | 516.24 | 
test_privategw_acl.py
    test_02_vpc_privategw_static_routes | Success | 452.44 | 
test_privategw_acl.py
    test_01_vpc_privategw_acl | Success | 113.17 | test_privategw_acl.py
    test_01_primary_storage_nfs | Success | 35.83 | test_primary_storage.py
    test_createPortablePublicIPRange | Success | 15.18 | 
test_portable_publicip.py
    test_createPortablePublicIPAcquire | Success | 15.41 | 
test_portable_publicip.py
    test_isolate_network_password_server | Success | 89.53 | 
test_password_server.py
    test_UpdateStorageOverProvisioningFactor | Success | 0.17 | 
test_over_provisioning.py
    test_oobm_zchange_password | Success | 21.02 | test_outofbandmanagement.py
    test_oobm_multiple_mgmt_server_ownership | Success | 16.51 | 
test_outofbandmanagement.py
    test_oobm_issue_power_status | Success | 10.52 | test_outofbandmanagement.py
    test_oobm_issue_power_soft | Success | 15.52 | test_outofbandmanagement.py
    test_oobm_issue_power_reset | Success | 15.51 | test_outofbandmanagement.py
    test_oobm_issue_power_on | Success | 15.52 | test_outofbandmanagement.py
    test_oobm_issue_power_off | Success | 15.52 | test_outofbandmanagement.py
    test_oobm_issue_power_cycle | Success | 15.52 | test_outofbandmanagement.py
    test_oobm_enabledisable_across_clusterzones | Success | 57.54 | 
test_outofbandmanagement.py
    test_oobm_enable_feature_valid | Success | 5.34 | 
test_outofbandmanagement.py
    test_oobm_enable_feature_invalid | Success | 0.14 | 
test_outofbandmanagement.py
    test_oobm_disable_feature_valid | Success | 5.19 | 
test_outofbandmanagement.py
    test_oobm_disable_feature_invalid | Success | 0.11 | 
test_outofbandmanagement.py
    test_oobm_configure_invalid_driver | Success | 0.09 | 
test_outofbandmanagement.py
    test_oobm_configure_default_driver | Success | 0.09 | 
test_outofbandmanagement.py
    test_oobm_background_powerstate_sync | Success | 29.57 | 
test_outofbandmanagement.py
    test_extendPhysicalNetworkVlan | Success | 15.28 | 
test_non_contigiousvlan.py
    test_01_nic | Success | 631.19 | test_nic.py
    test_releaseIP | Success | 278.86 | test_network.py
    test_reboot_router | Success | 409.34 | test_network.py
    test_public_ip_user_account | Success | 10.29 | test_network.py
    test_public_ip_admin_account | Success | 40.26 | test_network.py
    test_network_rules_acquired_public_ip_3_Load_Balancer_Rule | Success | 
67.17 | test_network.py
    test_network_rules_acquired_public_ip_2_nat_rule | Success | 61.81 | 
test_network.py
    test_network_rules_acquired_public_ip_1_static_nat_rule | Success | 121.88 
| test_network.py
    test_delete_account | Success | 308.97 | test_network.py
    test_02_port_fwd_on_non_src_nat | Success | 55.61 | test_network.py
    test_01_port_fwd_on_src_nat | Success | 109.78 | test_network.py
    test_nic_secondaryip_add_remove | Success | 258.78 | 
test_multipleips_per_nic.py
    login_test_saml_user | Success | 24.76 | test_login.py
    test_assign_and_removal_lb | Success | 134.58 | test_loadbalance.py
    test_02_create_lb_rule_non_nat | Success | 187.42 | test_loadbalance.py
    test_01_create_lb_rule_src_nat | Success | 218.79 | test_loadbalance.py
    test_03_list_snapshots | Success | 0.08 | test_list_ids_parameter.py
    test_02_list_templates | Success | 0.04 | test_list_ids_parameter.py
    test_01_list_volumes | Success | 0.03 | test_list_ids_parameter.py
    test_07_list_default_iso | Success | 0.06 | test_iso.py
    test_05_iso_permissions | Success | 0.06 | test_iso.py
    test_04_extract_Iso | Success | 5.19 | test_iso.py
    test_03_delete_iso | Success | 95.19 | test_iso.py
    test_02_edit_iso | Success | 0.05 | test_iso.py
    test_01_create_iso | Success | 21.87 | test_iso.py
    test_04_rvpc_internallb_haproxy_stats_on_all_interfaces | Success | 249.35 
| test_internal_lb.py
    test_03_vpc_internallb_haproxy_stats_on_all_interfaces | Success | 188.14 | 
test_internal_lb.py
    test_02_internallb_roundrobin_1RVPC_3VM_HTTP_port80 | Success | 516.68 | 
test_internal_lb.py
    test_01_internallb_roundrobin_1VPC_3VM_HTTP_port80 | Success | 480.48 | 
test_internal_lb.py
    test_dedicateGuestVlanRange | Success | 10.25 | test_guest_vlan_range.py
    test_UpdateConfigParamWithScope | Success | 0.13 | test_global_settings.py
    test_rolepermission_lifecycle_update | Success | 7.14 | test_dynamicroles.py
    test_rolepermission_lifecycle_list | Success | 6.92 | test_dynamicroles.py
    test_rolepermission_lifecycle_delete | Success | 6.75 | test_dynamicroles.py
    test_rolepermission_lifecycle_create | Success | 6.77 | test_dynamicroles.py
    test_rolepermission_lifecycle_concurrent_updates | Success | 6.88 | 
test_dynamicroles.py
    test_role_lifecycle_update_role_inuse | Success | 6.80 | 
test_dynamicroles.py
    test_role_lifecycle_update | Success | 12.01 | test_dynamicroles.py
    test_role_lifecycle_list | Success | 6.87 | test_dynamicroles.py
    test_role_lifecycle_delete | Success | 11.81 | test_dynamicroles.py
    test_role_lifecycle_create | Success | 6.79 | test_dynamicroles.py
    test_role_inuse_deletion | Success | 6.77 | test_dynamicroles.py
    test_role_account_acls_multiple_mgmt_servers | Success | 9.05 | 
test_dynamicroles.py
    test_role_account_acls | Success | 9.12 | test_dynamicroles.py
    test_default_role_deletion | Success | 6.86 | test_dynamicroles.py
    test_04_create_fat_type_disk_offering | Success | 0.06 | 
test_disk_offerings.py
    test_03_delete_disk_offering | Success | 0.03 | test_disk_offerings.py
    test_02_edit_disk_offering | Success | 0.04 | test_disk_offerings.py
    test_02_create_sparse_type_disk_offering | Success | 0.07 | 
test_disk_offerings.py
    test_01_create_disk_offering | Success | 0.10 | test_disk_offerings.py
    test_deployvm_userdispersing | Success | 20.57 | 
test_deploy_vms_with_varied_deploymentplanners.py
    test_deployvm_userconcentrated | Success | 20.56 | 
test_deploy_vms_with_varied_deploymentplanners.py
    test_deployvm_firstfit | Success | 50.62 | 
test_deploy_vms_with_varied_deploymentplanners.py
    test_deployvm_userdata_post | Success | 45.62 | 
test_deploy_vm_with_userdata.py
    test_deployvm_userdata | Success | 111.07 | test_deploy_vm_with_userdata.py
    test_02_deploy_vm_root_resize | Success | 6.87 | 
test_deploy_vm_root_resize.py
    test_01_deploy_vm_root_resize | Success | 7.12 | 
test_deploy_vm_root_resize.py
    test_00_deploy_vm_root_resize | Success | 253.45 | 
test_deploy_vm_root_resize.py
    test_deploy_vm_from_iso | Success | 208.43 | test_deploy_vm_iso.py
    test_DeployVmAntiAffinityGroup | Success | 55.84 | test_affinity_groups.py
    test_03_delete_vm_snapshots | Skipped | 0.00 | test_vm_snapshots.py
    test_02_revert_vm_snapshots | Skipped | 0.00 | test_vm_snapshots.py
    test_01_test_vm_volume_snapshot | Skipped | 0.00 | test_vm_snapshots.py
    test_01_create_vm_snapshots | Skipped | 0.00 | test_vm_snapshots.py
    test_06_copy_template | Skipped | 0.00 | test_templates.py
    test_static_role_account_acls | Skipped | 0.02 | test_staticroles.py
    test_11_ss_nfs_version_on_ssvm | Skipped | 0.02 | test_ssvm.py
    test_01_scale_vm | Skipped | 0.00 | test_scale_vm.py
    test_01_primary_storage_iscsi | Skipped | 0.03 | test_primary_storage.py
    test_06_copy_iso | Skipped | 0.00 | test_iso.py
    test_deploy_vgpu_enabled_vm | Skipped | 0.03 | 
test_deploy_vgpu_enabled_vm.py
    test_3d_gpu_support | Skipped | 0.03 | test_deploy_vgpu_enabled_vm.py



> 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.3.4#6332)

Reply via email to