Long queries caused "Internal Server Error"

[leeyuiwah]

When I ran a long query (e.g. when it takes more than 10 minutes), the webpage on JasperServer would return an error of \"Internal Server Error\" (* full message below). There was no error on the server log. In fact, if I went into mysql and use \"show processlist\", I would see the query was still running. So, it appears that JasperServer decided to time out even the query was still go on. Is there a way that I can

1. increase the timeout value ?

2. return a meaningful error page to users (e.g. "the query took too long to execute") ?

3. and if JS decides to time out, shouldn't it also terminate the query? (the equivalent of "kill" in mysql client)

 

* Here is the full error message saw from a web browser

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
 

[lucianc]

Is that all that the error page shows?  Is there any stacktrace in the logs?

We need more information to determine what exactly happens to the query and where the exception comes from.

Regards,

Lucian