Re: [xwiki-users] Upgrading to new 1.2rc1
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [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
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [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.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
Re: [xwiki-users] Upgrading to new 1.2rc1
They're taking 2s each at the moment. Err, let me update that. One document so far taken over 35 mins :(. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [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.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
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.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