zilliztech / zilliztech/VectorDBBench
psql: SSL SYSCALL error at docker image
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 1.2k
- Forks
- 438
- Avg merge
- 1d 4h
- Merged PRs (30d)
- 1
Description
The error is psql: SSL SYSCALL error: Success
This happens when we use psql or psycopg->libpq5 to connect to a encrypted sslmode=require PostgreSQL 16 endpoint, for PGVecto.rs.
pgvector is not tested, but it might have the same error, as this is the issue of PostgreSQL and libpq5.
| OS | version | link | Status |
|---|---|---|---|
| buster[picked] | 11.22 | https://packages.debian.org/buster/libpq5 | Error |
| bullseye | 13.15 | https://packages.debian.org/bullseye/libpq5 | Error |
| bookworm | 15.7 | https://packages.debian.org/bookworm/libpq5 | Success |
After my tests on local machine:
psql11 and 13 have the same errorpsql14, 15, 16 are ok
So it might be helpful if the Dockerfile could be upgraded to:
FROM python:3.11-bookworm as builder-image
FROM python:3.11-slim-bookworm
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 with the repository's Dockerfile and compare the reported Debian base images and libpq5 versions. Reproduce the SSL connection using psql or psycopg against a PostgreSQL 16 endpoint, then verify that the updated image builds and the connection no longer reports the SSL SYSCALL error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, postgresql, python
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 48/100