Hi. I'm troubleshooting a problem, and I would love some help understanding what is going on.
The problem is that Mongrel/Rails appears to hang or completely block if one of the users initiates a very slow, long-running query (via an ad-hoc report generation tool from within the app). For example, user A does a big query that takes minutes to complete. User B tries to do anything, but Rails seems completely dead. Should Rails be blocking on that query, effectively a single-user server? (I certainly wouldn't expect this...) Secondly, for what it's worth, I'm running a mongrel cluster, but that isn't helping right now. More info: "top" shows the host machine completely idle. development.log shows only user A's query SQL, but it does not show user B's request for a new page. When user A's query finally completes, then suddenly Rails comes back to life, and user B gets a response. This is a serious problem for me right now. It must be a configuration problem, because there's no way Rails is designed to behave this way...? Oh also, the database is hosted on another machine, and it's Oracle 9. Thanks! Michael --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
