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(a)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