microsoft / microsoft/vscode-pgsql
ValidationError on startup
Nobody has claimed this yet.
- Dominant language
- No language data
- Stars
- 395
- Forks
- 33
- Avg merge
- 1h 46m
- Merged PRs (30d)
- 3
Description
Hello ! Sounds like there is an issue somewhere but I can't find that log setting anywhere.
Describe the bug
When I start the extension I have this message :
pgsql: PostgreSQL Tools Service terminated unexpectedly.
Related to this log :
Traceback (most recent call last):
File "ossdbtoolsservice_main.py", line 16, in
File "", line 1027, in _find_and_load
File "", line 1006, in _find_and_load_unlocked
File "", line 688, in _load_unlocked
File "pyimod02_importers.py", line 457, in exec_module
File "ossdbtoolsservice/mcp_server/main.py", line 18, in
File "", line 1027, in _find_and_load
File "", line 1006, in _find_and_load_unlocked
File "", line 688, in _load_unlocked
File "pyimod02_importers.py", line 457, in exec_module
File "ossdbtoolsservice/mcp_server/mcp_server.py", line 7, in
File "", line 1027, in _find_and_load
File "", line 1006, in _find_and_load_unlocked
File "", line 688, in _load_unlocked
File "pyimod02_importers.py", line 457, in exec_module
File "fastmcp/init.py", line 8, in
File "pydantic_settings/main.py", line 188, in init
File "pydantic/main.py", line 253, in init
pydantic_core._pydantic_core.ValidationError: 1 validation error for Settings
log_level
Input should be 'DEBUG', 'INFO', 'WARNING', 'ERROR' or 'CRITICAL' [type=literal_error, input_value='WARN', input_type=str]
For further information visit https://errors.pydantic.dev/2.11/v/literal_error
[PYI-11258:ERROR] Failed to execute script 'ossdbtoolsservice_main' due to unhandled exception!
[Error - 2:42:22 PM] Connection to server got closed. Server will not be restarted.
To Reproduce
Steps to reproduce the behavior:
- Install the extension (last version 1.22.0)
- Click on the extension's tab, in attempt to create a new connection.
Expected behavior
Well... just a starting extension where I could create a connection
VS Code version
Version: 1.120.0 (user setup)
Commit: 0958016b2af9f09bb4257e0df4a95e2f90590f9f
Date: 2026-05-12T20:17:22Z
Electron: 39.8.8
ElectronBuildId: 13870025
Chromium: 142.0.7444.265
Node.js: 22.22.1
V8: 14.2.231.22-electron.0
OS: Windows_NT x64 10.0.26100
Contributor guide
No contributing guide indexed for this repository
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
Start at ossdbtoolsservice_main.py and follow the startup imports through ossdbtoolsservice/mcp_server/main.py and mcp_server.py to the Settings initialization shown in the traceback. Verify the configured log level against the accepted values, then reproduce startup from the extension and confirm that the PostgreSQL Tools Service remains connected.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python, vscode
- Domain
- database, tooling
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 58/100