0036862: update.database throws NPE in PostgreSQL 9.6

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #36862		[ All Revisions ] [ Back to Issue ]
Summary	0036862: update.database throws NPE in PostgreSQL 9.6

Revision	2017-09-15 09:09 by AugustoMauch
Description	Update.database fails if executed on an Openbravo instance that uses PostgreSQL 9.6. With the following error: [java] 20297 INFO - Updating database model... [java] org.apache.ddlutils.DdlUtilsException: java.lang.NullPointerException [java] at org.apache.ddlutils.util.CallbackClosure.execute(CallbackClosure.java:154) [java] at org.apache.ddlutils.platform.SqlBuilder$1.evaluate(SqlBuilder.java:975) [java] at org.apache.commons.collections.CollectionUtils.filter(CollectionUtils.java:406) [java] at org.apache.ddlutils.platform.SqlBuilder.applyForSelectedChanges(SqlBuilder.java:972) [java] at org.apache.ddlutils.platform.SqlBuilder.processChanges(SqlBuilder.java:1060) [java] at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java:576) [java] at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java:562) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:679) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:662) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:178) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) [java] Caused by: 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:506) [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder.writeDropFunctionStmt(PostgreSqlBuilder.java:346) [java] at org.apache.ddlutils.platform.SqlBuilder.dropFunction(SqlBuilder.java:4224) [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBui20485 ERROR - [java] java.lang.NullPointerException The functions that are causing the error when trying to be dropped are: - GIN_TRGM_TRICONSISTENT - WORD_SIMILARITY - etc Those are functions defined by the new version of pg_trgm extension. The excludeFilter needs to be updated to exclude these new functions.

Revision	2017-09-15 08:58 by AugustoMauch
Description	Update.database fails if executed on an Openbravo instance that uses PostgreSQL 9.6. With the following error: [java] 20283 INFO - Executed 117 SQL command(s) successfully in 361 ms [java] 20297 INFO - Updating database model... [java] org.apache.ddlutils.DdlUtilsException: java.lang.NullPointerException [java] at org.apache.ddlutils.util.CallbackClosure.execute(CallbackClosure.java:154) [java] at org.apache.ddlutils.platform.SqlBuilder$1.evaluate(SqlBuilder.java:975) [java] at org.apache.commons.collections.CollectionUtils.filter(CollectionUtils.java:406) [java] at org.apache.ddlutils.platform.SqlBuilder.applyForSelectedChanges(SqlBuilder.java:972) [java] at org.apache.ddlutils.platform.SqlBuilder.processChanges(SqlBuilder.java:1060) [java] at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java:576) [java] at org.apache.ddlutils.platform.SqlBuilder.alterDatabase(SqlBuilder.java:562) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:679) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:662) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:178) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) [java] Caused by: 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:506) [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder.writeDropFunctionStmt(PostgreSqlBuilder.java:346) [java] at org.apache.ddlutils.platform.SqlBuilder.dropFunction(SqlBuilder.java:4224) [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlBui20485 ERROR - [java] java.lang.NullPointerException The functions that are causing the error when trying to be dropped are: - GIN_TRGM_TRICONSISTENT - WORD_SIMILARITY - etc Those are functions defined by the new version of pg_trgm extension. The excludeFilter needs to be updated to exclude these new functions.