Hi, As Arnaud said, Xwiki use "text" data type in MySQL table but "varchar(20000)" in Postgres. Postgres also has the "text" data type withour size limitation. Should we change the data type rather than simply change the size limitation? What do you think? Many thanks. On 3/5/07, Arnaud Thimel <[email protected]> wrote:
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
-- 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