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.SqlHelper1.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.SqlHelper1.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.SqlHelper1.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 ...
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 ...
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 ...
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:
I have no idea whats is going on ... :-(
I get the following in the UmbracoTraceLog.txt
I get alot of these in the umbracoLog
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?
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 ...
This is the settings
This is the settings for the membership section ... as I can see they haven't changed ... same as before the upgrade ...
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?
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 ...
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:
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?
is working on a reply...