0012696: Sometimes update.database fails during model loading because function temp_findinarray cannot be dropped

Description

Sometimes update.database fails during model loading because function temp_findinarray cannot be dropped:

39954 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:599)
     [java] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:127)
     [java] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2197)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:100)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)

This problem cannot be reproduced, it appears to be completely random, and fairly unfrequent.

Steps To Reproduce

We don't know a way to reliably reproduce the issue.

Proposed Solution

The creation of the temp_findinarray function will be moved to the prescript.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0013067

2.50MP25

closed

marvintm

update.database: random startup issue with function temp_findinarray

Notes
(0033051) marvintm (developer) 2010-12-07 15:02	This issue is the same as the one mentioned, which has been recently fixed.

Issue History
Date Modified	Username	Field	Change
2010-03-16 12:11	marvintm	New Issue
2010-03-16 12:11	marvintm	Assigned To	=> marvintm
2010-03-22 08:32	alostale	Status	new => scheduled
2010-03-22 08:32	alostale	fix_in_branch	=> pi
2010-12-07 15:02	marvintm	Relationship added	duplicate of 0013067
2010-12-07 15:02	marvintm	Note Added: 0033051
2010-12-07 15:02	marvintm	Status	scheduled => closed
2010-12-07 15:02	marvintm	Resolution	open => duplicate
2010-12-09 15:59	anonymous	sf_bug_id	0 => 3133055