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
Hi,
In local it works fine, in our identical Production environment ( https:hathor.events ) it also works fine, with the exact same codebase, both were deployed at the same time. The configuration also looks the same to me, I have checked and double checked.
Here is a video of the production deploy:
https://1drv.ms/v/s!AkJmGuHQuob7kqUmF4Iietrj4J1G6A?e=vbVyIK
And now, when I go to https://test-dashboard.hathor.events I get a 400 error before the login UI. This has also been a huge issue for me when deploying to production, seems there may be intermittent issues connecting to the database. I have another ticket open for that.
I just need some help getting to the bottom of these issues when deploying. We have spent so much time on this project, and everything works fine locally but it is so unstable after deploying. I need to demo to our client and I can't do so, this is becoming critical for us.
Seems like everything is revolving around the Auth project in one way or another.
Here are the new logs, same exact deployment, now with 400:
https://1drv.ms/u/s!AkJmGuHQuob7kqUl46X837Ty84Ga_Q?e=zyRTum
[ERR] An error occurred using the connection to database 'ESv2-testing' on server 'tcp:hathor-hk.database.windows.net,1433'
I really need help getting things stable in production, any ideas or insight would be very much appreciated.
Thanks,
Karim
Hi,
OK I have confirmed that all KeyPrefixes are the same. Just to make sure, the KeyPrefix can be anything, correct? I have it as "ESv2:" for all projects.
I also copied the Redis config in to an Environment Variable and used the same value for all AppServices:
However I am still getting the exact same error:
any other ideas?
Thanks,
Karim
Hi,
Ah OK, that might make sense. Let me make sure I have Redis explicitly set up in the EnvVars. Just in appsettings now, as so:
"Redis": {
"Configuration": "hathor.redis.cache.windows.net:6380,password=XXXXXXXXXXXXXXXXXXXXXXXXXXXX=,ssl=True,abortConnect=False"
},
I have 2 completely separate environments now, not using Deployment Slots. One for Test, one for Production, running the exact same codebase. Using the same Redis connection string for both environments, all AppServices.
Is that OK, would you suggest a different setup / configuration? I plan now to move the Redis config into the EnvVars in Azure to have a bit better control. I will let you know how that works.
Any other suggestions?
Thanks,
Karim
Hi, I have given you access.
