Re: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.

From: Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>
To: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
Date: 2019-03-04 09:14:59
Message-ID: CADQhkWHXvuqjW05hiymkNWnVFaZSVOq=fxRHCXwKUa_WYF0_jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

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(at)ohumhealthcare(dot)com> wrote:

> CentOS Linux release 7.3.1611
>
> On Wed, Feb 27, 2019 at 9:22 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)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..?
>>
>> Thanks & Regards,
>> *Shreeyansh DBA Team*
>> www.shreeyansh.com
>>
>>
>> On Wed, Feb 27, 2019 at 6:45 PM Ashok Kumar Tiwari <
>> ashokt(at)ohumhealthcare(dot)com> wrote:
>>
>>> 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(at)gmail(dot)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.html
>>>>
>>>> Thanks & Regards,
>>>> *Shreeyansh DBA Team*
>>>> www.shreeyansh.com
>>>>
>>>>
>>>> On Tue, Feb 26, 2019 at 3:47 PM Ashok Kumar Tiwari <
>>>> ashokt(at)ohumhealthcare(dot)com> wrote:
>>>>
>>>>> 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)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Ashok Kumar Tiwari,
>>>>> Senior Technical Consultant,
>>>>> ashokt(at)ohumhealthcare(dot)com,
>>>>> *M*:+91-9657628833
>>>>>
>>>>>
>>>>> [image: http://www.blystreecare.com/images/tree-clipart-4.gif] 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.
>>>>>
>>>>
>>>
>>> --
>>> Ashok Kumar Tiwari,
>>> Senior Technical Consultant,
>>> ashokt(at)ohumhealthcare(dot)com,
>>> *M*:+91-9657628833
>>>
>>>
>>> [image: http://www.blystreecare.com/images/tree-clipart-4.gif] 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.
>>>
>>
>
> --
> Ashok Kumar Tiwari,
> Senior Technical Consultant,
> ashokt(at)ohumhealthcare(dot)com,
> *M*:+91-9657628833
>
>

--
Ashok Kumar Tiwari,
Senior Technical Consultant,
ashokt(at)ohumhealthcare(dot)com,
*M*:+91-9657628833

--

 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aliza Abulafia 2019-03-04 10:53:51 postgresql11 space reuse under high delete/update rate
Previous Message Jehan-Guillaume (ioguix) de Rorthais 2019-03-03 13:44:48 Re: switchover/switchback