Content tree not loading, eventually timing out, items duplicated visually? (Examine Index issue?)
I'm having an issue where the content tree will not load upon logging in. Eventually the request will time out and the backoffice will present a blank error to the user. This happens pretty frequently, more than once a week.
If I manually delete the Examine indexes and restart the website, the error will go away for the time being.
Another problem with the content tree happens is that some items are showing up twice. It doesnt have the duplicated item name "name (1)", its the same exact name and when you click on it, the original item is highlighted in the content tree. So it seems like they are referring to the same item.
I'm using Umbraco 7.2.6
Packages installed:
Config Tree
Examine Dashboard
FALM Housekeeping
ImageGen
RJP.MultiUrlPicker
Robots.txtEditor
I'm inheriting this, so I'm not sure if these might be related.
I guess I'm just looking for any insight.
Here is a stack trace for when the error happens:
> 2020-09-09 17:20:00,547 [9] INFO Umbraco.Web.Security.WebSecurity -
> [T43/D2] User Id: 15 logged in 2020-09-09 17:20:07,550 [9] INFO
> Umbraco.Core.PluginManager - [T16/D2] Starting resolution types of
> Umbraco.Web.Trees.TreeController 2020-09-09 17:20:07,551 [9] INFO
> Umbraco.Core.PluginManager - [T16/D2] Completed resolution of types of
> Umbraco.Web.Trees.TreeController, found 4 (took 0ms) 2020-09-09
> 17:20:33,260 [9] INFO Umbraco.Core.Persistence.UmbracoDatabase -
> [T12/D2] at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection, Action`1 wrapCloseInAction) at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
> System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj, Boolean& dataReady) at
> System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at
> System.Data.SqlClient.SqlDataReader.get_MetaData() at
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString, Boolean
> isInternal, Boolean forDescribeParameterEncryption, Boolean
> shouldCacheForAlwaysEncrypted) at
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,
> SqlDataReader ds, Boolean describeParameterEncryptionRequest) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
> Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method) at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method) at
> StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior
> behavior) at
> Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext() 2020-09-09
> 17:21:02,812 [9] INFO Umbraco.Core.Persistence.UmbracoDatabase -
> [T41/D2] at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection, Action`1 wrapCloseInAction) at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
> System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj, Boolean& dataReady) at
> System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at
> System.Data.SqlClient.SqlDataReader.get_MetaData() at
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString, Boolean
> isInternal, Boolean forDescribeParameterEncryption, Boolean
> shouldCacheForAlwaysEncrypted) at
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,
> SqlDataReader ds, Boolean describeParameterEncryptionRequest) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
> Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method) at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method) at
> StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior
> behavior) at
> Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext() 2020-09-09
> 17:22:28,444 [9] INFO Umbraco.Core.PluginManager - [T39/D2] Starting
> resolution types of Umbraco.Web.Trees.TreeController 2020-09-09
> 17:22:28,444 [9] INFO Umbraco.Core.PluginManager - [T39/D2] Completed
> resolution of types of Umbraco.Web.Trees.TreeController, found 4 (took
> 0ms) 2020-09-09 17:22:58,884 [9] INFO
> Umbraco.Core.Persistence.UmbracoDatabase - [T40/D2] at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection, Action`1 wrapCloseInAction) at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
> System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj, Boolean& dataReady) at
> System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at
> System.Data.SqlClient.SqlDataReader.get_MetaData() at
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString, Boolean
> isInternal, Boolean forDescribeParameterEncryption, Boolean
> shouldCacheForAlwaysEncrypted) at
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,
> SqlDataReader ds, Boolean describeParameterEncryptionRequest) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
> Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method) at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method) at
> StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior
> behavior) at
> Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext() 2020-09-09
> 17:28:20,447 [9] INFO Umbraco.Core.PluginManager - [T37/D2] Starting
> resolution types of Umbraco.Web.Trees.TreeController 2020-09-09
> 17:28:20,447 [9] INFO Umbraco.Core.PluginManager - [T37/D2] Completed
> resolution of types of Umbraco.Web.Trees.TreeController, found 4 (took
> 0ms) 2020-09-09 17:28:50,815 [9] INFO
> Umbraco.Core.Persistence.UmbracoDatabase - [T37/D2] at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection, Action`1 wrapCloseInAction) at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
> System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj, Boolean& dataReady) at
> System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at
> System.Data.SqlClient.SqlDataReader.get_MetaData() at
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString, Boolean
> isInternal, Boolean forDescribeParameterEncryption, Boolean
> shouldCacheForAlwaysEncrypted) at
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,
> SqlDataReader ds, Boolean describeParameterEncryptionRequest) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task& task,
> Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at
> System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method) at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method) at
> StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior
> behavior) at
> Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()
Content tree not loading, eventually timing out, items duplicated visually? (Examine Index issue?)
I'm having an issue where the content tree will not load upon logging in. Eventually the request will time out and the backoffice will present a blank error to the user. This happens pretty frequently, more than once a week.
If I manually delete the Examine indexes and restart the website, the error will go away for the time being.
Another problem with the content tree happens is that some items are showing up twice. It doesnt have the duplicated item name "name (1)", its the same exact name and when you click on it, the original item is highlighted in the content tree. So it seems like they are referring to the same item.
I'm using Umbraco 7.2.6
Packages installed:
I'm inheriting this, so I'm not sure if these might be related.
I guess I'm just looking for any insight.
Here is a stack trace for when the error happens:
is working on a reply...