Re: Broken python2-psycopg2-2.8.3-2.rhel7.x86_64.rpm package for PostgresQL versions 9.6 or lower

Hi,

On Thu, 2019-10-03 at 10:56 +0100, Sébastien Besson wrote:

> I hope I am posting to the relevant list to post this issue, please redirect
> me if this is incorrect.

This is the very right list.

> We have started encountering issues following the latest version of the
> python2-psycopg2 package (2.8.3-2) pushed to the YUM repository yesterday.
>
> The issue affects versions of PostgreSQL 9.6 and earlier and can minimally
> reproduced with the attached Docker file which installs the server, the
> psycopg2 package and tests the module import.
>
> With the Postgresql 10 package, the module import without issue
>
> $ docker build . —build-arg VERSION=10
> …
> Successfully built 66bbaec12338
>
> But with PostgreSQL 9.4 or 9.6, the module import fails with an undefined
> symbol error:
>
> $ docker build . —build-arg VERSION=94
> …
> Step 5/5 : RUN python -c 'import psycopg2'
> ---> Running in aadea9ee5590
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
> File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in
> <module>
> from psycopg2._psycopg import ( # noqa
> ImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so:
> undefined symbol: PQsslAttribute
>
> $ docker build . —build-arg VERSION=96
> Step 5/5 : RUN python -c 'import psycopg2'
> ---> Running in 0be14cd51ca1
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
> File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in
> <module>
> from psycopg2._psycopg import ( # noqa
> ImportError: /usr/lib64/python2.7/site-packages/psycopg2/_psycopg.so:
> undefined symbol: PQencryptPasswordConn
>
> Let me know if more information is required

Looks weird. I'll check.

Regards,

--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR