Debugger freeze

From: Stefan Stefanov <stefanov(dot)sm(at)abv(dot)bg>
To: pgadmin-support(at)postgresql(dot)org
Subject: Debugger freeze
Date: 2016-02-11 18:36:44
Message-ID: 1452869366.43922.1455215804457.JavaMail.apache@nm32.abv.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Dear Sir or Madam,

I am writing to report a bug in pgadmin III 1.22.0 running on Windows 7 x64 connected to PostgreSQL 9.5.0 VC++ build 1800, 64 bit.
To reproduce the bug create this trivial function using SQL query editor. The example is in "playground" schema.

create function playground.dbg_test() returns void as
$$
declare

i integer;

t text;
begin

for i in 1 .. 100 loop

t := 'XYZ' || to_char(i, '999');

raise notice 'Round %', t;

end loop;
end;
$$ language plpgsql;

Right-click the function in Object browser then debug. Step a few times through the loop then take some time doing other things in pgadmin iii (browse data, run queries etc.) then return to the debug window and step again a few times. The debug window usually freezes (debug.png).
Two locks remain (server status.png). The server may be cleared by cancelling the query of the global listener (pid 7748 in the example) but then pgadmin windows
stop responding.

This is preventing me from using the debugger and I need it badly.


Thank you for the great job you are doing.

Sincerely, Stefan

Attachment Content-Type Size
debug.png application/octet-stream 21.5 KB
server status.png application/octet-stream 31.7 KB

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-02-12 13:45:13 Re: Debugger freeze
Previous Message Sanket Mehta 2016-02-10 10:23:08 Re: DEFAULT PRIVILEGES incorrect