System exit by fcgi during multiple database transactions

I have a RoR application where user can upload a CSV; each row has
fields which
are written to several dbase tables.

My problem is with large CSVs which require several thousand inserts.

Under WebBrick, the operation completes without error.

Under fcgi, the fcgi issues a System:exit at seemingly random points
(not associated
with any particular database operation). If I reduce the size of the
CSV, it completes
without error.

All my database operations use SQL so there is no object
instantiation. I did this
thinking that memory might be the issue.

Has anyone seen this before? How did you fix the problem?

Thanks in advance,
Peter

On 24 Apr 2008, at 17:30, peterbe wrote:

(not associated
with any particular database operation). If I reduce the size of the
CSV, it completes
without error.

All my database operations use SQL so there is no object
instantiation. I did this
thinking that memory might be the issue.

Has anyone seen this before? How did you fix the problem?

We used to have fastcgi listeners dieing randomly every now and again.
In the end we switched away from fast cgi :slight_smile:

Fred

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs