[ https://issues.apache.org/jira/browse/CLOUDSTACK-6561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rayees Namathponnan closed 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.3.4#6332)