[jira] [Updated] (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 ] Abhinandan Prateek updated CLOUDSTACK-6561: --- Assignee: Rajani Karuturi [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%3DapiKey=JvzSZMCmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppT LQOYKz6_JEu-eQYEJERAcommand=queryAsyncJobResultresponse=jsonjobid=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-eQYEJERAprotocol=TCPaclid=7aff34c4-7d06-43d6-9161-a78c5 0eb9aaecidrlist=0.0.0.0%2F0number=10command=createNetworkACLsignature=WWITZnW2Brw8VooujZJ1Y9foKI4%3Daction=Denyresponse=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)
[jira] [Updated] (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 updated CLOUDSTACK-6561: 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%3DapiKey=JvzSZMCmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppT LQOYKz6_JEu-eQYEJERAcommand=queryAsyncJobResultresponse=jsonjobid=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-eQYEJERAprotocol=TCPaclid=7aff34c4-7d06-43d6-9161-a78c5 0eb9aaecidrlist=0.0.0.0%2F0number=10command=createNetworkACLsignature=WWITZnW2Brw8VooujZJ1Y9foKI4%3Daction=Denyresponse=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) was: 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%3DapiKey=JvzSZMCmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppT LQOYKz6_JEu-eQYEJERAcommand=queryAsyncJobResultresponse=jsonjobid=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-eQYEJERAprotocol=TCPaclid=7aff34c4-7d06-43d6-9161-a78c5
[jira] [Updated] (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 ] Rayees Namathponnan updated CLOUDSTACK-6561: Attachment: management.rar [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 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%3DapiKey=JvzSZMCmMMWf3NI_REoBUhcERwXI9omKlAyd5Prrxeg7w7uGPSg-bmVN4P9nCXZppT LQOYKz6_JEu-eQYEJERAcommand=queryAsyncJobResultresponse=jsonjobid=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-eQYEJERAprotocol=TCPaclid=7aff34c4-7d06-43d6-9161-a78c5 0eb9aaecidrlist=0.0.0.0%2F0number=10command=createNetworkACLsignature=WWITZnW2Brw8VooujZJ1Y9foKI4%3Daction=Denyresponse=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)