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:
=================
Table : ExperimentRawBioAssays
=================
=================
Table : ExperimentalFactors
=================
=================
Table : Experiments
Index : name_idx [name]
Exists : true(Experiments_name_idx)
Safe drop : true
DROP-SQL : DROP INDEX "Experiments_name_idx"
CREATE-SQL : CREATE INDEX "Experiments_name_idx" ON "Experiments"
("name")
Actions :
=================
=================
Table : ExtraValueTypes
Index : name_idx [name]
Exists : true(ExtraValueTypes_name_idx)
Safe drop : true
DROP-SQL : DROP INDEX "ExtraValueTypes_name_idx"
CREATE-SQL : CREATE INDEX "ExtraValueTypes_name_idx" ON
"ExtraValueTypes" ("name")
Actions :
=================
=================
Table : ExtraValues
=================
=================
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 ?
--
Emmanuel COURCELLE [EMAIL PROTECTED]
L.I.P.M. (UMR CNRS-INRA 2594/441) tel (33) 5-61-28-54-50
B.P.52627 - 31326 CASTANET TOLOSAN Cedex - FRANCE
------
-------------------------------------------------------------------------
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
[email protected]
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
