Hi,
We are using DNN6.02.03 professional and running around 30 portals. We experienced some issues regarding to the search module which comes with the DNN installation. Some of our sites can perform the search and list out all the results. But some of the sites receive no search result. I think it may be caused by adding and modifying the site alias in Site management. And Search Crawler did not reflect the change. We found an error in the Search Crawler Scheduler history.
Lock file already present. It appears that another instance of crawler is running. Skipping...If this message persists, please delete file manually: E:\Websites\dotnetNuke\Website\DesktopModules\DNNCorp\SearchCrawler\Input\index\Mywebsite\write.lock
We research on this issue and possible the search index was corrupted. Then we executed the following script on the database. Then we re-index the content in Search Admin section.
Truncate table SearchItemWordPosition
DELETE SearchItemWord
DELETE SearchWord
DELETE SearchItem
The re-indexing ran for 2 hours and stopped. I imagine that is session expired. Now I want to view the search crawler schedule history and experienced a memory leak. The portal suddenly consumes 4GB of memory when we view the history. Then the error message was shown on as follow:
1. A critical error has occurred. Error serializing value 'StartDate' of type 'System.String.'
2. A critical error has occurred. Error serializing value 'SearchCrawler - Start Indexing of Site http://mywebsite/ <br/>0 http://mywebsite/ <br/>SearchCrawler - An error occurred while downloading the previous URI: The remote name could not be resolved: 'mywebsite' SearchCrawler - Index Exists <br/>SearchCrawler - Index Copied <br/>Lock file already present. It appears that another instance of crawler is running. Skipping...If this message persists, please delete file manually: E:\Websites\dotnetNuke\Website\DesktopModules\DNNCorp\SearchCrawler\Input\index\mywebsite\write.lock <br/>SearchCrawler - Start Indexing of Site http://teams.com <br/>0 http://teams.com/ <br/>SearchCrawler - An error occurred while downloading the previous URI: The remote name could not be resolved: 'teams.com'SearchCrawler - Index Exists <br/>SearchCrawler - Index Copied <br/>Lock file already present. It appears that another instance of crawler is running. Skipping...If this message persists, please ...' of type 'System.String.'
In the pop up content area
Server Error in '/' Application.
Request timed out.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Request timed out.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[HttpException (0x80004005): Request timed out.]
|
EventLog:
<LogProperties>
<LogProperty>
<PropertyName>AssemblyVersion</PropertyName>
<PropertyValue>6.2.3</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>PortalID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>PortalName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>UserID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>UserName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>ActiveTabID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>ActiveTabName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>RawURL</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>AbsoluteURL</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>AbsoluteURLReferrer</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>UserAgent</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>DefaultDataProvider</PropertyName>
<PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>ExceptionGUID</PropertyName>
<PropertyValue>8117f414-bc97-4147-a217-b2e0c069a127</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>InnerException</PropertyName>
<PropertyValue>Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>FileName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>FileLineNumber</PropertyName>
<PropertyValue>0</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>FileColumnNumber</PropertyName>
<PropertyValue>0</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>Method</PropertyName>
<PropertyValue>System.Data.SqlClient.SqlConnection. </PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>StackTrace</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>Message</PropertyName>
<PropertyValue>
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.
The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection. (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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Services.Scheduling.DNNScheduling.SqlDataProvider.AddScheduleHistory(Int32 ScheduleID, DateTime StartDate, String Server)
at DotNetNuke.Services.Scheduling.DNNScheduling.SchedulingController.AddScheduleHistory(ScheduleHistoryItem objScheduleHistoryItem)
at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.AddScheduleHistory(ScheduleHistoryItem scheduleHistoryItem)
</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>Source</PropertyName>
<PropertyValue />
</LogProperty>
</LogProperties>
================================================================================================================
<LogProperties>
<LogProperty>
<PropertyName>AssemblyVersion</PropertyName>
<PropertyValue>6.2.3</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>PortalID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>PortalName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>UserID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>UserName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>ActiveTabID</PropertyName>
<PropertyValue>-1</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>ActiveTabName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>RawURL</PropertyName>
<PropertyValue>/images/logo33.gif</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>AbsoluteURL</PropertyName>
<PropertyValue>/default.aspx</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>AbsoluteURLReferrer</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>UserAgent</PropertyName>
<PropertyValue>Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; BTRS120924; GTB7.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; ShopperReports 3.0.485.0; SRS_IT_E8790270B2765C5731A895; BRI/2; AskTbFWV5/5.9.1.14019)</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>DefaultDataProvider</PropertyName>
<PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>ExceptionGUID</PropertyName>
<PropertyValue>f1881a90-8730-4788-beeb-1c353b659810</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>InnerException</PropertyName>
<PropertyValue>Unhandled Error: </PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>FileName</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>FileLineNumber</PropertyName>
<PropertyValue>0</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>FileColumnNumber</PropertyName>
<PropertyValue>0</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>Method</PropertyName>
<PropertyValue>DotNetNuke.Professional.HttpModules.OutputCache.OutputCacheModule.OnResolveRequestCache</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>StackTrace</PropertyName>
<PropertyValue />
</LogProperty>
<LogProperty>
<PropertyName>Message</PropertyName>
<PropertyValue>
System.Exception: Unhandled Error:
---> System.NullReferenceException: Object reference not set to an instance of an object.
at DotNetNuke.Professional.HttpModules.OutputCache.OutputCacheModule.OnResolveRequestCache(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
</PropertyValue>
</LogProperty>
<LogProperty>
<PropertyName>Source</PropertyName>
<PropertyValue />
</LogProperty>
</LogProperties>
Would any expert can guide me through to fix this issue? We need to response to our clients immediately.
Thanks & regards,
Ken