[xwiki-users] Upgrading to new 1.2rc1
Ludovic Dubost
ludovic at xwiki.org
Mon Dec 10 23:42:52 CET 2007
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.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(DatabaseMetadata.java:100)
>
> at
> org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiHibernateBaseStore.java:361)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:249)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
>
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
>
> at
> com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
>
> at
> com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
>
> at
> com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(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(RequestProcessor.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(ApplicationFilterChain.java:290)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>
> at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.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:263)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
>
> 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.java:76)
>
> at
> com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2256)
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> users mailing list
> users at 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
More information about the users
mailing list