Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038407Openbravo ERPA. Platformpublic2018-04-19 09:282018-04-27 09:06
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038407: 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
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-04-19 09:28alostaleNew Issue
2018-04-19 09:28alostaleAssigned To => platform
2018-04-19 09:28alostaleOBNetwork customer => No
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