Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,428 questions
Azure Database for PostgreSQL flexible servers
![](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(156.8, 50%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gazzela Vivakar
10
Reputation points
Db is frequently crashing suddenly how we can solve this temp we are restarting the server that is fixing the issue
08:28:43 ERR] An exception occurred while iterating over the results of a query for context type 'XXXX.EntityFramework.Shared.DbContexts.AdminIdentityDbContext'.
System.InvalidOperationException: An exception has been raised that is likely due to a transient failure.
---> Npgsql.PostgresException (0x80004005): 53300: remaining connection slots are reserved for non-replication superuser connections
at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|213_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|193_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.<Get>g__RentAsync|27_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
Azure Database for PostgreSQL
{count} votes
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator2023-10-12T16:38:10.7866667+00:00 Thank you for reaching out.
Could you please share the region where the Database was deployed. When was the server created.?
Regards,
Oury
-
Gazzela Vivakar 10 Reputation points
2023-10-13T07:29:03.6966667+00:00 We have created in West Europe created at 2023-02-13 21:31:01.1265853 UTC ,version : 14.8, config : Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-10-13T14:46:17.81+00:00 Thank you. Could you please send an email to azcommunity@microsoft.com the below details and mention in subject Line ATTN: Oury
Subscription ID:
Server Name:
Regards,
Oury
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-10-16T22:03:50.0533333+00:00 Did you had the chance to send an email to the above address so we can further investigate based on the information you will provide.
Regards,
Oury
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-12-18T18:55:20.2833333+00:00 @Gazzela Vivakar Thank you for your question.
I would suggest sharing sensitive information to azcommunity@microsoft.com with subject line ATTN: Oury.
since this this a public forum I would recommend sharing the information through email please.
Regards,
Oury
Sign in to comment
Sign in to answer