You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2020/04/30 09:07:26 UTC

[GitHub] [incubator-dolphinscheduler] 15921762467 opened a new issue #2588: Create a database connection exception

15921762467 opened a new issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588


   Through the dev branch "https://github.com/apache/incubator-dolphinscheduler/tree/dev/docker/docker-swarm/docker-compose.yml" after building, connect own dolphinscheduler abnormalities, excuse me, you need to do any change?
   通过dev分支“https://github.com/apache/incubator-dolphinscheduler/tree/dev/docker/docker-swarm/docker-compose.yml”构建后,连接自带的dolphinscheduler异常,请问,还需要做什么修改吗?
   ![1](https://user-images.githubusercontent.com/17587439/80693046-07ca0980-8b05-11ea-8345-067ecb8cd02d.jpg)
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [incubator-dolphinscheduler] dailidong commented on issue #2588: [QUESTION]Connect to the default database exception

Posted by GitBox <gi...@apache.org>.
dailidong commented on issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588#issuecomment-621769709


   please provide detail exception info


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [incubator-dolphinscheduler] tlhhup commented on issue #2588: [QUESTION]Connect to the default database exception

Posted by GitBox <gi...@apache.org>.
tlhhup commented on issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588#issuecomment-623294232


   > My connection to Postgresql via Navicat is normal
   
   ![image](https://user-images.githubusercontent.com/18378986/80942729-1a4f8600-8e18-11ea-8c45-bded6fec1caf.png)
   
   Maybe you should check you can Ping this host.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [incubator-dolphinscheduler] dailidong edited a comment on issue #2588: [QUESTION]Connect to the default database exception

Posted by GitBox <gi...@apache.org>.
dailidong edited a comment on issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588#issuecomment-621769709


   please provide detail exception info, see api server runtime log


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [incubator-dolphinscheduler] 15921762467 commented on issue #2588: [QUESTION]Connect to the default database exception

Posted by GitBox <gi...@apache.org>.
15921762467 commented on issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588#issuecomment-622201024


   My connection to Postgresql via Navicat is normal


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [incubator-dolphinscheduler] 15921762467 commented on issue #2588: [QUESTION]Connect to the default database exception

Posted by GitBox <gi...@apache.org>.
15921762467 commented on issue #2588:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/2588#issuecomment-622198389


   [ERROR] 2020-05-01 08:58:08.492 org.apache.dolphinscheduler.api.service.DataSourceService:[421] - The connection attempt failed.
   org.postgresql.util.PSQLException: The connection attempt failed.
           at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
           at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
           at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
           at org.postgresql.Driver.makeConnection(Driver.java:450)
           at org.postgresql.Driver.connect(Driver.java:252)
           at java.sql.DriverManager.getConnection(DriverManager.java:664)
           at java.sql.DriverManager.getConnection(DriverManager.java:247)
           at org.apache.dolphinscheduler.api.service.DataSourceService.getConnection(DataSourceService.java:418)
           at org.apache.dolphinscheduler.api.service.DataSourceService.checkConnection(DataSourceService.java:436)
           at org.apache.dolphinscheduler.api.service.DataSourceService$$FastClassBySpringCGLIB$$8d6cb828.invoke(<generated>)
           at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
           at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
           at org.apache.dolphinscheduler.api.service.DataSourceService$$EnhancerBySpringCGLIB$$3bd48a8.checkConnection(<generated>)
           at org.apache.dolphinscheduler.api.controller.DataSourceController.connectDataSource(DataSourceController.java:284)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:498)
           at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
           at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
           at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
           at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
           at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
           at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
           at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
           at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
           at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
           at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
           at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
           at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:867)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
           at com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.java:53)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
           at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
           at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
           at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
           at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
           at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
           at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
           at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
           at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
           at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
           at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
           at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)
           at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
           at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
           at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
           at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
           at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)
           at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
           at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
           at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
           at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
           at org.eclipse.jetty.server.Server.handle(Server.java:502)
           at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
           at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
           at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
           at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
           at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
           at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
           at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
           at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
           at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
           at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
           at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
           at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
           at java.lang.Thread.run(Thread.java:748)
   Caused by: java.net.NoRouteToHostException: Host is unreachable (Host unreachable)
           at java.net.PlainSocketImpl.socketConnect(Native Method)
           at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
           at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
           at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
           at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
           at java.net.Socket.connect(Socket.java:607)
           at org.postgresql.core.PGStream.<init>(PGStream.java:68)
           at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
           ... 77 common frames omitted
   
   **********************************************************************************
   But I see that the yml file is configured with the same network, can you help me analyze it?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org