openverse icon indicating copy to clipboard operation
openverse copied to clipboard

`ov` is missing dependencies required to run `psycopg2` in the container

Open sarayourfriend opened this issue 8 months ago • 1 comments

Description

ov needs this fix: https://docs.openverse.org/general/general_setup.html#psycopg2-build-prerequisites

Reproduction

  1. Run `ov pdm run -p api pgcli` and you will get the following output error:
sara@study ~/projects/openverse main [2] @ ov pdm run -p api pgcli
Traceback (most recent call last):
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/pgcli/main.py", line 2, in <module>
    from pgspecial.namedqueries import NamedQueries
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/pgspecial/__init__.py", line 12, in <module>
    from . import dbcommands
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/pgspecial/dbcommands.py", line 7, in <module>
    from psycopg.sql import SQL
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/psycopg/__init__.py", line 9, in <module>
    from . import pq  # noqa: F401 import early to stabilize side effects
    ^^^^^^^^^^^^^^^^
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/psycopg/pq/__init__.py", line 114, in <module>
    import_from_libpq()
  File "/opt/pdm/venvs/api-UJMDzYmD-3.11/lib/python3.11/site-packages/psycopg/pq/__init__.py", line 106, in import_from_libpq
    raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found

sarayourfriend avatar Jun 19 '24 00:06 sarayourfriend