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
Hi,
Yeah Redis does seem like it could be the problem here. I did set up a separate Redis server for Test, but I am not using it, Test is configured using the Production Redis db for now so that I can keep everything consistent for troubleshooting.
Any other ideas on what we can try here?
Thanks,
Karim
Hi,
I have removed the db call from the Index Page. Just hardcoding the ID needed now. Still getting many of the same db connection issues in the logs, both AUTH and API. At this point though the behavior is that the App loses authentication after a few seconds, this is the same issue as documented in my other open ticket.
Here are the logs for this deployment to https://test-dashboard.hathor.events :
https://1drv.ms/u/s!AkJmGuHQuob7kqZeKS0nlUov2TXVHQ?e=ComGjG
Thanks,
Karim
Hi,
OK I have sent the login details to your email.
Thanks,
Karim
Hi,
The error logs of the An error occurred using the connection to database are caused by TaskCanceledException: A task was canceled in the Index page.
I thought it was the other way around, the DB error was causing the TaskCancelledException. If the TaskCancelledException is causing the db error, then what is the root cause of the TaskCancelledException?
OK I commented out the // Application = await OpenIdApplicationRepository.GetListAsync(); line,
I uncommented that line, put it back in as it didn't seem to have any effect on the error. Are you asking me to comment out again and send logs?
Thanks,
Karim
Hi,
I have full AppService logs here:
https://1drv.ms/u/s!AkJmGuHQuob7kqUl46X837Ty84Ga_Q?e=zyRTum
If you are after database logs can you be more specific about what you need?
Thanks,
Karim
Hi,
Sure, but an account for what service? For our App, or for Azure? Sorry, not sure what you mean.
Thanks,
Karim
Hi,
Yeah I thought last week that this would be because of the Deployment Slots, so I removed all Deployment Slots. I now have 2 identical environments, Test and Production, but not using Deployment Slots at all. But still getting the same errors, I had hoped that would have fixed things.
Currently the Production environment has been running without any issues, for the past few days, but Test has not, same codebase, same setup / configuration.
OK I made a copy of the ESv2-testing db on Azure, called it ESv2-support. Updated the OpenIddictApplications table and added my localhost urls where needed. Set the db connection locally on Auth / API projects to the ESv2-support db on Azure.
Was able to get to the login page, logged in, then got an auth error but there were no [ERR] entries in the Auth log, so no issues with the connection it seems, though only ran it one time for now.
Can check back on this in a few hours. If any further ideas please let me know.
Thanks for your help,
Karim
Hi,
OK let me try that. It actually worked for about a day, no 400 errors however there was another Auth error on the web app that I created a separate ticket for. But now back to the 400 error on the login page. I think all of these issues are down to this db connection problem we are having.
I will try locally and let you know.
Thanks,
Karim
