Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039273Openbravo ERPA. Platformpublic2018-09-12 12:412018-09-20 18:54
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q4 
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
Summary0039273: PG 11: NPE updating DB
DescriptionAfter fix for 0039271, DB can still not be exported because an error is thrown.
Steps To ReproduceUsing PostgreSQL 11 and having patch for 0039271:
1. run ant install.source
  -> OK
2. run ant update.database
  -> ERROR:
     [java] 21683 INFO - Updating database model...
     [java] 22404 INFO - Executed 53 SQL command(s) successfully in 551 ms
     [java] 22460 INFO - Executed 5 forced SQL command(s) with 1 error(s) in 45 ms
     [java] 22483 INFO - Executed 1 forced SQL command(s) successfully in 68 ms
     [java] 22512 ERROR -
     [java] java.lang.NullPointerException
     [java] at org.apache.ddlutils.model.Parameter.getName(Parameter.java:53)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder.writeParameter(PostgreSqlBuilder.java:529)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder.writeDropFunctionStmt(PostgreSqlBuilder.java:346)
     [java] at org.apache.ddlutils.platform.SqlBuilder.dropFunction(SqlBuilder.java:4276)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder.dropFunction(PostgreSqlBuilder.java:519)
     [java] at org.apache.ddlutils.platform.SqlBuilder.processChange(SqlBuilder.java:1543)
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java] at java.lang.reflect.Method.invoke(Method.java:498)
     [java] at org.apache.ddlutils.util.CallbackClosure.execute(CallbackClosure.java:151)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0037310 closed gorkaion Amazon RDS - Postgresql compatibility. Remove superuser role. 
blocks feature request 0039270 closed platform support PostgreSQL 11 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-12 12:41alostaleNew Issue
2018-09-12 12:41alostaleAssigned To => platform
2018-09-12 12:41alostaleOBNetwork customer => No
2018-09-12 12:41alostaleModules => Core
2018-09-12 12:41alostaleTriggers an Emergency Pack => No
2018-09-12 12:41alostaleRelationship addedblocks 0039270
2018-09-12 14:03alostaleAssigned Toplatform => alostale
2018-09-12 14:03alostaleReview Assigned To => caristu
2018-09-12 14:04hgbotCheckin
2018-09-12 14:04hgbotNote Added: 0106701
2018-09-12 14:04hgbotStatusnew => resolved
2018-09-12 14:04hgbotResolutionopen => fixed
2018-09-12 14:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0cf455f5e7179c4cd547fadcefec189f7a9b14ad [^]
2018-09-12 14:05hgbotCheckin
2018-09-12 14:05hgbotNote Added: 0106703
2018-09-12 14:05hgbotCheckin
2018-09-12 14:05hgbotNote Added: 0106704
2018-09-12 21:33hudsonbotCheckin
2018-09-12 21:33hudsonbotNote Added: 0106735
2018-09-20 13:39caristuRelationship addedrelated to 0037310
2018-09-20 18:52hgbotCheckin
2018-09-20 18:52hgbotNote Added: 0106908
2018-09-20 18:52hgbotCheckin
2018-09-20 18:52hgbotNote Added: 0106909
2018-09-20 18:54caristuStatusresolved => closed
2018-09-20 18:54caristuFixed in Version => 3.0PR18Q4

Notes
(0106701)
hgbot   
2018-09-12 14:04   
Repository: erp/devel/pi
Changeset: 0cf455f5e7179c4cd547fadcefec189f7a9b14ad
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 12 13:58:11 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0cf455f5e7179c4cd547fadcefec189f7a9b14ad [^]

fixed issue 39273: PG 11 - NPE updating DB

  Excluded new functions included in pg_trgm extension

---
M src-db/database/model/excludeFilter.xml
---
(0106703)
hgbot   
2018-09-12 14:05   
Repository: erp/devel/dbsm-main
Changeset: 6a4714e2d2851259b78f5e766fccfdaac3d6d3f6
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 12 13:15:59 2018 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/6a4714e2d2851259b78f5e766fccfdaac3d6d3f6 [^]

related to issue 39273: PG 11 - NPE updating DB

  Excluded new functions in pg_trgm extension.

---
M src-test/model/excludeFilter/excludeExtensionFunctions.xml
---
(0106704)
hgbot   
2018-09-12 14:05   
Repository: erp/devel/dbsm-main
Changeset: 8c6e4dad6e66109bd889ee2b567b19e8c315bb9c
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 12 13:16:54 2018 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/8c6e4dad6e66109bd889ee2b567b19e8c315bb9c [^]

related to issue 39273: PG 11 - NPE updating DB

  Fixes test cases in PostgreSQL 11.

  Ensure extensions are created and dropped as system use, otherways PG 11
  doesn't allow it.

---
M src-test/src/org/openbravo/dbsm/test/base/DbsmTest.java
M src-test/src/org/openbravo/dbsm/test/model/ContainsSearchIndexes.java
---
(0106735)
hudsonbot   
2018-09-12 21:33   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ad75d3cb1744 [^]
Maturity status: Test
(0106908)
hgbot   
2018-09-20 18:52   
Repository: erp/devel/dbsm-main
Changeset: 75207a390ceef6ebb5e39282ff665ec0092e1fcf
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Sep 20 18:51:20 2018 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/75207a390ceef6ebb5e39282ff665ec0092e1fcf [^]

related to issue 39273: PG 11 - NPE updating DB

  Update copyright year

---
M src-test/src/org/openbravo/dbsm/test/base/DbsmTest.java
M src-test/src/org/openbravo/dbsm/test/model/ContainsSearchIndexes.java
---
(0106909)
hgbot   
2018-09-20 18:52   
Repository: erp/devel/dbsm-main
Changeset: 7c81a9b59e607e8921b68c902f6e10fb2ad16306
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Sep 20 18:52:18 2018 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/7c81a9b59e607e8921b68c902f6e10fb2ad16306 [^]

related to issue 39273: PG 11 - NPE updating DB

   Fixes test case in PostgreSQL 11.

 Ensure extensions are created and dropped as system use, otherways PG 11
 doesn't allow it.

---
M src-test/src/org/openbravo/dbsm/test/model/recreation/AddDropConstraints.java
---