Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038409Openbravo ERPA. Platformpublic2018-04-19 09:282018-04-27 09:09
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR18Q1.3Fixed in Version3.0PR18Q1.3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038409: error message activating heartbeat in PG10
DescriptionWhen 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 Reproduce1. 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 SolutionStarting 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
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0038407 closed alostale error message activating heartbeat in PG10 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-04-19 09:31alostaleTypedefect => backport
2018-04-19 09:31alostaleTarget Version => 3.0PR18Q1.2
2018-04-19 11:54alostaleTarget Version3.0PR18Q1.2 => 3.0PR18Q1.3
2018-04-25 12:18hgbotCheckin
2018-04-25 12:18hgbotNote Added: 0104073
2018-04-25 12:18hgbotStatusscheduled => resolved
2018-04-25 12:18hgbotResolutionopen => fixed
2018-04-25 12:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR18Q1.3/rev/ac2033d46b7c388a09698e2e2b1c1e34b940d01e [^]
2018-04-27 09:09caristuNote Added: 0104120
2018-04-27 09:09caristuStatusresolved => closed
2018-04-27 09:09caristuFixed in Version => 3.0PR18Q1.3

Notes
(0104073)
hgbot   
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   
2018-04-27 09:09   
Reviewed