question

RuttorfChristian-9443 avatar image
0 Votes"
RuttorfChristian-9443 asked ·

PostgreSQL received fast shutdown request by azure_superuser

Hi,

yesterday we've noticed a data loss with one of our postgresql for azure databases. In the server logs we were able to track it down to the following:

2021-03-10 19:24:38 UTC-60491cf6.1e380-LOG: connection received: host=127.0.0.1 port=33713 pid=123776
2021-03-10 19:24:39 UTC-60491cf6.1e380-LOG: connection authorized: user=azure_superuserdatabase=postgres SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)
2021-03-10 19:24:40 UTC-6000b022.24-LOG: received fast shutdown request
2021-03-10 19:24:40 UTC-6000b022.24-LOG: aborting any active transactions
2021-03-10 19:24:40 UTC-60491ceb.1e320-FATAL: terminating connection due to administrator command
[and so on]


is this expected behavior?


Thanks in advance
Christian

azure-sql-database
10 |1000 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.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered ·

@RuttorfChristian-9443

This could have happened cause of the planned maintenance for the underlying resources for the Azure Database for Postgresql. Here is the document that explains the same.

76909-image.png

You need to contact support to find if that exactly happened as they have telemetry to find that. Also the best approach to prevent this is below:

1) Retry Logic
76915-image.png

2) Planned restart notification set up
76973-image.png

Hope this helps.

Regards
Navtej S



image.png (45.1 KiB)
image.png (16.5 KiB)
image.png (60.5 KiB)
· 1 ·
10 |1000 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.

@NavtejSaini-MSFT indeed this was the case - thanks for clarification.

0 Votes 0 ·