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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013067
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorsometimes2010-04-22 07:542010-12-16 22:15
ReporterjpabloaeView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision431aa181f58d
ProjectionnoneETAnoneTarget Version2.50MP25
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision1133b8a877a3 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013067: update.database: random startup issue with function temp_findinarray

DescriptionThere are cases (random, once in a while, 3-5%) where the update.database fails with an error like the one paste below. It's not reproducible 100%, but it happens every month in our build farm:

update.database.java:
     [java] Executing database update process without checking changes in local files.
     [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/piinc. [^] User: tadpiinc
     [java] 2337 INFO - Executing full update.database
     [java] 2640 INFO - Reading tables...
     [java] 8977 ERROR - ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
     [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.closeMetadataSentences(PostgreSqlModelLoader.java:605)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:127)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2201)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:101)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2203)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:101)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
     [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.closeMetadataSentences(PostgreSqlModelLoader.java:605)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:127)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2201)
     [java] ... 3 more
     [java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:202)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] Caused by: org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2203)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:101)
     [java] ... 2 more
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
     [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.closeMetadataSentences(PostgreSqlModelLoader.java:605)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:127)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2201)
     [java] ... 3 more
     [java] --- Nested Exception ---
     [java] org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2203)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:101)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] Caused by: org.postgresql.util.PSQLException: ERROR: function temp_findinarray(integer[], integer) does not exist
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
     [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
     [java] at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.closeMetadataSentences(PostgreSqlModelLoader.java:605)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:127)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2201)
     [java] ... 3 more
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0012696 closedmarvintm Sometimes update.database fails during model loading because function temp_findinarray cannot be dropped 

-  Notes
(0032862)
hgbot (developer)
2010-11-25 18:28

 Repository: erp/devel/dbsm-main
Changeset: 798a8bf0173bc1f8686e12c460bc12b4452a3f9b
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Nov 25 18:13:14 2010 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/798a8bf0173bc1f8686e12c460bc12b4452a3f9b [^]

Fixed issue 13067. Removed temp_findinarray function so that it doesn't cause problems.

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0032863)
hgbot (developer)
2010-11-25 18:29

 Repository: erp/devel/pi
Changeset: 431aa181f58d9db075e26288d3ea65eace443937
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Nov 25 18:28:04 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/431aa181f58d9db075e26288d3ea65eace443937 [^]

Fixed issue 13067. Removed temp_findinarray function so that it doesn't cause problems.

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/excludeFilter.xml
---
(0032950)
hudsonbot (developer)
2010-11-30 17:52

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/431aa181f58d [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c27b4b566df [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19017.obx [^]
(0033143)
hgbot (developer)
2010-12-13 19:45

 Repository: erp/devel/dbsm-main
Changeset: 5f25c9ace5a536cc37c54af91474a8374cfcf115
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Dec 13 19:44:32 2010 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/5f25c9ace5a536cc37c54af91474a8374cfcf115 [^]

Issue 13067. Add @Override and some comments explaining the changed code

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0033144)
shuehner (administrator)
2010-12-13 19:47

 Reviewed and tested in pi/pgsql8.4 and pi/pgsql9.0 no inconsistencies related to index- or unique-constraint column ordering.
In addition tested by developer on pgsql8.4 and pgsql8.3

- Issue History
Date Modified Username Field Change
2010-04-22 07:54 jpabloae New Issue
2010-04-22 07:54 jpabloae Assigned To => alostale
2010-04-22 07:54 jpabloae Assigned To alostale => marvintm
2010-04-26 08:34 alostale Status new => scheduled
2010-10-25 15:57 egoitz Issue Monitored: networkb
2010-10-25 15:57 egoitz Issue Monitored: egoitz
2010-10-27 10:34 egoitz Target Version => 2.50MP25
2010-10-28 20:07 shuehner Issue Monitored: shuehner
2010-11-10 11:19 rafaroda Issue Monitored: rafaroda
2010-11-25 18:28 hgbot Checkin
2010-11-25 18:28 hgbot Note Added: 0032862
2010-11-25 18:28 hgbot Status scheduled => resolved
2010-11-25 18:28 hgbot Resolution open => fixed
2010-11-25 18:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/798a8bf0173bc1f8686e12c460bc12b4452a3f9b [^]
2010-11-25 18:29 hgbot Checkin
2010-11-25 18:29 hgbot Note Added: 0032863
2010-11-25 18:29 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/dbsm-main/rev/798a8bf0173bc1f8686e12c460bc12b4452a3f9b [^] => http://code.openbravo.com/erp/devel/pi/rev/431aa181f58d9db075e26288d3ea65eace443937 [^]
2010-11-30 17:52 hudsonbot Checkin
2010-11-30 17:52 hudsonbot Note Added: 0032950
2010-12-07 15:02 marvintm Relationship added has duplicate 0012696
2010-12-13 19:45 hgbot Checkin
2010-12-13 19:45 hgbot Note Added: 0033143
2010-12-13 19:47 shuehner Note Added: 0033144
2010-12-13 19:47 shuehner Status resolved => closed
2010-12-16 22:15 anonymous sf_bug_id 0 => 3138769

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker