Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unex

最新推荐文章于 2024-04-18 00:59:15 发布
最新推荐文章于 2024-04-18 00:59:15 发布
阅读量1.8k 收藏
点赞数
文章标签： java 数据库 测试
原文链接：https://yq.aliyun.com/articles/341909
版权

Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.


十一月 29, 2017 5:19:12 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [SpringMVC] in context with path [/smarthome] threw exception [Request processing failed; nested exception is org.springframework.dao.RecoverableDataAccessException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 88,231 milliseconds ago.  The last packet sent successfully to the server was 90,569 milliseconds ago.
### The error may exist in file [/Users/aven/Documents/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/smarthome/WEB-INF/classes/com/wanyu/smarthome/mapping/MessageMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * From (Select                   x.`id`,          x.`msg_type`,          x.`refer_id`,          x.`operation`,          x.`content`,          x.`create_time`,          x.`title`,          x.`from_id`,          x.`target_id`,          x.`avatar`,          x.`family_id`          , not isnull(y.id) isRead, y.`isDelete`       FROM `message` x left JOIN message_log y ON x.id=y.message_id           WHERE  x.`msg_type` >= ?             AND x.`msg_type` <= ?                                                                              AND x.`target_id` = ?                     Or isnull(x.target_id)         Or x.`family_id` = ?       group by x.id         ORDER BY  isRead DESC    ) temp Where isNull(`isDelete`)         AND isRead = false
### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 88,231 milliseconds ago.  The last packet sent successfully to the server was 90,569 milliseconds ago.
; SQL []; Communications link failure

The last packet successfully received from the server was 88,231 milliseconds ago.  The last packet sent successfully to the server was 90,569 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 88,231 milliseconds ago.  The last packet sent successfully to the server was 90,569 milliseconds ago.] with root cause
java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011)
	at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2064)
	at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1989)
	at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3410)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:470)
	at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3112)
	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2341)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2736)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
	at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	at com.sun.proxy.$Proxy14.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:205)
	at com.wanyu.frame.base.BaseMyIbatisDao.findRowBy(BaseMyIbatisDao.java:400)
	at com.wanyu.frame.base.BaseManager.findRowBy(BaseManager.java:151)
	at com.wanyu.smarthome.mobile.MessageMobile.hasMessage(MessageMobile.java:248)
	at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.wanyu.frame.base.AuthFilter.doFilter(AuthFilter.java:97)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1524)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1480)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)

偶尔会遇到这个问题，还不清楚原因。



