Hi Everyone, I was trying to upgrade from 0.984 to 1.0B3, but to no avail. I found this thread: http://mail-archive.objectweb.org/xwiki-users/2006-12/msg00106.html But there are no answers there. If I just run 1.0B3 on the existing database, I get an exception (trace below). Somewhere i read that this could mean the database is corrupted. But I don't think so, it works fine with release 0.984. So, is there an official way to upgrade the database so I can keep all the articles ? Thanks, Lukas com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:223) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
Hi Lukas, teh stu said:
I was trying to upgrade from 0.984 to 1.0B3, but to no avail. I found this thread: http://mail-archive.objectweb.org/xwiki-users/2006-12/msg00106.html
up to now I couldn't figure out how the updating stuff works without and problems. I would be very interesting which RDBMS you are using. After having a look at DDL dumps of 0.9.840 and 1.0b3 the updating stuff of Hibernate seems "just" to be in trouble with referential integrity constraints (Ludovic is right). This would even explain why updates on MySQL are possible without any serious problems. Some MySQL database types are not able to do referential integrity. Best regards, Fabian.
Hi Fabian, I'm using MySQL 4.0.22 on Windows. Do you think it could help to try the new XWiki on a MySQL 5 server ? I didn't quite follow you about the referential integrity problems in dumps. Is it something than can perhaps be fixed manually or with a script? - Lukas Fabian Gorsler wrote:
Hi Lukas,
teh stu said:
I was trying to upgrade from 0.984 to 1.0B3, but to no avail. I found this thread: http://mail-archive.objectweb.org/xwiki-users/2006-12/msg00106.html
up to now I couldn't figure out how the updating stuff works without and problems. I would be very interesting which RDBMS you are using.
After having a look at DDL dumps of 0.9.840 and 1.0b3 the updating stuff of Hibernate seems "just" to be in trouble with referential integrity constraints (Ludovic is right). This would even explain why updates on MySQL are possible without any serious problems. Some MySQL database types are not able to do referential integrity.
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Hi Lukas, On Do, 2007-02-01 at 15:18 +0100, teh stu wrote:
I'm using MySQL 4.0.22 on Windows.
it seems you're usign InnoDB tables which handle references correctly. But I don't know much about MySQL. In fact the only thing I know about MySQL which is interesting in this situation, that only InnoDB serves referential integrity.
Do you think it could help to try the new XWiki on a MySQL 5 server ?
AFAIK the update works with MySQL 5, but I'm not sure. Until yesterday I did read much mails on this list.
I didn't quite follow you about the referential integrity problems in dumps. Is it something than can perhaps be fixed manually or with a script?
While the database layout from 0.9.840 is updated to the new layout of 1.0b3 there seem to be some data sets which are referenced in other tables and because of that the new layout can't be applied. Perhaps it is possible to do the update when those data sets are deleted, but I don't know whether these data sets are only of temporary interest (session stuff, locks, ...) or if they are needed permanently. If they are needed, deleting them would be harmful. Best regards, Fabian.
OK, thanks! Is there a chance that a developer will respond on this list? Or.. maybe you are, I don't know.. :) But it seems to me nobody knows how to do this properly. Do you know who might know? Thanks, - Lukas Fabian Gorsler wrote:
Hi Lukas,
On Do, 2007-02-01 at 15:18 +0100, teh stu wrote:
I'm using MySQL 4.0.22 on Windows.
it seems you're usign InnoDB tables which handle references correctly. But I don't know much about MySQL. In fact the only thing I know about MySQL which is interesting in this situation, that only InnoDB serves referential integrity.
Do you think it could help to try the new XWiki on a MySQL 5 server ?
AFAIK the update works with MySQL 5, but I'm not sure. Until yesterday I did read much mails on this list.
I didn't quite follow you about the referential integrity problems in dumps. Is it something than can perhaps be fixed manually or with a script?
While the database layout from 0.9.840 is updated to the new layout of 1.0b3 there seem to be some data sets which are referenced in other tables and because of that the new layout can't be applied.
Perhaps it is possible to do the update when those data sets are deleted, but I don't know whether these data sets are only of temporary interest (session stuff, locks, ...) or if they are needed permanently. If they are needed, deleting them would be harmful.
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Hi, The 4.0 version is not recommended (supported) anymore. Among other things, the hibernate version we use causes a deadlock, and character sets are not supported. I think this was specified somewhere on the wiki... However, the update should not be a problem. Please try to update using a newer version of mysql, and tell us if it works, so that we can update the installation instructions to emphasize this issue. Sergiu Dumitriu, developer. On 2/1/07, teh stu <[email protected]> wrote:
OK, thanks!
Is there a chance that a developer will respond on this list? Or.. maybe you are, I don't know.. :)
But it seems to me nobody knows how to do this properly. Do you know who might know?
Thanks, - Lukas
Fabian Gorsler wrote:
Hi Lukas,
On Do, 2007-02-01 at 15:18 +0100, teh stu wrote:
I'm using MySQL 4.0.22 on Windows.
it seems you're usign InnoDB tables which handle references correctly. But I don't know much about MySQL. In fact the only thing I know about MySQL which is interesting in this situation, that only InnoDB serves referential integrity.
Do you think it could help to try the new XWiki on a MySQL 5 server ?
AFAIK the update works with MySQL 5, but I'm not sure. Until yesterday I did read much mails on this list.
I didn't quite follow you about the referential integrity problems in dumps. Is it something than can perhaps be fixed manually or with a script?
While the database layout from 0.9.840 is updated to the new layout of 1.0b3 there seem to be some data sets which are referenced in other tables and because of that the new layout can't be applied.
Perhaps it is possible to do the update when those data sets are deleted, but I don't know whether these data sets are only of temporary interest (session stuff, locks, ...) or if they are needed permanently. If they are needed, deleting them would be harmful.
Best regards, Fabian.
------------------------------------------------------------------------
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- You receive this message as a subscriber of the [email protected] list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Hi Sergiu, I just did that, running on Tomcat 5.5 against a MySQL 5.0.21 server. I loaded the database dump from the old xwiki app. Unfortunately, still the same error, see below. Thanks for your response, - Lukas ----------------------------------------------------------------------- com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121) Sergiu Dumitriu wrote:
Hi,
The 4.0 version is not recommended (supported) anymore. Among other things, the hibernate version we use causes a deadlock, and character sets are not supported. I think this was specified somewhere on the wiki... However, the update should not be a problem. Please try to update using a newer version of mysql, and tell us if it works, so that we can update the installation instructions to emphasize this issue.
Sergiu Dumitriu, developer.
On 2/1/07, *teh stu* <[email protected] <mailto:[email protected]>> wrote:
OK, thanks!
Is there a chance that a developer will respond on this list? Or.. maybe you are, I don't know.. :)
But it seems to me nobody knows how to do this properly. Do you know who might know?
Thanks, - Lukas
Fabian Gorsler wrote: > Hi Lukas, > > On Do, 2007-02-01 at 15:18 +0100, teh stu wrote: >> I'm using MySQL 4.0.22 on Windows. > > it seems you're usign InnoDB tables which handle references correctly. > But I don't know much about MySQL. In fact the only thing I know about > MySQL which is interesting in this situation, that only InnoDB serves > referential integrity. > >> Do you think it could help to try the new XWiki on a MySQL 5 server ? > > AFAIK the update works with MySQL 5, but I'm not sure. Until yesterday I > did read much mails on this list. > >> I didn't quite follow you about the referential integrity problems in >> dumps. Is it something than can perhaps be fixed manually or with a script? > > While the database layout from 0.9.840 is updated to the new layout of > 1.0b3 there seem to be some data sets which are referenced in other > tables and because of that the new layout can't be applied. > > Perhaps it is possible to do the update when those data sets are > deleted, but I don't know whether these data sets are only of temporary > interest (session stuff, locks, ...) or if they are needed permanently. > If they are needed, deleting them would be harmful. > > Best regards, > Fabian. > > > ------------------------------------------------------------------------
> > > -- > You receive this message as a subscriber of the [email protected] <mailto:[email protected]> mailing list. > To unsubscribe: mailto: [email protected] <mailto:[email protected]> > For general help: mailto:[email protected] <mailto:[email protected]>?subject=help > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- You receive this message as a subscriber of the [email protected] <mailto:[email protected]> mailing list. To unsubscribe: mailto: [email protected] <mailto:[email protected]> For general help: mailto:[email protected] <mailto:[email protected]>?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
------------------------------------------------------------------------
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
participants (3)
-
Fabian Gorsler -
Sergiu Dumitriu -
teh stu