Error while performing database login with the ssh driver: Communications link failure_百度知道
Error while performing database login with the ssh driver: Communications link failure
我用的是 MYsql5.2CE
MYeclips畅籂扳饺殖祭帮熄爆陇e 用的7.5 打开数据库打算添加文件时 出现以上错误 各位帮帮忙
提问者采纳
我可以帮你翻译一下错误信息的内容:在通过ssh驱动进行数据库载入时出现了错误：通讯连接失败上一次将信息包成功发送到服务器是在0毫秒前。驱畅籂扳饺殖祭帮熄爆陇动没有从服务器接收到任何信息包
提问者评价
其他类似问题
为您推荐：
ssh的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁广告剩余8秒
文档加载中
Short Headers Suffice for Communication in a DAG with Link Failures
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
Short Headers Suffice for Communication in a DAG with Link Failures
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer--144.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口MySQL数据库提示：Communications link failure，The last packet successfully received... - 苳眠的牧场 - ITeye技术网站
博客分类：
Last modified： 14:16:47
**********************************************
web网站使用MySQL数据库，今天突然报以下错误：
Communications link failure，The last packet successfully received from the server was *** millisecond ago.The last packet successfully sent to the server was ***
millisecond ago。
Mysql服务器默认的“wait_timeout”是8小时（也就是默认的值默认是28800秒），也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection，通俗的讲就是一个连接在8小时内没有活动，就会自动断开该连接。而连接池却认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。
wait timeout的值可以设定，但最多只能是2147483，不能再大了。也就是约24.85天。
修改方法：MySQL通过my.ini 在
# The TCP/IP Port the MySQL Server will listen on
port=3306下面添加
# this is myown dinifition for mysql connection timeout
wait_timeout=
interactive_timeout=
以上是在网上找到的解决方法，但是一般连接的有效时间不用修改，后来分析了以下问题，发现是由于数据库连接池的一句配置引发的：
&!-- 最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 --&
&property name="maxIdleTime" value="0"&&/property&
由于mysql的连接空闲超过8个小时，所以就关闭了，但是连接池却永不丢弃连接，认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。
解决方法将value设置为20。
使用数据连接池,如果常常发生连接失效,可以在连接池配置文件中添加连接测试:&house-keeping-test-sql&select 1&/house-keeping-test-sql&,及时过滤失效的连接.
wangjie2013
浏览: 60949 次
来自: 北京
keer2345 写道什么时候出续集，我在等待controll ...
什么时候出续集，我在等待controller部分呢
DaoImpl 还需要写吗？
wangjie2013 写道hoversong 写道请问您做第 ...
wangjie2013 写道hoversong 写道请问您做第 ...java - SQL Error: 0, SQLState: 08S01 Communications link failure - Stack Overflow
to customize your list.
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
J it only takes a minute:
Join the Stack Overflow community to:
Ask programming questions
Answer and help your peers
Get recognized for your expertise
I am getting this error (not so frequently):
16:44:35,786
WARN (JDBCExceptionReporter.java:100) [org.hibernate.util.JDBCExceptionReporter, logExceptions] - SQL Error: 0, SQLState: 08S01
16:44:35,786 ERROR (JDBCExceptionReporter.java:101) [org.hibernate.util.JDBCExceptionReporter, logExceptions] - 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.
16:44:35,833 ERROR (AdminDaoImpl.java:297) [com.myapp.admin.db.AdminDaoImpl, createFilePackage] - data-upload: Exception while adding new file package
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at com.myapp.admin.db.AdminDaoImpl. createFilePackage(AdminDaoImpl.java:182) [AdminDaoImpl.class:na]
at com.myapp.admin.ctrl.UploadController.processUploadZip(UploadController.java:217) [UploadController.class:na]
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source) [na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_35]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_35]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) [spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) [spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) [servlet-api.jar:na]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.35]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.35]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.35]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.35]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.35]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.35]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.35]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.35]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.35]
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) [tomcat-coyote.jar:7.0.35]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) [tomcat-coyote.jar:7.0.35]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) [tomcat-coyote.jar:7.0.35]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_35]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_35]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_35]
Caused by: com.mysql.jdbc.municationsException: Communications link failure
I have two web (spring mvc + hibernate + mysql) applications hosted on shared server:
1) main app to show files for download (which is inserted through admin app)
2) admin app with CRUD operations
This error appears sometime, when I am using "admin" application to upload files for "main" app, lets say may be after successfully uploading/processing around 100-120 files/requests and on each request hitting database with 10-20 insert/update queries.
Hosting Details:
Private tomcat hosting
java 1.6.0_35-b10
tomcat 7.0.35
heap size 288MB
MySQL Server 5
commons-dbcp 1.2.2
mysql-connector-java 5.1.9
Database + Hibernate + DBCP properties:
&bean id="dbDataSource" class="mons.dbcp.BasicDataSource"&
&property name="driverClassName" value="com.mysql.jdbc.Driver" /&
&property name="username" value="test" /&
&property name="password" value="test" /&
&property name="url" value="jdbc:mysql://localhost/my_database?useUnicode=yes&characterEncoding=UTF-8" /&
&!-- DBCP Connection Pool Settings --&
&property name="defaultAutoCommit" value="true" /&
&property name="initialSize" value="10" /&
&property name="maxActive" value="500" /&
&property name="maxIdle" value="8" /&
&property name="minIdle" value="0" /&
&property name="maxWait" value="30000" /&
&property name="validationQuery" value="SELECT 1" /&
&property name="testOnBorrow" value="true" /&
&property name="testOnReturn" value="false" /&
&property name="testWhileIdle" value="false" /&
&property name="timeBetweenEvictionRunsMillis" value="-1" /&
&property name="numTestsPerEvictionRun" value="3" /&
&property name="minEvictableIdleTimeMillis" value="180000" /&
&property name="poolPreparedStatements" value="true" /&
&property name="maxOpenPreparedStatements" value="25" /&
&property name="accessToUnderlyingConnectionAllowed" value="false" /&
&property name="removeAbandoned" value="false" /&
&property name="removeAbandonedTimeout" value="300" /&
&property name="logAbandoned" value="false" /&
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.hbm2ddl.auto=none
hibernate.jdbc.batch_size=100
hibernate.show_sql=false
hibernate.format_sql=false
hibernate.cache.use_second_level_cache=true
hibernate.cache.use_query_cache=false
hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider
hibernate.current_session_context_class=thread
Concerned Code:
public String createFilePackage(FilePackage package) {
String message = "";
Session session = getSessionFactory().openSession();
Transaction tx =
tx = session.beginTransaction();
// handling package, around 10-14 DB insert, 10 SELECT and 5 update queries on same session
tx.commit();
} catch(Exception e) {
logger.error("file-upload: Exception while adding new font package", e);
if(tx != null) { tx.rollback(); }
} finally {
session.close();
any advise how to solve this issue?
The communication link between the driver and the data source to which the driver was attempting to connect failed before the function completed processing.
So usually its a network error. This could be caused by packet drops or badly configured Firewall/Switch.
1,67221335
Did you find this question interesting? Try our newsletter
Sign up for our newsletter and get our top new questions delivered to your inbox ().
Subscribed!
Success! Please click the link in the confirmation email to activate your subscription.
Check your server config file /etc/f - verify bind_address is not set to 127.0.0.1. Set it to 0.0.0.0 or comment it out then restart server with:
sudo service mysql restart
7,75911234
This error occurs by timeout your connection
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
Stack Overflow works best with JavaScript enabledHFSS仿真出现的问题:Communication failure. - HFSS使用问答
易迪拓培训,专注于微波、射频、天线设计工程师的培养
HFSS仿真出现的问题:Communication failure.
HFSS仿真出现的问题:Communication failure.
在win7下仿真出现以下的问题
bowtie（C:/Users/ken/Documents/Ansoft/)
BowTie(DrivenModal)
[error] Communication failure. System error no: 14001, error description:Unknown error (1:56:13 &I&A&I& &AE&&O&A 05, 2010)
[error] Unable to create child process: hf3d. (1:56:13 &I&A&I& &AE&&O&A 05, 2010)
[error] Simulation completed with execution error on server: Local Machine. (1:56:13 &I&A&I& &AE&&O&A 05, 2010)
根本做不了仿真，但我真的不知道这是什么原因造成的，希望大家帮忙解决。同一个版本的hfss安装在xp下是没有任何问题的。在win7下重装了还是一样。
希望你们帮忙解决，谢谢各位
有可能是win7 版本和不兼容
你好，我用的是win7 的64 位。
可能是你安装的问题，我安装在Win7下C：Program Files (X86)Ansoft下，用起来没有问题
你好，我也是安装在这个目录下的，已经装了2次了。所以不知道为什么这样。而且应该不是硬件的问题。因为在旧的电脑上安装是可以用的。所以。望大家帮忙解决。
你换个安装路径&&&&不能安装在 USER那个路径下的&&&&重新安装试试看&&
好的，我再试试，谢谢
重装在C：Program Files (X86)Ansoft这里，不过结果一样，还是显示同样的错误。究竟是为什么呢。真烦人。呵呵
很感动ing。。重于搞掂拉。答案就是要先安装 VC++ redistributable 2010, 以及更改路径。不能在原来的地址安装。恩就这样。多謝各位
我是初学hfss的学员，对照按例仿真出现这个问题，，不知道是什么原因，请高手解答
hfss_diel_res
[error] Initial mesh, process mesh3d : Error while opening or writing the mesh files. (12:21 &I&A&I&&E&&O&&O&A 19, 2010)
[error] Simulation completed with execution error on server: Local Machine. (12:21 &I&A&I&&E&&O&&O&A 19, 2010)
申明：网友回复良莠不齐，仅供参考。如需专业解答，请学习由易迪拓培训专家讲授的。
HFSS视频培训课程推荐
迄今国内最全面、权威、专业的HFSS培训课程，可以帮助您从零开始，全面系统学习HFSS设计应用【】
HFSS相关栏目
频道总排行