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 > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
