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

From: Frank Reppin <frankreppin(at)gmail(dot)com>
To: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl
Date: 2023-01-11 08:32:51
Message-ID: CADqa7PHEwK3iqThY5Sxpp804J_YZb76=pQE3X2Rknt+6FOvPyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Just tested... works fine now ( postgresql-13.9-3-osx-binaries.zip ).
While we are at it... what is the recommended procedure to report such
issues back to EDB (without eligible support plan)?

Thankyou!
cheers, FR

On Thu, Jan 5, 2023, 03:04 Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
wrote:

> Hi,
>
> The issue is fixed and the website and the StackBuilder links are updated.
> Thanks again for reporting the issue.
>
> On Mon, Jan 2, 2023 at 10:16 AM Sandeep Thakkar <
> sandeep(dot)thakkar(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> Thanks for reporting the bug. This certainly looks like a linking issue.
>> I'll fix and provide the updates for PostgreSQL 13 at the earliest.
>>
>> On Fri, Dec 30, 2022 at 3:39 AM Frank Reppin <frankreppin(at)gmail(dot)com>
>> wrote:
>>
>>> Dear Andres, dear list,
>>>
>>> it's just only llvmjit.so which (weirdly) links to libncurses.6.dylib
>>> here in EDBs postgresql-13.9 build - nothing else.
>>> Neither plpgsql.so nor libpq.dylib reference libncurses.6.dylib - to
>>> answer your specific question about them.
>>>
>>> Since I agree that this is no classic pgsql bug at all - I too wonder
>>> how to lure someone at EDB on this matter.
>>> There seems no community support mail - just options for users owning a
>>> 'plan' ( I at least couldn't figure one out ).
>>> But it too seems that EDB staff lurks in here on a regular basis - so my
>>> hope was to have them pick it up from here ;)
>>> FWIW - I'll CC Sandeep Thakkar (from former issue #16460) in good hope
>>> to get things sorted.
>>>
>>> Thankyou!
>>> cheers,
>>> Frank Reppin
>>>
>>>
>>> Am Do., 29. Dez. 2022 um 21:36 Uhr schrieb Andres Freund <
>>> andres(at)anarazel(dot)de>:
>>>
>>>> Hi,
>>>>
>>>> On 2022-12-28 16:15:27 +0000, PG Bug reporting form wrote:
>>>> > The following bug has been logged on the website:
>>>> >
>>>> > Bug reference: 17733
>>>> > Logged by: Frank Reppin
>>>> > Email address: frankreppin(at)gmail(dot)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
>>>>
>>>> That looks like an issue with the specific build - you're going to have
>>>> to
>>>> take that up with EDB.
>>>>
>>>>
>>>> > frank(at)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)
>>>>
>>>> It's pretty odd that llvmjit.so is linking to ncurses. Looks like some
>>>> compiler flags might have been injected in a too broad way.
>>>>
>>>> Are other libraries, e.g. plpgsql.so and libpq.dylib also referencing
>>>> ncurses?
>>>>
>>>> Greetings,
>>>>
>>>> Andres Freund
>>>>
>>>
>>
>> --
>> Sandeep Thakkar
>>
>>
>>
>
> --
> Sandeep Thakkar
>
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ROCHER Julien 2023-01-11 09:07:08 TR: Issue: --exclude-schema flag not working with pgrestore
Previous Message Ruslan Talpa 2023-01-11 06:54:25 Re: set_config with is_local parameter true escapes transaction boundaries