6 Mar
2007
6 Mar
'07
1:33 a.m.
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 <thimel(a)codelutin.com> wrote:
Vincent Massol wrote:
--
Best regards,
Xin
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
--
Arnaud Thimel
Société Code Lutin - http://www.codelutin.com
--
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
On 3/5/07, Vincent Massol <vincent(a)massol.net> 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 <sergiu.dumitriu(a)gmail.com> wrote:
>>
>> On 3/5/07, Vincent Massol <vincent(a)massol.net> 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.
>>
>>
>> --
>> 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
>>
>>
>
>
> --
>
>
> Best regards,
> Xin
>
>
> --
> 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.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
--
Best regards,
Xin
--
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