Re: Time to drop plpython2?

Hi,

Thanks to some more buildfarm animal updates things are looking better. I
think there's now only three owners that haven't updated their animals
successfully. One of which I hadn't yet pinged (chipmunk / Heikki), done now.

There's snapper ("pgbf [ a t ] twiska.com"), and there's Mark Wong's large
menagerie. Mark said yesterday that he's working on updating.

There's one further failure, but the symptoms are quite different. I've also
pinged its owner. I think it's a problem on the system, rather than our side,
but less certain than with the other cases:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=haddock&dt=2022-02-17%2023%3A36%3A09

checking Python.h usability... no
checking Python.h presence... yes
configure: WARNING: Python.h: present but cannot be compiled
configure: WARNING: Python.h: check for missing prerequisite headers?
configure: WARNING: Python.h: see the Autoconf documentation
configure: WARNING: Python.h: section "Present But Cannot Be Compiled"
configure: WARNING: Python.h: proceeding with the compiler's result
configure: WARNING: ## ---------------------------------------------- ##
configure: WARNING: ## Report this to pgsql-bugs(at)lists(dot)postgresql(dot)org ##
configure: WARNING: ## ---------------------------------------------- ##
checking for Python.h... no
configure: error: header file <Python.h> is required for Python

configure:19158: ccache gcc -c -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -m32 -I/usr/include/python3.9 -DWAIT_USE_POLL -D_POSIX_PTHREAD_SEMANTICS -I/usr/include/libxml2 conftest.c >&5
In file included from /usr/include/python3.9/Python.h:8,
from conftest.c:235:
/usr/include/python3.9/pyconfig.h:1443: warning: "SIZEOF_LONG" redefined
1443 | #define SIZEOF_LONG 8
|
conftest.c:183: note: this is the location of the previous definition
183 | #define SIZEOF_LONG 4
|
In file included from /usr/include/python3.9/Python.h:8,
from conftest.c:235:
/usr/include/python3.9/pyconfig.h:1467: warning: "SIZEOF_SIZE_T" redefined
1467 | #define SIZEOF_SIZE_T 8
|
conftest.c:182: note: this is the location of the previous definition
182 | #define SIZEOF_SIZE_T 4
|
In file included from /usr/include/python3.9/Python.h:8,
from conftest.c:235:
/usr/include/python3.9/pyconfig.h:1476: warning: "SIZEOF_VOID_P" redefined
1476 | #define SIZEOF_VOID_P 8
|
conftest.c:181: note: this is the location of the previous definition
181 | #define SIZEOF_VOID_P 4
|
In file included from /usr/include/python3.9/Python.h:63,
from conftest.c:235:
/usr/include/python3.9/pyport.h:736:2: error: #error "LONG_BIT definition appears wrong for platform (bad gcc/glibc config?)."
736 | #error "LONG_BIT definition appears wrong for platform (bad gcc/glibc config?)."
| ^~~~~

This is a 64bit host, targetting 32bit "CFLAGS' => '-m32'. However it linked
successfully against python 2.

Greetings,

Andres Freund