weixin_34162401
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mysql: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection ...
weixin_34025051的博客
05-31 5272
2019-05-28 01:53:42.762 [message remind thread-24] ERROR druid.sql.Statement - {conn-10327, stmt-32027} execute error. SELECT 1 FROM DUALcom.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun...
web服务连接mysql报错 解析:Can not read response from server. Expected to read 4 bytes, read 0 bytes before c
xiaobai001gonsoni的博客
12-23 3万+
报错内容: The last packet successfully received from the server was 3,087,649 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago. at sun.reflect.GeneratedConstruct
mysql数据库大数据量jdbc查询报错: Can not read response from server
最新发布
高性价比服务器就选：蓝易云
04-18 513
总结来说，“Can not read response from server”错误通常涉及到网络、数据库配置和优化等多方面因素，在遇到此类错误时需要从多角度进行排查和解析，并根据具体原因采取相应措施进行修复处理。在大数据量情况下，可能会出现长时间无响应导致连接被关闭。在处理MySQL数据库时，如果你遇到了"Can not read response from server"的错误，这可能是由于多种原因导致的。尝试减少查询中返回的数据量，例如，只选择你需要的列，使用LIMIT语句限制返回行数。
Can not read response from server. Expected to read 4 bytes, read 0 bytes be
热门推荐
sumengnan的博客
06-05 6万+
springboot项目启动时连接mysql时提示，Can not read response from server. Expected to read 4 bytes, read 0 bytes be…… 解决办法： 1、检查数据库连接池的参数（尽量开发环境连接数不要设置太大） spring.datasource.max-active=100 spring.datasource.max-idle=20 spring.datasource.min-idle=8 spring.datasource.
Can not read response from server. Expected to read 4 bytes, read 0
北海之灵的博客
04-02 1万+
JavaWeb项目 Mysql报错如下： Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 连接池参数配置的问题。 项目中增加 连接池参数后重启项目...
mysql 报错：Can not read response from server. Expected to read 4 bytes, read 0 bytes be
q1035331653的博客
07-01 2万+
记录最近开发遇到一个这样的错误，Can not read response from server. Expected to read 4 bytes, read 0 bytes be，执行出错的第三是在定时任务，3秒一次执行，查询数据库的时候抛的错误 经过网上一堆查询资料后原因：使用的连接池，连接池里的链接已经关闭了，但是连接池未次此链接已关闭，仍然去执行sql，结果导致错误。 抱着试一试的心态，加上了一个验证链接的sql 基于springboot的项目，截图如下： 问题得到解决。 .
idea报错：Can not read response from server. Expected to read 4 bytes, read 0 bytes be
Remvery的博客
05-28 5862
问题描述 提示：这里描述项目中遇到的问题： 爆出这种说是超时错误 Can not read response from server. Expected to read 4 bytes, read 0 bytes be 原因分析： 提示：这里填写问题的分析： 网上有很多，我说说我怎么解决的吧，主要是在使用网上的方法前一定要尝试自己连接一波数据库 我就是数据库自己出现了异常排查了半天 2013 lost connection to Mysql 就像这种重启下数据库就了事的让我花了块半个小时， 小提醒：
http.client.IncompleteRead: IncompleteRead(0 bytes read)
12-21
File "/home/ubuntu/workspace/dcard/venv/lib/python3.5/site-packages/requests/packages/urllib3/response.py", line 435, in _update_chunk_length self.chunk_left = int(line, 16) ValueError: invalid ...
Pandas之read_csv()读取文件跳过报错行的解决
12-20
ParserError：Error tokenizing data.C error:Expected 2 fields in line 407,saw 3. 是指在csv文件的第407行数据，期待2个字段，但在第407行实际发现了3个字段。 原因：header只有两个字段名，但数据的第407行却...
Python3中内置类型bytes和str用法及byte和string之间各种编码转换 问题
12-25
Python 3最重要的新特性大概要算是对文本和二进制数据作了更为清晰的区分。文本总是Unicode，由str...bytes([1,2,3,4,5,6,7,8,9]) bytes("python", 'ascii') # 字符串，编码 设置一个原始的字符串 >>> website = 'htt
Python3——bytes和str
12-23
Python3——bytes 和str 参考链接： Python3种的str和bytes区别、包含python2与python3的区别 Python3中的bytes和str类型 编码方式 ASCII编码：8个比特位代表一个字符的编码，最多表示282^828个字符 UNICODE：规定...
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with Oracle database 8.1.7 and I have written a JAVA code to update the table which contains one BLOB field . I am using updateBinaryStream method of resultset to update the BLOB field...
Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection w
ccmedu的博客
01-09 6205
问题原因：数据库连接池太小 解决办法：增大初始连接数、增大最大连接数
mysql连接报错：Can not read response from server. Expected to read 4 bytes, read 0 bytes before connectio
weixin_44736853的博客
08-12 7032
问题描述：idea连不上mysql 问题分析：开始以为是版本问题造成的时区错误，url加上serverTimezone=GMT&useSSL=true，之后还是报错，navicat也连不上。 解决方法： 网上的解决方法： 1.mysql配置文件中设置回收时间：wait_timeout=86400 2.修改配置文件中的127.0.0.1为0.0.0.0 3.windows下直接到控制面板->服务中重启mysql服务 ...
datax同步到一半报错 java.io.EOFException:
wendyqian1996的博客
10-10 635
设置定时调度的datax任务，将数据从oracle库同步至mysql库，同步一半数据了，突然抛了个EOF异常：java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.可能是因为在同步数据过程中，数据源也在更新，类似于水龙头和排水口同时打开了，池子里的水出现了混乱，因此报错。
java.io.IOException: Unable to read entire header; 90 bytes read; expected 512 bytes
05-05
这个异常是由于IO操作时无法完整读取文件头部导致的。这可能是由于文件损坏或读取权限不足所致。你可以尝试以下步骤来解决这个问题： 1. 确认文件是否完整，如果文件已损坏，你需要找到一个完整的备份文件。 2. 检查文件读取权限，确保当前用户有读取该文件的权限。 3. 尝试使用其他方法读取文件，比如使用BufferedReader或Scanner类读取文件内容。 4. 如果以上方法都无法解决问题，那么可能是硬件故障导致的。你可以尝试更换存储设备或与设备厂商联系以获取更多帮助。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值