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

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

> 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.
>
Thanks.
In that case - we need to create a development environment on windows 8 and
see what's going wrong.
Can you please do it for us (when time permits)?

>
>
> 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*
>

--
--

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>