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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039273
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2018-09-12 12:412018-09-20 18:54
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q4
StatusclosedFix in branchFixed in SCM revision0cf455f5e717
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039273: 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)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0037310 closedgorkaion Amazon RDS - Postgresql compatibility. Remove superuser role. 
blocks feature request 0039270 closedplatform support PostgreSQL 11 

-  Notes
(0106701)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2018-09-12 12:41 alostale New Issue
2018-09-12 12:41 alostale Assigned To => platform
2018-09-12 12:41 alostale Modules => Core
2018-09-12 12:41 alostale Triggers an Emergency Pack => No
2018-09-12 12:41 alostale Relationship added blocks 0039270
2018-09-12 14:03 alostale Assigned To platform => alostale
2018-09-12 14:03 alostale Review Assigned To => caristu
2018-09-12 14:04 hgbot Checkin
2018-09-12 14:04 hgbot Note Added: 0106701
2018-09-12 14:04 hgbot Status new => resolved
2018-09-12 14:04 hgbot Resolution open => fixed
2018-09-12 14:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0cf455f5e7179c4cd547fadcefec189f7a9b14ad [^]
2018-09-12 14:05 hgbot Checkin
2018-09-12 14:05 hgbot Note Added: 0106703
2018-09-12 14:05 hgbot Checkin
2018-09-12 14:05 hgbot Note Added: 0106704
2018-09-12 21:33 hudsonbot Checkin
2018-09-12 21:33 hudsonbot Note Added: 0106735
2018-09-20 13:39 caristu Relationship added related to 0037310
2018-09-20 18:52 hgbot Checkin
2018-09-20 18:52 hgbot Note Added: 0106908
2018-09-20 18:52 hgbot Checkin
2018-09-20 18:52 hgbot Note Added: 0106909
2018-09-20 18:54 caristu Status resolved => closed
2018-09-20 18:54 caristu Fixed in Version => 3.0PR18Q4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker