Gonna try reinstalling the MySQL . This morning the (previously working) clean install test I did last night is not responding. Checked the config file, feeds.hbm.xml is being referenced as well. Should this be removed?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ludovic Dubost Sent: 10 December 2007 22:43 To: XWiki Users Subject: Re: [xwiki-users] Upgrading to new 1.2rc1 Hi, This line Can't create/write to file '#sql_fc0_0.MYD' (Errcode: 17) really does not seem right.. Have you tried a mysqlcheck to verify the db state Also does you hibernate file refer to feeds.hbm.xml in additional to xwiki.hbm.xml ? Ludovic Esbach, Brandon wrote: > > 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( > SQLStateConverter.java:91) > > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.ja > va:79) > > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelpe > r.java:43) > > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelpe > r.java:29) > > at > org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseM > etadata.java:100) > > at > org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configurati > on.java:838) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWik > iHibernateBaseStore.java:361) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernat > eBaseStore.java:249) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernat > eBaseStore.java:225) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibern > ateBaseStore.java:470) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase > Store.java:914) > > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernate > BaseStore.java:947) > > at > com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager > .getDBVersion(XWikiHibernateMigrationManager.java:60) > > at > com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra > tionsForDatabase(AbstractXWikiMigrationManager.java:140) > > at > com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra > tions(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(Request > Processor.java:431) > > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav > a: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(Appli > cationFilterChain.java:290) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnco > dingFilter.java:117) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa > lve.java:233) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa > lve.java:175) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja > va:128) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja > va:102) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv > e.java:109) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java > :263) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > 844) > > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proces > s(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 > .java:76) > > at > com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2256) > > ---------------------------------------------------------------------- > -- > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users