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.toshni...@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 <mowaisk...@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* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" >
