I scaffolded a asp.net core application from Postgresql db, I get the below error , please suggest. TimeoutException: Timeout during reading attempt I fails here SupaCrud.Controllers.QuestionsController.Index() in QuestionsController.cs + return _context.Questions != null ? System.InvalidOperationException: An exception has been raised that is likely due to a transient failure. ---> Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt

How to Increase timeout

Kalyan A 0

I scaffolded a asp.net core application from Postgresql db, I get the below error , please suggest.

TimeoutException: Timeout during reading attempt

I fails here

SupaCrud.Controllers.QuestionsController.Index() in QuestionsController.cs

return _context.Questions != null ?

System.InvalidOperationException: An exception has been raised that is likely due to a transient failure.
 ---> Npgsql.NpgsqlException (0x80004005): Exception while reading from stream
 ---> System.TimeoutException: Timeout during reading attempt

ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee

2024-07-01T09:40:34.73+00:00

Hi Kalyan A,

Welcome to Microsoft Q&A forum.

As I understand, you are getting Timeout issue in Azure Database for PostgreSQL when connecting from code.

What is the Region in which this server was created?

What is the configuration of the Flexible Server?

Is the server Data Encrypted with CMK?

If yes, make sure these requirements are met https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-data-encryption#requirements-for-configuring-data-encryption-for-azure-database-for-postgresql-flexible-server and check if connection to Key Vault exists.

Check if network settings are causing this timeout.

Transient errors occur when maintenance is performed, the system encounters an error with the hardware or software, or you change the vCores or service tier of your server. The Azure Database for PostgreSQL service has built-in high availability and is designed to mitigate these types of problems automatically. However, your application loses its connection to the server for a short period of time of typically less than 60 seconds at most. Some events can occasionally take longer to mitigate, such as when a large transaction causes a long-running recovery.

Also refer to https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-limits https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-troubleshoot-common-connection-issues

Thanks.

Share via

How to Increase timeout