Duplicate rows and runtime exception

Posted by Community Admin on 04-Aug-2018 16:53

Duplicate rows and runtime exception

All Replies

Posted by Community Admin on 19-Feb-2015 00:00

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 

 

Posted by Community Admin on 25-Feb-2015 00:00

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

 
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
 

This thread is closed