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

From: Sébastien Besson <seb(dot)besson(at)gmail(dot)com>
To: pgsql-pkg-yum(at)lists(dot)postgresql(dot)org
Subject: Broken python2-psycopg2-2.8.3-2.rhel7.x86_64.rpm package for PostgresQL versions 9.6 or lower
Date: 2019-10-03 09:56:50
Message-ID: EA7F5495-64AE-4BEF-81B1-7FA921BBE690@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

Hi everyone,

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

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
Best,
Sebastien

Attachment Content-Type Size
Dockerfile application/octet-stream 247 bytes

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Devrim Gündüz 2019-10-03 17:17:10 Re: Broken python2-psycopg2-2.8.3-2.rhel7.x86_64.rpm package for PostgresQL versions 9.6 or lower
Previous Message Karl O. Pinc 2019-10-03 02:00:42 Re: PG 12 rpm repo breaks yum