Error which creating Multicorn extension

[rohitskapoor]

I am getting the following error while creating multicorn extension.

ostgres=# CREATE EXTENSION multicorn; ERROR: could not load library "/opt/postgresql/pg96/lib/postgresql/multicorn.so": /opt/postgresql/pg96/lib/postgresql/multicorn.so: undefined symbol: oid_hash

Any thoughts.

Regards, Rohit

[nclu]

Same issue here when building from source on CentOS 7 for PostgreSQL-10

[SeverinAlexB]

I get a slightly different error but which is probably related to this issue.

ERROR: could not load library "/usr/lib/postgresql/9.6/lib/multicorn.so": /usr/lib/postgresql/9.6/lib/multicorn.so: undefined symbol: copyObjectImpl SQL state: XX000

[ZihaoTan]

Similar issue: ERROR: could not load library "/usr/local/Cellar/postgresql@9.5/9.5.20/lib/multicorn.so": dlopen(/usr/local/Cellar/postgresql@9.5/9.5.20/lib/multicorn.so, 10): Symbol not found: _AllocSetContextCreateExtended Referenced from: /usr/local/Cellar/postgresql@9.5/9.5.20/lib/multicorn.so Expected in: flat namespace in /usr/local/Cellar/postgresql@9.5/9.5.20/lib/multicorn.so

[ayandad]

In my case:

OS: Ubuntu 18.0 LTS Postgresql version 9.6

postgres=# CREATE EXTENSION multicorn; ERROR: could not load library "/usr/lib/postgresql/9.6/lib/multicorn.so": /usr/lib/postgresql/9.6/lib/multicorn.so: undefined symbol: copyObjectImpl

Reason: I found that my postgresql client that is being used in postgresql-client-10 So I removed that.

With only postgresql client 9.6 remaining I re-installed multicorn via using the apt-get sudo apt-get install postgresql-9.6-python-multicorn

then postgres=# CREATE EXTENSION multicorn; CREATE EXTENSION postgres=#