Skip to content

Postgres engine default keepalives_idle value causes setsockopt(TCP_KEEPIDLE) invalid value #3750

@ndemashov

Description

@ndemashov

Get OperationalError: connection to server at "localhost" (127.0.0.1), port 5432 failed: setsockopt(TCP_KEEPIDLE) failed: Invalid argument when run feast apply.
Because of keepalives_idle=config.keepalives_idle field in function '_get_conn' in infra/utils/postgres/connection_utils.py file. For example, to avoid this error I need to pass 'keepalives_idle=1', but that argument isn't parsed for the registry in feature_store.yaml and pass 'keepalives_idle=0' by default setting in infra/utils/postgres/postgres_config.py.

  • Version: 0.33.1
  • Platform: linux ubuntu 20.04
  • Subsystem:

Possible Solution

Check this issue with the same problem TobikoData/sqlmesh#750. I think you shouldn't pass 'keepalives_idle=0' by default.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions