"2021-11-21T10:52:51.349000Z":1:JAVA:INFO:demo2.coreip.co.in:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2021-11-21T10:53:02.808000Z":2:JAVA:WARNING:demo2.coreip.co.in:main:00000000:AbstractLifeCycle:"FAILED SslContextFactory@5c066d9b(/etc/sipxpbx/ssl/ssl-web.keystore,/etc/sipxpbx/ssl/ssl-web.keystore): java.io.EOFException" java.io.EOFException at java.io.DataInputStream.readInt(DataInputStream.java:392) at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:658) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) at sun.security.provider.KeyStoreDelegator.engineLoad(KeyStoreDelegator.java:224) at sun.security.provider.JavaKeyStore$DualFormatJKS.engineLoad(JavaKeyStore.java:70) at java.security.KeyStore.load(KeyStore.java:1381) at org.eclipse.jetty.util.security.CertificateUtils.getKeyStore(CertificateUtils.java:55) at org.eclipse.jetty.util.ssl.SslContextFactory.loadKeyStore(SslContextFactory.java:864) at org.eclipse.jetty.util.ssl.SslContextFactory.doStart(SslContextFactory.java:270) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.SslConnectionFactory.doStart(SslConnectionFactory.java:64) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:260) at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:81) at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:218) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.server.Server.doStart(Server.java:337) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174) "2021-11-21T10:53:02.809000Z":3:JAVA:WARNING:demo2.coreip.co.in:main:00000000:AbstractLifeCycle:"FAILED SslConnectionFactory@6a02d2c4{SSL-http/1.1}: java.io.EOFException" java.io.EOFException at java.io.DataInputStream.readInt(DataInputStream.java:392) at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:658) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) at sun.security.provider.KeyStoreDelegator.engineLoad(KeyStoreDelegator.java:224) at sun.security.provider.JavaKeyStore$DualFormatJKS.engineLoad(JavaKeyStore.java:70) at java.security.KeyStore.load(KeyStore.java:1381) at org.eclipse.jetty.util.security.CertificateUtils.getKeyStore(CertificateUtils.java:55) at org.eclipse.jetty.util.ssl.SslContextFactory.loadKeyStore(SslContextFactory.java:864) at org.eclipse.jetty.util.ssl.SslContextFactory.doStart(SslContextFactory.java:270) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.SslConnectionFactory.doStart(SslConnectionFactory.java:64) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:260) at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:81) at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:218) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.server.Server.doStart(Server.java:337) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174) "2021-11-21T10:53:02.810000Z":4:JAVA:WARNING:demo2.coreip.co.in:main:00000000:AbstractLifeCycle:"FAILED ServerConnector@5f5b783b{SSL-http/1.1}{0.0.0.0:8076}: java.io.EOFException" java.io.EOFException at java.io.DataInputStream.readInt(DataInputStream.java:392) at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:658) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) at sun.security.provider.KeyStoreDelegator.engineLoad(KeyStoreDelegator.java:224) at sun.security.provider.JavaKeyStore$DualFormatJKS.engineLoad(JavaKeyStore.java:70) at java.security.KeyStore.load(KeyStore.java:1381) at org.eclipse.jetty.util.security.CertificateUtils.getKeyStore(CertificateUtils.java:55) at org.eclipse.jetty.util.ssl.SslContextFactory.loadKeyStore(SslContextFactory.java:864) at org.eclipse.jetty.util.ssl.SslContextFactory.doStart(SslContextFactory.java:270) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.SslConnectionFactory.doStart(SslConnectionFactory.java:64) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:260) at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:81) at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:218) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.server.Server.doStart(Server.java:337) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174) "2021-11-21T10:53:02.811000Z":5:JAVA:WARNING:demo2.coreip.co.in:main:00000000:AbstractLifeCycle:"FAILED org.eclipse.jetty.server.Server@6e329a65: java.io.EOFException" java.io.EOFException at java.io.DataInputStream.readInt(DataInputStream.java:392) at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:658) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) at sun.security.provider.KeyStoreDelegator.engineLoad(KeyStoreDelegator.java:224) at sun.security.provider.JavaKeyStore$DualFormatJKS.engineLoad(JavaKeyStore.java:70) at java.security.KeyStore.load(KeyStore.java:1381) at org.eclipse.jetty.util.security.CertificateUtils.getKeyStore(CertificateUtils.java:55) at org.eclipse.jetty.util.ssl.SslContextFactory.loadKeyStore(SslContextFactory.java:864) at org.eclipse.jetty.util.ssl.SslContextFactory.doStart(SslContextFactory.java:270) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.SslConnectionFactory.doStart(SslConnectionFactory.java:64) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:260) at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:81) at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:218) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.server.Server.doStart(Server.java:337) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174) "2021-11-21T10:53:09.686000Z":6:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Checking DST..." "2021-11-21T10:53:09.686000Z":7:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Detected timezone: Eastern Standard Time" "2021-11-21T10:53:09.686000Z":8:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST now in daylight time: false date: Sun Nov 21 05:53:09 EST 2021" "2021-11-21T10:53:09.687000Z":9:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST tomorrow in daylight time: false date: Mon Nov 22 05:53:09 EST 2021" "2021-11-21T10:53:09.687000Z":10:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, START ROLL: Mon Nov 22 05:53:09 EST 2021" "2021-11-21T10:53:09.687000Z":11:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, END ROLL: Mon Nov 22 05:53:09 EST 2021" "2021-11-21T11:07:33.220000Z":1:JAVA:INFO:demo2.coreip.co.in:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2021-11-21T11:07:51.259000Z":2:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Checking DST..." "2021-11-21T11:07:51.261000Z":3:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Detected timezone: Eastern Standard Time" "2021-11-21T11:07:51.266000Z":4:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST now in daylight time: false date: Sun Nov 21 06:07:51 EST 2021" "2021-11-21T11:07:51.268000Z":5:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST tomorrow in daylight time: false date: Mon Nov 22 06:07:51 EST 2021" "2021-11-21T11:07:51.269000Z":6:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, START ROLL: Mon Nov 22 06:07:51 EST 2021" "2021-11-21T11:07:51.270000Z":7:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, END ROLL: Mon Nov 22 06:07:51 EST 2021" "2021-11-21T11:12:41.485000Z":1:JAVA:INFO:demo2.coreip.co.in:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2021-11-21T11:13:00.290000Z":2:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Checking DST..." "2021-11-21T11:13:00.291000Z":3:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Detected timezone: Eastern Standard Time" "2021-11-21T11:13:00.292000Z":4:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST now in daylight time: false date: Sun Nov 21 06:13:00 EST 2021" "2021-11-21T11:13:00.292000Z":5:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST tomorrow in daylight time: false date: Mon Nov 22 06:13:00 EST 2021" "2021-11-21T11:13:00.293000Z":6:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, START ROLL: Mon Nov 22 06:13:00 EST 2021" "2021-11-21T11:13:00.294000Z":7:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, END ROLL: Mon Nov 22 06:13:00 EST 2021" "2021-11-21T11:20:25.333000Z":1:JAVA:INFO:demo2.coreip.co.in:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2021-11-21T11:20:44.426000Z":2:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Checking DST..." "2021-11-21T11:20:44.427000Z":3:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Detected timezone: Eastern Standard Time" "2021-11-21T11:20:44.427000Z":4:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST now in daylight time: false date: Sun Nov 21 06:20:44 EST 2021" "2021-11-21T11:20:44.427000Z":5:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST tomorrow in daylight time: false date: Mon Nov 22 06:20:44 EST 2021" "2021-11-21T11:20:44.428000Z":6:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, START ROLL: Mon Nov 22 06:20:44 EST 2021" "2021-11-21T11:20:44.428000Z":7:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, END ROLL: Mon Nov 22 06:20:44 EST 2021" "2021-11-21T11:22:20.273000Z":8:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-19:00000000:LoggerListener:"Authentication event AuthenticationSuccessEvent: superadmin; details: org.sipfoundry.sipxconfig.security.SipxAuthenticationDetails@ffff4c9c: RemoteIpAddress: 10.9.24.3; SessionId: 1lms59zu08zfwiui40xgimhlr" "2021-11-21T11:22:37.996000Z":9:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-22:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 25006" "2021-11-21T11:22:37.996000Z":10:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-22:00000000:JDBCExceptionReporter:"ERROR: cannot execute nextval() in a read-only transaction" "2021-11-21T11:22:38.274000Z":11:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-22:00000000:RequestExceptionReporter:"Unable to process client request: Exception invoking listener method onOk of component user/NewUser/formActions: Exception invoking listener method commit of component user/NewUser: Failure invoking listener method 'public org.apache.tapestry.IPage org.sipfoundry.sipxconfig.site.user.NewUser.commit(org.apache.tapestry.IRequestCycle)' on $NewUser_87@3c1[user/NewUser]: Hibernate operation: could not get next sequence value; uncategorized SQLException for SQL [select nextval ('user_seq')]; SQL state [25006]; error code [0]; ERROR: cannot execute nextval() in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction" org.apache.tapestry.BindingException: Exception invoking listener method onOk of component user/NewUser/formActions: Exception invoking listener method commit of component user/NewUser: Failure invoking listener method 'public org.apache.tapestry.IPage org.sipfoundry.sipxconfig.site.user.NewUser.commit(org.apache.tapestry.IRequestCycle)' on $NewUser_87@3c1[user/NewUser]: Hibernate operation: could not get next sequence value; uncategorized SQLException for SQL [select nextval ('user_seq')]; SQL state [25006]; error code [0]; ERROR: cannot execute nextval() in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction [context:/WEB-INF/common/FormActions.jwc, line 18, column 54] at org.apache.tapestry.binding.ListenerMethodBinding.actionTriggered(ListenerMethodBinding.java:93) at org.apache.tapestry.listener.ListenerInvokerTerminator.invokeListener(ListenerInvokerTerminator.java:50) at org.sipfoundry.sipxconfig.components.UserExceptionFilter.invokeListener(UserExceptionFilter.java:31) at $ListenerInvokerFilter_17d4239fb93.invokeListener($ListenerInvokerFilter_17d4239fb93.java) at $ListenerInvoker_17d4239fb95.invokeListener($ListenerInvoker_17d4239fb95.java) at $ListenerInvoker_17d4239f882.invokeListener($ListenerInvoker_17d4239f882.java) at org.apache.tapestry.form.AbstractSubmit.handleClick(AbstractSubmit.java:98) at org.apache.tapestry.form.AbstractSubmit.rewindFormComponent(AbstractSubmit.java:63) at org.apache.tapestry.form.AbstractFormComponent.renderComponent(AbstractFormComponent.java:90) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:724) at org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:187) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:538) at org.apache.tapestry.components.IfBean.renderComponent(IfBean.java:94) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:724) at org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:187) at org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:107) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:724) at org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:187) at org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:538) at org.apache.tapestry.form.FormSupportImpl.rewind(FormSupportImpl.java:624) at org.apache.tapestry.form.Form.renderComponent(Form.java:196) at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:724) at org.apache.tapestry.services.impl.DefaultResponseBuilder.render(DefaultResponseBuilder.java:187) at org.apache.tapestry.form.Form.rewind(Form.java:269) at org.apache.tapestry.engine.RequestCycle.rewindForm(RequestCycle.java:469) at org.apache.tapestry.form.Form.trigger(Form.java:280) at org.apache.tapestry.engine.DirectService.triggerComponent(DirectService.java:166) at org.apache.tapestry.engine.DirectService.service(DirectService.java:142) at $IEngineService_17d4239f91d.service($IEngineService_17d4239f91d.java) at org.apache.tapestry.services.impl.EngineServiceOuterProxy.service(EngineServiceOuterProxy.java:72) at org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:241) at org.apache.tapestry.services.impl.InvokeEngineTerminator.service(InvokeEngineTerminator.java:54) at $WebRequestServicer_17d4239f8d6.service($WebRequestServicer_17d4239f8d6.java) at org.sipfoundry.sipxconfig.site.DiagnosticContextFilter.service(DiagnosticContextFilter.java:34) at $WebRequestServicerFilter_17d4239f8d4.service($WebRequestServicerFilter_17d4239f8d4.java) at $WebRequestServicer_17d4239f8d8.service($WebRequestServicer_17d4239f8d8.java) at org.sipfoundry.sipxconfig.site.DiscardSessionFilter.service(DiscardSessionFilter.java:36) at $WebRequestServicerFilter_17d4239f8d2.service($WebRequestServicerFilter_17d4239f8d2.java) at $WebRequestServicer_17d4239f8d8.service($WebRequestServicer_17d4239f8d8.java) at $WebRequestServicer_17d4239f8ce.service($WebRequestServicer_17d4239f8ce.java) at org.apache.tapestry.services.impl.WebRequestServicerPipelineBridge.service(WebRequestServicerPipelineBridge.java:61) at $ServletRequestServicer_17d4239f8b4.service($ServletRequestServicer_17d4239f8b4.java) at org.apache.tapestry.request.DecodedRequestInjector.service(DecodedRequestInjector.java:55) at $ServletRequestServicerFilter_17d4239f8b0.service($ServletRequestServicerFilter_17d4239f8b0.java) at $ServletRequestServicer_17d4239f8b6.service($ServletRequestServicer_17d4239f8b6.java) at org.apache.tapestry.multipart.MultipartDecoderFilter.service(MultipartDecoderFilter.java:52) at $ServletRequestServicerFilter_17d4239f8ae.service($ServletRequestServicerFilter_17d4239f8ae.java) at $ServletRequestServicer_17d4239f8b6.service($ServletRequestServicer_17d4239f8b6.java) at org.apache.tapestry.services.impl.SetupRequestEncoding.service(SetupRequestEncoding.java:53) at $ServletRequestServicerFilter_17d4239f8b2.service($ServletRequestServicerFilter_17d4239f8b2.java) at $ServletRequestServicer_17d4239f8b6.service($ServletRequestServicer_17d4239f8b6.java) at $ServletRequestServicer_17d4239f8a8.service($ServletRequestServicer_17d4239f8a8.java) at org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:126) at org.apache.tapestry.ApplicationServlet.doPost(ApplicationServlet.java:171) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.tapestry.BindingException: Exception invoking listener method commit of component user/NewUser: Failure invoking listener method 'public org.apache.tapestry.IPage org.sipfoundry.sipxconfig.site.user.NewUser.commit(org.apache.tapestry.IRequestCycle)' on $NewUser_87@3c1[user/NewUser]: Hibernate operation: could not get next sequence value; uncategorized SQLException for SQL [select nextval ('user_seq')]; SQL state [25006]; error code [0]; ERROR: cannot execute nextval() in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction [context:/WEB-INF/user/NewUser.html, line 20] at org.apache.tapestry.binding.ListenerMethodBinding.actionTriggered(ListenerMethodBinding.java:93) at org.apache.tapestry.listener.ListenerInvokerTerminator.invokeListener(ListenerInvokerTerminator.java:50) at org.sipfoundry.sipxconfig.components.UserExceptionFilter.invokeListener(UserExceptionFilter.java:31) at $ListenerInvokerFilter_17d4239fb93.invokeListener($ListenerInvokerFilter_17d4239fb93.java) at $ListenerInvoker_17d4239fb95.invokeListener($ListenerInvoker_17d4239fb95.java) at $ListenerInvoker_17d4239f882.invokeListener($ListenerInvoker_17d4239f882.java) at org.sipfoundry.sipxconfig.components.FormActions.apply(FormActions.java:64) at org.sipfoundry.sipxconfig.components.FormActions.onOk(FormActions.java:44) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeTargetMethod(ListenerMethodInvokerImpl.java:276) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeListenerMethod(ListenerMethodInvokerImpl.java:221) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.searchAndInvoke(ListenerMethodInvokerImpl.java:157) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeListenerMethod(ListenerMethodInvokerImpl.java:80) at org.apache.tapestry.listener.SyntheticListener.actionTriggered(SyntheticListener.java:52) at org.apache.tapestry.binding.ListenerMethodBinding.actionTriggered(ListenerMethodBinding.java:77) ... 92 more Caused by: org.apache.hivemind.ApplicationRuntimeException: Failure invoking listener method 'public org.apache.tapestry.IPage org.sipfoundry.sipxconfig.site.user.NewUser.commit(org.apache.tapestry.IRequestCycle)' on $NewUser_87@3c1[user/NewUser]: Hibernate operation: could not get next sequence value; uncategorized SQLException for SQL [select nextval ('user_seq')]; SQL state [25006]; error code [0]; ERROR: cannot execute nextval() in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction [context:/WEB-INF/user/NewUser.page, line 3, column 75] at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeListenerMethod(ListenerMethodInvokerImpl.java:230) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.searchAndInvoke(ListenerMethodInvokerImpl.java:157) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeListenerMethod(ListenerMethodInvokerImpl.java:80) at org.apache.tapestry.listener.SyntheticListener.actionTriggered(SyntheticListener.java:52) at org.apache.tapestry.binding.ListenerMethodBinding.actionTriggered(ListenerMethodBinding.java:77) ... 109 more Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not get next sequence value; uncategorized SQLException for SQL [select nextval ('user_seq')]; SQL state [25006]; error code [0]; ERROR: cannot execute nextval() in a read-only transaction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:683) at org.sipfoundry.sipxconfig.common.CoreContextImpl.saveUser(CoreContextImpl.java:228) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.sipfoundry.sipxconfig.common.event.DaoEventDispatcher.invoke(DaoEventDispatcher.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy35.saveUser(Unknown Source) at org.sipfoundry.sipxconfig.setting.GroupAutoAssign.assignUserData(GroupAutoAssign.java:209) at org.sipfoundry.sipxconfig.site.user.NewUser.commit(NewUser.java:92) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeTargetMethod(ListenerMethodInvokerImpl.java:276) at org.apache.tapestry.listener.ListenerMethodInvokerImpl.invokeListenerMethod(ListenerMethodInvokerImpl.java:221) ... 113 more Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:112) at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:105) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697) at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:686) at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 137 more "2021-11-21T11:22:46.187000Z":12:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-21:00000000:LoggerListener:"Authentication event AuthenticationSuccessEvent: superadmin; details: org.sipfoundry.sipxconfig.security.SipxAuthenticationDetails@380f4: RemoteIpAddress: 10.9.24.3; SessionId: 1i23pzb9u2ume3bk5x8lmlzev" "2021-11-21T11:26:10.003000Z":13:JAVA:ERR:demo2.coreip.co.in:pool-14-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." com.mongodb.MongoTimeoutException: Timed out after 10000 ms while waiting for a server that matches {serverSelectors=[ReadPreferenceServerSelector{readPreference=nearest : [TagSet{[Tag{name='clusterId', value='2'}]}, TagSet{[Tag{name='shardId', value='0'}]}, TagSet{[]}]}, LatencyMinimizingServerSelector{acceptableLatencyDifference=15 ms}]}. Client view of cluster state is {type=ReplicaSet, servers=[{address=demo2.coreip.co.in:27017, type=Unknown, state=Connecting, exception={com.mongodb.MongoException$Network: Exception opening the socket}, caused by {java.net.ConnectException: Connection refused (Connection refused)}}] at com.mongodb.BaseCluster.getServer(BaseCluster.java:82) at com.mongodb.DBTCPConnector.getServer(DBTCPConnector.java:656) at com.mongodb.DBTCPConnector.access$500(DBTCPConnector.java:40) at com.mongodb.DBTCPConnector$MyPort.getConnection(DBTCPConnector.java:505) at com.mongodb.DBTCPConnector$MyPort.get(DBTCPConnector.java:448) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:284) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:269) at com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84) at com.mongodb.DB.command(DB.java:320) at com.mongodb.DB.command(DB.java:299) at com.mongodb.DBCollection.getCount(DBCollection.java:1269) at com.mongodb.DBCollection.getCount(DBCollection.java:1247) at com.mongodb.DBCursor.size(DBCursor.java:819) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getItems(RegistrationContextImpl.java:213) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getRegistrations(RegistrationContextImpl.java:59) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.operateTimeRegistrationStatistics(RegistrationContextImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:29:10.004000Z":14:JAVA:ERR:demo2.coreip.co.in:pool-14-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." com.mongodb.MongoTimeoutException: Timed out after 10000 ms while waiting for a server that matches {serverSelectors=[ReadPreferenceServerSelector{readPreference=nearest : [TagSet{[Tag{name='clusterId', value='2'}]}, TagSet{[Tag{name='shardId', value='0'}]}, TagSet{[]}]}, LatencyMinimizingServerSelector{acceptableLatencyDifference=15 ms}]}. Client view of cluster state is {type=ReplicaSet, servers=[{address=demo2.coreip.co.in:27017, type=Unknown, state=Connecting, exception={com.mongodb.MongoException$Network: Exception opening the socket}, caused by {java.net.ConnectException: Connection refused (Connection refused)}}] at com.mongodb.BaseCluster.getServer(BaseCluster.java:82) at com.mongodb.DBTCPConnector.getServer(DBTCPConnector.java:656) at com.mongodb.DBTCPConnector.access$500(DBTCPConnector.java:40) at com.mongodb.DBTCPConnector$MyPort.getConnection(DBTCPConnector.java:505) at com.mongodb.DBTCPConnector$MyPort.get(DBTCPConnector.java:448) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:284) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:269) at com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84) at com.mongodb.DB.command(DB.java:320) at com.mongodb.DB.command(DB.java:299) at com.mongodb.DBCollection.getCount(DBCollection.java:1269) at com.mongodb.DBCollection.getCount(DBCollection.java:1247) at com.mongodb.DBCursor.size(DBCursor.java:819) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getItems(RegistrationContextImpl.java:213) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getRegistrations(RegistrationContextImpl.java:59) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.operateTimeRegistrationStatistics(RegistrationContextImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:30:10.004000Z":15:JAVA:ERR:demo2.coreip.co.in:pool-14-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." com.mongodb.MongoTimeoutException: Timed out after 10000 ms while waiting for a server that matches {serverSelectors=[ReadPreferenceServerSelector{readPreference=nearest : [TagSet{[Tag{name='clusterId', value='2'}]}, TagSet{[Tag{name='shardId', value='0'}]}, TagSet{[]}]}, LatencyMinimizingServerSelector{acceptableLatencyDifference=15 ms}]}. Client view of cluster state is {type=ReplicaSet, servers=[{address=demo2.coreip.co.in:27017, type=Unknown, state=Connecting, exception={com.mongodb.MongoException$Network: Exception opening the socket}, caused by {java.net.ConnectException: Connection refused (Connection refused)}}] at com.mongodb.BaseCluster.getServer(BaseCluster.java:82) at com.mongodb.DBTCPConnector.getServer(DBTCPConnector.java:656) at com.mongodb.DBTCPConnector.access$500(DBTCPConnector.java:40) at com.mongodb.DBTCPConnector$MyPort.getConnection(DBTCPConnector.java:505) at com.mongodb.DBTCPConnector$MyPort.get(DBTCPConnector.java:448) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:284) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:269) at com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84) at com.mongodb.DB.command(DB.java:320) at com.mongodb.DB.command(DB.java:299) at com.mongodb.DBCollection.getCount(DBCollection.java:1269) at com.mongodb.DBCollection.getCount(DBCollection.java:1247) at com.mongodb.DBCursor.size(DBCursor.java:819) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getItems(RegistrationContextImpl.java:213) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.getRegistrations(RegistrationContextImpl.java:59) at org.sipfoundry.sipxconfig.registrar.RegistrationContextImpl.operateTimeRegistrationStatistics(RegistrationContextImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:32:20.347000Z":16:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:ConfigManagerImpl:"Running registration check" "2021-11-21T11:32:20.349000Z":17:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:AgentRunner:"Starting agent run /usr/bin/sipxagent --host 127.0.0.1 --bundle last_seen " "2021-11-21T11:32:21.351000Z":18:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-26:00000000:ConfigManagerImpl:"registration check" org.sipfoundry.sipxconfig.cfgmgt.ConfigException: demo1.coreip.co.in:Could not read agent results. Write end dead at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.runJob(AgentRunner.java:89) at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.run(AgentRunner.java:64) at org.sipfoundry.sipxconfig.cfgmgt.RunBundleAgent.run(RunBundleAgent.java:38) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.run(ConfigManagerImpl.java:417) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.lastSeen(ConfigManagerImpl.java:442) at org.sipfoundry.sipxconfig.cfgmgt.RegisteredLocationResolver.getRegisteredLocations(RegisteredLocationResolver.java:65) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.getRegisteredLocations(ConfigManagerImpl.java:177) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:79) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:32:21.352000Z":19:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-26:00000000:ConfigManagerImpl:"registration check" org.sipfoundry.sipxconfig.cfgmgt.ConfigException: demo1.coreip.co.in:Error. System error for fopen: "No such file or directory". Authentication dialogue with 127.0.0.1 failed at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.runJob(AgentRunner.java:95) at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.run(AgentRunner.java:64) at org.sipfoundry.sipxconfig.cfgmgt.RunBundleAgent.run(RunBundleAgent.java:38) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.run(ConfigManagerImpl.java:417) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.lastSeen(ConfigManagerImpl.java:442) at org.sipfoundry.sipxconfig.cfgmgt.RegisteredLocationResolver.getRegisteredLocations(RegisteredLocationResolver.java:65) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.getRegisteredLocations(ConfigManagerImpl.java:177) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:79) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:32:21.353000Z":20:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-26:00000000:RegisteredLocationResolver:"Cannot determine registered systems, missing file /var/sipxdata/cfupload/lastseen.csv" "2021-11-21T11:32:21.353000Z":21:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:RegisteredLocationResolver:"demo2 is not registered" "2021-11-21T11:32:21.353000Z":22:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:RegisteredLocationResolver:"demo3 is not registered" "2021-11-21T11:32:21.355000Z":23:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:SimpleCommandRunner:"/usr/bin/mongodb-status --full" "2021-11-21T11:32:22.514000Z":24:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-26:00000000:SimpleCommandRunner:"/usr/bin/mongodb-analyzer" "2021-11-21T11:32:22.553000Z":25:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-26:00000000:RestSpringAdapterServlet:"GET /sipxconfig/rest/mongoGlobal/" java.lang.NullPointerException at org.sipfoundry.sipxconfig.feature.FeatureManagerImpl.isFeatureEnabled(FeatureManagerImpl.java:120) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy38.isFeatureEnabled(Unknown Source) at org.sipfoundry.sipxconfig.mongo.MongoApi.metaMap(MongoApi.java:209) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:81) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:32:36.605000Z":26:JAVA:WARNING:demo2.coreip.co.in:elasticsearch[Super Sabre][transport_client_boss][T#1]{New I/O boss #5}:00000000:netty:"[Super Sabre] exception caught on transport layer [[id: 0x560f881e]], closing connection" java.net.NoRouteToHostException: No route to host at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:741) at org.elasticsearch.common.netty.channel.socket.nio.NioClientBoss.connect(NioClientBoss.java:152) at org.elasticsearch.common.netty.channel.socket.nio.NioClientBoss.processSelectedKeys(NioClientBoss.java:105) at org.elasticsearch.common.netty.channel.socket.nio.NioClientBoss.process(NioClientBoss.java:79) at org.elasticsearch.common.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:337) at org.elasticsearch.common.netty.channel.socket.nio.NioClientBoss.run(NioClientBoss.java:42) at org.elasticsearch.common.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) at org.elasticsearch.common.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:33:23.738000Z":27:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:ConfigManagerImpl:"Running registration check" "2021-11-21T11:33:23.743000Z":28:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:AgentRunner:"Starting agent run /usr/bin/sipxagent --host 127.0.0.1 --bundle last_seen " "2021-11-21T11:33:24.751000Z":29:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-25:00000000:ConfigManagerImpl:"registration check" org.sipfoundry.sipxconfig.cfgmgt.ConfigException: demo1.coreip.co.in:Could not read agent results. Write end dead at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.runJob(AgentRunner.java:89) at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.run(AgentRunner.java:64) at org.sipfoundry.sipxconfig.cfgmgt.RunBundleAgent.run(RunBundleAgent.java:38) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.run(ConfigManagerImpl.java:417) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.lastSeen(ConfigManagerImpl.java:442) at org.sipfoundry.sipxconfig.cfgmgt.RegisteredLocationResolver.getRegisteredLocations(RegisteredLocationResolver.java:65) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.getRegisteredLocations(ConfigManagerImpl.java:177) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:79) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:33:24.752000Z":30:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-25:00000000:ConfigManagerImpl:"registration check" org.sipfoundry.sipxconfig.cfgmgt.ConfigException: demo1.coreip.co.in:Error. System error for fopen: "No such file or directory". Authentication dialogue with 127.0.0.1 failed at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.runJob(AgentRunner.java:95) at org.sipfoundry.sipxconfig.cfgmgt.AgentRunner.run(AgentRunner.java:64) at org.sipfoundry.sipxconfig.cfgmgt.RunBundleAgent.run(RunBundleAgent.java:38) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.run(ConfigManagerImpl.java:417) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.lastSeen(ConfigManagerImpl.java:442) at org.sipfoundry.sipxconfig.cfgmgt.RegisteredLocationResolver.getRegisteredLocations(RegisteredLocationResolver.java:65) at org.sipfoundry.sipxconfig.cfgmgt.ConfigManagerImpl.getRegisteredLocations(ConfigManagerImpl.java:177) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:79) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:33:24.753000Z":31:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-25:00000000:RegisteredLocationResolver:"Cannot determine registered systems, missing file /var/sipxdata/cfupload/lastseen.csv" "2021-11-21T11:33:24.754000Z":32:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:RegisteredLocationResolver:"demo2 is not registered" "2021-11-21T11:33:24.754000Z":33:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:RegisteredLocationResolver:"demo3 is not registered" "2021-11-21T11:33:24.754000Z":34:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:SimpleCommandRunner:"/usr/bin/mongodb-status --full" "2021-11-21T11:33:25.009000Z":35:JAVA:INFO:demo2.coreip.co.in:qtp2094160003-25:00000000:SimpleCommandRunner:"/usr/bin/mongodb-analyzer" "2021-11-21T11:33:25.049000Z":36:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-25:00000000:RestSpringAdapterServlet:"GET /sipxconfig/rest/mongoGlobal/" java.lang.NullPointerException at org.sipfoundry.sipxconfig.feature.FeatureManagerImpl.isFeatureEnabled(FeatureManagerImpl.java:120) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy38.isFeatureEnabled(Unknown Source) at org.sipfoundry.sipxconfig.mongo.MongoApi.metaMap(MongoApi.java:209) at org.sipfoundry.sipxconfig.mongo.MongoApi.represent(MongoApi.java:81) at org.restlet.resource.Resource.getRepresentation(Resource.java:302) at org.restlet.resource.Resource.handleGet(Resource.java:464) at org.restlet.Finder.handle(Finder.java:353) at org.restlet.Filter.doHandle(Filter.java:150) at org.restlet.Filter.handle(Filter.java:195) at org.restlet.Router.handle(Router.java:504) at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:197) at org.sipfoundry.sipxconfig.rest.RestSpringAdapterServlet.service(RestSpringAdapterServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.sipfoundry.sipxconfig.security.OptionsAuthFilter.doFilter(OptionsAuthFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) "2021-11-21T11:37:43.215000Z":37:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-24:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:37:43.215000Z":38:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-24:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:37:43.215000Z":39:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-24:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:37:43.216000Z":40:JAVA:ERR:demo2.coreip.co.in:qtp2094160003-24:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:37:43.219000Z":41:JAVA:WARNING:demo2.coreip.co.in:qtp2094160003-24:00000000:ServletHandler:"/sipxconfig/admin/commserver/Registrations,$common$AutoRefreshForm.refreshForm.sdirect" org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.bean_with_settings_id as bean1_74_4_, this_.bean_id as bean2_74_4_, this_.value_storage_id as value3_74_4_, valuestora2_.value_storage_id as value1_70_0_, valuestora2_1_.name as name72_0_, valuestora2_1_.description as descript3_72_0_, valuestora2_1_.resource as resource72_0_, valuestora2_1_.weight as weight72_0_, valuestora2_1_.branch_id as branch6_72_0_, case when valuestora2_1_.group_id is not null then 1 when valuestora2_.value_storage_id is not null then 0 end as clazz_0_, branch3_.branch_id as branch1_101_1_, branch3_.name as name101_1_, branch3_.description as descript3_101_1_, branch3_.phone_number as phone4_101_1_, branch3_.fax_number as fax5_101_1_, branch3_.time_zone as time6_101_1_, branch3_.address_id as address7_101_1_, branch3_.fallback_branch_id as fallback8_101_1_, address4_.address_id as address1_86_2_, address4_.street as street86_2_, address4_.zip as zip86_2_, address4_.city as city86_2_, address4_.country as country86_2_, address4_.state as state86_2_, address4_.office_designation as office7_86_2_, branch5_.branch_id as branch1_101_3_, branch5_.name as name101_3_, branch5_.description as descript3_101_3_, branch5_.phone_number as phone4_101_3_, branch5_.fax_number as fax5_101_3_, branch5_.time_zone as time6_101_3_, branch5_.address_id as address7_101_3_, branch5_.fallback_branch_id as fallback8_101_3_ from bean_with_settings this_ left outer join value_storage valuestora2_ on this_.value_storage_id=valuestora2_.value_storage_id left outer join group_storage valuestora2_1_ on valuestora2_.value_storage_id=valuestora2_1_.group_id left outer join branch branch3_ on valuestora2_1_.branch_id=branch3_.branch_id left outer join address address4_ on branch3_.address_id=address4_.address_id left outer join branch branch5_ on branch3_.fallback_branch_id=branch5_.branch_id where this_.bean_id='adminSettings']; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findAll(BeanWithSettingsDaoImpl.java:47) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:41) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:26) at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy30.findOrCreateOne(Unknown Source) at org.sipfoundry.sipxconfig.admin.AdminContextImpl.getSettings(AdminContextImpl.java:182) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.getAllowedCorsDomains(SipxFilterChainProxy.java:132) at org.sipfoundry.sipxconfig.security.SipxFilterChainProxy.doFilter(SipxFilterChainProxy.java:102) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:462) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 40 more "2021-11-21T11:37:49.737000Z":42:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:37:49.740000Z":43:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:37:49.740000Z":44:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:37:49.741000Z":45:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:37:49.743000Z":46:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select attendantr0_.attendant_dialing_rule_id as dialing1_23_, attendantr0_1_.name as name23_, attendantr0_1_.description as descript3_23_, attendantr0_1_.enabled as enabled23_, attendantr0_1_.schedule_id as schedule5_23_, attendantr0_.attendant_aliases as attendant2_33_, attendantr0_.extension as extension33_, attendantr0_.did as did33_, attendantr0_.live_attendant as live5_33_, attendantr0_.live_attendant_extension as live6_33_, attendantr0_.live_attendant_ring_for as live7_33_, attendantr0_.follow_user_call_forward as follow8_33_, attendantr0_.live_attendant_code as live9_33_, attendantr0_.live_attendant_enabled as live10_33_, attendantr0_.live_attendant_expire as live11_33_, attendantr0_.after_hours_attendant_id as after12_33_, attendantr0_.after_hours_attendant_enabled as after13_33_, attendantr0_.holiday_attendant_id as holiday14_33_, attendantr0_.holiday_attendant_enabled as holiday15_33_, attendantr0_.working_time_attendant_id as working16_33_, attendantr0_.working_time_attendant_enabled as working17_33_ from attendant_dialing_rule attendantr0_ inner join dialing_rule attendantr0_1_ on attendantr0_.attendant_dialing_rule_id=attendantr0_1_.dialing_rule_id where attendantr0_.live_attendant=true and attendantr0_.live_attendant_enabled=false]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:979) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:971) at org.sipfoundry.sipxconfig.dialplan.AutoAttendantManagerImpl.checkLiveAttendant(AutoAttendantManagerImpl.java:463) at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 16 more "2021-11-21T11:37:50.249000Z":47:JAVA:WARNING:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:37:50.250000Z":48:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:37:50.250000Z":49:JAVA:WARNING:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:37:50.250000Z":50:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:37:50.251000Z":51:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:LdapTimer:"Failed running disabled/delete task " org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.bean_with_settings_id as bean1_74_4_, this_.bean_id as bean2_74_4_, this_.value_storage_id as value3_74_4_, valuestora2_.value_storage_id as value1_70_0_, valuestora2_1_.name as name72_0_, valuestora2_1_.description as descript3_72_0_, valuestora2_1_.resource as resource72_0_, valuestora2_1_.weight as weight72_0_, valuestora2_1_.branch_id as branch6_72_0_, case when valuestora2_1_.group_id is not null then 1 when valuestora2_.value_storage_id is not null then 0 end as clazz_0_, branch3_.branch_id as branch1_101_1_, branch3_.name as name101_1_, branch3_.description as descript3_101_1_, branch3_.phone_number as phone4_101_1_, branch3_.fax_number as fax5_101_1_, branch3_.time_zone as time6_101_1_, branch3_.address_id as address7_101_1_, branch3_.fallback_branch_id as fallback8_101_1_, address4_.address_id as address1_86_2_, address4_.street as street86_2_, address4_.zip as zip86_2_, address4_.city as city86_2_, address4_.country as country86_2_, address4_.state as state86_2_, address4_.office_designation as office7_86_2_, branch5_.branch_id as branch1_101_3_, branch5_.name as name101_3_, branch5_.description as descript3_101_3_, branch5_.phone_number as phone4_101_3_, branch5_.fax_number as fax5_101_3_, branch5_.time_zone as time6_101_3_, branch5_.address_id as address7_101_3_, branch5_.fallback_branch_id as fallback8_101_3_ from bean_with_settings this_ left outer join value_storage valuestora2_ on this_.value_storage_id=valuestora2_.value_storage_id left outer join group_storage valuestora2_1_ on valuestora2_.value_storage_id=valuestora2_1_.group_id left outer join branch branch3_ on valuestora2_1_.branch_id=branch3_.branch_id left outer join address address4_ on branch3_.address_id=address4_.address_id left outer join branch branch5_ on branch3_.fallback_branch_id=branch5_.branch_id where this_.bean_id='adminSettings']; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findAll(BeanWithSettingsDaoImpl.java:47) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:41) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:26) at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy30.findOrCreateOne(Unknown Source) at org.sipfoundry.sipxconfig.admin.AdminContextImpl.getSettings(AdminContextImpl.java:182) at org.sipfoundry.sipxconfig.admin.AdminContextImpl.isDelete(AdminContextImpl.java:221) at sun.reflect.GeneratedMethodAccessor223.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy64.isDelete(Unknown Source) at org.sipfoundry.sipxconfig.bulk.ldap.LdapTimer.disableDeleteUsers(LdapTimer.java:43) at sun.reflect.GeneratedMethodAccessor222.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 36 more "2021-11-21T11:37:50.421000Z":52:JAVA:ERR:demo2.coreip.co.in:pool-12-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select 1 from feature_local where feature_id = ?]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:805) at org.sipfoundry.sipxconfig.feature.FeatureManagerImpl.isFeatureEnabled(FeatureManagerImpl.java:135) at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy38.isFeatureEnabled(Unknown Source) at org.sipfoundry.sipxconfig.systemaudit.ConfigChangeLoader.run(ConfigChangeLoader.java:35) at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ... 28 more "2021-11-21T11:38:00.544000Z":53:JAVA:WARNING:demo2.coreip.co.in:Timer-8:00000000:ThreadPoolAsynchronousRunner:"com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@7b8ee439 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!" "2021-11-21T11:38:00.551000Z":54:JAVA:WARNING:demo2.coreip.co.in:Timer-8:00000000:ThreadPoolAsynchronousRunner:"com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@7b8ee439 -- APPARENT DEADLOCK!!! Complete Status: \n Managed Threads: 3\n Active Threads: 3\n Active Tasks: \n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3eaa8a2e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2e55f226 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c8cb48e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)\n Pending Tasks: \n com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@69a1dd11\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b8bd45\n com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@791fde5\nPool thread stack traces:\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n\n" "2021-11-21T11:38:12.240000Z":55:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2e55f226 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:18.800000Z":56:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3eaa8a2e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:19.304000Z":57:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c8cb48e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:19.748000Z":58:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:38:19.749000Z":59:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:38:19.750000Z":60:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:38:19.751000Z":61:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:38:19.752000Z":62:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select attendantr0_.attendant_dialing_rule_id as dialing1_23_, attendantr0_1_.name as name23_, attendantr0_1_.description as descript3_23_, attendantr0_1_.enabled as enabled23_, attendantr0_1_.schedule_id as schedule5_23_, attendantr0_.attendant_aliases as attendant2_33_, attendantr0_.extension as extension33_, attendantr0_.did as did33_, attendantr0_.live_attendant as live5_33_, attendantr0_.live_attendant_extension as live6_33_, attendantr0_.live_attendant_ring_for as live7_33_, attendantr0_.follow_user_call_forward as follow8_33_, attendantr0_.live_attendant_code as live9_33_, attendantr0_.live_attendant_enabled as live10_33_, attendantr0_.live_attendant_expire as live11_33_, attendantr0_.after_hours_attendant_id as after12_33_, attendantr0_.after_hours_attendant_enabled as after13_33_, attendantr0_.holiday_attendant_id as holiday14_33_, attendantr0_.holiday_attendant_enabled as holiday15_33_, attendantr0_.working_time_attendant_id as working16_33_, attendantr0_.working_time_attendant_enabled as working17_33_ from attendant_dialing_rule attendantr0_ inner join dialing_rule attendantr0_1_ on attendantr0_.attendant_dialing_rule_id=attendantr0_1_.dialing_rule_id where attendantr0_.live_attendant=true and attendantr0_.live_attendant_enabled=false]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:979) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:971) at org.sipfoundry.sipxconfig.dialplan.AutoAttendantManagerImpl.checkLiveAttendant(AutoAttendantManagerImpl.java:463) at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 16 more "2021-11-21T11:38:20.424000Z":63:JAVA:ERR:demo2.coreip.co.in:pool-12-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select 1 from feature_local where feature_id = ?]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:805) at org.sipfoundry.sipxconfig.feature.FeatureManagerImpl.isFeatureEnabled(FeatureManagerImpl.java:135) at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy38.isFeatureEnabled(Unknown Source) at org.sipfoundry.sipxconfig.systemaudit.ConfigChangeLoader.run(ConfigChangeLoader.java:35) at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ... 28 more "2021-11-21T11:38:29.597000Z":64:JAVA:WARNING:demo2.coreip.co.in:Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1ad5264e:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b8bd45 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:30.545000Z":65:JAVA:WARNING:demo2.coreip.co.in:Timer-8:00000000:ThreadPoolAsynchronousRunner:"com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@7b8ee439 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!" "2021-11-21T11:38:30.550000Z":66:JAVA:WARNING:demo2.coreip.co.in:Timer-8:00000000:ThreadPoolAsynchronousRunner:"com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@7b8ee439 -- APPARENT DEADLOCK!!! Complete Status: \n Managed Threads: 3\n Active Threads: 3\n Active Tasks: \n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@64203230 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7dbf20aa (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ef9b965 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)\n Pending Tasks: \n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2cfa9d91\n com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@797eb1a8\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6cc1cae8\n com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@26f07d20\nPool thread stack traces:\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]\n java.lang.Thread.sleep(Native Method)\n com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)\n com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)\n\n" "2021-11-21T11:38:48.874000Z":67:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ef9b965 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:48.875000Z":68:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7dbf20aa -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:48.876000Z":69:JAVA:WARNING:demo2.coreip.co.in:com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1:00000000:BasicResourcePool:"com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@64203230 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: " org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:598) at java.net.Socket.connect(Socket.java:547) at java.net.Socket.(Socket.java:447) at java.net.Socket.(Socket.java:227) at org.postgresql.core.PGStream.(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77) ... 14 more "2021-11-21T11:38:49.757000Z":70:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:38:49.757000Z":71:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:38:49.757000Z":72:JAVA:WARNING:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:38:49.758000Z":73:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:38:49.758000Z":74:JAVA:ERR:demo2.coreip.co.in:pool-11-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select attendantr0_.attendant_dialing_rule_id as dialing1_23_, attendantr0_1_.name as name23_, attendantr0_1_.description as descript3_23_, attendantr0_1_.enabled as enabled23_, attendantr0_1_.schedule_id as schedule5_23_, attendantr0_.attendant_aliases as attendant2_33_, attendantr0_.extension as extension33_, attendantr0_.did as did33_, attendantr0_.live_attendant as live5_33_, attendantr0_.live_attendant_extension as live6_33_, attendantr0_.live_attendant_ring_for as live7_33_, attendantr0_.follow_user_call_forward as follow8_33_, attendantr0_.live_attendant_code as live9_33_, attendantr0_.live_attendant_enabled as live10_33_, attendantr0_.live_attendant_expire as live11_33_, attendantr0_.after_hours_attendant_id as after12_33_, attendantr0_.after_hours_attendant_enabled as after13_33_, attendantr0_.holiday_attendant_id as holiday14_33_, attendantr0_.holiday_attendant_enabled as holiday15_33_, attendantr0_.working_time_attendant_id as working16_33_, attendantr0_.working_time_attendant_enabled as working17_33_ from attendant_dialing_rule attendantr0_ inner join dialing_rule attendantr0_1_ on attendantr0_.attendant_dialing_rule_id=attendantr0_1_.dialing_rule_id where attendantr0_.live_attendant=true and attendantr0_.live_attendant_enabled=false]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:979) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:971) at org.sipfoundry.sipxconfig.dialplan.AutoAttendantManagerImpl.checkLiveAttendant(AutoAttendantManagerImpl.java:463) at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:988) at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 16 more "2021-11-21T11:38:50.271000Z":75:JAVA:WARNING:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 57P01" "2021-11-21T11:38:50.271000Z":76:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"FATAL: terminating connection due to administrator command" "2021-11-21T11:38:50.271000Z":77:JAVA:WARNING:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 08006" "2021-11-21T11:38:50.271000Z":78:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:JDBCExceptionReporter:"An I/O error occured while sending to the backend." "2021-11-21T11:38:50.271000Z":79:JAVA:ERR:demo2.coreip.co.in:pool-10-thread-1:00000000:LdapTimer:"Failed running disabled/delete task " org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.bean_with_settings_id as bean1_74_4_, this_.bean_id as bean2_74_4_, this_.value_storage_id as value3_74_4_, valuestora2_.value_storage_id as value1_70_0_, valuestora2_1_.name as name72_0_, valuestora2_1_.description as descript3_72_0_, valuestora2_1_.resource as resource72_0_, valuestora2_1_.weight as weight72_0_, valuestora2_1_.branch_id as branch6_72_0_, case when valuestora2_1_.group_id is not null then 1 when valuestora2_.value_storage_id is not null then 0 end as clazz_0_, branch3_.branch_id as branch1_101_1_, branch3_.name as name101_1_, branch3_.description as descript3_101_1_, branch3_.phone_number as phone4_101_1_, branch3_.fax_number as fax5_101_1_, branch3_.time_zone as time6_101_1_, branch3_.address_id as address7_101_1_, branch3_.fallback_branch_id as fallback8_101_1_, address4_.address_id as address1_86_2_, address4_.street as street86_2_, address4_.zip as zip86_2_, address4_.city as city86_2_, address4_.country as country86_2_, address4_.state as state86_2_, address4_.office_designation as office7_86_2_, branch5_.branch_id as branch1_101_3_, branch5_.name as name101_3_, branch5_.description as descript3_101_3_, branch5_.phone_number as phone4_101_3_, branch5_.fax_number as fax5_101_3_, branch5_.time_zone as time6_101_3_, branch5_.address_id as address7_101_3_, branch5_.fallback_branch_id as fallback8_101_3_ from bean_with_settings this_ left outer join value_storage valuestora2_ on this_.value_storage_id=valuestora2_.value_storage_id left outer join group_storage valuestora2_1_ on valuestora2_.value_storage_id=valuestora2_1_.group_id left outer join branch branch3_ on valuestora2_1_.branch_id=branch3_.branch_id left outer join address address4_ on branch3_.address_id=address4_.address_id left outer join branch branch5_ on branch3_.fallback_branch_id=branch5_.branch_id where this_.bean_id='adminSettings']; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findAll(BeanWithSettingsDaoImpl.java:47) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:41) at org.sipfoundry.sipxconfig.setting.BeanWithSettingsDaoImpl.findOrCreateOne(BeanWithSettingsDaoImpl.java:26) at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy30.findOrCreateOne(Unknown Source) at org.sipfoundry.sipxconfig.admin.AdminContextImpl.getSettings(AdminContextImpl.java:182) at org.sipfoundry.sipxconfig.admin.AdminContextImpl.isDelete(AdminContextImpl.java:221) at sun.reflect.GeneratedMethodAccessor223.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy64.isDelete(Unknown Source) at org.sipfoundry.sipxconfig.bulk.ldap.LdapTimer.disableDeleteUsers(LdapTimer.java:43) at sun.reflect.GeneratedMethodAccessor222.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 36 more "2021-11-21T11:38:50.458000Z":80:JAVA:ERR:demo2.coreip.co.in:pool-12-thread-1:00000000:TaskUtils$LoggingErrorHandler:"Unexpected error occurred in scheduled task." org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select 1 from feature_local where feature_id = ?]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:805) at org.sipfoundry.sipxconfig.feature.FeatureManagerImpl.isFeatureEnabled(FeatureManagerImpl.java:135) at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy38.isFeatureEnabled(Unknown Source) at org.sipfoundry.sipxconfig.systemaudit.ConfigChangeLoader.run(ConfigChangeLoader.java:35) at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ... 28 more "2021-11-21T11:59:15.498000Z":1:JAVA:INFO:demo2.coreip.co.in:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2021-11-21T11:59:33.901000Z":2:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Checking DST..." "2021-11-21T11:59:33.903000Z":3:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Detected timezone: Eastern Standard Time" "2021-11-21T11:59:33.904000Z":4:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST now in daylight time: false date: Sun Nov 21 06:59:33 EST 2021" "2021-11-21T11:59:33.905000Z":5:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"DST tomorrow in daylight time: false date: Mon Nov 22 06:59:33 EST 2021" "2021-11-21T11:59:33.907000Z":6:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, START ROLL: Mon Nov 22 06:59:33 EST 2021" "2021-11-21T11:59:33.908000Z":7:JAVA:INFO:demo2.coreip.co.in:pool-9-thread-1:00000000:CheckDST:"Find when DST changes, END ROLL: Mon Nov 22 06:59:33 EST 2021"