Failed upgrade (SDPLUS 9.2.0-SP-1.0.0)

Failed upgrade (SDPLUS 9.2.0-SP-1.0.0)

Greetings, today we tried to upgrade our SDPlus installation (9.2 Build 9235) but the upgrade failed when we tried to apply ManageEngine_ServiceDesk_Plus_9_2_0_SP-1_0_0.ppm, the server starts using all the available memory then it drops back to the cli, this is CentOS 7 x64 installation with PostgreSQL 9.2 as db server, it has 4GB installed and 2GB free in operation:

 org.postgresql.util.PSQLException: Ran out of memory retrieving query results.

16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1817)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBackUp.java:1522)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1197)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:394)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:108)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil.handleBackup(SDPreProcessorUtil.java:702)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.preInstallPatch(SDPreProcessor.java:151)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.installPatch(SDPreProcessor.java:66)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.persistence.DefaultPreProcessor.install(DefaultPreProcessor.java:132)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at java.lang.reflect.Method.invoke(Unknown Source)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:319)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at java.lang.Thread.run(Unknown Source)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] : Caused by: java.lang.OutOfMemoryError: Java heap space
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:364)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1814)
16-02-2017 02:57:24 PM  [SYSERR]  [Información] :       ... 21 more
16-02-2017 02:57:24 PM  [SYSERR]  [Información] : java.io.IOException: Stream Closed

All info regarding this problem is welcome, thanks.

                  New to ADSelfService Plus?