实战

回到首页 个人中心 反馈问题 注册登录
下载APP
首页 课程 实战 体系课 手记 专栏 慕课教程

数据库telnet没问题后，启动应用访问接口出现这样的情况是为什么

来源：4-2 数据库远程开放端口连接

qq_V_209

2020-03-16


  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.2.4.RELEASE)

2020-03-16 16:13:22.893  INFO 24936 --- [           main] c.z.secondskill.SecondskillApplication   : Starting SecondskillApplication v0.0.1-SNAPSHOT on iZbp1bm4w0rtoyl5q6ay0kZ with PID 24936 (/root/miaosha.jar started by root in /root)
2020-03-16 16:13:22.896  INFO 24936 --- [           main] c.z.secondskill.SecondskillApplication   : The following profiles are active: pro
2020-03-16 16:13:24.454  INFO 24936 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-03-16 16:13:24.457  INFO 24936 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
2020-03-16 16:13:24.508  INFO 24936 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19ms. Found 0 Redis repository interfaces.
2020-03-16 16:13:25.420  INFO 24936 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-03-16 16:13:26.207  INFO 24936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 80 (http)
2020-03-16 16:13:26.220  INFO 24936 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-03-16 16:13:26.221  INFO 24936 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.30]
2020-03-16 16:13:26.381  INFO 24936 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-03-16 16:13:26.381  INFO 24936 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 3331 ms
2020-03-16 16:13:28.945  INFO 24936 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-03-16 16:13:31.076  INFO 24936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 80 (http) with context path ''
2020-03-16 16:13:31.095  INFO 24936 --- [           main] c.z.secondskill.SecondskillApplication   : Started SecondskillApplication in 9.427 seconds (JVM running for 10.404)
2020-03-16 16:13:41.641  INFO 24936 --- [p-nio-80-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
2020-03-16 16:13:41.641  INFO 24936 --- [p-nio-80-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2020-03-16 16:13:41.656  INFO 24936 --- [p-nio-80-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 15 ms
2020-03-16 16:13:41.975  INFO 24936 --- [p-nio-80-exec-1] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
2020-03-16 16:13:42.145 ERROR 24936 --- [eate-1552007070] com.alibaba.druid.pool.DruidDataSource   : create connection error, url: jdbc:mysql://127.0.0.1:3306/secondskill?useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_201]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_201]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_201]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_201]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.14.jar!/:na]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_201]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_201]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_201]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_201]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464) ~[druid-1.1.3.jar!/:1.1.3]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529) ~[druid-1.1.3.jar!/:1.1.3]
        at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2239) ~[druid-1.1.3.jar!/:1.1.3]
Caused by: java.net.ConnectException: Connection refused (Connection refused)
        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_201]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[na:1.8.0_201]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[na:1.8.0_201]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[na:1.8.0_201]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_201]
        at java.net.Socket.connect(Socket.java:589) ~[na:1.8.0_201]
        at java.net.Socket.connect(Socket.java:538) ~[na:1.8.0_201]
        at java.net.Socket.<init>(Socket.java:434) ~[na:1.8.0_201]
        at java.net.Socket.<init>(Socket.java:244) ~[na:1.8.0_201]
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254) ~[mysql-connector-java-5.1.14.jar!/:na]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[mysql-connector-java-5.1.14.jar!/:na]
        ... 15 common frames omitted

2020-03-16 16:13:42.152 ERROR 24936 --- [eate-1552007070] com.alibaba.druid.pool.DruidDataSource   : create connection error, url: jdbc:mysql://127.0.0.1:3306/secondskill?useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01
写回答

1回答

龙虾三少

2020-03-16

确认下驱动版本和数据库版本是否一致

0
3
qq_慕用2474925
回复
qq_V_209
兄弟咋解决的
2021-07-04
共3条回复

聚焦Java性能优化 打造亿级流量秒杀系统(赠秒杀项目)

理解高流量电商网站性能构建思路 用高逼格技术解决性能提升问题

2174 学习 · 1009 问题

查看课程

相似问题

修改本地hosts文件后80端口可以ping、telnet都没问题但用浏览器访问显示404

回答 2

A连接不上B的数据库 出现 telnet: connect to address 数据库服务器地址: Connection refused

回答 1

4-2 部署应用服务器似乎没问题，但是一访问就报错

回答 1

关于库存一致的问题

回答 1

将项目部署到阿里云上面通过通过阿里云公网IP地址访问是访问不了

回答 2

打开慕课网App查看更多内容