Hi folks, I've been going through an upgrade process to get 1.2rc1 testing underway; but I can't seem to get the xwiki database correctly updated. So far I've run down the usual avenues: * Added the connector for mysql. * Setup the hibernate.cfg.xml as defined. * Granted permissions to the xwiki database to the mysql xwiki user. The previous version being run was 1.1.2 This is not a problem if I create a new database (create empty db and let xwiki generate tables/etc); only when I expect the database to be upgraded.
I'm almost certain to be missing some crucial step, but can't for the life of me think of what? Error Log from tomcat log file ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------ 17:18:08,896 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome] [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02 17:18:08,896 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome] [http-8080-1] ERROR util.JDBCExceptionReporter - Table 'xwiki.xwikidbversion' doesn't exist 17:18:08,912 [] [http-8080-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 17:25:54,208 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome] [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 1, SQLState: HY000 17:25:54,208 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome] [http-8080-1] ERROR util.JDBCExceptionReporter - Can't create/write to file '#sql_fc0_0.MYD' (Errcode: 17) 17:25:54,208 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome] [http-8080-1] ERROR store.XWikiHibernateBaseStore - Failed creating schema update script org.hibernate.exception.GenericJDBCException: could not get table metadata: feeds_aggregatorgroup at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQ LStateConverter.java:91) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java :79) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. java:29) at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMet adata.java:100) at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration .java:838) at com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiH ibernateBaseStore.java:361) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateB aseStore.java:249) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateB aseStore.java:225) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernat eBaseStore.java:470) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseSt ore.java:914) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBa seStore.java:947) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.g etDBVersion(XWikiHibernateMigrationManager.java:60) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrati onsForDatabase(AbstractXWikiMigrationManager.java:140) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrati ons(AbstractXWikiMigrationManager.java:102) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708) at com.xpn.xwiki.XWiki.<init>(XWiki.java:659) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2 63) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process( Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Can't create/write to file '#sql_fc0_0.MYD' (Errcode: 17) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.Connection.execSQL(Connection.java:3178) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1203) at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2382) at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.j ava:76) at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2256)
_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users