We recently moved one of our CF projects to Amazon Web Servers and have started to get the "500 internal server error". This happens regularly when we run a stored proc with does a lot of DB processing. It often takes more than 300 seconds. I've set all the CF timeouts to 300 secs so why don't I at least get a CF exception that I can handle?
This app previously ran on CF7 and it never produced the 500 error. If it timed out then we got a CF timeout that I could handle with code. But that was a local pair of VM servers. We also get this problem on our UAT environment which is local (a pair of VM servers in our building), so I shouldn't be blaming Amazon. This is a fairly new CF install. I had originally left the JVM heap and Garbage collection settings at default. Do they typically require modifications when installing on 64 bit systems? I've just changed the UAT server to JVM heap min & max of 1024MB but it hasn't helped. I have set production at 512 and 768. There's not a lot of CF processing going on. It just displays the query result in a table. And we rarely have more than 3 or 4 users at a time. But these errors are occuring when I know that I am the only user. So there's one stored proc being called and CF is just sitting there waiting. Often the error will occur, then I hit refresh and bang, the query result displays perfectly. Hmmm, that final cfloop to display the table is pretty big but it hasn't been a problem in the past. I have looked at all those JVM heap and GC settings in the past for an app that does have lots of users and does a lot of CF processing and it certainly helped but I really don't think that CF is the problem here. There just aren't that many users and not a lot of processing. Anyway, we're running out of ideas, I'll listen to anything to do with "500 internal server error" regards, Stephen -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.