Vincent Massol wrote:
What needs to be documented is the PostGre SQL steps for installing XWiki with PostGre SQL... I don't think this has anything to do with XAR. It was simply that your installation wasn't correct. Errors could have happened in several places bcause of the xwd_archive size issue. Hi Vincent,
I'm not sure that the problem comes from the installation. I got the same problem a few days ago but didn't have enough time to post about it. I'm also using XWiki under Postgre. I created a blank Postgre database, exported an XAR from a standalone XWiki (/HSQL), tried to import it in my newly created database and got the same error than Xin. To fix it, I increased the size in the XWiki Hibernate mapping, and tried again. Import was OK. Now I sent a request to my database : xwiki-gds=# SELECT char_length(xwd_class_xml) from xwikidoc where xwd_fullname='XWiki.XWikiPreferences'; char_length ------------- 23071 (1 ligne) I did exactly the same operation with MySQL and didn't need to modify the Hibernate mapping. If you detail the column type under MySQL and Postgres, you get different information : MySQL : | XWD_CLASS_XML | text | YES | | NULL | | Postgres : xwd_class_xml | character varying(20000) | Size limitation isn't visible on MySQL which could explain why import didn't produce any error. So I think it would be better to increase the limitation under Hibernate rathet than under PostgreSQL. Regards, Arnaud.
Thanks -Vincent
On 3/5/07, Vincent Massol <[email protected]> wrote:
On Mar 5, 2007, at 10:30 AM, xin wu wrote:
Hi,
Thanks to all of you. The errors are due to limitation of the xml doc table (I just do what Paul said: change the limitation of xwd_class_xml in xml doc table from 20000 to 200000, I also change xwd_archive from 200000 to 2000000). Then the installation seemed OK except that preference page is locked by XWikiGuest(You can just edit it by force). I think it will be better to mention the size limitation in the guide.
Yes that's a good idea. Can you do it?
Thanks -Vincent
Many thanks again.
On 3/5/07, Sergiu Dumitriu <[email protected]> wrote:
On 3/5/07, Vincent Massol <[email protected]> wrote:
On Mar 5, 2007, at 8:46 AM, Sergiu Dumitriu wrote:
I don't think it's related to XWIKI-530, since the import works
for most pages, except the specified 2.
Indeed, importing the XWikiPreferences page causes an error. The
page is deleted, but not imported back.
Sergiu, is this a regression? I've never had this problem with the
XWikiPreferences page. Do we have a jira for it? Is it fixed in Beta 5?
Here's the error I got (yesterday, so b5 doesn't fix it):
13:27:30,130 [TP-Processor6] WARN util.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000 13:27:30,132 [TP-Processor6] ERROR util.JDBCExceptionReporter - Duplicate entry '-944455444-tags' for key 1 13:27:30,133 [TP-Processor6] ERROR .AbstractFlushingEventListener - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException : could not insert: [com.xpn.xwiki.objects.IntegerProperty] at org.hibernate.exception.SQLStateConverter.convert (SQLStateConverter.java:69)
So it's a duplicate key issue.
-- You receive this message as a subscriber of the xwiki- [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
--
Best regards, Xin
-- You receive this message as a subscriber of the xwiki- [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] 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
--
Best regards, Xin
-- 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
-- Arnaud Thimel Société Code Lutin - http://www.codelutin.com