microsoft / microsoft/vscode-pgsql

Extension fails to load due to missing GLIBC 2.35

Open
#19 16 comments 16 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

Describe the bug

The pgsql extension does not load. A notification appears: "pgsql: PostgreSQL Tools Service component could not start."

To Reproduce

  1. Connect to a remote CentOS 7.9.2009 host using Remote SSH from a MacBook Pro (Apple M4 Pro, macOS 15.5)
  2. Install or enable the ms-ossdata.vscode-pgsql extension
  3. Attempt to use the extension
  4. Observe error notification and extension fails to start

Expected behavior

The extension should load and initialize the PostgreSQL Tools Service successfully, making its features available in VS Code.

Screenshots

N/A (see logs below)

VS Code version

Client Machine:

Model Name:	MacBook Pro
Model Identifier:	Mac16,7
Model Number:	MX2X3LL/A
Chip:	Apple M4 Pro
Total Number of Cores:	14 (10 performance and 4 efficiency)
Memory:	24 GB
System Version:	macOS 15.5 (24F74)

Remote SSH Host:

LSB Version:    :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description:    CentOS Linux release 7.9.2009 (Core)
Release:        7.9.2009
Codename:       Core

Extension Logs

[2:41:46 PM] [PgToolsService Initialization] ServiceDownloadProvider initialized
[2:41:46 PM] [PgToolsService Initialization] Initializing PostgreSQL Tools Service for the pgsql extension.
[2:41:46 PM] [PgToolsService Initialization] Note: pgsql commands will be available after installing the service.
[2:41:46 PM] [PgToolsService Initialization] 
[2:41:46 PM] [PgToolsService Initialization] Platform: linux, x86_64, name=centos, version=7 (CentOS)
[2:41:46 PM] [PgToolsService Initialization] 
[2:41:46 PM] [PgToolsService Initialization] Checking server path for runtime ID: CentOS_7
[2:41:46 PM] [PgToolsService Initialization] Server path not found for runtime ID: CentOS_7
[2:41:46 PM] [PgToolsService Initialization] Downloading server files
[2:41:46 PM] [PgToolsService Initialization] Using tools server filename: linux-x64.tar.gz
[2:41:46 PM] [PgToolsService Initialization] Installing PostgreSQL Tools Service to /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS.
[2:41:46 PM] [PgToolsService Initialization] Downloading https://github.com/microsoft/pgsql-tools/releases/download/v2.0.3/pgsqltoolsservice-linux-x64.tar.gz
[2:41:47 PM] [PgToolsService Initialization] (81795 KB) ....................[Verbose]: Downloaded to /tmp/package-6102akMl5M2OT4kw.tmp...
[2:41:56 PM] [PgToolsService Initialization]  Done!
[2:41:56 PM] [PgToolsService Initialization] Installing ...
[2:42:21 PM] [PgToolsService Initialization] Done! 1824 files unpacked.

[2:42:21 PM] [PgToolsService Initialization] Server files downloaded to: /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/ossdbtoolsservice_main
[2:42:21 PM] [PgToolsService Initialization] Attempting to initialize language client
[2:42:21 PM] [PgToolsService Initialization] Checking overrides for language client initialization
[2:42:21 PM] [PgToolsService Initialization] Creating the language client with options: {"command":"/root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/ossdbtoolsservice_main","args":["--log-file","/root/.vscode-server/data/logs/20250520T144045/exthost1/ms-ossdata.vscode-pgsql/sqltools.log","--tracing-level","All","--application-name","Code","--data-path","/root/.config","--enable-sql-authentication-provider"],"transport":0}
[2:42:21 PM] [PgToolsService Initialization] Language client created
[2:42:21 PM] [PgToolsService Initialization] Starting language client
[2:42:21 PM] [PgToolsService Initialization] Language client started
[2:42:21 PM] [PgToolsService Initialization] Waiting for client to be ready
[Error - 2:42:21 PM] Connection to server is erroring. Shutting down server.
[PYI-9544:ERROR] Failed to load Python shared library '/root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/_internal/libpython3.10.so': dlopen: /lib64/libm.so.6: version `GLIBC_2.35' not found (required by /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/_internal/libpython3.10.so)

Additional context

It appears the extension's service is built against GLIBC 2.35, but CentOS 7 only provides GLIBC 2.17. This makes the extension unusable on CentOS 7 remote hosts.

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 with the CentOS_7 runtime selection and the downloaded pgsqltoolsservice-linux-x64.tar.gz artifact described in the issue, then inspect the packaged ossdbtoolsservice_main and its _internal/libpython3.10.so dependency. Reproduce on CentOS 7 and identify a compatible service build or packaging path. Done means the extension service initializes without requiring GLIBC_2.35 and the connection error no longer appears.

Written by the indexing model from the issue text.

Assessment

Tech stack
linux, postgresql, python, vscode
Domain
databases, devtools
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
43/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.