Re: In-Context Debugging - pgAdmin

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