Thread: loading plpython error
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?
thanks
alan
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 followingerror: > 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.
I would guess this is a related version mismatch; likely in the build/release process.
Indeed, that was it. Thank you Tom! alan > On Feb 14, 2019, at 4:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > 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 followingerror: > >> 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 >