Problems upgrading from 11115 to 11119, Postgres upgrade

Problems upgrading from 11115 to 11119, Postgres upgrade

Hello

I am having a few issues with an upgrade of ManageEngine from 11115 to 11119 on a Linux host.

On upgrade, it seems as though that pgsql doesn't upgrade correctly - I see entries in the log that read:

26-Jun-2020 2:55:51 PM  [com.adventnet.persistence.PostgresPreProcessor]  [INFO] : /home/manageengine/ManageEngine/ServiceDesk/bin/initPgsql.sh: 186: /home/manageengine/ManageEngine/ServiceDesk/bin/initPgsql.sh: /home/manageengine/ManageEngine/ServiceDesk/tools/postgres/bin/gettimezone: not found

26-Jun-2020 2:55:51 PM  [com.adventnet.persistence.PostgresPreProcessor]  [INFO] : Failed to set timezone

26-Jun-2020 2:55:51 PM  [com.adventnet.persistence.PostgresPreProcessor]  [SEVERE] : InitPgsqlScript exited with value :: 1

26-Jun-2020 2:55:51 PM  [com.adventnet.persistence.PostgresPreProcessor]  [SEVERE] : {0}java.lang.Exception: InitPgsqlScript exited with value :: 1

        at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1757)

        at com.adventnet.persistence.PostgresPreProcessor.install(PostgresPreProcessor.java:519)

        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 com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:377)

        at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:140)

        at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:315)

        at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:243)

        at java.lang.Thread.run(Thread.java:748)

 

26-Jun-2020 2:55:51 PM  [com.adventnet.persistence.PostgresPreProcessor]  [SEVERE] : Restoring postgres (PostgreSQL) 10.5 database



The revert fails as well (maybe?) and the application no longer starts:

[14:58:32:609]|[06-26-2020]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[1]: Trying to start PostgresSQL server failed |

java.net.ConnectException: Trying to start PostgresSQL server failed

        at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:177)

        at com.adventnet.db.adapter.postgres.PostgresDBAdapter.startAndCheckDBServer(PostgresDBAdapter.java:781)

        at com.adventnet.db.adapter.postgres.PostgresDBAdapter.setUpDB(PostgresDBAdapter.java:764)

        at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1268)

        at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1231)

        at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:694)

        at com.adventnet.persistence.PersistenceInitializer.initializeDBAndPers(PersistenceInitializer.java:449)

        at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:427)

        at com.zoho.mickey.startup.MEServer.startServer(MEServer.java:200)

        at com.adventnet.mfw.Starter.start(Starter.java:387)

        at com.adventnet.mfw.Starter.main(Starter.java:702)

        at com.adventnet.me.servicedesk.start.SDPStarter.main(SDPStarter.java:100)

 

[14:58:32:609]|[06-26-2020]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[1]: Problem while starting Database due to:Trying to start PostgresSQL server failed |

[14:58:32:609]|[06-26-2020]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[1]: Error Code : 10001|

[14:58:32:609]|[06-26-2020]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[1]: Localized Error Msg : null|

[14:58:32:609]|[06-26-2020]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[1]: Error Msg : null|

[14:58:32:609]|[06-26-2020]|[SYSERR]|[INFO]|[1]: java.lang.Exception: Exception while initializing DB.|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.initializeDBAndPers(PersistenceInitializer.java:453)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:427)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.zoho.mickey.startup.MEServer.startServer(MEServer.java:200)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.mfw.Starter.start(Starter.java:387)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.mfw.Starter.main(Starter.java:702)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.me.servicedesk.start.SDPStarter.main(SDPStarter.java:100)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]: Caused by: java.lang.RuntimeException: Trying to start PostgresSQL server failed |

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:1439)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1331)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1231)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:694)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        at com.adventnet.persistence.PersistenceInitializer.initializeDBAndPers(PersistenceInitializer.java:449)|

[14:58:32:610]|[06-26-2020]|[SYSERR]|[INFO]|[1]:        ... 5 more|

[14:58:32:610]|[06-26-2020]|[com.zoho.mickey.startup.MEServer]|[SEVERE]|[1]: STACK TRACE|




Furthermore, I can't restore the backup - it's asking for a password to restore, and I have never supplied one when the backup was being taken.

Help ..!


Thanks,


Tim




        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products