HSQLDB port

Products

• CA Application Performance Management SaaS

Issue/Introduction

DX gateway/restmon and APMIA using 9001 port to talk with HSQLDB, impossible to run both processes at the same server.

When starting APMIA or DX Gateway, we see the following error:

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 - [[email protected]]:

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 - [Thread[HSQLDB Server @2015dddb,5,main]]:

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 - run()/openServerSocket():

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 - java.net.BindException: Address already in use (Bind failed)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at java.net.PlainSocketImpl.socketBind(Native Method)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at java.net.ServerSocket.bind(ServerSocket.java:390)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at java.net.ServerSocket.<init>(ServerSocket.java:252)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at java.net.ServerSocket.<init>(ServerSocket.java:143)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown Source)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at org.hsqldb.server.Server.openServerSocket(Unknown Source)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at org.hsqldb.server.Server.run(Unknown Source)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at org.hsqldb.server.Server.access$000(Unknown Source)

[HSQLDB Server @2015dddb] ERROR HyperSQLLogger:44 -         at org.hsqldb.server.Server$ServerThread.run(Unknown Source)

How can we change HSQLDB port?

Environment

DX Gateway/Restmon
Application Performance Management Infrastructure Agent.

Resolution

There is no way to change the HSQLDB from DX Gateway/Restmon or Application Performance Management Infrastructure Agent. It is hardcoded, this behavior will be fixed in the next release. The estimated time for the new DX Gateway/Restmon release is around mid-November 2020. There is no intermediate fix available as this requires a code change in the core product.