1 Oct
2010
1 Oct
'10
5:04 p.m.
Kelly Lakas wrote:
Hi -
I am using XWiki Enterprise 2.0-milestone-1.21570.
I am attaching files that are between 1-10 MB into the wiki, and when I
check it right after upload and attach, the file downloads properly.
However, later on, like the next day, I get an error when clicking on
the link "no template exist". I try to click the link again and the doc
downloads, but it is 0 bytes.
I did some searching through the mailing list archives, and saw a note
about increasing the max_packet_size in MySQL. Our default size is
16mb. Is there anything else we need to check or do to make sure the
attachments continue to exist properly? Beyond upgrading, that is.
This appears to be what is happening, the save fails but the cache hides the problem. The
cache
coherency issue should be fixed on the 2.5 branch.
When you save an attachment, the binary is placed in the database. For versioning the
attachment is
converted to base-64 and saved in an xml structure. Whenever you save a new revision of
the
attachment, the base-64 encoded size of the new revision is added to the size of the old
revision
making the size grow cumulatively if you take advantage of attachment version control.
The short answer is that for best safety, max_packet_size should be very large.
If you want to be alerted when attachments are not saving properly, you may query for
objects of
type XWikiAttachment, XWikiAttachmentContent and XWikiAttachmentArchive. for every value
of
XWikiAttachment.id there should be a matching XWikiAttachmentContent.id and
XWikiAttachmentArchive.id.
Caleb
Kelly
Kelly Lakas
Project Manager
next wave logistics inc.
28377 Davis Parkway, Suite 607A
Warrenville, IL 60555
________________________
[web] www.nwlinc.com <http://www.nwlinc.com/>
[office] 847.798.8897
[cell] 312.307.2079
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users