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

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*