[
https://issues.apache.org/jira/browse/EAGLE-822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15721411#comment-15721411
]
Lingang Deng commented on EAGLE-822:
------------------------------------
[~chenghao] It's duplicated with
[EAGLE-687|https://issues.apache.org/jira/browse/EAGLE-687]
> 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)
