Copied to clipboard

Flag this post as spam?

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


  • james 5 posts 75 karma points
    Oct 09, 2017 @ 12:06
    james
    0

    upgrade to 7.6.6 and now getting sharing violations on Azure.

    Manually Upgraded to 7.7.6. everything works as expected on the site. Login in as an administrator

    -10-08 02:35:45,558 [P4920/D2/T24] ERROR Umbraco.Web.Strategies.ServerRegistrationEventHandler - Failed to update server record in database.
    System.Data.SqlServerCe.SqlCeException (0x80004005): There is a file sharing violation. A different process might be using the file. [ D:\home\site\wwwroot\App_Data\Umbraco.sdf ]
       at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
       at System.Data.SqlServerCe.SqlCeConnection.Open()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Action action)
       at Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection, RetryPolicy retryPolicy)
       at Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection)
       at Umbraco.Core.Persistence.Database.OpenSharedConnection()
       at Umbraco.Core.Persistence.Database.BeginTransaction(IsolationLevel isolationLevel)
       at Umbraco.Core.Scoping.Scope.get_Database()
       at Umbraco.Core.Persistence.UnitOfWork.ScopeUnitOfWork.get_Database()
       at Umbraco.Core.Persistence.LockingRepository`1.WithWriteLocked(Action`1 action, Boolean autoCommit)
       at Umbraco.Core.Services.ServerRegistrationService.TouchServer(String serverAddress, String serverIdentity, TimeSpan staleTimeout)
       at Umbraco.Web.Strategies.ServerRegistrationEventHandler.TouchServerTask.PerformRun()
     2017-10-08 03:27:08,773 [P4920/D2/T25] ERROR Umbraco.Web.Scheduling.ScheduledPublishing - Failed (see exception).
    System.Data.SqlServerCe.SqlCeException (0x80004005): There is a file sharing violation. A different process might be using the file. [ D:\home\site\wwwroot\App_Data\Umbraco.sdf ]
       at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
       at System.Data.SqlServerCe.SqlCeConnection.Open()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Action action)
       at Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection, RetryPolicy retryPolicy)
       at Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection)
       at Umbraco.Core.Persistence.Database.OpenSharedConnection()
       at Umbraco.Core.Persistence.Database.BeginTransaction(IsolationLevel isolationLevel)
       at Umbraco.Core.Scoping.Scope.get_Database()
       at Umbraco.Core.Persistence.UnitOfWork.ScopeUnitOfWork.get_Database()
       at Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sqlFull, PagingSqlQuery pagingSqlQuery, Boolean withCache, Boolean includeAllVersions)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.PerformGetByQuery(IQuery`1 query)
       at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetByQuery(IQuery`1 query)
       at Umbraco.Core.Services.ContentService.GetContentForRelease()
       at Umbraco.Core.Publishing.ScheduledPublisher.CheckPendingAndProcess()
       at Umbraco.Web.Scheduling.ScheduledPublishing.<PerformRunAsync>d__5.MoveNext()
    
  • Alex Skrypnyk (skrypnyk.dev) 6070 posts 23408 karma points MVP 6x admin c-trib
    Oct 10, 2017 @ 14:35
    Alex Skrypnyk (skrypnyk.dev)
    0

    Hi James

    Did you solve the issue?

    Are you using sqlce database all the time?

    Thanks,

    Alex

  • james 5 posts 75 karma points
    Oct 14, 2017 @ 19:53
    james
    0

    Sadly no. and yes I am using the sqlce db.

  • Alex Skrypnyk (skrypnyk.dev) 6070 posts 23408 karma points MVP 6x admin c-trib
    Oct 14, 2017 @ 21:34
    Alex Skrypnyk (skrypnyk.dev)
    0

    Can you move the database to MSSQL?

  • Kyle 13 posts 84 karma points
    Oct 25, 2017 @ 19:15
    Kyle
    0

    Hi James and Alex, any progress on this as I am also having the same problem.

  • Damien Holley 165 posts 504 karma points
    Oct 29, 2017 @ 07:19
    Damien Holley
    0

    Same issues here, been using sqlce for over a year now with no real issues, now all of a sudden it's full of sharing violations.

Please Sign in or register to post replies

Write your reply to:

Draft