Thread: In-Context Debugging - pgAdmin
- Linux/MacOS: ~/.pgadmin/pgadmin4.log
- Windows: %APPDATA%\pgAdmin\pgadmin4.log
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.
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
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 ToshniwalpgAdmin Hacker | Software Architect | edbpostgres.com"Don't Complain about Heat, Plant a TREE"
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 ToshniwalpgAdmin Hacker | Software Architect | edbpostgres.com"Don't Complain about Heat, Plant a TREE"