BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl
Date
Msg-id 17733-4e0960121695ddcc@postgresql.org
Whole thread Raw
Responses Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl
Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17733
Logged by:          Frank Reppin
Email address:      frankreppin@gmail.com
PostgreSQL version: 13.9
Operating system:   macOS Catalina 10.15.7
Description:

Dear all,
... this is maybe related to an older issue #16460 - and it currently only
fails on 13.x - tested with postgresql-13.9-1-osx-binaries.zip ( from EDB
).

Outcome with 13.9 is (simple testcase) in an otherwise empty database
testdb:

testdb=> create table t1 (id serial);
CREATE TABLE
testdb=> insert INTO t1 (id) select * from generate_series(1, 10000000);
ERROR:  could not load library
"/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so":
dlopen(/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so, 10):
Library not loaded: @loader_path/../..//opt/local/lib/libncurses.6.dylib
  Referenced from:
/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so
  Reason: no suitable image found.  Did find:
    file system relative paths not allowed in hardened programs
testdb=> \q

frank@imac postgres % otool -L
/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so 
/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so:
    @loader_path/../../lib/libz.1.dylib (compatibility version 1.0.0, current
version 1.2.13)
    @loader_path/../..//opt/local/lib/libncurses.6.dylib (compatibility version
6.0.0, current version 6.0.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1292.100.5)
    /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version
905.6.0)

I ran the very same test with postgresql-12.13 and postgresql-14.6 - both
succeeded there.

Please advise! :)
TY!


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17732: pg_restore fails with check constraint
Next
From: "David G. Johnston"
Date:
Subject: BUG #17732: pg_restore fails with check constraint