23:11:29.200 request_id=GDG3fR224Q2rQPIAAARR [error] ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 10428ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:
SQL Server database is supplied by an external provider, i really like the fly.io general context, but if can’t resolve this issue, have to look for another alternative to deploy my application
I am not troubled if you stay or leave, I am just a Fly customer. However, it’s worth bearing in mind that each cloud provider has its complexities, and you can’t leave them all
Try shelling into your running machine and seeing if you can make a connection to the database server. If the host is a DNS name rather than an IP, see if it resolves. Also, see if it resolves to an IPv6 or an IPv4 address, and if so, which one the db host requires.
Check the port is correct too. Finally, there may be a firewall on the db provider side, and I wonder if you need to add an address or a range to let a connection from Fly succeed.
There is technical support here, but I think one has to pay a monthly sum for it. Technical support is hard to offer on a free-of-charge basis, unfortunately; even with AWS, I would doubt that I could ask for help to get any of their services working. I seem to recall I tried once, and it was worse than useless.
