Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0038407Openbravo ERPA. Platformpublic2018-04-19 09:282018-04-27 09:06
alostale 
alostale 
normalminoralways
closedfixed 
5
 
3.0PR18Q3 
caristu
Core
No
0038407: error message activating heartbeat in PG10
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.
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
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
No tags attached.
related to feature request 0036911 closed alostale support PostgreSQL 10 
depends on backport 00384083.0PR18Q2 closed alostale error message activating heartbeat in PG10 
depends on backport 00384093.0PR18Q1.3 closed alostale error message activating heartbeat in PG10 
Issue History
2018-04-19 09:28alostaleNew Issue
2018-04-19 09:28alostaleAssigned To => platform
2018-04-19 09:28alostaleModules => Core
2018-04-19 09:28alostaleTriggers an Emergency Pack => No
2018-04-19 09:29alostaleRelationship addedrelated to 0036911
2018-04-19 09:30alostaleAssigned Toplatform => alostale
2018-04-19 09:31alostaleReview Assigned To => caristu
2018-04-19 09:31alostaleStatusnew => scheduled
2018-04-19 12:09hgbotCheckin
2018-04-19 12:09hgbotNote Added: 0103991
2018-04-19 12:09hgbotStatusscheduled => resolved
2018-04-19 12:09hgbotResolutionopen => fixed
2018-04-19 12:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8442228af1dd7d886f90829c803ec89ca8144558 [^]
2018-04-27 09:06caristuNote Added: 0104118
2018-04-27 09:06caristuStatusresolved => closed
2018-04-27 09:06caristuFixed in Version => 3.0PR18Q3

Notes
(0103991)
hgbot   
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   
2018-04-27 09:06   
Code reviewed + tested