System exit by fcgi during multiple database transactions

rubyonrails-talk
1

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

2

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

Fred