1 Feb
2007
1 Feb
'07
2:33 p.m.
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)
1 Feb
1 Feb
3:11 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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.
3:18 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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 xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
3:56 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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.
4:19 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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 xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws 
4:54 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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 <stukas14(a)gmx.net> 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:
--
http://purl.org/net/sergiu
Hi Lukas,
On Do, 2007-02-01 at 15:18 +0100, teh stu wrote:
script?
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
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
xwiki-users(a)objectweb.org mailing
list.
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.orgmailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
5:43 p.m.
New subject: [xwiki-users] upgrade from 0.984 to 1.0B3
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* <stukas14(a)gmx.net <mailto:stukas14@gmx.net>> 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:
correctly.
I'm using MySQL 4.0.22 on Windows.
it seems you're usign InnoDB tables which handle references 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
xwiki-users(a)objectweb.org
<mailto:xwiki-users@objectweb.org> mailing
list.
To unsubscribe: mailto:
xwiki-users-unsubscribe(a)objectweb.org
<mailto:xwiki-users-unsubscribe@objectweb.org>
For general help: mailto:sympa@objectweb.org
<mailto:sympa@objectweb.org>?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws
--
You receive this message as a subscriber of the
xwiki-users(a)objectweb.org <mailto:xwiki-users@objectweb.org> mailing
list.
To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org
<mailto:xwiki-users-unsubscribe@objectweb.org>
For general help: mailto:sympa@objectweb.org
<mailto:sympa@objectweb.org>?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
http://purl.org/net/sergiu
------------------------------------------------------------------------
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
6490
days inactive
6490
days old
6 comments
3 participants
participants (3)
-
Fabian Gorsler -
Sergiu Dumitriu -
teh stu