This is going to contain a lot of info, but I thought better to fully explain so I can get the help needed to fix these issues. I have a DNN Instance that was upgraded from 4.9.0 to 5.6.0... All sites sunction normally (with the exception of some not being able to access the HTML editor correctly - I have another thread on this).
My system admin has told me that the log file for this particular site is getting big fast... if he purges/truncates the log within a day it will grow to 1GB or more... Below are some of the more common errors that show up. They will happen every few seconds for minutes at a time.
How can I do to remendy these issues. I have no idea what these mean:
AssemblyVersion: 5.6.0
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: aca9e1db-71c6-498f-931b-4b7818ff466b
InnerException: Violation of UNIQUE KEY constraint 'IX_Dnn_SearchItemWord'. Cannot insert duplicate key in object 'dbo.Dnn_SearchItemWord'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace:
Message: System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_Dnn_SearchItemWord'. Cannot insert duplicate key in object 'dbo.Dnn_SearchItemWord'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddSearchItemWord(Int32 SearchItemId, Int32 SearchWordsID, Int32 Occurrences) at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 indexId, SearchItemInfo searchItem, String language) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)
Source:
Server Name: WEBSERV01
AssemblyVersion: 5.6.0
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 48f14c6c-278e-4a1a-9d8d-d196f144e34c
InnerException: Collection index must be in the range 1 to the size of the collection.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.VisualBasic.Collection.IndexCheck
StackTrace:
Message: System.IndexOutOfRangeException: Collection index must be in the range 1 to the size of the collection. at Microsoft.VisualBasic.Collection.IndexCheck(Int32 Index) at Microsoft.VisualBasic.Collection.get_Item(Int32 Index) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.ScheduleQueueContains(ScheduleItem objScheduleItem) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.AddToScheduleQueue(ScheduleHistoryItem objScheduleHistoryItem) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.WorkCompleted(SchedulerClient& objSchedulerClient)
Source:
Server Name: WEBSERV01
I also get a lof of these errors - the Type will change however they are all related tot eh scheduler:
THREAD ID: 81
TYPE: DotNetNuke.Services.Search.SearchEngineScheduler
EXCEPTION: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
RESCHEDULED FOR: 3/9/2011 5:11:35 PM
SOURCE: STARTED_FROM_BEGIN_REQUEST
ACTIVE THREADS: 0
FREE THREADS: 1
READER TIMEOUTS: 6516
WRITER TIMEOUTS: 6109
IN PROGRESS: 4
IN QUEUE: 9
Server Name: WEBSERV01
Below is a screen grab of the scheduler... does this look correct? Should I remove anything? Please let me know.
