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

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 e

rror 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,loca

tion='112.868339,28.194399',precisionlevel=3,geom=st_geomfromtext ('point(112.86

8339 28.194399)',4326) where 1=1 and tbprjid=18259

### Cause: org.postgresql.util.PSQLException: An I/O error occurred while sendin

g to the backend.

; An I/O error occurred while sending to the backend.; nested exception is org.p

ostgresql.util.PSQLException: An I/O error occurred while sending to the backend

.

        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra

nslate(SQLStateSQLExceptionTranslator.java:107)

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat

or.translate(AbstractFallbackSQLExceptionTranslator.java:72)

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat

or.translate(AbstractFallbackSQLExceptionTranslator.java:81)

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat

or.translate(AbstractFallbackSQLExceptionTranslator.java:81)

        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPos

sible(MyBatisExceptionTranslator.java:73)

        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(Sq

lSessionTemplate.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(ProjectInf

o_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.doInvok

e(InvocableHandlerMethod.java:189)

        at org.springframework.web.method.support.InvocableHandlerMethod.invokeF

orRequest(InvocableHandlerMethod.java:138)

        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocabl

eHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)

        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH

andlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)

        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH

andlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)

        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapt

er.handle(AbstractHandlerMethodAdapter.java:87)

        at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch

erServlet.java:1038)

        at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche

rServlet.java:942)

        at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame

workServlet.java:1005)

        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServ

let.java:908)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)

        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkSer

vlet.java:882)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:231)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53

)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(

RequestContextFilter.java:99)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR

equestFilter.java:107)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.springframework.web.filter.FormContentFilter.doFilterInternal(For

mContentFilter.java:92)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR

equestFilter.java:107)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInterna

l(HiddenHttpMethodFilter.java:93)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR

equestFilter.java:107)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern

al(CharacterEncodingFilter.java:200)

        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR

equestFilter.java:107)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:200)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

torBase.java:490)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:139)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:92)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:74)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:343)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java

:408)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig

ht.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract

Protocol.java:834)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo

int.java:1415)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas

e.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(TaskTh

read.java:61)

        at java.lang.Thread.run(Unknown Source)

Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sendin

g to the backend.

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja

va: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(PgPreparedSt

atement.java:143)

        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.j

ava:132)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:67)

        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(

PreparedStatementHandler.java:47)

        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(R

outingStatementHandler.java:74)

        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.jav

a:50)

        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)


        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.jav

a:76)

        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSq

lSession.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(Sq

lSessionTemplate.java:433)

        ... 60 more

Caused 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(VisibleBuffer

edInputStream.java:140)

        at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBuf

feredInputStream.java:109)

        at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedIn

putStream.java:67)

        at org.postgresql.core.PGStream.receiveChar(PGStream.java:306)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor

Impl.java:1952)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja

va:308)

        ... 75 more


查看完整描述

目前暂无任何回答

添加回答

回复

举报

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