Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0017466 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | critical | always | 2011-06-02 13:48 | 2011-06-09 16:09 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP0 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 866ee1af74ac | |||
| Projection | none | ETA | none | Target Version | 3.0MP0 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | 12e58eab2d50 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0017466: Upgrade error from 3.0RC7 | |||||||
| Description | Upgrading from 3.0RC7 fails with this error: update.database.java: [java] Executing database update process without checking changes in local files. [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/int_upgrade_pgsql. [^] User: int_upgrade_pgsql [java] 1034 INFO - Executing full update.database [java] 1049 INFO - Reading tables... [java] 8143 INFO - Reading views... [java] 8274 INFO - Reading sequences... [java] 8280 INFO - Reading triggers... [java] 8325 INFO - Reading functions... [java] 8729 INFO - Sorting foreign keys, indexes and checks... [java] 8999 INFO - Starting function and trigger standardization. [java] 59405 INFO - Checking datatypes from the model loaded from the database [java] 59421 INFO - Original model loaded from database. [java] 68294 INFO - Checking datatypes from the model loaded from XML files [java] 68348 INFO - Loading data from XML files [java] 73260 INFO - Loading and applying configuration scripts [java] 73276 INFO - Applying structure part of configuration script: org.openbravo.v3 [java] 73278 INFO - Loading configuration script: /srv/hudson/workspace/int-upgrade-pgsql/SANDBOX/main/modules/org.openbravo.v3/src-db/database/configScript.xml [java] Checking if database structure was modified locally. [java] Checking if data has changed in the application dictionary. [java] 74574 ERROR - Error while updating in the database : ERROR: column "upgrade_available" of relation "ad_module" does not exist [java] Position: 727 [java] org.postgresql.util.PSQLException: ERROR: column "upgrade_available" of relation "ad_module" does not exist [java] Position: 727 [java] org.apache.ddlutils.DatabaseOperationException: Error while updating in the database : ERROR: column "upgrade_available" of relation "ad_module" does not exist [java] Position: 727 [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1964) [java] at org.apache.ddlutils.platform.PlatformImplBase.updateinsert(PlatformImplBase.java:1527) [java] at org.openbravo.ddlutils.util.DBSMOBUtil.moveModuleDataFromInstTables(DBSMOBUtil.java:676) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:145) [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] Caused by: org.postgresql.util.PSQLException: ERROR: column "upgrade_available" of relation "ad_module" does not exist [java] Position: 727 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1958) [java] ... 5 more [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.ddlutils.platform.PlatformImplBase.privateupdate(PlatformImplBase.java:1958) [java] at org.apache.ddlutils.platform.PlatformImplBase.updateinsert(PlatformImplBase.java:1527) [java] at org.openbravo.ddlutils.util.DBSMOBUtil.moveModuleDataFromInstTables(DBSMOBUtil.java:676) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:145) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] Error while moving data from install tables. [java] 74594 INFO - Executing default prescript [java] 75108 INFO - Executed 118 SQL command(s) successfully [java] 75125 INFO - Updating database model... [java] 86318 INFO - Executed 815 SQL command(s) successfully [java] 86331 INFO - Executed 5 forced SQL command(s) successfully [java] 86333 INFO - Model update complete. [java] 86335 INFO - Disabling foreign keys [java] 92187 INFO - Executed 2125 SQL command(s) successfully [java] 92200 INFO - Disabling triggers [java] 93386 INFO - Executed 534 SQL command(s) successfully [java] 94432 INFO - Executed 560 SQL command(s) successfully | |||||||
| Steps To Reproduce | 1. install.source in 3.0RC7 2. Upgrade to the distribution created from tip. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0038199) shuehner (administrator) 2011-06-09 16:01 |
https://code.openbravo.com/erp/devel/dbsm-main/rev/876554edb8bb [^] |
|
(0038200) shuehner (administrator) 2011-06-09 16:09 |
dbsm code-change reviewed and looks fine as new position of move data is after table structure update which ensures that newly added columns exist. (which are used in the move). Functionally not extra tested as already been done as the builds.openbravo.com test which found this issue is no longer failing. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-06-02 13:48 | jpabloae | New Issue | |
| 2011-06-02 13:48 | jpabloae | Assigned To | => alostale |
| 2011-06-02 13:48 | jpabloae | Modules | => Core |
| 2011-06-02 13:48 | jpabloae | OBNetwork customer | => No |
| 2011-06-02 14:03 | alostale | Status | new => scheduled |
| 2011-06-02 14:03 | alostale | Assigned To | alostale => marvintm |
| 2011-06-02 14:03 | alostale | fix_in_branch | => pi |
| 2011-06-02 19:17 | dmitry_mezentsev | Status | scheduled => resolved |
| 2011-06-02 19:17 | dmitry_mezentsev | Fixed in Version | => 3.0MP0 |
| 2011-06-02 19:17 | dmitry_mezentsev | Fixed in SCM revision | => https://code.openbravo.com/erp/devel/pi/rev/866ee1af74ac [^] |
| 2011-06-02 19:17 | dmitry_mezentsev | Resolution | open => fixed |
| 2011-06-09 16:01 | shuehner | Note Added: 0038199 | |
| 2011-06-09 16:09 | shuehner | Note Added: 0038200 | |
| 2011-06-09 16:09 | shuehner | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |