El dia dj 17 gen 2013 17:24:19 CET, Denis Gervalle va escriure:
Àlex,
This is definitely an unexpected issue, but not an issue from the
migration. It is however difficult to know which version has introduce
it, and if the issue is still in the latest one. I would bet it isn't.
Maybe, the best way to get around that issue, would be to rename the
first document, so you will get access to the second one, and be able
to rename it as well. Later you may rename the first one back.
If you start hacking the database, you risk to introduce some
inconsistencies, so I do not recommend that. For example, your
proposed delete statements does not take care of objects, if any are
attached with the document.
Regards,
On Thu, Jan 17, 2013 at 5:10 PM, Àlex Magaz Graça
<[email protected] <mailto:[email protected]>> wrote:
Al 17/01/13 10:19, En/na Denis Gervalle ha escrit:
Hi Àlex,
Sorry for this late reply.
I need a larger extract of your logs to be able to help and
probably more
later. You may send it to me privately if you prefer.
Regards,
On Tue, Jan 8, 2013 <tel:2013> at 12:19 PM, Àlex Magaz Graça
<[email protected] <mailto:[email protected]>>__wrote:
Hi,
I'm trying to upgrade from XWiki 3.1 to 4.4, but I'm
having problems with
the data migration process.
It all goes well up until R40000XWIKI6990, which fails due
to a duplicate
key (see below, full Tomcat log also attached). It also
fails with safemode
enabled.
ERROR o.h.u.JDBCExceptionReporter - ERROR: duplicate
key value violates
unique constraint "xwikidoc_pkey"
I've tried running SQL commands from XWIKI-8129 <tel:8129>
[1] jira issue too, but
it doesn't apply any modification in my case. So it
doesn't make any
difference.
Older version of XWiki in-between also fail.
The system set up is:
Fedora 14 (x86_64)
Java 1.6.0_20 -- OpenJDK Runtime Environment (IcedTea6 1.9.10)
Tomcat 6
PostgreSQL 8.4.9
XWiki 3.1 (upgraded from 2.2.1 and with no configuration
options changes)
Any idea of how to solve this problem?
Thanks,
Àlex
[1] http://jira.xwiki.org/browse/*__*XWIKI-8129
<http://jira.xwiki.org/browse/**XWIKI-8129><http://jira.xwiki.__org/browse/XWIKI-8129
<http://jira.xwiki.org/browse/XWIKI-8129>>
Hi Denis,
I finally got it solved yesterday. I was able to find the database
record that made the migration process fail by rising the log
level to debug. I'll explain in case someone else finds a similar
problem.
The problem was a wiki page that somehow got duplicated or created
twice, but with a slightly different name. Moreover, although the
two database records had different document ids, the id migration
process assigned the same final id for both of them. The records
look like this in the database:
xwd_id | xwd_fullname | xwd_name |
xwd_title |
----------+-------------------__-----------------------+------__----+-------------------------__-----------+
292584123 <tel:292584123> | Main.Cursos per a professorat
2011.2012 <tel:2011.2012> | 2012 <tel:2012> | Cursos per a
professorat 2011/2012 <tel:2011%2F2012> |
971984561 | Main\.Cursos per a professorat 2011.2012
<tel:2011.2012> | 2012 <tel:2012> | Cursos per a professorat
2011/2012 <tel:2011%2F2012> |
xwd_date | xwd_content_update_date |
xwd_creation_date | xwd_author | xwd_content_author
---------------------+--------__-----------------+------------__---------+---------------+----__----------------+
2011-10-25 20:30:10 | 2011-10-25 20:30:10 | 2011-08-26
13:30:42 | XWiki.user1 | XWiki.user1
2012-11-12 11:25:30 | 2012-11-12 11:25:30 | 2011-12-13
15:41:49 | XWiki.user2 | XWiki.user2
xwd_creator | xwd_web | xwd_version
| xwd_parent
----------------+-------------__-----------------------+------__-------+-------------
XWiki.user2 | Main.Cursos per a professorat 2011 <tel:2011> |
146.1 | Main.BETSEA
XWiki.user1 | Main.Cursos per a professorat 2011 <tel:2011> |
22.1 | Main.BETSEA
The rest of the fields either have the same values or are empty.
As can be seen in xwd_fullname, it looks like the dot on the page
name might have confused XWiki. In fact, if get to the page from
the web interface, the name of the page is "2012 <tel:2012>". It
is as if XWiki had split the name at the "." and had taken the
previous string as the space name. The URL looks like this:
http://intranet-sbd.udl.cat/__xwiki/bin/view/Main.Cursos+__per+a+professorat+2011/2012
<http://intranet-sbd.udl.cat/xwiki/bin/view/Main.Cursos+per+a+professorat+2011/2012>
and in the toolbar the following appears:
SPACE: Main.Cursos per a professorat 2011 <tel:2011>
PAGE: 2012 <tel:2012>
This is for the first record in the database. I couldn't access
the second one from the web interface.
By deleting the page corresponding to the first record, the
migration process finishes without problems. Now I'd like to
instead remove the references to the second page from the
database. Would it be enough to remove the entries with the
following commands?
delete FROM xwikidoc where xwd_id=292584123 <tel:292584123>;
delete FROM xwikiattachment where xwa_doc_id=292584123
<tel:292584123>;
delete FROM xwikilinks where xwl_doc_id=292584123 <tel:292584123>;
delete FROM xwikircs where xwr_docid=292584123 <tel:292584123>;
If you think this might be a bug that should be solved, I still
can send the logs or provide any information needed.
Thanks,
Àlex
--
Denis Gervalle
SOFTEC sa - CEO
eGuilde sarl - CTO
Hi Denis,
I finally managed to fix the problem by renaming the document as you
suggested.
Thanks,
Àlex
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
