Hi Nicklas... and others.
Sorry to bother you, but I couldn't update to 2.2.0
Running Tomcat 5.5.20 and postgresql 8.1.5 on Debian.
My install is a Base 2.1 (did not upgrade to 2.1.x), ./updatadb.sh
crashed, of course ./updateindexes.sh refuses to start because the
schema is not good,
and of course too, base2.2.0 refuses to start when I restart Tomcat.
Tried to revert to base2.1, he refuses to start either.
Should I restart the backups, or do you think it is still possible to
go on with the update process ?
Here is the stack trace:
[EMAIL PROTECTED] bin]$ ./updatedb.sh et-bin-ron
[0%] Building database...............
[30%] Database built successfully.
[35%] Initialising database...
[36%] --Creating quota types...
[37%] --Creating quota...
[39%] --Creating roles...
[40%] --Creating users...
[42%] --Creating groups...
[43%] --Creating keys...
[44%] --Creating protocol types...
[46%] --Creating hardware types...
[47%] --Creating hardware...
[49%] --Creating software types...
[50%] --Creating software...
[51%] --Creating directories...
[53%] --Creating file types...
[54%] --Creating MIME types...
[56%] --Creating plate geometries...
[57%] --Creating plate mappings...
[58%] --Creating labels...
[60%] --Creating annotation types...
[61%] --Creating clients...
[63%] --Creating news...
[64%] --Creating plugin definitions...
[67%] --Creating formulas...
[68%] --Creating job agents...
[70%] Database initialised successfully.
[75%] Updating database...
[83%] --Updating schema version: 20 -> 23...
[85%] --Updating schema version: 23 -> 24...
[85%] --NOTE! The "FileValues" table is no longer used by BASE. It may
be removed from the database.
[85%] --Updating schema version: 24 -> 25...
[86%] --Updating schema version: 25 -> 27...
[87%] --Updating schema version: 27 -> 28...
[87%] --Updating schema version: 28 -> 29...08:45:23,424 ERROR
Update:1150 - updateToSchemaVersion29: FAILED
net.sf.basedb.core.BaseException: could not execute query
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1355)
at
net.sf.basedb.core.Update.updateToSchemaVersion29(Update.java:1105)
at net.sf.basedb.core.Update.updateDatabase(Update.java:504)
at net.sf.basedb.install.InitDB.main(InitDB.java:69)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2214)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1351)
... 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column
"measuredbi1_.id" must appear in the GROUP BY clause or be used in an
aggregate function
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:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
... 11 more
[90%] Database update failed: could not execute query
net.sf.basedb.core.BaseException: could not execute query
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1355)
at
net.sf.basedb.core.Update.updateToSchemaVersion29(Update.java:1105)
at net.sf.basedb.core.Update.updateDatabase(Update.java:504)
at net.sf.basedb.install.InitDB.main(InitDB.java:69)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2214)
at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
net.sf.basedb.core.HibernateUtil.loadList(HibernateUtil.java:1351)
... 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column
"measuredbi1_.id" must appear in the GROUP BY clause or be used in an
aggregate function
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:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
... 11 more
--
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
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
