Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039271Openbravo ERPA. Platformpublic2018-09-12 09:582018-09-20 19:27
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
Summary0039271: PG 11: error when updating database
DescriptionWhen trying to update database, an error is thrown and the process does not complete.
Steps To ReproduceUsing PostgreSQL 11:
1. run ant install.source
  -> OK
2. run ant update.database
  -> ERROR
     [java] 6951 INFO - Reading functions...
     [java] 6978 ERROR - ERROR: column pg_proc.proisagg does not exist
     [java] Hint: Perhaps you meant to reference the column "pg_proc.prolang".
     [java] Position: 497
     [java] org.postgresql.util.PSQLException: ERROR: column pg_proc.proisagg does not exist
     [java] Hint: Perhaps you meant to reference the column "pg_proc.prolang".
     [java] Position: 497
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
     [java] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
     [java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
     [java] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
     [java] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.fillList(ModelLoaderBase.java:882)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.readFunction(PostgreSqlModelLoader.java:519)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase$28.getRow(ModelLoaderBase.java:639)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:833)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.readFunctions(ModelLoaderBase.java:636)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:222)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.readDatabase(PostgreSqlModelLoader.java:89)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:131)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2210)
     [java] at org.openbravo.ddlutils.process.DBUpdater.update(DBUpdater.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:69)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:88)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:81)
     [java] org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: column pg_proc.proisagg does not exist
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039332 closed alostale PG 11: ad_db_modified function fails 
blocks feature request 0039270 closed platform support PostgreSQL 11 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-12 09:58alostaleNew Issue
2018-09-12 09:58alostaleAssigned To => platform
2018-09-12 09:58alostaleOBNetwork customer => No
2018-09-12 09:58alostaleModules => Core
2018-09-12 09:58alostaleTriggers an Emergency Pack => No
2018-09-12 09:59alostaleRelationship 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: 0106700
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/361d99d453c4cbecb83df3841931e1635af090e1 [^]
2018-09-12 14:05hgbotCheckin
2018-09-12 14:05hgbotNote Added: 0106702
2018-09-12 14:05hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/361d99d453c4cbecb83df3841931e1635af090e1 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/462a04c948fc7203e4f678546edb34cf50d59ab8 [^]
2018-09-12 21:33hudsonbotCheckin
2018-09-12 21:33hudsonbotNote Added: 0106734
2018-09-20 13:25caristuNote Added: 0106881
2018-09-20 13:25caristuStatusresolved => closed
2018-09-20 13:25caristuFixed in Version => 3.0PR18Q4
2018-09-20 19:27caristuIssue cloned0039332
2018-09-20 19:27caristuRelationship addedrelated to 0039332

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

fixed issue 39271: PG 11 - error when updating database

  PostgreSQL 11 replaces pg_proc.proisagg boolean column with prokind which is
  a flag for different types of procedures. Created new ModelLoader for PG 11
  making use of this new column.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0106702)
hgbot   
2018-09-12 14:05   
Repository: erp/devel/dbsm-main
Changeset: 462a04c948fc7203e4f678546edb34cf50d59ab8
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 12 13:14:54 2018 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/462a04c948fc7203e4f678546edb34cf50d59ab8 [^]

fixed issue 39271: PG 11 - error when updating database

  PostgreSQL 11 replaces pg_proc.proisagg boolean column with prokind which is
  a flag for different types of procedures. Created new ModelLoader for PG 11
  making use of this new column.

---
M src/org/apache/ddlutils/PlatformFactory.java
A src/org/apache/ddlutils/platform/postgresql/PostgreSql11ModelLoader.java
A src/org/apache/ddlutils/platform/postgresql/PostgreSql11Platform.java
---
(0106734)
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
(0106881)
caristu   
2018-09-20 13:25   
Code reviewed + tested OK.

Tested with version: "PostgreSQL 11beta3 (Ubuntu 11~beta3-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit"