Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,431 questions
postgresql - azuresu wrong backend_type encoding in pg_stat_activity
![](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(112.00000000000001, 4%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gajzler, Simon
5
Reputation points
When I list pg_stat_activity, I see process from azuresu user which has wrong encoded text in backend_type column:
select * from pg_stat_activity;
datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start |
xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | que
ry_id | query | backend_type
24601 | azure_sys | 480 | | 10 | azuresu | | | | | 2024-07-23 13:29:54.360536+00 | | | | IPC | BgWorkerStartup | | | | | | ▒\x14▒(▒\x7F
Azure Database for PostgreSQL
{count} vote
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator2024-07-24T22:24:25.6666667+00:00 @Gajzler, Simon Thank you for reaching out.
Could you please check the Postgres version you are using and update if necessary.
Regards,
Oury
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-07-31T18:39:38.5533333+00:00 I am checking internally if this is a known issue and will get back to you as soon as got a confirmation. Does it have a business impact.?
Regards,
Oury
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-08-19T17:30:14.44+00:00 Thank you for being patient while checking on this issue.
We have identified this issue as a bug and fix is expected for upcoming deployment which is by the end of the month - Mid September. We are sorry for the inconvenience this might have caused.
We will keep you posted on any updates.
Regards,
Oury
-
![](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(137.6, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Savan Dosanjh 0 Reputation points2024-10-14T14:46:45.5766667+00:00 Currently still seeing the same issue with an invalid encoding for the backend_type.
Could you give an estimation time for the fix?
Kind regards,
Savan
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-10-17T21:48:50.5466667+00:00 @Savan Dosanjh This issue was already fixed. If you are still facing the same issue. I would suggest creating a support ticket sharing your impacted server then we can investigate further.
Regards,
Oury
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-10-17T21:49:35.2+00:00
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more