question

EggDev-4738 avatar image
0 Votes"
EggDev-4738 asked OuryBa-MSFT commented

Unable to connect to Azure Postgresql, timeout expired. Even restart doesn't help.

Hi all,

So in short, it seems my Azure PostgreSQL went into limbo.

I've been experiencing issues with connection after psql server encountered several errors below
- OperationalError: SSL SYSCALL error: EOF detected
- OperationalError: server closed connection unexpectedly

Little bit a background here, I'm using psycopg2 and sqlalchemy libraries in Python scripts to communicate with the database, along with pgAdmin for general database management. And the Python scripts run off of Azure Linux VM. I let my scripts run overnight to collect and store the data from the data sources to Azure PostgreslSQL Database that I subscribed, which might have been quite a lot of workload to the server compared to previous run. On the next day, I found the scripts had encountered the errors above and stopped the scripts from running to run again after fixing the code. I suspect this could have had the database lose its connection from client side abnormally and put the server in the limbo.

I tried restart psql from Azure Portal 3 times. Restart succeeded once out of 3 requests. I was able to connect to psql for a short moment once it was successfully restarted but it went into limbo shortly after.

So the current status:
- Unable to connect with pgAdmin, prompting timeout expired.
108253-image.png

  • Connection Security from Azure Portal where Firewall settings can be configured keeps loading not showing the page.
    108230-image.png

  • 'Available' Status in Azure Portal but actually not responding.
    108180-image.png

  • Was not able to communicate with Azure CLI either, tried Get-AzPostgreSqlConfiguration command hoping that I can change the 'timeout' related config.
    108207-image.png


Can you please help me to find what's the possible root cause and resolve this issue? I'm pretty new to this cloud server and database as a whole. It is very frustrating that I cannot even find what's the issue behind as the server doesn't let me get into.

Thanks in advance!


azure-database-postgresql
image.png (19.1 KiB)
image.png (19.5 KiB)
image.png (26.9 KiB)
image.png (31.8 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @EggDev-4738 Thank you for posting your question. Could you please raise a support ticket, we cannot troubleshoot this remotely.
Let me know your support ticket number so that I can keep track of your case. If you run into any issues, feel free to let me know.
Regards,
Oury

0 Votes 0 ·

Will do, thanks!

0 Votes 0 ·

@OuryBa-MSFT, It doesn't let me create the ticket unless I upgrade my basic plan to paid support plan. That's why I posted my case first here in this community. What am I supposed to do? Upgrading my plan is only way I can ask for help?

0 Votes 0 ·

121062326001403 - Have opened a ticket, thanks. @OuryBa-MSFT

0 Votes 0 ·

@EggDev-4738 Thanks for sharing the ticket number. We will keep track of your case.
Regards,
Oury

0 Votes 0 ·

0 Answers