Re: pgAdmin debugger hangs on Windows 8 after closing debug window

Hi Ashesh

I have tested this issue on Windows 7 64 bit and Windows 8. I am able to
reproduce the issue on Windows 8, but not able to reproduce it on Windows
7. I haven't open the second instance of the pgAdmin. I have followed the
steps mentioned in the email, instead of opening the second instance of the
pgAdmin, I have tried with the same instance and with the help of query
tool I have insert the values in the table.

This bug is reproducible only when Play button from the toolbar is pressed,
it works with F5 key. First time I am able to debug the function but when I
pressed the play button then onwards not able to debug, execution marker is
not visible but it stops at the first line of the function and all the
toolbar option is disabled on the debugger window, so we can't do anything.
Status bar of the query tool is showing query is running.

On Tue, Oct 29, 2013 at 4:34 PM, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com
> wrote:

> Ok. Will try that
>
>
> On Tue, Oct 29, 2013 at 3:55 PM, Ashesh Vashi <
> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> Akshay,
>>
>> Can you also try?
>> On 29 Oct 2013 14:17, "EDUARDO ESTEBAN" <eduardo(at)deisa(dot)net> wrote:
>>
>>> **
>>> I don´t really know what to say. I have made the same test several times
>>> on 2 different computers (one with Windows 7 Pro and another one with
>>> Windows 8) and both fails.
>>> I am using PostgreSQL 9.3.1-1 and pgAdmin 1.18.1
>>>
>>> Thank you.
>>>
>>>
>>> ------------------------------
>>> *De:* Ashesh Vashi [mailto:ashesh(dot)vashi(at)enterprisedb(dot)com]
>>> *Enviado el:* martes, 29 de octubre de 2013 7:50
>>> *Para:* EDUARDO ESTEBAN
>>> *CC:* pgadmin-support
>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>> after closing debug window
>>>
>>> On Mon, Oct 28, 2013 at 11:36 PM, EDUARDO ESTEBAN <eduardo(at)deisa(dot)net>wrote:
>>>
>>>> **
>>>> Try to push the play button on the toolbar insted of pressing F5 Key...
>>>> With F5 worked but noy when pressing the play button (wich should be
>>>> equivalent).
>>>>
>>> Both are same, same function is attached to both events.
>>>
>>>>
>>>> Thank you
>>>>
>>>> ------------------------------
>>>> *De:* Ashesh Vashi [mailto:ashesh(dot)vashi(at)enterprisedb(dot)com]
>>>> *Enviado el:* lunes, 28 de octubre de 2013 18:57
>>>>
>>>> *Para:* EDUARDO ESTEBAN
>>>> *CC:* pgadmin-support
>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>>> after closing debug window
>>>>
>>>> On Mon, Oct 28, 2013 at 10:51 PM, EDUARDO ESTEBAN <eduardo(at)deisa(dot)net>wrote:
>>>>
>>>>> **
>>>>> Thank you for your fast answer.
>>>>> I don´t know what you exactly mean by session, but please let me
>>>>> resume the steps to reproduce the problem:
>>>>>
>>>>> 1- To test it, use the example (database, table and trigger function y
>>>>> supplied)
>>>>> 2- Open one pgAdmin (we call this pgAdmin 1) and "set breakpoint"
>>>>> on the trigger function isql_country_b_trigger.
>>>>> 3- Open another pgAdmin (we call this pgAdmin 2) and insert a
>>>>> record in the COUNTRY_COU table (only the cou_id field is mandatory)
>>>>> 3- On pgAdmin 1 you will see that the debugger is waiting..., press F5
>>>>> and don´t close any window
>>>>> 4- On pgAdmin 2 insert a new record in the COUNTRY_COU table
>>>>> 5- pgAdmin 2 is frozen and pgAdmin 1 is not sttoped in de debug window
>>>>> as it was on step 3.
>>>>>
>>>> Unfortunately - I am not able reproduce the scenario.
>>>> I tried multiple times and multiple ways without luck...
>>>>
>>>>>
>>>>> Regards.
>>>>> Eduardo Esteban
>>>>>
>>>>> ------------------------------
>>>>> *De:* Ashesh Vashi [mailto:ashesh(dot)vashi(at)enterprisedb(dot)com]
>>>>> *Enviado el:* lunes, 28 de octubre de 2013 17:59
>>>>>
>>>>> *Para:* EDUARDO ESTEBAN
>>>>> *CC:* pgadmin-support
>>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>>>> after closing debug window
>>>>>
>>>>> Do mean to say that - the debugger does not remember the
>>>>> break-points for two different sessions?
>>>>> Then yes - it is not remembering them at the moment.
>>>>> I will send a patch to resolve the issue soon.
>>>>>
>>>>>
>>>>> On Mon, Oct 28, 2013 at 9:14 PM, EDUARDO ESTEBAN <eduardo(at)deisa(dot)net>wrote:
>>>>>
>>>>>> **
>>>>>> Dear Ashesh,
>>>>>> I told you that the pgAdmin debug was working on 9.3.1.-1 but making
>>>>>> a deeper test it doesn´t work well at all.
>>>>>> Once a breakpoint is reached, if F5 key is pressed (to continue) if
>>>>>> the breakpoint is reached later again then it doesn´t stop on the debuggged
>>>>>> function but at the same time the function doesn´t continue with the
>>>>>> execution (it seems that the breakpoint is reached but it doesn´t show up
>>>>>> and the xecution of the function is stopped)
>>>>>> You can try it with the same test example that i described on my
>>>>>> previous email.
>>>>>>
>>>>>>
>>>>>> Thank you in advance
>>>>>> Eduardo Esteban
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------
>>>>>> *De:* pgadmin-support-owner(at)postgresql(dot)org [mailto:
>>>>>> pgadmin-support-owner(at)postgresql(dot)org] *En nombre de *Ashesh Vashi
>>>>>> *Enviado el:* martes, 22 de octubre de 2013 19:40
>>>>>>
>>>>>> *Para:* EDUARDO ESTEBAN
>>>>>> *CC:* pgadmin-support
>>>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>>>>> after closing debug window
>>>>>>
>>>>>>
>>>>>> On 22 Oct 2013 20:16, "EDUARDO ESTEBAN" <eduardo(at)deisa(dot)net> wrote:
>>>>>> >
>>>>>> > Dear Ashesh.
>>>>>> > I have tested the pgAdmin debugger with PostgreSQL 9.3.1 and it
>>>>>> works fine on Windows 8 x64.
>>>>>> Glad to hear that...
>>>>>>
>>>>>> -- Ashesh
>>>>>> >
>>>>>> > Thank you very much for your help.
>>>>>> > Regards.
>>>>>> > Eduardo Esteban
>>>>>> >
>>>>>> > ________________________________
>>>>>> > De: pgadmin-support-owner(at)postgresql(dot)org [mailto:
>>>>>> pgadmin-support-owner(at)postgresql(dot)org] En nombre de Ashesh Vashi
>>>>>> > Enviado el: martes, 22 de octubre de 2013 15:49
>>>>>> >
>>>>>> > Para: EDUARDO ESTEBAN
>>>>>> > CC: pgadmin-support
>>>>>> > Asunto: Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>>>>> after closing debug window
>>>>>> >
>>>>>> > On Mon, Oct 21, 2013 at 8:12 PM, EDUARDO ESTEBAN <eduardo(at)deisa(dot)net>
>>>>>> wrote:
>>>>>> >>
>>>>>> >> Dear Ashesh,
>>>>>> >> Thank you for your fast answer.
>>>>>> >> It fails with any function or trigger that i have tested it always
>>>>>> on Windows 8 x64 and i have tested with several pgAdmin and PostgreSQL
>>>>>> versions on Windows 8.
>>>>>> >> Anyway here there are the details of the version and a example to
>>>>>> test.
>>>>>> >> PostgreSQL 9.2.4 on x64
>>>>>> >> Compiled by Visual C++ build 1600 64 bit
>>>>>> >>
>>>>>> >> PGAdmin 1.16.1 April 2 2013 REV: REL-1_16_1
>>>>>> >
>>>>>> > Hi,
>>>>>> >
>>>>>> > Thanks for the inputs...
>>>>>> >
>>>>>> > FYI - We've redesigned the debugger code completely in pgAdmin 1.18.
>>>>>> > Unfortunately - we found a lot of design issues with debugger code
>>>>>> in older version, which couldn't be tracked and fixed, which forced us to
>>>>>> redesign ti for the latest version.
>>>>>> >
>>>>>> > Please use the latest pgAdmin III (1.18.1) bundled with one-click
>>>>>> installer PostgreSQL 9.3.1 , or you can download it for windows from this
>>>>>> link:
>>>>>> > http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/win32/
>>>>>> >
>>>>>> > Can you please share your experience with the latest pgAdmin III?
>>>>>> >>
>>>>>> >>
>>>>>> >> PostgreSQL and pgAdmin are installed using the Windows installer
>>>>>> provided by Enterprisedb from the download page of postgresql.org
>>>>>> >>
>>>>>> >> The database coding by default is UTF8 but i change it to WIN1252
>>>>>> once the database is created.
>>>>>> >> These are all the steps to reproduce the problem:
>>>>>> >>
>>>>>> >> -- CREATE DATABASE
>>>>>> >> CREATE DATABASE "i.TEST.2013.0"
>>>>>> >> WITH OWNER = postgres
>>>>>> >> TABLESPACE = pg_default
>>>>>> >> LC_COLLATE = 'Spanish_Spain.1252'
>>>>>> >> LC_CTYPE = 'Spanish_Spain.1252'
>>>>>> >> CONNECTION LIMIT = -1;
>>>>>> >>
>>>>>> >> --UPDATE DATABASE CODING
>>>>>> >> update "pg_catalog"."pg_database" set encoding=24 where
>>>>>> datname='i.TEST.2013.0'
>>>>>> >>
>>>>>> >> -- ACTIVATE DEBUGGER
>>>>>> >> CREATE EXTENSION pldbgapi;
>>>>>> >>
>>>>>> >> -- CREATE TABLE
>>>>>> >> CREATE TABLE "COUNTRY_COU"
>>>>>> >> (
>>>>>> >> cou_id character varying(2) NOT NULL DEFAULT ''::character
>>>>>> varying, -- ID ISO 2
>>>>>> >> cou_iso3 character varying(3), -- ISO 3
>>>>>> >> cou_countryname character varying(100), -- País
>>>>>> >> cou_isocode integer, -- Cod. ISO
>>>>>> >> cou_flag bytea, -- Bandera
>>>>>> >> CONSTRAINT cou_id PRIMARY KEY (cou_id) -- ID ISO 2
>>>>>> >> )
>>>>>> >> WITH (
>>>>>> >> OIDS=FALSE
>>>>>> >> );
>>>>>> >> ALTER TABLE "COUNTRY_COU"
>>>>>> >> OWNER TO postgres;
>>>>>> >>
>>>>>> >> -- Index: cou_countryname
>>>>>> >>
>>>>>> >> -- DROP INDEX cou_countryname;
>>>>>> >>
>>>>>> >> CREATE UNIQUE INDEX cou_countryname
>>>>>> >> ON "COUNTRY_COU"
>>>>>> >> USING btree
>>>>>> >> (cou_countryname);
>>>>>> >> -- Index: cou_iso3
>>>>>> >>
>>>>>> >> -- DROP INDEX cou_iso3;
>>>>>> >>
>>>>>> >> CREATE UNIQUE INDEX cou_iso3
>>>>>> >> ON "COUNTRY_COU"
>>>>>> >> USING btree
>>>>>> >> (cou_iso3);
>>>>>> >> -- Index: cou_isocode
>>>>>> >>
>>>>>> >> -- DROP INDEX cou_isocode;
>>>>>> >>
>>>>>> >> CREATE UNIQUE INDEX cou_isocode
>>>>>> >> ON "COUNTRY_COU"
>>>>>> >> USING btree
>>>>>> >> (cou_isocode);
>>>>>> >> -- CREATE FUNCTION
>>>>>> >> CREATE OR REPLACE FUNCTION isql_country_b_trigger()
>>>>>> >> RETURNS trigger AS
>>>>>> >> $BODY$
>>>>>> >> DECLARE
>>>>>> >>
>>>>>> >> BEGIN
>>>>>> >> IF (TG_OP = 'INSERT') OR (TG_OP = 'UPDATE') THEN
>>>>>> >> IF NEW.cou_id IS NULL THEN
>>>>>> >> RAISE 'cou_id is null' USING ERRCODE = '42000';
>>>>>> >> END IF;
>>>>>> >> IF NEW.cou_iso3 IS NULL THEN
>>>>>> >> NEW.cou_iso3 = NEW.cou_id;
>>>>>> >> END IF;
>>>>>> >> IF NEW.cou_countryname IS NULL THEN
>>>>>> >> NEW.cou_countryname = NEW.cou_id;
>>>>>> >> END IF;
>>>>>> >> RETURN NEW;
>>>>>> >> ELSIF (TG_OP = 'DELETE') THEN
>>>>>> >> RETURN OLD;
>>>>>> >> ELSIF (TG_OP = 'UPDATE') THEN
>>>>>> >> RETURN NEW;
>>>>>> >> END IF;
>>>>>> >> RETURN NULL;
>>>>>> >> END;
>>>>>> >> $BODY$
>>>>>> >> LANGUAGE plpgsql VOLATILE
>>>>>> >> COST 1000;
>>>>>> >> ALTER FUNCTION isql_country_b_trigger()
>>>>>> >> OWNER TO postgres;
>>>>>> >> --CREATE TRIGGER
>>>>>> >> CREATE TRIGGER isql_tri_0_b_iud_country_cou
>>>>>> >> BEFORE INSERT OR UPDATE OR DELETE
>>>>>> >> ON "COUNTRY_COU"
>>>>>> >> FOR EACH ROW
>>>>>> >> EXECUTE PROCEDURE isql_country_b_trigger();
>>>>>> >>
>>>>>> >>
>>>>>> >>
>>>>>> >> Finally, to reproduce the problem open one pgAdmin Window to debug
>>>>>> the trigger function.
>>>>>> >>
>>>>>> >> Open another pgAdmin Window and insert a record on the table.
>>>>>> >>
>>>>>> >> When the debug Window is closed then the pgAdmin freezes and it
>>>>>> should be closed from the task manager.
>>>>>> >>
>>>>>> >>
>>>>>> >> Thank you in advance
>>>>>> >> Eduardo Esteban
>>>>>> >>
>>>>>> >>
>>>>>> >>
>>>>>> >> ________________________________
>>>>>> >> De: pgadmin-support-owner(at)postgresql(dot)org [mailto:
>>>>>> pgadmin-support-owner(at)postgresql(dot)org] En nombre de Ashesh Vashi
>>>>>> >> Enviado el: lunes, 21 de octubre de 2013 13:08
>>>>>> >> Para: EDUARDO ESTEBAN
>>>>>> >> CC: pgadmin-support
>>>>>> >> Asunto: Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8
>>>>>> after closing debug window
>>>>>> >>
>>>>>> >> Hi Eduardo Esteban,
>>>>>> >>
>>>>>> >> Can you please share the pl/pgsql for debugging?
>>>>>> >> (We require that to understand the function structure. i.e. return
>>>>>> values, arguments, etc.)
>>>>>> >>
>>>>>> >> We will also require following information:
>>>>>> >> 1. pgAdmin III version
>>>>>> >> 2. OS version
>>>>>> >> 3. Database server version
>>>>>> >>
>>>>>> >> NOTE: A step by step reproduction steps will be very helpful.
>>>>>> >>
>>>>>> >> On Mon, Oct 21, 2013 at 4:25 PM, EDUARDO ESTEBAN <
>>>>>> eduardo(at)deisa(dot)net> wrote:
>>>>>> >>>
>>>>>> >>> Hi,
>>>>>> >>> When using the debugger in pgAdmin on Windows 8 debugging any
>>>>>> pl/pgsql funtion it hangs and the pgAdmin should be close from the task
>>>>>> manager.
>>>>>> >>> This only happens on whatever version of pgAdmin used on Windows
>>>>>> 8 64 bits (for example pgAdmin 1.18.0).
>>>>>> >>> To reproduce the problem try to debug a pl/pgsql function and
>>>>>> after the debug window shows, try to close the debug window and you will
>>>>>> see that the pgAdmin hangs and it should be restarted.
>>>>>> >>>
>>>>>> >>> Thank you in advance.
>>>>>> >>> Eduardo Esteban
>>>>>> >>>
>>>>>> >>
>>>>>> >>
>>>>>> >>
>>>>>> >>
>>>>>> >> --
>>>>>> >> --
>>>>>> >>
>>>>>> >> Thanks & Regards,
>>>>>> >>
>>>>>> >> Ashesh Vashi
>>>>>> >> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>>>>> >>
>>>>>> >>
>>>>>> >>
>>>>>> >> http://www.linkedin.com/in/asheshvashi
>>>>>> >
>>>>>> > --
>>>>>> >
>>>>>> > Thanks & Regards,
>>>>>> >
>>>>>> > Ashesh Vashi
>>>>>> > EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>>>>> >
>>>>>> >
>>>>>> > http://www.linkedin.com/in/asheshvashi
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> --
>>>>>
>>>>> Thanks & Regards,
>>>>>
>>>>> Ashesh Vashi
>>>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com>
>>>>>
>>>>>
>>>>>
>>>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> --
>>>>
>>>> Thanks & Regards,
>>>>
>>>> Ashesh Vashi
>>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com>
>>>>
>>>>
>>>>
>>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
>>>>
>>>
>>>
>>>
>>> --
>>> --
>>>
>>> Thanks & Regards,
>>>
>>> Ashesh Vashi
>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com>
>>>
>>>
>>>
>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
>>>
>>
>
>
> --
> *Akshay Joshi*
> *Principal Software Engineer *
> *
> *
> **
> *
> *
> *Phone: +91 20-3058-9517
> Mobile: +91 976-788-8246*
>

--
*Akshay Joshi*
*Principal Software Engineer *
*
*
**
*
*
*Phone: +91 20-3058-9517
Mobile: +91 976-788-8246*