My Rails app allows file uploads in several places. Most of the time the
files are pretty small (under 1MB) and we never have any trouble.
There is one section where the files are a bit larger, about (10-15MB).
This
section uses the same code as other places and works with small files.
It breaks with larger files… This is what happens on both server
(FCGI/Apache) and local (WebBrick):
Upload the file and click ‘Submit’. The gears turn, looks fine… Then
it
just chugs along, forever. Nothing happens, it just sits there. Apache
will
go forever, WebBrick eventually dies with an error that it can’t find
the
action (strange error).
So, does anyone have any suggestions (other than ‘don’t use HTTP for
uploads
of this size’). I realize that FTP and other solutions are better for
large
files but in my opinion this file isn’t all that large and I’m pretty
sure
that other folks have accomplished this… Strongspace is a Rails app
and I
believe handles this situation.
If you’re using MySQL the default max_allowed_packet size is set to 1M,
meaning that
you cannot transfer/receive records larger than 1 megabyte. Resetting
this
in the my.ini file to something like 8M and restarting the db may fix
your problem.
I’m actually not on MySQL, we’re on Postgres… But these files are
being
stored in the filesystem, not the database so I don’t think that’s
coming
into play.