Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0056837
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2024-10-19 09:522024-10-19 12:39
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PriorityurgentResolutionfixedFixed in VersionPR25Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0056837: compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272

DescriptionExecuting 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)
Steps To ReproduceSee it being reproduced in ci: https://builds.openbravo.com/job/try-pos2-checks-modules-pgsql/7200/testReport/ [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0054768 closedAugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
depends on backport 0056838PR24Q4 closedAugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
depends on backport 0056839PR24Q3.2 closedAugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
depends on backport 0056840PR24Q2.4 closedAugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
related to defect 0056846 acknowledgedAugustoMauch Review other oid-as-int problems 

-  Notes
(0170599)
hgbot (developer)
2024-10-19 09:56

Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/50 [^]
(0170600)
hgbot (developer)
2024-10-19 09:56

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1398 [^]
(0170601)
hgbot (developer)
2024-10-19 12:39

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1398 [^]
(0170602)
hgbot (developer)
2024-10-19 12:39

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 34649c9d81bbef4edcaa64f21e81d17566a40f8f
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 19-10-2024 11:00:26
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/34649c9d81bbef4edcaa64f21e81d17566a40f8f [^]

Fixes ISSUE-56837: error reading operator oid if oid excedes max int value

When oid excedes the maximum value for int in Java, an error is thrown reading
functions from pg catalog.

Changed to read them as long instead of integer.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0170603)
hgbot (developer)
2024-10-19 12:39

Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/50 [^]
(0170604)
hgbot (developer)
2024-10-19 12:39

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 39dfa51ead26207368b5a6212cfac52d93327770
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 19-10-2024 11:00:01
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/39dfa51ead26207368b5a6212cfac52d93327770 [^]

Fixes ISSUE-56837: error reading operator oid if oid excedes max int value

When oid excedes the maximum value for int in Java, an error is thrown reading
functions from pg catalog.

Changed to read them as long instead of integer.

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---

- Issue History
Date Modified Username Field Change
2024-10-19 09:52 AugustoMauch New Issue
2024-10-19 09:52 AugustoMauch Assigned To => AugustoMauch
2024-10-19 09:52 AugustoMauch Modules => Core
2024-10-19 09:52 AugustoMauch Triggers an Emergency Pack => No
2024-10-19 09:52 AugustoMauch Issue generated from 0054768
2024-10-19 09:53 AugustoMauch Relationship added related to 0054768
2024-10-19 09:56 hgbot Note Added: 0170599
2024-10-19 09:56 hgbot Note Added: 0170600
2024-10-19 09:57 AugustoMauch Status new => scheduled
2024-10-19 12:39 hgbot Resolution open => fixed
2024-10-19 12:39 hgbot Status scheduled => closed
2024-10-19 12:39 hgbot Note Added: 0170601
2024-10-19 12:39 hgbot Fixed in Version => PR25Q1
2024-10-19 12:39 hgbot Note Added: 0170602
2024-10-19 12:39 hgbot Note Added: 0170603
2024-10-19 12:39 hgbot Note Added: 0170604
2024-10-21 12:42 AugustoMauch Relationship added related to 0056846


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker