Re: In-Context Debugging - pgAdmin

Hi Owais,

Please raise the bug request here with steps and logs here for the team to
investigate further -
https://redmine.postgresql.org/projects/pgadmin4/issues/new

On Fri, Oct 22, 2021 at 6:57 PM Owais Khan <mowaiskhan(at)gmail(dot)com> wrote:

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

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"