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)
