为了账号安全,请及时绑定邮箱和手机立即绑定

postgresql执行一段时间报 An I/O e rror occurred while sending to the backend.求解!

postgresql执行一段时间报 An I/O e rror occurred while sending to the backend.求解!

勿莣洎莪 2019-11-07 11:36:01
### Error updating database.  Cause: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.### The error may exist in com/cennavi/Mybatis/Mapper/ProjectInfoExt_BasicMapper.java (best guess)### The error may involve com.cennavi.Mybatis.Mapper.ProjectInfoExt_BasicMapper.Update-Inline### The error occurred while setting parameters### SQL: update projectinfoext  set longitude=112.868339,latitude=28.194399,location='112.868339,28.194399',precisionlevel=3,geom=st_geomfromtext ('point(112.868339 28.194399)',4326) where 1=1 and tbprjid=18259### Cause: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.; An I/O error occurred while sending to the backend.; nested exception is org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)        at com.sun.proxy.$Proxy69.update(Unknown Source)        at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)        at com.sun.proxy.$Proxy76.Update(Unknown Source)        at com.cennavi.Service.ProjectInfo_Basic.UpdateProjectInfoExt(ProjectInfo_Basic.java:69)        at com.cennavi.Controller.ProjectInfo_Basic.UpdateProjectExt(ProjectInfo_Basic.java:84)        at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)        at java.lang.reflect.Method.invoke(Unknown Source)        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:660)        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)        at java.lang.Thread.run(Unknown Source)Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:335)        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67)        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)        at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)        at java.lang.reflect.Method.invoke(Unknown Source)        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)        ... 60 moreCaused by: java.net.SocketTimeoutException: Read timed out        at java.net.SocketInputStream.socketRead0(Native Method)        at java.net.SocketInputStream.socketRead(Unknown Source)        at java.net.SocketInputStream.read(Unknown Source)        at java.net.SocketInputStream.read(Unknown Source)        at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140)        at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109)        at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67)        at org.postgresql.core.PGStream.receiveChar(PGStream.java:306)        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1952)        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)        ... 75 more
查看完整描述

目前暂无任何回答

  • 0 回答
  • 0 关注
  • 11432 浏览
慕课专栏
更多

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信