Override metrics DB port using com.gs.ui.metrics.db.port system property

after set “-Dcom.gs.ui.metrics.db.port=9102”, multiple GS managers can be started in same server.

However, the manager log continuous print warning no matter I set “-Dcom.gs.hsqldb.all-metrics-recording.enabled=false” or not.

Look like the connection string is not picking up the port settings.

Logs:

2020-06-15 00:36:06,069 INFO [org.eclipse.jetty.server.handler.ContextHandler.ROOT] [LoggingDispatcher] - LUS [main] Initializing Spring DispatcherServlet 'NewWebUI'

2020-06-15 00:36:08,172 INFO [com.gigaspaces.newwebui.db.HsqlServerBean] [LoggingDispatcher] - LUS [main] HSQL Server Startup sequence initiated

2020-06-15 00:36:08,489 INFO [hsqldb.db.HSQLDB713E0F8BD0.ENGINE] [LoggingDispatcher] - REST [null] dataFileCache open start

2020-06-15 00:36:08,500 INFO [hsqldb.db.HSQLDB713E0F8BD0.ENGINE] [LoggingDispatcher] - REST [HSQLDB Server @573870cb] dataFileCache open end

2020-06-15 00:36:08,573 INFO [com.gigaspaces.newwebui.db.HsqlServerBean] [LoggingDispatcher] - LUS [main] HSQL Server listening on port 9102

………………………………….

2020-06-15 00:36:09,994 INFO [com.gigaspaces.manager] [LoggingDispatcher] - LUS [main] Started at http://vhkdld1158:8091

2020-06-15 00:36:44,985 INFO [com.gigaspaces.grid.gsm.peer] [LoggingDispatcher] - GSM [null] Adding [fmsuserspace] from GSM - [GSM pid[15878] host[VKLNLD875/10.22.77.216]]

2020-06-15 00:36:45,048 INFO [com.gigaspaces.grid.gsm.peer] [LoggingDispatcher] - GSM [GS-LRMI-Connection-pool-1-thread-7] Downloading [fmsuserspace] into [/app/python/GigaSpacesXAP/gs-deploy/fmsuserspace] from managing GSM located at [http://10.22.77.216:45205/fmsuserspace] ...

2020-06-15 00:36:46,225 INFO [com.gigaspaces.grid.gsm.peer] [LoggingDispatcher] - GSM [GS-LRMI-Connection-pool-1-thread-7] Downloaded [fmsuserspace], size [2.31kb] to [/app/python/GigaSpacesXAP/gs-deploy/fmsuserspace]

2020-06-15 00:36:50,515 INFO [com.gigaspaces.grid.gsm.services] [LoggingDispatcher] - GSM [null] Monitoring Service: [fmsuserspace.1_1 [1]] at host: [10.22.77.209]

2020-06-15 00:36:52,001 WARNING [com.gigaspaces.metrics.hsqldb.SharedJdbcConnectionWrapper] [LoggingDispatcher] - LUS [null] Jdbc Connection failed 1 consecutive times - [url=jdbc:hsqldb:hsql://vhkdld1158:9101/metricsdb]; Caused by: java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused (Connection refused)

2020-06-15 00:36:52,001 WARNING [com.gigaspaces.metrics.hsqldb.HsqlDbReporter] [LoggingDispatcher] - LUS [GS-metrics-sampler-default] Report skipped - connection is not available yet

2020-06-15 00:36:57,000 WARNING [com.gigaspaces.metrics.hsqldb.SharedJdbcConnectionWrapper] [LoggingDispatcher] - LUS [GS-metrics-sampler-default] Jdbc Connection failed 2 consecutive times - [url=jdbc:hsqldb:hsql://vhkdld1158:9101/metricsdb]; Caused by: java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused (Connection refused)