PMP 9200 to 9300 upgrade breaks pmp
We've been upgrading and when we upgrade from 9200 to 9300 it has problems. The upgrade completes fine but when we try and connect to PMP it doesn't start and eventually stops the service.
Here are some bits from the log - i can email the whole thing if needed.
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureHandlerImpl]|[INFO]|[18]: Error Code :: 10,006|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Error Code : 10006|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Localized Error Msg : null|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Error Msg : java.sql.SQLException: Ran out of memory retrieving query results.|
[14:17:57:466]|[05-03-2018]|[com.adventnet.db.adapter.postgres.PostgresExceptionSorter]|[SEVERE]|[18]: Returning [false] from isDBAlive method ErrorCode: 0 SqlState: 08006|
[14:17:57:466]|[05-03-2018]|[com.adventnet.db.adapter.BaseExceptionSorter]|[SEVERE]|[18]: Going to Halt the JVM|
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.ConnectionCreator]|[INFO]|[18]: ClusterIP:localhost connection detail is marked as invalid due to error isValid? false usage_counter:0 inuse?:true|
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.Txn]|[SEVERE]|[18]: exception during connection rollback|
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at com.zoho.cp.Txn.rollbackConnections(Txn.java:171)
at com.zoho.cp.Txn.rollbackTransaction(Txn.java:151)
at com.zoho.cp.Txn.rollback(Txn.java:87)
at com.zoho.cp.TxMgr.rollback(TxMgr.java:95)
at com.adventnet.mfw.bean.BeanProxy.doCommit(BeanProxy.java:150)
at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:62)
at com.sun.proxy.$Proxy2.delete(Unknown Source)
at com.adventnet.authentication.service.AuthenticationService.checkAndCloseSessions(AuthenticationService.java:60)
at com.adventnet.authentication.service.AuthenticationService.stop(AuthenticationService.java:46)
at com.adventnet.mfw.service.ServiceStarter.destroyServices(ServiceStarter.java:218)
at com.adventnet.mfw.Server.shutDown(Server.java:1036)
at com.adventnet.mfw.Server.startServer(Server.java:380)
at com.adventnet.mfw.Starter.start(Starter.java:365)
at com.adventnet.mfw.Starter.main(Starter.java:574)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
at java.lang.Thread.run(Thread.java:745)
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.ConnectionPool]|[INFO]|[18]: ClusterIP:localhost Connection detail removed from the pool due to error isValid? false usage_counter:0 inuse?:true|
Here are some bits from the log - i can email the whole thing if needed.
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureHandlerImpl]|[INFO]|[18]: Error Code :: 10,006|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Error Code : 10006|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Localized Error Msg : null|
[14:17:57:450]|[05-03-2018]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[18]: Error Msg : java.sql.SQLException: Ran out of memory retrieving query results.|
[14:17:57:466]|[05-03-2018]|[com.adventnet.db.adapter.postgres.PostgresExceptionSorter]|[SEVERE]|[18]: Returning [false] from isDBAlive method ErrorCode: 0 SqlState: 08006|
[14:17:57:466]|[05-03-2018]|[com.adventnet.db.adapter.BaseExceptionSorter]|[SEVERE]|[18]: Going to Halt the JVM|
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.ConnectionCreator]|[INFO]|[18]: ClusterIP:localhost connection detail is marked as invalid due to error isValid? false usage_counter:0 inuse?:true|
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.Txn]|[SEVERE]|[18]: exception during connection rollback|
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at com.zoho.cp.Txn.rollbackConnections(Txn.java:171)
at com.zoho.cp.Txn.rollbackTransaction(Txn.java:151)
at com.zoho.cp.Txn.rollback(Txn.java:87)
at com.zoho.cp.TxMgr.rollback(TxMgr.java:95)
at com.adventnet.mfw.bean.BeanProxy.doCommit(BeanProxy.java:150)
at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:62)
at com.sun.proxy.$Proxy2.delete(Unknown Source)
at com.adventnet.authentication.service.AuthenticationService.checkAndCloseSessions(AuthenticationService.java:60)
at com.adventnet.authentication.service.AuthenticationService.stop(AuthenticationService.java:46)
at com.adventnet.mfw.service.ServiceStarter.destroyServices(ServiceStarter.java:218)
at com.adventnet.mfw.Server.shutDown(Server.java:1036)
at com.adventnet.mfw.Server.startServer(Server.java:380)
at com.adventnet.mfw.Starter.start(Starter.java:365)
at com.adventnet.mfw.Starter.main(Starter.java:574)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
at java.lang.Thread.run(Thread.java:745)
[14:17:57:466]|[05-03-2018]|[com.zoho.cp.ConnectionPool]|[INFO]|[18]: ClusterIP:localhost Connection detail removed from the pool due to error isValid? false usage_counter:0 inuse?:true|