From: | Owais Khan <mowaiskhan(at)gmail(dot)com> |
---|---|
To: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: In-Context Debugging - pgAdmin |
Date: | 2021-10-22 13:27:24 |
Message-ID: | CAFCVw4+mykpyGUe0T2n-pO+E0vWkWE2CrNR3g9H9GABVreOtUg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi Aditya,
I removed logs and started pgAdmin fresh and repeated the above steps.
Following are logs. Thanks for your help.
2021-10-22 17:16:34,895: WARNING werkzeug: WebSocket transport
not available. Install simple-websocket for improved performance.
2021-10-22 17:17:56,676: ERROR pgadmin: Failed to execute query
(execute_async) for the server #3 - CONN:1137473(Query-id: 2743861):
Error Message:ERROR: execute cannot be used while an asynchronous query is
underway
2021-10-22 17:21:56,398: ERROR pgadmin: Failed to execute query
(execute_async) for the server #3 - CONN:8026700(Query-id: 4853377):
Error Message:ERROR: execute cannot be used while an asynchronous query is
underway
On Fri, Oct 22, 2021 at 4:55 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> Hi Owais,
>
> Can you share pgAdmin logs ?
>
> - Linux/MacOS: ~/.pgadmin/pgadmin4.log
> - Windows: %APPDATA%\pgAdmin\pgadmin4.log
>
>
>
> On Fri, Oct 22, 2021 at 3:48 PM Owais Khan <mowaiskhan(at)gmail(dot)com> wrote:
>
>> Hi Team,
>>
>> I am using pgAdmin 6.1 on MacOS 11.6 against a PG Database 10 running on
>> CentOS in Azure.
>>
>> I am observing that whenever I try to do the following it breaks.
>>
>> 1) I open up "Query Tool" in pgAdmin and write a PL/SQL block containing
>> 2 user defined function calls - Let's say first one is A and the second one
>> is B.
>>
>> 2) I right click function B and select "Set Breakpoint" - pgAdmin starts
>> showing a circle doing rounds saying "Waiting target to be invoked"
>>
>> 3) I select all whole PL/SQL block in point-1 and press "run"
>>
>> 4) Debugger breaks into function B as expected but as soon as I say "step
>> over" 2nd time it gives the following error.
>>
>> Error while executing step over in debugging session.
>>
>> I can't seem to figure out what's the issue. Appreciate your help.
>>
>> Thanks,
>> Owais.
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>
From | Date | Subject | |
---|---|---|---|
Next Message | Saif Manai | 2021-10-22 13:38:07 | Re: pgAdmin commandLine |
Previous Message | Aditya Toshniwal | 2021-10-22 11:56:51 | Re: pgAdmin4 6.0+ http mixed content problem |