Re: [xwiki-users] Failed migration from 3.0 to 4.3.1

Hi Denis, both queries didn't produce any rows. If you have time we could talk via IRC (http://webchat.quakenet.org/ channelname is #xwiki) Regards, Robert Denis Gervalle-2 wrote > Robert, > > Could you run the following queries on the original DB: > > SELECT COUNT(*) AS cnt FROM xwikilinks GROUP BY XWL_DOC_ID, XWL_LINK > HAVING > cnt > 1; > > SELECT XWL_DOC_ID FROM xwikilinks LEFT JOIN xwikidoc ON XWL_DOC_ID = > XWD_ID > WHERE XWD_ID IS NULL; > > Does on of them produce any resulting rows ? it should not obviously. > Regards, > > > On Thu, Jan 17, 2013 at 11:50 AM, rschmid89 <

> r.schmidpeter@

> &gt;wrote: > >> To 1) I'm using MS SQL >> To 2) I have basic knowledge >> To 3) At the moment I can only talk over e-mail >> >> Regards, >> >> >> Denis Gervalle-2 wrote >> > Robert, >> > >> > Statistic cleaning is useless since you have never used XWIki Stats on >> > that >> > DB. >> > Look at the logs, what happens is somewhat impossible ! So I will have >> to >> > be creative to understand why the impossible became possible. But >> before, >> > I >> > need some more information. >> > >> > 1) Have you migrated that wiki (at some point in time) from a MyISAM >> to >> > innoDB MySQL engine ? >> > 2) What are your skill in databases ? >> > 3) Are you available to talk over irc or any other IM network (MSN, >> gTalk, >> > ...) ?, it may be faster for me to help you interactively. >> > >> > Regards, >> > >> > >> > On Thu, Jan 17, 2013 at 10:38 AM, rschmid89 &lt; >> >> > r.schmidpeter@ >> >> > &gt;wrote: >> > >> >> Hi Denis, >> >> >> >> I did the statistic cleaning every time after the rewriting of the >> backup >> >> on >> >> the db. And I delete the to changelog tables everytime before >> starting >> >> xwiki. >> >> >> >> So here is the stdout (http://pastebin.com/eSXE88Q5), it would be >> great >> >> if >> >> you could help me through this. >> >> >> >> Regards >> >> >> >> >> >> Denis Gervalle-2 wrote >> >> > Hi Robert, >> >> > >> >> > The migration had failed in some way, and the log you provided is >> just >> >> the >> >> > consequences of that. To understand what may have happened, you >> need >> to >> >> > look at logs (the standard output of the server), and looks >> carefully >> >> > where >> >> > the migration failed. If you are migrating a wiki that have existed >> >> before >> >> > 3.x, and you have some statistics in your database, you may also >> want >> >> to >> >> > clean them up as explained in the release notes. >> >> > >> >> > If you may provide the log of the migration, I will try to help you >> >> > understand the issue. >> >> > Regards, >> >> > >> >> > >> >> > On Thu, Jan 17, 2013 at 9:08 AM, rschmid89 &lt; >> >> >> >> > r.schmidpeter@ >> >> >> >> > &gt;wrote: >> >> > >> >> >> Sorry I forgot to say that I'm running xwiki on Tomcat 7 with MS >> SQL >> >> as >> >> >> database. >> >> >> >> >> >> In my xwiki.cfg the xwiki.store.migration=1, so it's set. I also >> tried >> >> >> setting xwiki.store.migration.R40000XWIKI6990.safemode=1, but >> there >> >> were >> >> >> no >> >> >> changes, so I've tried >> xwiki.store.migration.force=R40001XWIKI7540. >> >> But >> >> >> the >> >> >> only changes were, that I entered an empty xwiki and there the >> import >> >> of >> >> >> the >> >> >> enterprise-ui. xar made problems. >> >> >> >> >> >> http://pastebin.com/xdM0QZia (xwiki.cfg) >> >> >> >> >> >> >> >> >> >> >> >> Thomas Mortagne wrote >> >> >> >> com.xpn.xwiki.store.migration.MigrationRequiredException: >> Database >> >> >> xwiki >> >> >> >> needs migration(s), it could not be safely used! >> >> >> > >> >> >> > As far as I know this means you disabled migration and XWiki is >> >> >> > telling you that there is no wait it can continue without >> migrating >> >> >> > the database so you will need to enable it in xwiki.cfg >> >> >> > (xwiki.store.migration property). >> >> >> > >> >> >> > On Wed, Jan 16, 2013 at 2:43 PM, rschmid89 &lt; >> >> >> >> >> >> > r.schmidpeter@ >> >> >> >> >> >> > &gt; wrote: >> >> >> >> Hello, >> >> >> >> >> >> >> >> could someone please help me with the following error: >> >> >> >> >> >> >> >> 16.01.2013 12:36:11 >> org.apache.catalina.core.StandardWrapperValve >> >> >> invoke >> >> >> >> SCHWERWIEGEND: Servlet.service() for servlet [action] in >> context >> >> with >> >> >> >> path >> >> >> >> [/xwiki] threw exception [com.xpn.xwiki.XWikiException: Error >> >> number >> >> 3 >> >> >> in >> >> >> >> 0: >> >> >> >> Could not initialize main XWiki context >> >> >> >> Wrapped Exception: Error number 3202 in 3: Exception while >> reading >> >> >> >> document >> >> >> >> [xwiki:XWiki.TagClass] >> >> >> >> Wrapped Exception: Error number 3301 in 3: Exception while >> >> switching >> >> >> to >> >> >> >> database xwiki >> >> >> >> Wrapped Exception: Database xwiki needs migration(s), it could >> not >> >> be >> >> >> >> safely >> >> >> >> used!] with root cause >> >> >> >> com.xpn.xwiki.store.migration.MigrationRequiredException: >> Database >> >> >> xwiki >> >> >> >> needs migration(s), it could not be safely used! >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:442) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:678) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:853) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:785) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:749) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290) >> >> >> >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1404) >> >> >> >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1447) >> >> >> >> at >> >> >> com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:824) >> >> >> >> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:794) >> >> >> >> at com.xpn.xwiki.XWiki. >> >> >> > >> >> > >> > > <init> >> >> >> > (XWiki.java:735) >> >> >> >> at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:394) >> >> >> >> at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:483) >> >> >> >> at >> >> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) >> >> >> >> at >> >> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) >> >> >> >> 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:621) >> >> >> >> at >> >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:284) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:322) >> >> >> >> at >> >> >> >> >> >> >> >> >> >> org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1684) >> >> >> >> at >> >> >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >> >> >> >> Source) >> >> >> >> at >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >> >> >> >> Source) >> >> >> >> at java.lang.Thread.run(Unknown Source) >> >> >> >> >> >> >> >> I've tried everything I found so far, but nothing changed the >> >> outcome. >> >> >> >> >> >> >> >> With best regards >> >> >> >> >> >> >> >> Robert >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> View this message in context: >> >> >> >> >> >> >> >> >> >> http://xwiki.475771.n2.nabble.com/Failed-migration-from-3-0-to-4-3-1-tp7583… >> >> >> >> Sent from the XWiki- Users mailing list archive at Nabble.com. >> >> >> >> _______________________________________________ >> >> >> >> users mailing list >> >> >> >> >> >> >> >> >> >> > users@ >> >> >> >> >> >> >> >> >> > >> >> >> > >> >> >> > >> >> >> > -- >> >> >> > Thomas Mortagne >> >> >> > _______________________________________________ >> >> >> > users mailing list >> >> >> >> >> >> > users@ >> >> >> >> >> >> > http://lists.xwiki.org/mailman/listinfo/users >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> View this message in context: >> >> >> >> >> >> http://xwiki.475771.n2.nabble.com/Failed-migration-from-3-0-to-4-3-1-tp7583… >> >> >> Sent from the XWiki- Users mailing list archive at Nabble.com. >> >> >> _______________________________________________ >> >> >> users mailing list >> >> >> >> >> >> >> > users@ >> >> >> >> >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > Denis Gervalle >> >> > SOFTEC sa - CEO >> >> > eGuilde sarl - CTO >> >> > _______________________________________________ >> >> > users mailing list >> >> >> >> > users@ >> >> >> >> > http://lists.xwiki.org/mailman/listinfo/users >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> View this message in context: >> >> >> http://xwiki.475771.n2.nabble.com/Failed-migration-from-3-0-to-4-3-1-tp7583… >> >> Sent from the XWiki- Users mailing list archive at Nabble.com. >> >> _______________________________________________ >> >> users mailing list >> >> >> >> > users@ >> >> >> >> >> > >> > >> > >> > -- >> > Denis Gervalle >> > SOFTEC sa - CEO >> > eGuilde sarl - CTO >> > _______________________________________________ >> > users mailing list >> >> > users@ >> >> > http://lists.xwiki.org/mailman/listinfo/users >> >> >> >> >> >> -- >> View this message in context: >> http://xwiki.475771.n2.nabble.com/Failed-migration-from-3-0-to-4-3-1-tp7583… >> Sent from the XWiki- Users mailing list archive at Nabble.com. >> _______________________________________________ >> users mailing list >>

> users@

>> > > > > -- > Denis Gervalle > SOFTEC sa - CEO > eGuilde sarl - CTO > _______________________________________________ > users mailing list

> users@

> http://lists.xwiki.org/mailman/listinfo/users