Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Timeout Issues

web-app

For some time now we've been having timeout issues when loading pages that contain more data. (projects with lots of issues, etc). I'm pretty sure the issue has been there since the beginning. but because we've only recently begun actively using Gemini.. the problem has come to light.

The errors we get are as follows: When clicking on a 'large' project.. the browser starts to load for about 20 seconds and then gives out a gemini error. The gemini log shows the following:

 

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 22/03/2010 14:46:31 at CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) at CounterSoft.Gemini.Web.Project.ProjectHome.SelectTab() at CounterSoft.Gemini.Web.Project.ProjectHome.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) .Net SqlClient Data Provider

 

I've monitored both the webserver and the database server. and neither seem to be under any considerable load. They have enough resources available (memory, cpu and bandwidth).

I have no idea what is causing this. If anyone has any pointers they'd be more than welcome.

Gemini version 3.1.2

Bakker
· 1
Bakker
Replies (2)
helpful
0
not helpful

This might be a database fragmentation issue.

Try reindex the gemini_issues table or at least update statistics on it.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hello SaarCohen,

The fix you suggested coupled with moving the database to an instance on the web server seemed to have done the trick.

Thank you for your quick support.


Bakker
· 1
Bakker