Emmanuel Courcelle wrote:
> Nicklas Nordborg a écrit :
>> Hello Postgres users,
>>
>> We have now published some information about a workaround to make it
>> possible to upgrade a BASE installation running on a Postgres database.
>>
>>
> Hi Nicklas
> Thanks for the workaround.
>
> I did the updatedb.sh as you suggested: it ran quite smoothly
> Then I tried the updateindexes.sh script, and I got the message:
The indexes are not really needed but they will increase performance.
For example, the Features table may receive lots of data and is one that
you want to have indexes on. At first, it may seem unfortunate that this
is the table that is causing the problem. But, the index exists, it's
just that the update script doesn't find it. This time it is not a bug
in Hibernate, but in the BASE code. Well, fix it for the 2.1.1 release.
What you can do until then is to remove the index before executing the
updateindexes.sh script. You remove it with the following SQL command:
ALTER TABLE "Features" DROP CONSTRAINT "Features_uniquecoordinate"
/Nicklas
> =================
> Table : Features
> Unique : uniquecoordinate [column, row, arraydesignblock_id]
> Exists : false
> Safe drop : false
> DROP-SQL :
> CREATE-SQL : ALTER TABLE "Features" ADD CONSTRAINT
> "Features_uniquecoordinate" UNIQUE ("column", "row", "arraydesignblock_id")
> Actions : CREATE
> 13:54:53,569 ERROR core:1723 - Exception
> org.postgresql.util.PSQLException: ERROR: relation
> "Features_uniquecoordinate" already exists
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
> at
> com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
> at
> net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1715)
> at net.sf.basedb.install.InitDB.main(InitDB.java:85)
>
>
> net.sf.basedb.core.BaseException: ERROR: relation
> "Features_uniquecoordinate" already exists
> at
> net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1724)
> at net.sf.basedb.install.InitDB.main(InitDB.java:85)
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "Features_uniquecoordinate" already exists
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
> at
> com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
> at
> net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1715)
> ... 1 more
>
> Is it serious ?
>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
