Connection DoesNotExistsError:connection was closed in the middle of operation

Humankind 0

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!

Adithya Prasad K 10 Reputation points Microsoft Vendor

2025-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 like ping or traceroute to 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. 
Humankind 0 Reputation points

2025-02-26T14:31:23.95+00:00

Thanks Adithya,!
PratikLad 80 Reputation points Microsoft Vendor

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

Share via

Connection DoesNotExistsError:connection was closed in the middle of operation

Your answer