You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Rajani Karuturi (JIRA)" <ji...@apache.org> on 2014/05/02 12:27:15 UTC

[jira] [Reopened] (CLOUDSTACK-6561) [Automation] createNetworkACL API failing with DB Exception

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-6561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajani Karuturi reopened CLOUDSTACK-6561:
-----------------------------------------


> [Automation] createNetworkACL API failing with DB Exception 
> ------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6561
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6561
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: 4.4.0
>         Environment: KVM advanced zone 
> build 4.4-forward
>            Reporter: Rayees Namathponnan
>            Assignee: Rajani Karuturi
>            Priority: Blocker
>             Fix For: 4.4.0
>
>         Attachments: management.rar
>
>
> `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)



--
This message was sent by Atlassian JIRA
(v6.2#6252)