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
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
