Database exceptions while running in Azure, how to handle without EnableRetryOnFailure #7848

34 Answer(s)

• 

  0

  okains created one month ago

  Hi,

  at ESv2.Pages.IndexModel.OnGetAsync() in D:\a\Hathor\Hathor\aspnet-core\src\ESv2.AuthServer\Pages\Index.cshtml.cs:line 30

  OK that is in the Auth project, the line that I added back in as it didn't have any effect previously on these issues. I will comment this out again and update the CancellationTokenProvider and send logs.

  Thanks,

  Karim

  Save Cancel
• 

  0

  okains created one month ago

  Btw You can try using NullCancellationTokenProvider instead HttpContextCancellationTokenProvider to troubleshoot the A task was canceled. problem

   
  public override void ConfigureServices(ServiceConfigurationContext context) 
  { 
      context.Services.Replace(ServiceDescriptor.Transient<ICancellationTokenProvider, NullCancellationTokenProvider>()); 
           
  } 
  

  Getting an error here:

  

  Any idea on how to get this to work?

  Thanks,

  Karim

  Save Cancel
• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  hi

  public class MyNullCancellationTokenProvider : CancellationTokenProviderBase
  {
      public static NullCancellationTokenProvider Instance { get; } = new();
  
      public override CancellationToken Token => OverrideValue?.CancellationToken ?? CancellationToken.None;
  
      public MyNullCancellationTokenProvider()
          : base(new AmbientDataContextAmbientScopeProvider<CancellationTokenOverride>(new AsyncLocalAmbientDataContext()))
      {
      }
  }
  
  
  

  Save Cancel
• 

  0

  okains created one month ago

  Hi,

  OK I have commented out the AppService call in Index, and also the db call in Index in the Auth project. I don't see any of those DB errors in the logs now, though still having ABPAuthentication errors ( different support ticket ).

  Here are the new logs:

  https://1drv.ms/u/s!AkJmGuHQuob7kqdJN7sF0etJ-CbLzQ?e=GYNaHp

  Is there a way for me to fix this so that I can add back my code? Is this related to the OpenIDDict db context? Hope to be able to find a proper fix for this so that I can continue working.

  Thanks,

  Karim

  Save Cancel
• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  hi

  Try to use the below Index Get code.

  public async Task OnGetAsync()
  {
      var cancellationTokenSource = new CancellationTokenSource();
      var cancellationToken = cancellationTokenSource.Token;
      Applications = await OpenIdApplicationRepository.GetListAsync(cancellationToken: cancellationToken);
  
      Languages = await LanguageProvider.GetLanguagesAsync();
      CurrentLanguage = CultureInfo.CurrentCulture.DisplayName;
      
      cancellationTokenSource.Dispose();
  }
  

  Save Cancel
• 

  0

  okains created one month ago

  Hi,

  Sorry for late reply, was travelling. I will add this in and do some further testing, if the db issues are no longer in the logs then that will be great. My only concern is that there is a lot of extra code / configuration to get to this point and that might have other unintended effects. I am going to be doing some heavy load testing on this app next week so I want to make sure we haven't introduced any issues that might come up during testing.

  For now please keep this ticket open until I can finish my testing and confirm that things are OK.

  Thanks,

  Karim

  Save Cancel
• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  ok

  Save Cancel
• 

  0

  okains created one month ago

  As discussed, waiting on another support ticket to clear on this then I will run load testing, please keep open just in case these issues occur again during load testing. Once I get through the other support ticket, and the testing, I will close.

  Thanks,

  Karim

  Save Cancel
• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  ok

  Save Cancel