I get hundreds of errors like this one in my event log and it seems to be related to AF. Is this a known issue and are there any solutions?


[...]
ModuleControlSource: DesktopModules/ActiveForums/ActiveForums.ascx
[...]
InnerException: Transaction (Process ID 62) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[...]

This is not a known issue, but we need the full error message to troubleshoot further.

Here's an example of a full error message ():

ModuleId: 371
ModuleDefId: 125
FriendlyName: Forum
ModuleControlSource: DesktopModules/ActiveForums/ActiveForums.ascx
AssemblyVersion: 5.6.1
PortalID: 0
PortalName: Lav-Det-Selv.dk
UserID: -1
UserName:
ActiveTabID: 54
ActiveTabName: Forum
RawURL: /Forum/aft/127019
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.google.dk/url?sa=t&sourc...h4b6KAMXRw
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MAAU; .NET4.0C; InfoPath.2)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 93f96224-8599-4f43-834c-a91c7ba02bd0
InnerException: Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Forums.SqlDataProvider.UI_TopicView(Int32 PortalId, Int32 ModuleId, Int32 ForumId, Int32 TopicId, Int32 UserId, Int32 PageIndex, Int32 PageSize, Boolean IsSuper, String Sort) at Active.Modules.Forums.Controls.TopicView.LoadData(Int32 PageId) at Active.Modules.Forums.Controls.TopicView.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: BART

Will, had a chance to look at this error message?

Thanks

Will, please respond to this.

Thanks a lot.

Will, please respond to this. I know your busy, but this is a major issue for me.

The error occurs in the event log multiple times per minute. Every single error represents a user not being able to access the forum. Google Webmaster Tool show that my website performance is significantly affected by this: Avg. page load increased from 4 sec. to 6 sec.

Allan,
I just clicked on the link the error you posted. The site loaded just find and very quick. Usually when we see errors like the one you posted above it means something is going on with the database. This could be anything from a database backup to an auto grow of the database or log file. It could also be related to performance related to a bot indexing your site.

I know that the errors are not consistent / occurs every time you visit the forum. But with 14.000 visits per day + Google-bots, errors with even a small percentage of every page loading is quite a big problem.

I've been checking SQL Server, and found nothing alarming. The DB size is 1.4 GB and set to autogrow by 1 mb unrestricted. The errors occur all the time (24/7) and is thus not related to a backup. The site is running on a dedicated server (2 x 6-core processors, 16 GB RAM, SAS harddrive etc) so I'm pretty sure that this has nothing to do with the server being over loaded.

When googling the "deadlock"-error message, you get a lot of advice on analysing and tracing the SQLs and how to minimize deadlocks when writing software. I don't know what I can do to solve this on my own.

Nothing else (other modules) on my site causes this error, only AF. Will, are you sure that this is a server issue? If so, could you please help me in the right direction (how to debug)?

Thanks.

I think I solved it! I rebuild the index mentioned in the deadlock graph and it's been 3 hours since the last "Module Load Exception" occured in the event log.

Does it sound right, Will, that this could be caused by a index needed to be rebuild?

I'm crossing my fingers

[Crying like a baby]

The error is back. 4 hours with no problems and it's back again. Same deadlock

Will, I hope you can help me to stop crying...

I still have this problem. Could you PLEASE take a look at it, Will?!?

Multiple errors EVERY minut causing new forum posts to fail being posted, meaing lost as they are not saved in the database. Every entry in the log equals a user getting an error, which is not acceptable.

Bump....

Will?...Ben?

I still get this error all the time: Today every 2 seconds. I have no idea what to do. I've consulted with a developer who tried to debug this issue and everything points to Active Forums.

Please look into this and let me know if you can/will help me or not.