RE: Big File Upload => MySQLContentStore and PacketTooBigException - SOLVED

[Stuart MacPherson <ap...@dsl.pipex.com>]

Hi Ingo

I just discovered the same solution (in a sun forum), and I amended the
max_allowed_packet entry in the my.ini file.  It worked fine for me, and has
solved my problem, but what I might add is that it only works if you set the
max size to WAY above the expected maximum FILE (yes, the whole thing!)
size... now this might seem a bit odd, and upload overheads alone cannot
account for this... but it works nonetheless.

Thanks for your solution.

Regards
Stuart


-----Original Message-----
From: Ingo Brunberg [mailto:ib@fiz-chemie.de] 
Sent: 21 August 2003 16:14
To: slide-user@jakarta.apache.org
Subject: Re: Big File Upload => MySQLContentStore and PacketTooBigException

I remember someone posted the same problem before. See here:

http://nagoya.apache.org/eyebrowse/ReadMsg?listName=slide-user@jakarta.apach
e.org&msgId=499972

You could try to increase the max_allowed_packet variable in MySQL,
but according to the above message that doesn't help either.

Perhaps you might try to tune other MySQL parameters.

Regards,
Ingo

> Hi
> 
> =20
> 
> I managed to sort out the problems I was having with Slide =
> inappropriately
> creating a collection instead of a file. it seems it does this when =
> there is
> a problem with the file handling process, and it doesn't get the full =
> file..
> 
> =20
> 
> Anyway.  I am getting another mysterious error when I try to upload a =
> large
> (ish) test file of around 1.53MB.
> 
> =20
> 
> It happily writes away with 2048 sized chunks, until it gets to 1537638 =
> (the
> end of the file) when it shows a 1646 sized chunk, and the DB instigates =
> a
> SQLException, inside which it says:
> 
> =20
> 
> =20
> 
> com.mysql.jdbc.PacketTooBigException
> 
> =20
> 
> =20
> 
> Why is it saying this at the last packet, which is smaller than all the
> rest?! =20
> 
> =20
> 
> Does anyone know what to do to sort this i.e. do I need to change a DB
> setting, or should I do something within Slide?
> 
> =20
> 
> Incidentally, the way my Servlet code handles it (for files this large) =
> is
> to write to a temporary area on the server, open an InputStream and then
> pass this to the WebdavResource.putMethod() for writing to Slide.  Is =
> this
> the best way. or is this in fact the root of my problems above?! =20
> 
> =20
> 
> Any suggestions?
> 
> =20
> 
> Many thanks
> 
> =20
> 
> Stuart


---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org