0038407: 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 ]

related to	feature request	0036911		closed	alostale	support PostgreSQL 10
depends on	backport	0038408	3.0PR18Q2	closed	alostale	error message activating heartbeat in PG10
depends on	backport	0038409	3.0PR18Q1.3	closed	alostale	error message activating heartbeat in PG10

Notes
(0103991) hgbot (developer) 2018-04-19 12:09	Repository: erp/devel/pi Changeset: 8442228af1dd7d886f90829c803ec89ca8144558 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Apr 19 12:09:11 2018 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/8442228af1dd7d886f90829c803ec89ca8144558 [^] fixes 38407: 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 ---

(0104118) caristu (developer) 2018-04-27 09:06	Code reviewed + tested

Issue History
Date Modified	Username	Field	Change
2018-04-19 09:28	alostale	New Issue
2018-04-19 09:28	alostale	Assigned To	=> platform
2018-04-19 09:28	alostale	Modules	=> Core
2018-04-19 09:28	alostale	Triggers an Emergency Pack	=> No
2018-04-19 09:29	alostale	Relationship added	related to 0036911
2018-04-19 09:30	alostale	Assigned To	platform => alostale
2018-04-19 09:31	alostale	Review Assigned To	=> caristu
2018-04-19 09:31	alostale	Status	new => scheduled
2018-04-19 12:09	hgbot	Checkin
2018-04-19 12:09	hgbot	Note Added: 0103991
2018-04-19 12:09	hgbot	Status	scheduled => resolved
2018-04-19 12:09	hgbot	Resolution	open => fixed
2018-04-19 12:09	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/8442228af1dd7d886f90829c803ec89ca8144558 [^]
2018-04-27 09:06	caristu	Note Added: 0104118
2018-04-27 09:06	caristu	Status	resolved => closed
2018-04-27 09:06	caristu	Fixed in Version	=> 3.0PR18Q3