You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@eagle.apache.org by "Michael Wu (JIRA)" <ji...@apache.org> on 2016/12/05 06:34:58 UTC

[jira] [Created] (EAGLE-822) sql exception thrown while creating a site with blank display name or description

Michael Wu created EAGLE-822:
--------------------------------

             Summary: sql exception thrown while creating a site with blank display name or description
                 Key: EAGLE-822
                 URL: https://issues.apache.org/jira/browse/EAGLE-822
             Project: Eagle
          Issue Type: Bug
            Reporter: Michael Wu
            Assignee: Hao Chen


Reproduce: 
Create any site, fill site id and leave display-name or description blank, then an exception is thrown out, telling the corresponding sql parameter is not given.
pls. if the case is to create the first site, there will be a "Oops" overlay popped up, but if it's to create site that's not the first one, there are no error notification.
According to usage logic, the display-name and description fields are optional parameters, so if users don't input value, the site should also be created with "" instead of eagle's blocking the creation.

Below are error logs captured.

ERROR [2016-12-05 06:24:12,576] org.apache.eagle.metadata.resource.RESTResponse: ExecutionException: javax.ws.rs.WebApplicationException: java.lang.IllegalArgumentException: Error to insert SiteEntity: SiteEntity[siteId = sandbox, siteName =sandbox, description = null, uuid = c3807497-b9d1-4cb1-a2e8-5cc57788a300]java.sql.SQLException: No value specified for parameter 6
! java.lang.IllegalArgumentException: Error to insert SiteEntity: SiteEntity[siteId = sandbox, siteName =sandbox, description = null, uuid = c3807497-b9d1-4cb1-a2e8-5cc57788a300]java.sql.SQLException: No value specified for parameter 6
! at org.apache.eagle.metadata.store.jdbc.service.SiteEntityServiceJDBCImpl.create(SiteEntityServiceJDBCImpl.java:159) ~[eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.store.jdbc.service.SiteEntityServiceJDBCImpl.create(SiteEntityServiceJDBCImpl.java:37) ~[eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.SiteResource.lambda$createSite$0(SiteResource.java:54) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.RESTResponse$RestResponseBuilder.lambda$async$1(RESTResponse.java:197) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! ... 6 common frames omitted
! Causing: javax.ws.rs.WebApplicationException: java.lang.IllegalArgumentException: Error to insert SiteEntity: SiteEntity[siteId = sandbox, siteName =sandbox, description = null, uuid = c3807497-b9d1-4cb1-a2e8-5cc57788a300]java.sql.SQLException: No value specified for parameter 6
! at org.apache.eagle.metadata.resource.RESTResponse$RestResponseBuilder.raiseWebAppException(RESTResponse.java:226) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.RESTResponse$RestResponseBuilder.lambda$async$1(RESTResponse.java:202) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) ~[na:1.8.0_91]
! at java.util.concurrent.CompletableFuture$AsyncRun.exec(CompletableFuture.java:1618) ~[na:1.8.0_91]
! at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) ~[na:1.8.0_91]
! at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) ~[na:1.8.0_91]
! at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) ~[na:1.8.0_91]
! at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157) ~[na:1.8.0_91]
! Causing: java.util.concurrent.ExecutionException: javax.ws.rs.WebApplicationException: java.lang.IllegalArgumentException: Error to insert SiteEntity: SiteEntity[siteId = sandbox, siteName =sandbox, description = null, uuid = c3807497-b9d1-4cb1-a2e8-5cc57788a300]java.sql.SQLException: No value specified for parameter 6
! at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357) ~[na:1.8.0_91]
! at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1895) ~[na:1.8.0_91]
! at org.apache.eagle.metadata.resource.RESTResponse$RestResponseBuilder.runAsync(RESTResponse.java:211) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.RESTResponse$RestResponseBuilder.async(RESTResponse.java:205) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.RESTResponse.async(RESTResponse.java:98) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.metadata.resource.SiteResource.createSite(SiteResource.java:53) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_91]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_91]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
! at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) [jersey-server-1.19.1.jar:1.19.1]
! at io.dropwizard.jersey.guava.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) [dropwizard-jersey-0.7.1.jar:0.7.1]
! at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [jersey-server-1.19.1.jar:1.19.1]
! at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [jersey-servlet-1.19.1.jar:1.19.1]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) [jersey-servlet-1.19.1.jar:1.19.1]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) [jersey-servlet-1.19.1.jar:1.19.1]
! at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at io.dropwizard.jetty.NonblockingServletHolder.handle(NonblockingServletHolder.java:49) [dropwizard-jetty-0.7.1.jar:0.7.1]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1515) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:295) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at io.dropwizard.jetty.BiDiGzipFilter.doFilter(BiDiGzipFilter.java:127) [dropwizard-jetty-0.7.1.jar:0.7.1]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at io.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29) [dropwizard-servlets-0.7.1.jar:0.7.1]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at io.dropwizard.jersey.filter.AllowedMethodsFilter.handle(AllowedMethodsFilter.java:44) [dropwizard-jersey-0.7.1.jar:0.7.1]
! at io.dropwizard.jersey.filter.AllowedMethodsFilter.doFilter(AllowedMethodsFilter.java:39) [dropwizard-jersey-0.7.1.jar:0.7.1]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.apache.eagle.alert.resource.SimpleCORSFiler.doFilter(SimpleCORSFiler.java:51) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:66) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:519) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1097) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:448) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1031) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at com.codahale.metrics.jetty9.InstrumentedHandler.handle(InstrumentedHandler.java:175) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at io.dropwizard.jetty.RoutingHandler.handle(RoutingHandler.java:51) [dropwizard-jetty-0.7.1.jar:0.7.1]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:92) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:162) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.Server.handle(Server.java:446) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:271) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:246) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532) [eagle-topology-0.5.0-incubating-SNAPSHOT-hadoop-2.4.1-EBAY-11-assembly.jar:na]
! at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)