Duplicate rows and runtime exception
Hello ,
I just upgraded the environment to V 6.0 4210 from V 4.4 2117 and when i view any blog post i found this below exception in event viewer , Also when i ran this query for specific blog post i found 20000 records duplicated with different last_modified date and this query took 20 min to run plus when i view this post from my home page i found 7 new record inserted in table [dynmc_906fc1536f34c50b80cf7149] ,Is this normal behavior or shall i delete this records
System.Data.SqlClient.SqlException (0x80131904): Could not find prepared statement with handle -1.
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
ClientConnectionId:17158031-a3e5-493e-b85a-14babda9a0de
Error Number:8179,State:1,Class:16
CommandType=Text, CommandTimeout=30, ConnectionState=Open, Transaction=1
driver.stat.execQuery 183 SELECT a.[id] AS COL1, b.[voa_class] AS COL2, a.[categories] AS COL3, a.[content] AS COL4, a.[expiration_date] AS COL5, a.[item_hash] AS COL6, a.[lnk] AS COL7, a.[owner_email] AS COL8, a.[owner_first_name] AS COL9, a.[owner_last_name] AS COL10, a.[publication_date] AS COL11, a.[summary] AS COL12, a.[title] AS COL13, a.[username] AS COL14, b.[application_name] AS COL15, b.[last_modified] AS COL16, b.[original_item_id] AS COL17, b.[original_parent_id] AS COL18, b.[voa_version] AS COL19 FROM [dynmc_906fc1536f34c50b80cf7149] a JOIN [sf_dynamic_type_base] AS b ON (a.[id] = b.[id]) WHERE b.[application_name] = '/PublishingItems' AND b.[original_item_id] = @p0 ORDER BY COL1
Hello Anthony,
Looking at the error logs, the issue seem related to Publishing system background task running. Please try to stop the "PublishingSystemInvokerTask" in the database before starting the upgrade.
I hope this information helps.
Regards,
Svetoslav Manchev
Telerik