Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Andy Robinson 9 posts 96 karma points c-trib
    Dec 01, 2014 @ 11:28
    Andy Robinson
    0

    Pages unpublishing by themselves

    Morning all!,

    I wonder if anyone can help me, with this. I had a situation over the weekend, where the homepage of one of my sites became unpublished, therefore taking down the site. 

    There was nothing showing in the audit history to indicate an unpublish, and the "Unpublish At" has never been set. I can't even blame it on the client as they dont have access to the CMS.

    Looking at the logs (below) there were a couple of issue around that time; something with Umbraco.Web.Scheduling.ScheduledPublishing and umbraco.DataLayer.SqlHelper.

    I've seen historcially, there was a simular bug before 4.5.2. (see http://our.umbraco.org/forum/core/general/33980-Random-Unpublishing-of-Node) is this bug still around or possibly resurfaced? 

    Highlights from the log files...

    2014-11-29 08:28:50,048 [8] ERROR Umbraco.Web.Scheduling.ScheduledPublishing - [Thread 34] An error occurred with the scheduled publishing
    System.Net.WebException: The request was aborted: The operation has timed out.
       at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)
       at System.Net.WebClient.UploadString(Uri address, String method, String data)
       at Umbraco.Web.Scheduling.ScheduledPublishing.Start(ApplicationContext appContext)
    2014-11-29 08:28:56,208 [8] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 34] Error executing query Select versionId from cmsContentVersion where contentID = 3313 order by id desc 
    System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired
       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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       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.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
    ClientConnectionId:f0e689af-3b96-499c-b7f2-1ae9cffa00db

    Techy Setup 

    • Umbraco 7.1.8
    • Hosing: Azure Cloud Services, 2x Instances on 2x Roles (geographically distributed)
    • Database: SQL Azure 
    Any help here will be appricated.
    Thanks
    Andy

  • James 2 posts 22 karma points
    Dec 10, 2014 @ 11:45
    James
    0

    Hopefully you will get an answer here. Vote it up so that it gets sorted:

    http://issues.umbraco.org/issue/U4-5982

Please Sign in or register to post replies

Write your reply to:

Draft