Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0056839Openbravo ERPA. Platformpublic2024-10-19 09:522024-10-21 10:42
AugustoMauch 
AugustoMauch 
urgentmajoralways
closedfixed 
5
 
PR24Q3.2PR24Q3.2 
Core
No
0056839: compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272
Executing update.database command, error is happening when the postgresql OID assigned to functions is higher than max int value (2,147,483,647).

java.lang.NumberFormatException: For input string: "2177813260"
    at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.base/java.lang.Integer.parseInt(Integer.java:652)
    at java.base/java.lang.Integer.parseInt(Integer.java:770)
    at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.getOperatorClassName(PostgreSqlModelLoader.java:955)
    at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.readIndex(PostgreSqlModelLoader.java:932)
    at org.apache.ddlutils.platform.ModelLoaderBase$7.getRow(ModelLoaderBase.java:354)
    at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:665)
    at org.apache.ddlutils.platform.ModelLoaderBase.readIndexes(ModelLoaderBase.java:351)
    at org.apache.ddlutils.platform.ModelLoaderBase.readTable(ModelLoaderBase.java:264)
    at org.apache.ddlutils.platform.ModelLoaderBase$1.getRow(ModelLoaderBase.java:207)
    at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:665)
    at org.apache.ddlutils.platform.ModelLoaderBase.readTables(ModelLoaderBase.java:203)
    at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:162)
See it being reproduced in ci: https://builds.openbravo.com/job/try-pos2-checks-modules-pgsql/7200/testReport/ [^]
No tags attached.
blocks defect 0056837 closed AugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
Issue History
2024-10-19 09:57AugustoMauchTypedefect => backport
2024-10-19 09:57AugustoMauchTarget Version => PR24Q3.2
2024-10-21 10:37hgbotNote Added: 0170664
2024-10-21 10:38hgbotNote Added: 0170665
2024-10-21 10:42hgbotResolutionopen => fixed
2024-10-21 10:42hgbotStatusscheduled => closed
2024-10-21 10:42hgbotNote Added: 0170666
2024-10-21 10:42hgbotNote Added: 0170667
2024-10-21 10:42hgbotNote Added: 0170668
2024-10-21 10:42hgbotFixed in Version => PR24Q3.2
2024-10-21 10:42hgbotNote Added: 0170669

Notes
(0170664)
hgbot   
2024-10-21 10:37   
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/52 [^]
(0170665)
hgbot   
2024-10-21 10:38   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1400 [^]
(0170666)
hgbot   
2024-10-21 10:42   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 9cb6efd88ab7f4b1d9bd59fd225e4f5234fa7b30
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 21-10-2024 10:36:53
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/9cb6efd88ab7f4b1d9bd59fd225e4f5234fa7b30 [^]

Fixes ISSUE-56839: Fixes errors related to storing oids in ints - 24Q3

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0170667)
hgbot   
2024-10-21 10:42   
Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/52 [^]
(0170668)
hgbot   
2024-10-21 10:42   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1400 [^]
(0170669)
hgbot   
2024-10-21 10:42   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: b1847a1659e0dd67c1dbd81a521e37f054a79fbf
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 21-10-2024 10:37:47
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/b1847a1659e0dd67c1dbd81a521e37f054a79fbf [^]

Fixes ISSUE-56839: Fixes errors related to storing oids in ints - 24Q3

---
M src-db/database/lib/dbsourcemanager.jar
---