Emmanuel Courcelle wrote: > 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 ?
You are not the first with a failed update. See http://sourceforge.net/mailarchive/forum.php?thread_id=31614751&forum_id=12992 for more info. It is not possible to revert unless you have a backup of the database that you can restore. What you can do is to manually update the schema version in the database to 29. The schema version is stored in the single row in the SchemaVersion table. /Nicklas > > > 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 > > > > > > ------------------------------------------------------------------------- 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]
