0038409: error message activating heartbeat in PG10

Description

When trying to activate Heartbeat in an instance with PostgreSQL 10, an error message is displayed and heartbeat log is not saved in local DB although beat is correctly sent and saved in heartbeat server.

Steps To Reproduce

1. Log in as System Admin
2. Open Heartbeat Configuration window
3. Click on Enable Heartbeat button
-> ERROR: databaseVersion: Value (10.3 (Ubuntu 10.3-1.pgdg16.04+1)) is too long

Proposed Solution

Starting from PostgreSQL 10, server_version information includes not only version itself but also the package it is installed from, example:

PG 10
show server_version;
server_version
----------------------------------
10.3 (Ubuntu 10.3-1.pgdg16.04+1)
(1 row)

PG 9
show server_version;
server_version
----------------
9.3.21
(1 row)

This issue can be fixed by one of these:

1. Parse version to remove package information
2. Keep package information and extend column size to support it: not in this case will cause a formal API change

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0038407

closed

alostale

error message activating heartbeat in PG10

Notes
(0104073) hgbot (developer) 2018-04-25 12:18	Repository: erp/backports/3.0PR18Q1.3 Changeset: ac2033d46b7c388a09698e2e2b1c1e34b940d01e Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Apr 19 12:09:11 2018 +0200 URL: http://code.openbravo.com/erp/backports/3.0PR18Q1.3/rev/ac2033d46b7c388a09698e2e2b1c1e34b940d01e [^] fixes 38409: error message activating heartbeat in PG10 Starting from PostgreSQL 10, server version string includes also package, being a longer String it doesn't fit current column size. Fixed by getting just the first word of the version (which is the actual server version) skipping the rest that refers to the package. Examples: 9.3.21 -> 9.3.21 10.3 (Ubuntu 10.3-1.pgdg16.04+1) -> 10.3 11devel (Debian 11~~devel~20180418.2231-1~573.git5372c2c.pgdg90+1) -> 11devel --- M src/org/openbravo/erpCommon/utility/SystemInfo.java ---

(0104120) caristu (developer) 2018-04-27 09:09	Reviewed

Issue History
Date Modified	Username	Field	Change
2018-04-19 09:31	alostale	Type	defect => backport
2018-04-19 09:31	alostale	Target Version	=> 3.0PR18Q1.2
2018-04-19 11:54	alostale	Target Version	3.0PR18Q1.2 => 3.0PR18Q1.3
2018-04-25 12:18	hgbot	Checkin
2018-04-25 12:18	hgbot	Note Added: 0104073
2018-04-25 12:18	hgbot	Status	scheduled => resolved
2018-04-25 12:18	hgbot	Resolution	open => fixed
2018-04-25 12:18	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR18Q1.3/rev/ac2033d46b7c388a09698e2e2b1c1e34b940d01e [^]
2018-04-27 09:09	caristu	Note Added: 0104120
2018-04-27 09:09	caristu	Status	resolved => closed
2018-04-27 09:09	caristu	Fixed in Version	=> 3.0PR18Q1.3