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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Frederick Cheung
2008-Apr-24 16:38 UTC
Re: System exit by fcgi during multiple database transactions
On 24 Apr 2008, at 17:30, peterbe wrote:> > 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?We used to have fastcgi listeners dieing randomly every now and again. In the end we switched away from fast cgi :-) Fred --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---