10 Dec
2007
10 Dec
'07
6:49 p.m.
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)
10 Dec
10 Dec
11:42 p.m.
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
11 Dec
11 Dec
10:37 a.m.
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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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(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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:51 p.m.
Still waiting on the first page to load (hopefully all ok now)
---
14:44:26,415 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome]
[http-8080-1] INFO bernate.R4359XWIKI1459Migrator - Updating document
---
The above has been recording to the log the last 30 mins for different
documents; is this going to be done on every document in the database?
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of Esbach, Brandon
Sent: 11 December 2007 09:37
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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(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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:56 p.m.
Esbach, Brandon wrote:
Still waiting on the first page to load (hopefully all
ok now)
---
14:44:26,415 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome]
[http-8080-1] INFO bernate.R4359XWIKI1459Migrator - Updating document
---
The above has been recording to the log the last 30 mins for different
documents; is this going to be done on every document in the database?
Yes, but only for the first time.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of Esbach, Brandon
Sent: 11 December 2007 09:37
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
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?
No, it should be there.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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)
>
4:03 p.m.
Ah, ok.
I understand the need for the change (and accept it has to be done), but
is there any quicker way to do get the changes updated? They're taking
2s each at the moment.
As this is just a "test" migration first, I'm gonna have to repeat the
process a few times before I can do the actual upgrade (taking our live
wiki offline for more than an hour or two during business hours makes
things a little tense).
About 1800 documents over 5 virtual wikis could take awhile :o.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of Sergiu Dumitriu
Sent: 11 December 2007 14:56
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
Esbach, Brandon wrote:
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Still waiting on the first page to load (hopefully all
ok now)
---
14:44:26,415 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome]
[http-8080-1] INFO bernate.R4359XWIKI1459Migrator - Updating
document
---
The above has been recording to the log the last 30 mins for different
documents; is this going to be done on every document
in the database?
Yes, but only for the first time.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On
Behalf Of Esbach, Brandon
Sent: 11 December 2007 09:37
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
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?
No, it should be there.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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.j
a
va:79)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
e
r.java:43)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
e
r.java:29)
at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(Database
M
etadata.java:100)
at
org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configurat
i
on.java:838)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWi
k
iHibernateBaseStore.java:361)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHiberna
t
eBaseStore.java:249)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHiberna
t
eBaseStore.java:225)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber
n
ateBaseStore.java:470)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBas
e
Store.java:914)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernat
e
BaseStore.java:947)
at
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManage
r
.getDBVersion(XWikiHibernateMigrationManager.java:60)
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigr
a
tionsForDatabase(AbstractXWikiMigrationManager.java:140)
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigr
a
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(Reques
t
Processor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
v
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(Appl
> i
> cationFilterChain.java:290)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> i
> lterChain.java:206)
>
at
>
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc
> o
> dingFilter.java:117)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> i
> cationFilterChain.java:235)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> i
> lterChain.java:206)
>
at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> a
> lve.java:233)
>
at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> a
> lve.java:175)
>
at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> a
> va:128)
>
at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> a
> va:102)
>
at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> v
> e.java:109)
>
at
>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a
> :263)
>
at
>
844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
s
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(DatabaseMetaDat
> a
> .java:76)
>
> at
> com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2256
> )
>
5:49 p.m.
>They're taking 2s each at the moment.
Err, let me update that. One document so far taken over 35 mins :(.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of Esbach, Brandon
Sent: 11 December 2007 15:04
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
Ah, ok.
I understand the need for the change (and accept it has to be done), but
is there any quicker way to do get the changes updated? They're taking
2s each at the moment.
As this is just a "test" migration first, I'm gonna have to repeat the
process a few times before I can do the actual upgrade (taking our live
wiki offline for more than an hour or two during business hours makes
things a little tense).
About 1800 documents over 5 virtual wikis could take awhile :o.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf
Of Sergiu Dumitriu
Sent: 11 December 2007 14:56
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
Esbach, Brandon wrote:
Still waiting on the first page to load (hopefully all
ok now)
---
14:44:26,415 [http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome]
[http-8080-1] INFO bernate.R4359XWIKI1459Migrator - Updating
document
---
The above has been recording to the log the last 30 mins for different
documents; is this going to be done on every document
in the database?
Yes, but only for the first time.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On
Behalf Of Esbach, Brandon
Sent: 11 December 2007 09:37
To: XWiki Users
Subject: Re: [xwiki-users] Upgrading to new 1.2rc1
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?
No, it should be there.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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.j
a
va:79)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
e
r.java:43)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
e
r.java:29)
at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(Database
M
etadata.java:100)
at
org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configurat
i
on.java:838)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWi
k
iHibernateBaseStore.java:361)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHiberna
t
eBaseStore.java:249)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHiberna
t
eBaseStore.java:225)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHiber
n
ateBaseStore.java:470)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBas
e
Store.java:914)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernat
e
BaseStore.java:947)
at
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManage
r
.getDBVersion(XWikiHibernateMigrationManager.java:60)
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigr
a
tionsForDatabase(AbstractXWikiMigrationManager.java:140)
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigr
a
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(Reques
t
Processor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
v
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(Appl
> i
> cationFilterChain.java:290)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> i
> lterChain.java:206)
>
at
>
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc
> o
> dingFilter.java:117)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> i
> cationFilterChain.java:235)
>
at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> i
> lterChain.java:206)
>
at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> a
> lve.java:233)
>
at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> a
> lve.java:175)
>
at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> a
> va:128)
>
at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> a
> va:102)
>
at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> v
> e.java:109)
>
at
>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a
> :263)
>
at
>
844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
s
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(DatabaseMetaDat
> a
> .java:76)
>
> at
> com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2256
> )
>
6221
days inactive
6222
days old
6 comments
3 participants
participants (3)
-
Esbach, Brandon -
Ludovic Dubost -
Sergiu Dumitriu