I apologize if this has been covered before, I checked the archives and didn''t see anything over the last few months. I am running IIS6 with IsapiRewriter and a single mongrel service for each Rails application. One of my apps does a long query to the database to produce a CSV file. After the request has gone beyond 30 seconds, the user get a 500 Internal Server Error. I''ve looked around for ways to adjust the response timeout, either in IIS or mongrel, but haven''t found anything yet. Any ideas? -- -- Jay Turpin "One test is worth a thousand expert opinions." - Bill Nye (The Science Guy) -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/mongrel-users/attachments/20060819/92bcc485/attachment.html
For long running tasks, you should look into Ezra''s BackgrounDRb: http://brainspl.at/articles/2006/07/02/backgroundrb-updated =Will Jay Turpin wrote:> I apologize if this has been covered before, I checked the archives > and didn''t see anything over the last few months. > > I am running IIS6 with IsapiRewriter and a single mongrel service for > each Rails application. One of my apps does a long query to the > database to produce a CSV file. After the request has gone beyond 30 > seconds, the user get a 500 Internal Server Error. > > I''ve looked around for ways to adjust the response timeout, either in > IIS or mongrel, but haven''t found anything yet. Any ideas? > > -- > -- Jay Turpin > "One test is worth a thousand expert opinions." - Bill Nye (The > Science Guy) > >------------------------------------------------------------------------ > >_______________________________________________ >Mongrel-users mailing list >Mongrel-users at rubyforge.org >http://rubyforge.org/mailman/listinfo/mongrel-users >
Are you using SQL Server? I think the connection times-out after 30s, so you''re probably seeing a SQL Timeout error. On 8/19/06, Jay Turpin <jay.turpin at gmail.com> wrote:> I apologize if this has been covered before, I checked the archives and > didn''t see anything over the last few months. > > I am running IIS6 with IsapiRewriter and a single mongrel service for each > Rails application. One of my apps does a long query to the database to > produce a CSV file. After the request has gone beyond 30 seconds, the user > get a 500 Internal Server Error. > > I''ve looked around for ways to adjust the response timeout, either in IIS or > mongrel, but haven''t found anything yet. Any ideas? > > -- > -- Jay Turpin > "One test is worth a thousand expert opinions." - Bill Nye (The Science Guy) > > _______________________________________________ > Mongrel-users mailing list > Mongrel-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/mongrel-users > >
I think the timeouts were occurring becasue of a combination of IsapiRewriter being configured incorrectly and security settings on the files prompting users for login/passwords. Once I got both of those things straighted out, everything is working great! Thanks for the advice! -- -- Jay Turpin "One test is worth a thousand expert opinions." - Bill Nye (The Science Guy) On 8/22/06, Ed C. <defeated2k4 at gmail.com> wrote:> > Are you using SQL Server? I think the connection times-out after 30s, > so you''re probably seeing a SQL Timeout error. > > On 8/19/06, Jay Turpin <jay.turpin at gmail.com> wrote: > > I apologize if this has been covered before, I checked the archives and > > didn''t see anything over the last few months. > > > > I am running IIS6 with IsapiRewriter and a single mongrel service for > each > > Rails application. One of my apps does a long query to the database to > > produce a CSV file. After the request has gone beyond 30 seconds, the > user > > get a 500 Internal Server Error. > > > > I''ve looked around for ways to adjust the response timeout, either in > IIS or > > mongrel, but haven''t found anything yet. Any ideas? > > > > -- > > -- Jay Turpin > > "One test is worth a thousand expert opinions." - Bill Nye (The Science > Guy) > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/mongrel-users/attachments/20060822/6c636624/attachment.html