AW: [opencms-dev] Publishing large files

[Nick Panienski]

Okay, we found the problem.
If you upload a file that is larger than the max_allowed_packet OpenCMS will
launch the upload dialogue and finish without any complaint. The file is
visible in the explorer view and everything seems to be fine.
BUT when you read your opencms.log you see the following:

25 Apr 2005 15:38:59,815 ERROR [org.opencms.db.CmsSqlException:  64]
org.opencms.db.CmsSqlException: [org.opencms.db.mysql.CmsVfsDriver] where:
org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:146),
why: com.mysql.jdbc.PacketTooBigException: Packet for query is too large
(1433042 > 1048576). You can change this value on the server by setting the
max_allowed_packet' variable.query:
com.mysql.jdbc.PreparedStatement at 1ed54a0: INSERT INTO CMS_OFFLINE_CONTENTS
(CONTENT_ID,RESOURCE_ID,FILE_CONTENT) VALUES
('c2d94c8a-b597-11d9-ac06-a1ed3a60732f','c2d7c5e9-b597-11d9-ac06-a1ed3a60732
f',** STREAM DATA **)
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1433042
> 1048576). You can change this value on the server by setting the
max_allowed_packet' variable.

You should change this behaviour in later versions...

Bye
Nick

> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-
> bounces at opencms.org] Im Auftrag von Nick Panienski
> Gesendet: Montag, 25. April 2005 16:36
> An: 'The OpenCms mailing list'
> Betreff: AW: [opencms-dev] Publishing large files
> 
> Sounds promising, but how comes I can upload large files via the
> Download-Gallery but not export or publish?!
> I set the max_allowed_packet to 8MB, but still the export or publish
> crashes
> with the following error message:
> 
> Error publishing file /sites/master/gallery/download/3mbfile.pdf
> Exception org.opencms.file.CmsVfsResourceNotFoundException:
> [org.opencms.db.mysql.CmsVfsDriver.readFile]
> 8139f81c-b593-11d9-b2d6-0db545bdc524 [Code 2 - Resource not found!]
> at org.opencms.db.generic.CmsVfsDriver.readFile(CmsVfsDriver.java:963)
> at
> org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDrive
> r.
> java:1035)
> at
> org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:
> 92
> 1)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.ja
> va
> :1368)
> at
> org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:4665)
> at
> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java:2
> 53
> 9)
> at org.opencms.file.CmsObject.publishProject(CmsObject.java:1889)
> at org.opencms.threads.CmsPublishThread.run(CmsPublishThread.java:82)
> 
> 
> > -----Ursprüngliche Nachricht-----
> > Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-
> > bounces at opencms.org] Im Auftrag von Tim Howland
> > Gesendet: Montag, 25. April 2005 12:50
> > An: The OpenCms mailing list
> > Betreff: RE: [opencms-dev] Publishing large files
> >
> > Check your max_allowed_packet size in mysql - (show variables like
> > max%). 1MB is the default size.
> >
> > HTH,
> >
> > Tim
> >
> > -----Original Message-----
> > From: Nick Panienski [mailto:panienski at codecentric.de]
> > Sent: Monday, April 25, 2005 6:04 AM
> > To: 'The OpenCms mailing list'
> > Subject: [opencms-dev] Publishing large files
> >
> > Hello,
> >
> > I have a problem publishing 'large' files (think I read somthing like
> > this before, but I cannot remember...).
> >
> > I tried to publish a site (OpenCMS 6b1, MySQL 4, Win) with a Download
> > Gallery containing PDFs. All PDFs which where larger than 1 MB (approx)
> > caused the publish process to crash. (I think it was a VFS File not
> > Found exception - not sure, it happend at a customers premises last
> > Friday ...).
> >
> > Anyone experienced a similar behaviour?!
> >
> > Bye
> > Nick
> >
> >
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list To change
> > your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> >
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
> visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev