Thread: org.postgresql.util.PSQLException: An I/O error occurred whilesending to the backend.
Hi.
my java application display error please help
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
Hi Ashok,
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.html
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.html
On Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:
Hi.my java application display error please helporg.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
Hi Shreeyansh .
My pgpool-ii log display this errors
Feb 27 17:11:44 pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:11:57 pgpool-01 kernel: traps: pgpool[28586] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:11:59 pgpool-01 kernel: traps: pgpool[28676] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:12:00 pgpool-01 kernel: traps: pgpool[28815] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:12:01 pgpool-01 kernel: traps: pgpool[28814] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:12:03 pgpool-01 kernel: traps: pgpool[28217] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-1] 2019-02-27 17:12:04: pid 28924: WARNING: fail_over_on_backend_error is changed to failover_on_backend_error
Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-2] 2019-02-27 17:12:04: pid 28924: DETAIL: setting failover_on_backend_error has no effect
Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-3] 2019-02-27 17:12:04: pid 28924: HINT: use failover_on_backend_error instead
Feb 27 17:12:05 pgpool-01 pgpool[28929]: [1-1] 2019-02-27 17:12:05: pid 28929: WARNING: fail_over_on_backend_error is changed to failover_on_backend_error
Feb 27 17:12:05 pgpool-01 pgpool[28929]: [1-2] 2019-02-27 17:12:05: pid 28929: DETAIL: setting failover_on_backend_error has no effect
Feb 27 17:12:05 pgpool-01 pgpool[28929]: [1-3] 2019-02-27 17:12:05: pid 28929: HINT: use failover_on_backend_error instead
Feb 27 17:20:28 pgpool-01 pgpool[29841]: [1-1] 2019-02-27 17:20:28: pid 29841: WARNING: fail_over_on_backend_error is changed to failover_on_backend_error
Feb 27 17:20:28 pgpool-01 pgpool[29841]: [1-2] 2019-02-27 17:20:28: pid 29841: DETAIL: setting failover_on_backend_error has no effect
Feb 27 17:20:28 pgpool-01 pgpool[29841]: [1-3] 2019-02-27 17:20:28: pid 29841: HINT: use failover_on_backend_error instead
Feb 27 17:20:58 pgpool-01 pgpool[30332]: [9-2] 2019-02-27 17:20:58: pid 30332: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:20:58 pgpool-01 pgpool[30264]: [9-2] 2019-02-27 17:20:58: pid 30264: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:20:58 pgpool-01 pgpool[30301]: [9-2] 2019-02-27 17:20:58: pid 30301: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:20:58 pgpool-01 pgpool[30346]: [9-2] 2019-02-27 17:20:58: pid 30346: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:20:58 pgpool-01 pgpool[30339]: [9-2] 2019-02-27 17:20:58: pid 30339: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:20:58 pgpool-01 pgpool[30179]: [9-2] 2019-02-27 17:20:58: pid 30179: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30486]: [286-2] 2019-02-27 17:25:37: pid 30486: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30519]: [352-2] 2019-02-27 17:25:37: pid 30519: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30528]: [370-2] 2019-02-27 17:25:37: pid 30528: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30388]: [90-2] 2019-02-27 17:25:37: pid 30388: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30242]: [9-2] 2019-02-27 17:25:37: pid 30242: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:25:37 pgpool-01 pgpool[30430]: [174-2] 2019-02-27 17:25:37: pid 30430: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:26:37 pgpool-01 kernel: traps: pgpool[30459] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]
Feb 27 17:29:23 pgpool-01 pgpool[30233]: [12-2] 2019-02-27 17:29:23: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:23 pgpool-01 pgpool[30495]: [304-2] 2019-02-27 17:29:23: pid 30495: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:23 pgpool-01 pgpool[30398]: [110-2] 2019-02-27 17:29:23: pid 30398: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:23 pgpool-01 pgpool[29858]: [9-2] 2019-02-27 17:29:23: pid 29858: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:23 pgpool-01 pgpool[30392]: [98-2] 2019-02-27 17:29:23: pid 30392: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:23 pgpool-01 pgpool[30442]: [202-2] 2019-02-27 17:29:23: pid 30442: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:29:35 pgpool-01 kernel: traps: pgpool[30388] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]
Feb 27 17:32:04 pgpool-01 pgpool[30655]: [622-2] 2019-02-27 17:32:04: pid 30655: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:32:04 pgpool-01 pgpool[30658]: [628-2] 2019-02-27 17:32:04: pid 30658: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:32:04 pgpool-01 pgpool[30233]: [13-2] 2019-02-27 17:32:04: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:32:04 pgpool-01 pgpool[30694]: [700-2] 2019-02-27 17:32:04: pid 30694: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:32:04 pgpool-01 pgpool[30745]: [802-2] 2019-02-27 17:32:04: pid 30745: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30823]: [958-2] 2019-02-27 17:41:34: pid 30823: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30914]: [1140-2] 2019-02-27 17:41:34: pid 30914: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30900]: [1112-2] 2019-02-27 17:41:34: pid 30900: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30909]: [1130-2] 2019-02-27 17:41:34: pid 30909: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]
[
On Tue, Feb 26, 2019 at 6:41 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
Hi Ashok,
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.htmlOn Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi.my java application display error please helporg.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
This is a software bug, which OS you are using..?
This is a software bug, which OS you are using..?
On Wed, Feb 27, 2019 at 6:45 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:
Hi Shreeyansh .My pgpool-ii log display this errorsFeb 27 17:11:44 pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:57 pgpool-01 kernel: traps: pgpool[28586] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:59 pgpool-01 kernel: traps: pgpool[28676] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:00 pgpool-01 kernel: traps: pgpool[28815] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:01 pgpool-01 kernel: traps: pgpool[28814] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:03 pgpool-01 kernel: traps: pgpool[28217] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-1] 2019-02-27 17:12:04: pid 28924: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-2] 2019-02-27 17:12:04: pid 28924: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-3] 2019-02-27 17:12:04: pid 28924: HINT: use failover_on_backend_error insteadFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-1] 2019-02-27 17:12:05: pid 28929: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-2] 2019-02-27 17:12:05: pid 28929: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-3] 2019-02-27 17:12:05: pid 28929: HINT: use failover_on_backend_error insteadFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-1] 2019-02-27 17:20:28: pid 29841: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-2] 2019-02-27 17:20:28: pid 29841: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-3] 2019-02-27 17:20:28: pid 29841: HINT: use failover_on_backend_error insteadFeb 27 17:20:58 pgpool-01 pgpool[30332]: [9-2] 2019-02-27 17:20:58: pid 30332: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30264]: [9-2] 2019-02-27 17:20:58: pid 30264: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30301]: [9-2] 2019-02-27 17:20:58: pid 30301: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30346]: [9-2] 2019-02-27 17:20:58: pid 30346: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30339]: [9-2] 2019-02-27 17:20:58: pid 30339: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30179]: [9-2] 2019-02-27 17:20:58: pid 30179: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30486]: [286-2] 2019-02-27 17:25:37: pid 30486: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30519]: [352-2] 2019-02-27 17:25:37: pid 30519: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30528]: [370-2] 2019-02-27 17:25:37: pid 30528: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30388]: [90-2] 2019-02-27 17:25:37: pid 30388: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30242]: [9-2] 2019-02-27 17:25:37: pid 30242: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30430]: [174-2] 2019-02-27 17:25:37: pid 30430: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:26:37 pgpool-01 kernel: traps: pgpool[30459] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:29:23 pgpool-01 pgpool[30233]: [12-2] 2019-02-27 17:29:23: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30495]: [304-2] 2019-02-27 17:29:23: pid 30495: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30398]: [110-2] 2019-02-27 17:29:23: pid 30398: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[29858]: [9-2] 2019-02-27 17:29:23: pid 29858: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30392]: [98-2] 2019-02-27 17:29:23: pid 30392: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30442]: [202-2] 2019-02-27 17:29:23: pid 30442: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:35 pgpool-01 kernel: traps: pgpool[30388] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:32:04 pgpool-01 pgpool[30655]: [622-2] 2019-02-27 17:32:04: pid 30655: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30658]: [628-2] 2019-02-27 17:32:04: pid 30658: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30233]: [13-2] 2019-02-27 17:32:04: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30694]: [700-2] 2019-02-27 17:32:04: pid 30694: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30745]: [802-2] 2019-02-27 17:32:04: pid 30745: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30823]: [958-2] 2019-02-27 17:41:34: pid 30823: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30914]: [1140-2] 2019-02-27 17:41:34: pid 30914: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30900]: [1112-2] 2019-02-27 17:41:34: pid 30900: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30909]: [1130-2] 2019-02-27 17:41:34: pid 30909: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000][On Tue, Feb 26, 2019 at 6:41 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Ashok,
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.htmlOn Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi.my java application display error please helporg.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
--
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
CentOS Linux release 7.3.1611
On Wed, Feb 27, 2019 at 9:22 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
This is a software bug, which OS you are using..?On Wed, Feb 27, 2019 at 6:45 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi Shreeyansh .My pgpool-ii log display this errorsFeb 27 17:11:44 pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:57 pgpool-01 kernel: traps: pgpool[28586] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:59 pgpool-01 kernel: traps: pgpool[28676] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:00 pgpool-01 kernel: traps: pgpool[28815] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:01 pgpool-01 kernel: traps: pgpool[28814] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:03 pgpool-01 kernel: traps: pgpool[28217] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-1] 2019-02-27 17:12:04: pid 28924: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-2] 2019-02-27 17:12:04: pid 28924: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-3] 2019-02-27 17:12:04: pid 28924: HINT: use failover_on_backend_error insteadFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-1] 2019-02-27 17:12:05: pid 28929: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-2] 2019-02-27 17:12:05: pid 28929: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-3] 2019-02-27 17:12:05: pid 28929: HINT: use failover_on_backend_error insteadFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-1] 2019-02-27 17:20:28: pid 29841: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-2] 2019-02-27 17:20:28: pid 29841: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-3] 2019-02-27 17:20:28: pid 29841: HINT: use failover_on_backend_error insteadFeb 27 17:20:58 pgpool-01 pgpool[30332]: [9-2] 2019-02-27 17:20:58: pid 30332: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30264]: [9-2] 2019-02-27 17:20:58: pid 30264: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30301]: [9-2] 2019-02-27 17:20:58: pid 30301: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30346]: [9-2] 2019-02-27 17:20:58: pid 30346: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30339]: [9-2] 2019-02-27 17:20:58: pid 30339: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30179]: [9-2] 2019-02-27 17:20:58: pid 30179: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30486]: [286-2] 2019-02-27 17:25:37: pid 30486: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30519]: [352-2] 2019-02-27 17:25:37: pid 30519: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30528]: [370-2] 2019-02-27 17:25:37: pid 30528: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30388]: [90-2] 2019-02-27 17:25:37: pid 30388: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30242]: [9-2] 2019-02-27 17:25:37: pid 30242: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30430]: [174-2] 2019-02-27 17:25:37: pid 30430: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:26:37 pgpool-01 kernel: traps: pgpool[30459] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:29:23 pgpool-01 pgpool[30233]: [12-2] 2019-02-27 17:29:23: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30495]: [304-2] 2019-02-27 17:29:23: pid 30495: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30398]: [110-2] 2019-02-27 17:29:23: pid 30398: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[29858]: [9-2] 2019-02-27 17:29:23: pid 29858: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30392]: [98-2] 2019-02-27 17:29:23: pid 30392: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30442]: [202-2] 2019-02-27 17:29:23: pid 30442: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:35 pgpool-01 kernel: traps: pgpool[30388] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:32:04 pgpool-01 pgpool[30655]: [622-2] 2019-02-27 17:32:04: pid 30655: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30658]: [628-2] 2019-02-27 17:32:04: pid 30658: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30233]: [13-2] 2019-02-27 17:32:04: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30694]: [700-2] 2019-02-27 17:32:04: pid 30694: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30745]: [802-2] 2019-02-27 17:32:04: pid 30745: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30823]: [958-2] 2019-02-27 17:41:34: pid 30823: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30914]: [1140-2] 2019-02-27 17:41:34: pid 30914: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30900]: [1112-2] 2019-02-27 17:41:34: pid 30900: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30909]: [1130-2] 2019-02-27 17:41:34: pid 30909: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000][On Tue, Feb 26, 2019 at 6:41 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Ashok,
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.htmlOn Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi.my java application display error please helporg.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
--
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
HI Shreeyansh team,
Please help me how can i solve this issue , im using postgresql 11.2 and pgpool-ii v4 on CentOS Linux release 7.3.1611.
1. issune.
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
2. issue ( pgpool-2) v4 log error.
Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer"
Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]
[
On Thu, Feb 28, 2019 at 12:54 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:
CentOS Linux release 7.3.1611On Wed, Feb 27, 2019 at 9:22 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]
This is a software bug, which OS you are using..?On Wed, Feb 27, 2019 at 6:45 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi Shreeyansh .My pgpool-ii log display this errorsFeb 27 17:11:44 pgpool-01 kernel: traps: pgpool[28703] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:57 pgpool-01 kernel: traps: pgpool[28586] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:11:59 pgpool-01 kernel: traps: pgpool[28676] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:00 pgpool-01 kernel: traps: pgpool[28815] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:01 pgpool-01 kernel: traps: pgpool[28814] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:03 pgpool-01 kernel: traps: pgpool[28217] general protection ip:7f74c04fa77a sp:7fff11d4bea0 error:0 in ld-2.17.so[7f74c04e7000+20000]Feb 27 17:12:04 pgpool-01 pgpool[28924]: [1-1] 2019-02-27 17:12:04: pid 28924: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-2] 2019-02-27 17:12:04: pid 28924: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:04 pgpool-01 pgpool[28924]: [1-3] 2019-02-27 17:12:04: pid 28924: HINT: use failover_on_backend_error insteadFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-1] 2019-02-27 17:12:05: pid 28929: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-2] 2019-02-27 17:12:05: pid 28929: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:12:05 pgpool-01 pgpool[28929]: [1-3] 2019-02-27 17:12:05: pid 28929: HINT: use failover_on_backend_error insteadFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-1] 2019-02-27 17:20:28: pid 29841: WARNING: fail_over_on_backend_error is changed to failover_on_backend_errorFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-2] 2019-02-27 17:20:28: pid 29841: DETAIL: setting failover_on_backend_error has no effectFeb 27 17:20:28 pgpool-01 pgpool[29841]: [1-3] 2019-02-27 17:20:28: pid 29841: HINT: use failover_on_backend_error insteadFeb 27 17:20:58 pgpool-01 pgpool[30332]: [9-2] 2019-02-27 17:20:58: pid 30332: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30264]: [9-2] 2019-02-27 17:20:58: pid 30264: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30301]: [9-2] 2019-02-27 17:20:58: pid 30301: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30346]: [9-2] 2019-02-27 17:20:58: pid 30346: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30339]: [9-2] 2019-02-27 17:20:58: pid 30339: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:20:58 pgpool-01 pgpool[30179]: [9-2] 2019-02-27 17:20:58: pid 30179: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30486]: [286-2] 2019-02-27 17:25:37: pid 30486: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30519]: [352-2] 2019-02-27 17:25:37: pid 30519: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30528]: [370-2] 2019-02-27 17:25:37: pid 30528: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30388]: [90-2] 2019-02-27 17:25:37: pid 30388: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30242]: [9-2] 2019-02-27 17:25:37: pid 30242: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:25:37 pgpool-01 pgpool[30430]: [174-2] 2019-02-27 17:25:37: pid 30430: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:26:37 pgpool-01 kernel: traps: pgpool[30459] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:29:23 pgpool-01 pgpool[30233]: [12-2] 2019-02-27 17:29:23: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30495]: [304-2] 2019-02-27 17:29:23: pid 30495: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30398]: [110-2] 2019-02-27 17:29:23: pid 30398: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[29858]: [9-2] 2019-02-27 17:29:23: pid 29858: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30392]: [98-2] 2019-02-27 17:29:23: pid 30392: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:23 pgpool-01 pgpool[30442]: [202-2] 2019-02-27 17:29:23: pid 30442: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:29:35 pgpool-01 kernel: traps: pgpool[30388] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000]Feb 27 17:32:04 pgpool-01 pgpool[30655]: [622-2] 2019-02-27 17:32:04: pid 30655: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30658]: [628-2] 2019-02-27 17:32:04: pid 30658: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30233]: [13-2] 2019-02-27 17:32:04: pid 30233: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30694]: [700-2] 2019-02-27 17:32:04: pid 30694: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:32:04 pgpool-01 pgpool[30745]: [802-2] 2019-02-27 17:32:04: pid 30745: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30823]: [958-2] 2019-02-27 17:41:34: pid 30823: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30914]: [1140-2] 2019-02-27 17:41:34: pid 30914: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30900]: [1112-2] 2019-02-27 17:41:34: pid 30900: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30909]: [1130-2] 2019-02-27 17:41:34: pid 30909: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[29917]: [9-2] 2019-02-27 17:41:34: pid 29917: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:41:34 pgpool-01 pgpool[30800]: [912-2] 2019-02-27 17:41:34: pid 30800: DETAIL: socket read failed with an error "Connection reset by peer"Feb 27 17:45:13 pgpool-01 kernel: traps: pgpool[30939] general protection ip:7f7347ae6f32 sp:7ffd9b2ebe60 error:0 in libc-2.17.so[7f7347a6e000+1b6000][On Tue, Feb 26, 2019 at 6:41 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Ashok,
When you look at the Postgres logs in the pg_log directory on the database server, do you see any log messages that match your PDI errors? Do these steps take a long time to run? From your log snippet, Most likely your JDBC socket is timing out after a certain time before the function could finish executing.
You can try setting the socket timeout to a higher value as mentioned in https://jdbc.postgresql.org/documentation/head/connect.htmlOn Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <ashokt@ohumhealthcare.com> wrote:Hi.my java application display error please helporg.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at org.postgresql.jdbc.PgConnection.isValid(PgConnection.java:1364)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:150)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:172)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:312)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1647)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:732)
at org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:747)
at org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:250)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:342)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1070)
at com.ohum.dao.GenericDAO$GenericQuery.procResultSet(GenericDAO.java:1193)
at com.ohum.services.pas.UserManagementServiceImpl.loginNameExists(UserManagementServiceImpl.java:96)
at com.ohum.services.pas.UserManagementServiceImpl$$FastClassBySpringCGLIB$$a732c9b.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.pas.UserManagementServiceImpl$$EnhancerBySpringCGLIB$$60984b37.loginNameExists(<generated>)
at com.ohum.util.auth.DefaultAuthenticationImpl.attempAuthentication(DefaultAuthenticationImpl.java:187)
at com.ohum.util.auth.DefaultAuthenticationImpl$$FastClassBySpringCGLIB$$560cdbef.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.util.auth.DefaultAuthenticationImpl$$EnhancerBySpringCGLIB$$f542f0a5.attempAuthentication(<generated>)
at com.ohum.services.AuthenticationServiceImpl.loginFormParams(AuthenticationServiceImpl.java:89)
at com.ohum.services.AuthenticationServiceImpl$$FastClassBySpringCGLIB$$c8c8349d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.ohum.aspects.ServiceLayerAspect$1.execute(ServiceLayerAspect.java:171)
at com.ohum.aspects.ServiceLayerAspect.handleWorkflow(ServiceLayerAspect.java:545)
at com.ohum.aspects.ServiceLayerAspect.handleServices(ServiceLayerAspect.java:168)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:643)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:632)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.ohum.services.AuthenticationServiceImpl$$EnhancerBySpringCGLIB$$bc33747d.loginFormParams(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268)
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:52)
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.CorsFilter.doFilterInternal(CorsFilter.java:96)
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 com.ohum.interceptors.sso.SSOAuthFilter.doFilter(SSOAuthFilter.java:227)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.ohum.interceptors.CrudOperationsFilter.doFilter(CrudOperationsFilter.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:204)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
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:81)
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 com.ohum.interceptors.IntegrationOperationsFilter.doFilter(IntegrationOperationsFilter.java:549)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
--
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.
--
Save a tree. Please avoid printing this email unless necessary.
***** Email confidentiality notice *****
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.