Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Recurring error in event log: timeout period expired.Recurring error in event log: timeout period expired.
Previous
 
Next
New Post
2/6/2010 10:37 PM
 

Likewise, I'm running in the exact same error when upgrading from 4.x to 5.2.2:

System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The cause is not that server is slow, but that the connection between my (test) DNN instance and the SQL server host is slow. The timeout occurs in the .NET ExecuteQuery code (or similar). These calls normally wait X seconds for the server to process the request. The upgrade scripts are pretty heavy, especially across a slow network. The .NET classes have a property for the timeout. I don't know enough of the internals of DNN and how you can set it, but it would be great if the code could be improved for three things:

  1. Making the timeout maximum configurable (perhaps this is already possible?)
  2. Catching the timeout error as a specific error and either offer the option to the user to increase the timeout (good!) or retry with a larger timeout value.
  3. Stop de upgrade process when an error occurs: it's useless to upgrade the next step if the previous fails.

Maybe somebody knows a way to set this SQL Query timeout value?

or.

 
New Post
5/3/2010 7:24 PM
 
I am now recivieing this error too its on a shared server and none of my other installs are doing this. I have recently upgraded to 5.4.1 System.ApplicationException: This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4) at System.Threading.ReaderWriterLock.AcquireReaderLockInternal(Int32 millisecondsTimeout) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.get_ScheduleInProgress()
 
New Post
5/3/2010 7:57 PM
 

Dr Ocelot,

I started getting this error in my event viewer after upgrading from DNN 4.9.5 to DNN 5.2.3. I have another forum open but no solution. Some suggestions were to truncate the sitelog, schedulehistory, and eventlog tables which I did and have continued to do frequently but I still get the error. The memory being used on my webhead and my SQL server is fine (using about 1GB out of 2GB). One thing I have been noticing is that on my webhead my cpu is busy a lot and at times it spikes. Please let me know if you find a solution.

 

Thanks,


Matt

 
New Post
5/3/2010 10:29 PM
 

The circumstances of this timeout problem:

System.Threading.ReaderWriterLock.AcquireReaderLockInternal

Would lead me to believe it's possible there is a deadlock / locking thread issue.  What this is that a process is not releasing the Sql resources correctly, and is keeping a set of records in the database locked.  When the next thread comes alon and tries to read that set of records, it waits for the previous thread to complete and the lock to be released, which never happens,  thus it returns with a timeout.

I would search the log carefully and see if there are any other mentions of deadlocking or resource contention.  I would also see if you can reliably recreate the circumstances of the timeout (ie, is it at system startup, schedule running ,etc?) and monitor the Sql Server instance directly with a sp_who and sp_who2 command.  This will tell you the identifity and last-run Sql of locking/blocking threads, from which you could work backwards and identify where the problem is coming from.

If this is genuinely because of an upgrade to the DNN Version (rather than just finding it after doing an upgrade) then it's much more likely to be the introduction of new code (whether DNN core, or third party module) than just a Sql Server running out of space or memory.  Also, just because a Sql Server has enough memory doesn't mean it won't get timeouts.  All the memory in the world isn't going to help a poorly-constructed query.  Frequent Cpu spikes should be traced back to the process causing the spikes.  If it's the sql server process. then you've got a good chance of identifying the query(ies) causing the issue and tracing backwards.  Once you know the Sql that causes the problem, it's pretty easy to work backwards into the code to identify where it's going wrong.

 
New Post
5/23/2010 11:57 PM
 
Was there a solution to this problem?
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Recurring error in event log: timeout period expired.Recurring error in event log: timeout period expired.


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out