1644770 - Please update psycopg2 to 2.8.4+

Status: RESOLVED FIXED

(Webtools Graveyard :: Pontoon, defect)

Description

[Fabien LOISON]

User Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0

Steps to reproduce:

I tried to install Pontoon on Ubuntu 20.04 that is shipped with Python 3.8.

Actual results:

The installation fails because psycopg2==2.7.3.2 is not compatible with Python 3.8:

$ pip3 install psycopg2==2.7.3.2
...
g/psycopgmodule.o -Wdeclaration-after-statement
psycopg/psycopgmodule.c: In function ‘psyco_is_main_interp’:
psycopg/psycopgmodule.c:685:18: error: dereferencing pointer to incomplete type ‘PyInterpreterState’ {aka ‘struct _is’}
685 | while (interp->next)
| ^~
error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
----------------------------------------
ERROR: Command errored out with exit status 1: /tmp/env/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-2jwf8tib/psycopg2/setup.py'"'"'; file='"'"'/tmp/pip-install-2jwf8tib/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record /tmp/pip-record-_o85feth/install-record.txt --single-version-externally-managed --compile --install-headers /tmp/env/include/site/python3.8/psycopg2 Check the logs for full command output.

Expected results:

According the following issue, psycopg2==2.8.4 is the first version compatible with Python 3.8:

• https://github.com/psycopg/psycopg2/issues/854

Is it possible to update this dependency?

Comment 1

[Matjaz Horvat [:mathjazz]]

Hi mozilla :)

I assume you're installing Pontoon on a server, not locally (where we recommend using Docker).

Have you noticed anything else that needed to be changed in order to run Pontoon on python 3.8?

Jotes, should we consider upgrading Pontoon to python 3.8?

Comment 2

[Jarek Śmiejczak [:jotes]]

I can take a look at this. I'll add Python 3.8 to our testing matrix on TravisCI and if everything is okay then I'll bump up versions of Python and psycopg2 together.

Comment 3

[Jarek Śmiejczak [:jotes]]

I'm sorry, I removed the "needinfo?" flag by mistake.

Comment 4

[GitHub Bugzilla PR Linker]

Attachment: Link to GitHub pull-request: https://github.com/mozilla/pontoon/pull/1646

Comment 5

[Fabien LOISON]

Excluding the psycopg2 dep, everything seems ok with Py2.8 :)