Uploaded image for project: 'CloudStack'
  1. CloudStack
  2. CLOUDSTACK-6561

[Automation] createNetworkACL API failing with DB Exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Cannot Reproduce
    • 4.4.0
    • 4.4.0
    • Management Server
    • Security Level: Public (Anyone can view this level - this is the default.)
    • None
    • KVM advanced zone
      build 4.4-forward

    Description

      `test case integration.smoke.test_network_acl.TestNetworkACL.test_network_acl failing with latest build, test case failing while calling createNetworkACL

      2014-05-01 21:07:07,367 DEBUG [c.c.a.ApiServlet] (catalina-exec-3:ctx-9757351f ctx-24370d4a ctx-0341fee1) ===END=== 10.223.240.1
      94 – GET signature=eY2%2BliuFvCh5btJLs6WNF%2BSe1AQ%3D&apiKey=JvzSZMCmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppT
      LQOYKz6_JEu-eQYEJERA&command=queryAsyncJobResult&response=json&jobid=0e438f1b-8ba8-4190-becd-4b5ef3dc9b3b
      2014-05-01 21:07:07,382 DEBUG [c.c.a.ApiServlet] (catalina-exec-9:ctx-8826b293) ===START=== 10.223.240.194 – GET apiKey=JvzSZM
      CmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppTLQOYKz6_JEu-eQYEJERA&protocol=TCP&aclid=7aff34c4-7d06-43d6-9161-a78c5
      0eb9aae&cidrlist=0.0.0.0%2F0&number=10&command=createNetworkACL&signature=WWITZnW2Brw8VooujZJ1Y9foKI4%3D&action=Deny&response=jso
      n
      2014-05-01 21:07:07,590 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-9:ctx-8826b293 ctx-bc96c725 ctx-70a1e707) Root Access gra
      nted to Acct[3c84f86a-d189-11e3-9a99-1a6f7bb0d0a8-admin] by RoleBasedEntityAccessChecker
      2014-05-01 21:07:07,785 ERROR [c.c.a.ApiServer] (catalina-exec-9:ctx-8826b293 ctx-bc96c725 ctx-70a1e707) unhandled exception exec
      uting api command: [Ljava.lang.String;@7d818602
      com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@62ee65dd: SELECT network_
      acl_item.id, network_acl_item.start_port, network_acl_item.end_port, network_acl_item.protocol, network_acl_item.state, network_a
      cl_item.created, network_acl_item.acl_id, network_acl_item.icmp_code, network_acl_item.icmp_type, network_acl_item.traffic_type,
      network_acl_item.cidr, network_acl_item.uuid, network_acl_item.number, network_acl_item.action, network_acl_item.display FROM net
      work_acl_item WHERE network_acl_item.acl_id = 8 AND network_acl_item.number = 10 ORDER BY RAND() LIMIT 1
      at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:425)
      at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:361)
      at com.cloud.utils.db.GenericDaoBase.findOneIncludingRemovedBy(GenericDaoBase.java:889)
      at com.cloud.utils.db.GenericDaoBase.findOneBy(GenericDaoBase.java:900)
      at com.cloud.network.vpc.dao.NetworkACLItemDaoImpl.findByAclAndNumber(NetworkACLItemDaoImpl.java:134)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      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.$Proxy185.findByAclAndNumber(Unknown Source)
      at com.cloud.network.vpc.NetworkACLServiceImpl.createNetworkACLItem(NetworkACLServiceImpl.java:378)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      Attachments

        1. management.rar
          2.90 MB
          Rayees Namathponnan

        Activity

          People

            rajanik Rajani Karuturi
            rayeesn Rayees Namathponnan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: