Обсуждение: Debugger locks up
We have a PgAdmin PLPgSQL debugger issue.
We are running it on the same server with the database and there is not much else besides Postgres running on that server. Windows server 2012 OS.
We have tried running it as the admin role and a superuser role – neither one fixes the issue.
While it is running, we can typically step into/over 2 or things, and then the debugger just locks up.
We end up having to kill the process in Task Manager after it locks up – waiting, etc., change nothing.
Has anyone had this issue and have any good ideas? We have Postgres (and the debugger) running on several Win 2012 environments (server and desktop versions) and they all have the same issue. SO perhaps it is some kind of config issue?
Postgres 9.4
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Bradley, Christie D
Sent: Tuesday, November 10, 2015 7:24 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Debugger locks up
We have a PgAdmin PLPgSQL debugger issue.
We are running it on the same server with the database and there is not much else besides Postgres running on that server. Windows server 2012 OS.
We have tried running it as the admin role and a superuser role – neither one fixes the issue.
While it is running, we can typically step into/over 2 or things, and then the debugger just locks up.
We end up having to kill the process in Task Manager after it locks up – waiting, etc., change nothing.
Has anyone had this issue and have any good ideas? We have Postgres (and the debugger) running on several Win 2012 environments (server and desktop versions) and they all have the same issue. SO perhaps it is some kind of config issue?
On 11/10/15 9:30 AM, Bradley, Christie D wrote: > Postgres 9.4 > > *From:* pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] *On Behalf Of *Bradley, > Christie D > *Sent:* Tuesday, November 10, 2015 7:24 AM > *To:* pgsql-general@postgresql.org > *Subject:* [GENERAL] Debugger locks up > > We have a PgAdmin PLPgSQL debugger issue. > > We are running it on the same server with the database and there is not > much else besides Postgres running on that server. Windows server 2012 OS. > > We have tried running it as the admin role and a superuser role – > neither one fixes the issue. > > While it is running, we can typically step into/over 2 or things, and > then the debugger just locks up. > > We end up having to kill the process in Task Manager after it locks up – > waiting, etc., change nothing. > > Has anyone had this issue and have any good ideas? We have Postgres (and > the debugger) running on several Win 2012 environments (server and > desktop versions) and they all have the same issue. SO perhaps it is > some kind of config issue? If you get a stack trace of the stuck process someone as well as the debugger someone might be able to help. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com