microsoft / microsoft/vscode-pgsql

ValidationError on startup

Open
#263 7 comments 1 reaction 0 assignees View on GitHub

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:

  1. Install the extension (last version 1.22.0)
  2. 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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.