Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,219 questions
Thanks Adithya,!
Connection DoesNotExistsError:connection was closed in the middle of operation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 27%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Humankind
0
Reputation points
Hi, Users are complaining "Connection DoesNotExistsError:connection was closed in the middle of operation" error while using a streamlit UI based web app deployed on Azure.
Thanks for help!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Adithya Prasad K 10 Reputation points Microsoft Vendor2025-02-26T12:57:59.1933333+00:00 Hi Humankind,
Thanks for the question and using MS Q&A platform.
Could you kindly provide us with the resource name and any additional details? It would be greatly helpful. -
Humankind 0 Reputation points
2025-02-26T13:01:56.62+00:00 resource name - mankind-ai, Azure Database for PostgreSQL flexible server
-
Humankind 0 Reputation points
2025-02-26T13:49:33.5+00:00 Sharing a screenshot
-
Adithya Prasad K 10 Reputation points Microsoft Vendor
2025-02-26T14:22:01.4266667+00:00 Hi
This error typically indicates that the connection to the database (likely Azure SQL Database or another data source) was unexpectedly terminated during an operation. This can happen due to various reasons, including:
1.Network connectivity issues
2.Timeout settings
3.Resource limitations on the database
4.Idle connections being closed by the server-Could you please Check Database Connection Settings: Ensure that your database connection string is correctly configured. Verify that the connection timeout settings are appropriate for your application
-Implement Connection Resiliency: Use connection pooling and implement retry logic in your application to handle transient errors. This can help automatically reconnect when a connection is lost.
-Increase Timeout Settings: If your operations take a long time, consider increasing the command timeout settings in your database connection configuration
-Monitor Database Performance:Use Azure Monitor to check the performance metrics of your database. Look for high CPU usage, memory pressure, or other indicators that might suggest resource limitations
-Review Application Logs: Check the logs of your Streamlit application for any additional error messages or context that might help diagnose the issue
-Test Network Connectivity: Ensure that there are no network issues affecting connectivity to the database. You can use tools likepingortracerouteto diagnose network problems.
-Consider Using Azure Functions or Azure App Service: If your application is under heavy load, consider using Azure Functions or Azure App Service to scale your application and manage connections more effectively.I would request you to refer the below mentioned links for more information
https://docs.python.org/3/library/asyncio.html
https://docs.streamlit.io/
I hope this information helps. Please do let us know if you have any further queries. -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad 80 Reputation points Microsoft Vendor2025-02-27T04:59:14.2933333+00:00 Hi Humankind,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Humankind 0 Reputation points
2025-02-27T08:36:40.1333333+00:00 Hello Pratik, The issue is not resolved yet.
Sign in to comment