Copied to clipboard

Flag this post as spam?

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


  • Mikael Syska 24 posts 91 karma points
    Oct 05, 2018 @ 03:17
    Mikael Syska
    0

    Upgrading from 7.5.14 to 7.12.3 - Unable to login

    Trying to upgrade my Umbraco Cloud ... finally.

    After fixes some issue with version and other stuff ... still have an issue with connections leaking because of extensive logging or maybe other stuff, but I hope that will be fixed when the database is actually upgraded ... else I just have another issue to solve.

    I get the following exception when trying to login to Auth the upgrade:

    StackTrace: "   ved Umbraco.Core.Models.Membership.User..ctor(Int32 id, String name, String email, String username, String rawPasswordValue, IEnumerable`1 userGroups, Int32[] startContentIds, Int32[] startMediaIds)
    ↵   ved Umbraco.Core.Persistence.Factories.UserFactory.BuildEntity(UserDto dto)
    ↵   ved Umbraco.Core.Services.UserService.GetByUsername(String username)
    ↵   ved Umbraco.Core.Security.BackOfficeUserStore.<FindByNameAsync>d__10.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved Umbraco.Core.Security.BackOfficeSignInManager.<PasswordSignInAsyncImpl>d__6.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved Umbraco.Core.Security.BackOfficeSignInManager.<PasswordSignInAsync>d__5.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved Umbraco.Web.Editors.AuthenticationController.<PostLogin>d__13.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
    ↵--- Afslutningen på staksporingen fra den tidligere placering, hvor undtagelsen blev udløst ---
    ↵   ved System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    ↵   ved System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    ↵   ved System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"
    

    I have no idea whats is going on ... :-(

    I get the following in the UmbracoTraceLog.txt

    2018-10-05 04:40:49,223 [P29332/D30/T83] INFO Umbraco.Deploy.Cloud.LocalInitializer - Run :: initializing 2018-10-05 04:40:49,404 [P29332/D30/T83] INFO Umbraco.Deploy.Cloud.LocalInitializer - Run :: Is not running remote, Is not using Sql Azure. 2018-10-05 04:40:49,511 [P29332/D30/T83] INFO Umbraco.Deploy.Cloud.LocalInitializer - Run :: web.config configured with a SqlServer/LocalDb database. 2018-10-05 04:40:49,724 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoNode' was created 2018-10-05 04:40:49,726 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContentType' was created 2018-10-05 04:40:49,728 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsTemplate' was created 2018-10-05 04:40:49,730 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContent' was created 2018-10-05 04:40:49,732 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContentVersion' was created 2018-10-05 04:40:49,735 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsDocument' was created 2018-10-05 04:40:49,737 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMedia' was created 2018-10-05 04:40:49,738 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsDocumentType' was created 2018-10-05 04:40:49,739 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsDataType' was created 2018-10-05 04:40:49,740 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsDataTypePreValues' was created 2018-10-05 04:40:49,742 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsDictionary' was created 2018-10-05 04:40:49,743 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoLanguage' was created 2018-10-05 04:40:49,744 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsLanguageText' was created 2018-10-05 04:40:49,745 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoDomains' was created 2018-10-05 04:40:49,746 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoLog' was created 2018-10-05 04:40:49,747 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMacro' was created 2018-10-05 04:40:49,748 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMacroProperty' was created 2018-10-05 04:40:49,749 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMemberType' was created 2018-10-05 04:40:49,751 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMember' was created 2018-10-05 04:40:49,752 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsMember2MemberGroup' was created 2018-10-05 04:40:49,752 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContentXml' was created 2018-10-05 04:40:49,754 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsPreviewXml' was created 2018-10-05 04:40:49,755 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsPropertyTypeGroup' was created 2018-10-05 04:40:49,757 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsPropertyType' was created 2018-10-05 04:40:49,759 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsPropertyData' was created 2018-10-05 04:40:49,761 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoRelationType' was created 2018-10-05 04:40:49,762 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoRelation' was created 2018-10-05 04:40:49,764 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsTags' was created 2018-10-05 04:40:49,765 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsTagRelationship' was created 2018-10-05 04:40:49,766 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUser' was created 2018-10-05 04:40:49,767 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsTaskType' was created 2018-10-05 04:40:49,770 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsTask' was created 2018-10-05 04:40:49,772 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContentType2ContentType' was created 2018-10-05 04:40:49,774 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'cmsContentTypeAllowedContentType' was created 2018-10-05 04:40:49,776 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUser2NodeNotify' was created 2018-10-05 04:40:49,777 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoServer' was created 2018-10-05 04:40:49,778 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoAccess' was created 2018-10-05 04:40:49,779 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoAccessRule' was created 2018-10-05 04:40:49,781 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoCacheInstruction' was created 2018-10-05 04:40:49,781 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoExternalLogin' was created 2018-10-05 04:40:49,783 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoMigration' was created 2018-10-05 04:40:49,784 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoRedirectUrl' was created 2018-10-05 04:40:49,785 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoLock' was created 2018-10-05 04:40:49,786 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUserGroup' was created 2018-10-05 04:40:49,786 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUser2UserGroup' was created 2018-10-05 04:40:49,787 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUserGroup2NodePermission' was created 2018-10-05 04:40:49,788 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUserGroup2App' was created 2018-10-05 04:40:49,789 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUserStartNode' was created 2018-10-05 04:40:49,791 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoUserLogin' was created 2018-10-05 04:40:49,792 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoConsent' was created 2018-10-05 04:40:49,794 [P29332/D30/T83] INFO Umbraco.Core.Persistence.Database - New table 'umbracoAudit' was created 2018-10-05 04:41:17,812 [P29332/D30/T83] INFO Umbraco.Core.CoreBootManager - Umbraco 7.12.3 application starting on SS-16 2018-10-05 04:41:17,831 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-10-05 04:41:17,851 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Hash determined (took 19ms) 2018-10-05 04:41:17,900 [P29332/D30/T83] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-10-05 04:41:17,902 [P29332/D30/T83] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-10-05 04:41:17,904 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:41:17,986 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 81ms) 2018-10-05 04:41:17,986 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-10-05 04:41:17,987 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms) 2018-10-05 04:41:18,035 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:41:18,036 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:41:18,037 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-10-05 04:41:18,037 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms) 2018-10-05 04:41:18,037 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:41:18,038 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:41:18,038 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-10-05 04:41:18,040 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 1ms) 2018-10-05 04:41:18,063 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:41:18,063 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:41:18,063 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-10-05 04:41:18,064 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms) 2018-10-05 04:41:18,065 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:41:18,065 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:41:18,065 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-10-05 04:41:18,067 [P29332/D30/T83] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 1ms) 2018-10-05 04:41:21,884 [P29332/D30/T83] INFO Umbraco.Core.DatabaseContext - CanConnect = True 2018-10-05 04:41:22,208 [P29332/D30/T83] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 4396ms) 2018-10-05 04:41:22,522 [P29332/D30/T83] INFO Hangfire.SqlServer.SqlServerStorage - Start installing Hangfire SQL objects... 2018-10-05 04:41:22,611 [P29332/D30/T83] INFO Hangfire.SqlServer.SqlServerStorage - Hangfire SQL objects installed. 2018-10-05 04:41:23,344 [P29332/D30/T202] INFO Umbraco.Core.Sync.ApplicationUrlHelper - New ApplicationUrl detected: http://ssp.dev/umbraco 2018-10-05 04:41:23,345 [P29332/D30/T202] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://ssp.dev/umbraco (UmbracoModule request) 2018-10-05 04:41:26,442 [P29332/D30/T202] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:41:37,839 [P29332/D30/T48] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:42:25,822 [P29332/D30/T110] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:42:31,351 [P29332/D30/T110] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:42:31,351 [P29332/D30/T110] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:42:31,351 [P29332/D30/T110] INFO Umbraco.Core.PluginManager - Resolving [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController 2018-10-05 04:42:31,375 [P29332/D30/T110] INFO Umbraco.Core.PluginManager - Resolved [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController (took 23ms) 2018-10-05 04:42:31,569 [P29332/D30/T57] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:42:31,606 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:42:31,607 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:42:31,607 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IAction 2018-10-05 04:42:31,624 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IAction (took 16ms) 2018-10-05 04:42:31,828 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-10-05 04:42:31,829 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-10-05 04:42:31,829 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IParameterEditor 2018-10-05 04:42:31,852 [P29332/D30/T57] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IParameterEditor (took 23ms) 2018-10-05 04:42:32,969 [P29332/D30/T126] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:42:32,993 [P29332/D30/T126] WARN Umbraco.Core.Logging.OwinLogger - Event Id: 0, state: Unprotect ticket failed 2018-10-05 04:42:48,168 [P29332/D30/T114] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,168 [P29332/D30/T144] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>cDisplayClass200.0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper
    1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,168 [P29332/D30/T137] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,168 [P29332/D30/T111] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>cDisplayClass200.0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper
    1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,168 [P29332/D30/T82] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,168 [P29332/D30/T88] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>cDisplayClass20_0.0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper
    1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2018-10-05 04:42:48,171 [P29332/D30/T57] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass20_0.<ExecuteAction>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.OpenSharedConnection()
    --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at umbraco.DataLayer.CurrentConnectionUsing..ctor() at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)

    I get alot of these in the umbracoLog

    No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 2 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 326 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 2 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 2 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 1 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 1 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 1 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 1 ms. No connection string was found. Indicating a fresh Umbraco7 instance. Determining took: 1 ms.

    That might be causing the first issue ... but it's not a fresh install ... and apparently ... it can see the connection string so I'm not sure what is going on here ...

    I have tried seaching ... no luck ...

    tress.config and applications.config looks fine ...

    Any ideas how I can debug this?

  • Mikael Syska 24 posts 91 karma points
    Oct 05, 2018 @ 03:28
    Mikael Syska
    0

    This issue could be related: https://issues.umbraco.org/issue/U4-10545

    I havent tried any of the drop tables or alter ...

    Can't find the other issue the creator said he created ...

  • Mikael Syska 24 posts 91 karma points
    Oct 05, 2018 @ 03:36
    Mikael Syska
    0

    This is the settings

    <membership defaultProvider="UmbracoMembershipProvider" userIsOnlineTimeWindow="15">
      <providers>
        <clear />
        <add name="UmbracoMembershipProvider" type="UmbracoIdentity.IdentityEnabledMembersMembershipProvider, UmbracoIdentity" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="6" useLegacyEncoding="false" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="Employee" passwordFormat="Hashed" />
        <add name="UsersMembershipProvider" type="Umbraco.Web.Security.Providers.UsersMembershipProvider, Umbraco" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="8" useLegacyEncoding="true" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" passwordFormat="Hashed" />
      </providers>
    </membership>
    

    This is the settings for the membership section ... as I can see they haven't changed ... same as before the upgrade ...

  • Paul 142 posts 488 karma points
    Oct 05, 2018 @ 07:37
    Paul
    0

    I thought you needed to upgrade to 7.7 first then upgrade again to 7.12 if you were coming from 7.5 or below?

  • Mikael Syska 24 posts 91 karma points
    Oct 05, 2018 @ 16:24
    Mikael Syska
    0

    I'm not sure about that ... you got any information on that?

    I'm upgrading a Umbraco Cloud and I was only giving the option to selected the latest veresion, unless I have missed something in the UI on the Umbraco.io portal ...

  • Mikael Syska 24 posts 91 karma points
    Oct 05, 2018 @ 20:31
    Mikael Syska
    0

    Okay ... so the SQL Connection pool problem is caused by uCommerce ... hurray ... they they have fixed this in a new version ... and since we also are going to upgrade that ... not real issue.

    The login problem was fixed with the follow:

    ALTER TABLE umbracoUser ADD startMediaID2 int 
    GO
    UPDATE umbracoUser SET umbracoUser.startMediaID2 = umbracoUser.startMediaID 
    GO
    ALTER TABLE umbracoUser DROP COLUMN startMediaID 
    GO
    ALTER TABLE umbracoUser ADD startMediaID int
    GO
    UPDATE umbracoUser SET umbracoUser.startMediaID = umbracoUser.startMediaID2 ALTER TABLE umbracoUser DROP COLUMN startMediaID2
    

    Seems like they need a certain order ... hurray.

    So ... now i'm closer to they goal ...

    Needed to give myself admin access ... but actually had that before.

    My last problem is that the "GetNodes" api call from the backoffice is empty ... nothing at all returned ...

    Any ideas how do debug this?

Please Sign in or register to post replies

Write your reply to:

Draft