Can anyone help try to figure out why this erro might occur?

The error occurs on my development machine (Windows 2003 SP2). The page the error occurs on contains I custom module I am developing and a HTML Content module. I am running client side javascript when the error occurs.

My Custom Module is going to be a gallery. At the moment I am focused on layout. I have not yet added any calls to the database. So far I have stubbed out the code using CodeSmith, developed the setup and copied in some example code based on this example: http://www.twospy.com/galleriffic/example-5.html

So it is using javascript. The page runs OK, but after click next a couple dozen times I get the error.

The last time I updated from SVN was just after the last patch.

Message:  An unhandled exception occurred and the process was terminated.

Exception: System.Data.SqlClient.SqlException

Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Call stack

> mojoPortal.Data.DLL!mojoPortal.Data.SqlHelper.ExecuteReader(string connectionString = "Integrated Security=true;Initial Catalog=mojo01;Data Source=(local);server=(local);database=mojo01", System.Data.CommandType commandType = StoredProcedure, string commandText = "mp_TaskQueue_SelectIncomplete", System.Data.SqlClient.SqlParameter[] commandParameters = null) Line 133 C#
mojoPortal.Data.DLL!mojoPortal.Data.DBTaskQueue.GetUnfinished() Line 348 + 0x1d bytes C#
mojoPortal.Business.DLL!mojoPortal.Business.TaskQueue.GetUnfinished() Line 457 + 0x5 bytes C#
mojoPortal.Web.DLL!mojoPortal.Web.WebTaskManager.RunTask() Line 263 + 0xb bytes C#
mojoPortal.Web.DLL!mojoPortal.Web.WebTaskManager.RunTaskOnNewThread(object oTask = {mojoPortal.Web.WebTaskManager}) Line 245 + 0xa bytes C#
 

Thanks,

Leah

Hi Joe,

Thanks for the idea but it says no tasks are running. Can I turn it off if I don't need to use it?

I was wondering if my javascript might be clashing with something? Like could I be clashing with a namespace somewhere.

The jquery component was using an id that mojoportal uses in its HTML. I have changed that and can look for others.

Cheers,
Leah

Hi Joe,

Fixed (ish)!

After more testing I found that the problem occurs only in Firefox and only when firebug is enabled. So I think there is some clash with the javascript.

Running running Exec mp_TaskQueue_SelectIncomplete showed only:
       App Keep Alive Task
       WebTaskManager

Other database queries were working so hadn't thought that the database connection might be an issue. I will change to use a sql user to connect to the database.

It seems to me that the error was occuring because my environment had grown unstable after getting a few exceptions during custom module development. Making the Timeout exception one of those errors that is not directly connected to the cause. I will keep an eye on it.

Thanks again for your help.

Cheers,
Leah