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.toshniwal@enterprisedb.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@gmail.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

"Don't Complain about Heat, Plant a TREE"