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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039271
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2018-09-12 09:582018-09-20 19:27
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q4
StatusclosedFix in branchFixed in SCM revision462a04c948fc
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version11Ant 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

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0039332 closedalostale PG 11: ad_db_modified function fails 
blocks feature request 0039270 acknowledgedplatform support PostgreSQL 11 

-  Notes
(0106700)
hgbot (developer)
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 (developer)
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 (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
(0106881)
caristu (developer)
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"

- Issue History
Date Modified Username Field Change
2018-09-12 09:58 alostale New Issue
2018-09-12 09:58 alostale Assigned To => platform
2018-09-12 09:58 alostale Modules => Core
2018-09-12 09:58 alostale Triggers an Emergency Pack => No
2018-09-12 09:59 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: 0106700
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/361d99d453c4cbecb83df3841931e1635af090e1 [^]
2018-09-12 14:05 hgbot Checkin
2018-09-12 14:05 hgbot Note Added: 0106702
2018-09-12 14:05 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/361d99d453c4cbecb83df3841931e1635af090e1 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/462a04c948fc7203e4f678546edb34cf50d59ab8 [^]
2018-09-12 21:33 hudsonbot Checkin
2018-09-12 21:33 hudsonbot Note Added: 0106734
2018-09-20 13:25 caristu Note Added: 0106881
2018-09-20 13:25 caristu Status resolved => closed
2018-09-20 13:25 caristu Fixed in Version => 3.0PR18Q4
2018-09-20 19:27 caristu Issue cloned 0039332
2018-09-20 19:27 caristu Relationship added related to 0039332


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker