mirror of
https://github.com/levinsv/pgadmin3.git
synced 2026-05-15 14:15:49 -06:00
[GH-ISSUE #36] pgAdmin Server Status Icon Issue #36
Labels
No labels
bug
bug
enhancement
pull-request
question
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/pgadmin3#36
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @winmedatgmaildotcom on GitHub (Sep 26, 2023).
Original GitHub issue: https://github.com/levinsv/pgadmin3/issues/36
Thank you very much for keeping pgAdmin 3 updated with the latest PostgreSQL versions.
I have encountered an issue with the Server Status and was hoping for some assistance. As seen in the attached screenshot, the “Cancel Query” and “Terminate backend” icon buttons do not seem to be functioning properly. Whenever I click on a target session, it briefly flashes but then becomes disabled and inactive. I am unsure if this is a bug or if there is a workaround that I could try.
@levinsv commented on GitHub (Sep 27, 2023):
You need to shift the focus to the "Activity" window. To do this, click on the title of the "Activity" window.
@winmedatgmaildotcom commented on GitHub (Sep 27, 2023):
Thank you for the guidence. It worked but now only 'Cancel Query' is enabled. The 'Terminate backend' button is still disabled. Am I missing something again?
@winmedatgmaildotcom commented on GitHub (Sep 27, 2023):
Thank you for the guidence. It worked but now only 'Cancel Query' is enabled. The 'Terminate backend' button is still disabled. Am I missing something again?
@levinsv commented on GitHub (Sep 27, 2023):
pgAdmin3 did not find the pg_terminate_backend (pid integer) function on your server.
SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2 FROM pg_proc JOIN pg_namespace n ON n.oid=pronamespace WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex','bt_index_parent_check') AND nspname IN ('pg_catalog', 'public')@winmedatgmaildotcom commented on GitHub (Sep 27, 2023):
Found out the terminate backend works on PostgreSQL 13 but not on version 15. Here is the query result on both servers.
The query result in version 13.
The query result in version 15.
@levinsv commented on GitHub (Sep 27, 2023):
The fix is in this commit
23b6a2a458@winmedatgmaildotcom commented on GitHub (Sep 27, 2023):
Perfect! The issue is resolved after the fix.
Thank you!