loading plpython error

On 2/14/19 4:17 PM, Alan Nilsson wrote:

Platform: �Linux x86-64, CentOS 6, Postgres 11.1.

We have installed from the YUM repo. �The server runs fine but we are
trying to add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we
invoke create extension, we are greeted with the following error:

ERROR: �could not load library "/usr/pgsql-11/lib/plpython2.so":
/usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

Is there something yet to be installed? �Is this a package error? �Any
hints to fixing?

Is there Python 2.x on this machine?

As I understand it by default plpython is for Python 2.x

thanks
alan

--
Adrian Klaver
adrian.klaver@aklaver.com

On 2/14/19 4:17 PM, Alan Nilsson wrote:

Platform: �Linux x86-64, CentOS 6, Postgres 11.1.

We have installed from the YUM repo. �The server runs fine but we are
trying to add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we
invoke create extension, we are greeted with the following error:

ERROR: �could not load library "/usr/pgsql-11/lib/plpython2.so":
/usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

Is there something yet to be installed? �Is this a package error? �Any
hints to fixing?

What happens if you try?:

CREATE EXTENSION plpython3u;

thanks
alan

--
Adrian Klaver
adrian.klaver@aklaver.com

On 2/14/19 4:34 PM, Adrian Klaver wrote:

On 2/14/19 4:17 PM, Alan Nilsson wrote:

Platform: �Linux x86-64, CentOS 6, Postgres 11.1.

We have installed from the YUM repo. �The server runs fine but we are
trying to add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we
invoke create extension, we are greeted with the following error:

ERROR: �could not load library "/usr/pgsql-11/lib/plpython2.so":
/usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

Is there something yet to be installed? �Is this a package error? �Any
hints to fixing?

What happens if you try?:

CREATE EXTENSION plpython3u;

Forget the above, I looked at:

https://yum.postgresql.org/testing/11/redhat/rhel-6-x86_64/repoview/postgresql11-plpython.html

and it only includes plpython2u.

thanks
alan

--
Adrian Klaver
adrian.klaver@aklaver.com

Alan Nilsson <anilsson@apple.com> writes:

Platform: Linux x86-64, CentOS 6, Postgres 11.1.
We have installed from the YUM repo. The server runs fine but we are trying to add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we invoke create extension, we are greeted with the following error:

ERROR: could not load library "/usr/pgsql-11/lib/plpython2.so": /usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

getmissingattr is a new core-PG function in 11.2. I believe this means
you're trying to load an 11.2 build of plpython2.so into an 11.1 server.
You need to either update the server, or find an 11.1 build of plpython.

regards, tom lane

On 2/14/19 4:17 PM, Alan Nilsson wrote:

Platform: Linux x86-64, CentOS 6, Postgres 11.1.

We have installed from the YUM repo. The server runs fine but we
are
trying to add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we
invoke create extension, we are greeted with the following error:

ERROR: could not load library "/usr/pgsql-11/lib/plpython2.so":
/usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

Is there something yet to be installed? Is this a package error?
Any
hints to fixing?

I see one possibly related issue talked about on a Debian list that
extensions compiled against PostgreSQL 11.2 would likely not load into
previous releases due to this missing symbol.

https://bugs.launchpad.net/ubuntu/+source/skytools3/+bug/1815665

I would guess this is a related version mismatch; likely in the
build/release process.

Indeed, that was it. Thank you Tom!

alan