pgadmin-org / pgadmin-org/pgadmin4
Debugger Error "Error while polling result"
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
Summary
The pgAdmin 4 debugger fails during execution of a stored procedure/function, returning a "Debugger Error: Error while polling result" popup. Browser console logs indicate a 500 Internal Server Error on the /debugger/poll_result and /debugger/start_listener endpoints.
2. Environment Information
• pgAdmin 4 Version: (9.14)
• Mode: Desktop / Server (whichever you are using)
• Browser: Chrome (indicated by DevTools)
• OS: Windows
• PostgreSQL Version: (e.g., postgresql-18.3-3-windows-x64)
• pldbgapi extension version: (Run SELECT * FROM pg_extension WHERE extname = 'pldbgapi';)
- Steps to Reproduce
- Open pgAdmin 4 and connect to a database where the pldbgapi extension is installed and added to shared_preload_libraries.
- Navigate to Schemas > [Schema Name] > Procedures (or Functions).
- Right-click a procedure/Function (e.g., sp_f... as seen in your screenshot) and select Debugging > Setbreak point
- Again select Debugging > Setbreak point.
- Observe the debugger interface initializing.
- Actual Behavior: A "Debugger Error" dialog appears stating "Error while polling result," and the debugger fails to advance. The browser console shows AxiosError: Request failed with status code 500.
- Expected Behavior: The debugger should initialize, stop at the first line of code, and allow stepping through the logic.
- Error Details (From DevTools)
• Endpoint: /debugger/poll_result/[SessionID]
• Status Code: 500 (Internal Server Error)
• Console Trace: AxiosError: Request failed with status code 500 at Ve (vendor.others.js...)
Screenshot:
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the debugger failure using the listed procedure steps and inspect the /debugger/poll_result/[SessionID] and /debugger/start_listener requests alongside the server error details. Trace the 500 response to its backend cause; done means the debugger initializes, stops at the first line, and supports stepping without the polling error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100