pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
3+ messages / 3 participants
[nested] [flat]

* BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
@ 2020-05-25 15:43  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 2 replies; 3+ messages in thread

From: PG Bug reporting form @ 2020-05-25 15:43 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: randall.williams@analyteks.com

The following bug has been logged on the website:

Bug reference:      16460
Logged by:          Randall Williams
Email address:      randall.williams@analyteks.com
PostgreSQL version: 12.3
Operating system:   macOS 10.14.6
Description:        

Here is the error message:

ERROR:  could not load library
"/Library/PostgreSQL/lib/postgresql/llvmjit.so":
dlopen(/Library/PostgreSQL/lib/postgresql/llvmjit.so, 10): 
Library not loaded: @loader_path/../..//opt/local/lib/libncurses.6.dylib
Referenced from: /Library/PostgreSQL/lib/postgresql/llvmjit.so
Reason: image not found

When the error occurs, I am running as a non-administrative user in macOS
and as a non-administrative user in pgAdmin 4.

PostgreSQL was installed using the EDB Mac OS X installer for PostgreSQL
version 12.3. The pgAdmin 4 version is 4.21.0. The Materialized View was
created using the Create Materialized View contextual menu and the
Materialized View was successfully saved. When the command to Refresh
Materialized View was issued using the contextual menu, the error was
generated about in about 0.25 sec. and the status code shown is: Failed
(exit code: 1). PgAdmin 4 was used to refresh 36 other Materialized Views
without error. This was the only case where an error occurred.

The files llvmjit.so and llvmjit_types.bc are both installed in
/Library/PostgreSQL/lib/postgresql. File ownership for llvmjit.so is
root:daemon and permissions are set to rwxr-xr-x.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
@ 2020-05-26 00:38  Michael Paquier <michael@paquier.xyz>
  parent: PG Bug reporting form <noreply@postgresql.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2020-05-26 00:38 UTC (permalink / raw)
  To: randall.williams@analyteks.com; pgsql-bugs@lists.postgresql.org

On Mon, May 25, 2020 at 03:43:14PM +0000, PG Bug reporting form wrote:
> PostgreSQL was installed using the EDB Mac OS X installer for PostgreSQL
> version 12.3. The pgAdmin 4 version is 4.21.0. The Materialized View was
> created using the Create Materialized View contextual menu and the
> Materialized View was successfully saved. When the command to Refresh
> Materialized View was issued using the contextual menu, the error was
> generated about in about 0.25 sec. and the status code shown is: Failed
> (exit code: 1). PgAdmin 4 was used to refresh 36 other Materialized Views
> without error. This was the only case where an error occurred.

This pretty much sounds like a packaging issue, so you may want to see
with the maintainers of this installer what went wrong.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
@ 2020-06-15 07:26  Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Sandeep Thakkar @ 2020-06-15 07:26 UTC (permalink / raw)
  To: randall.williams@analyteks.com; pgsql-bugs@lists.postgresql.org

Thanks for reporting. This looks like the install name issue. Will fix it
and provide an updated installer.

On Mon, May 25, 2020 at 10:21 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      16460
> Logged by:          Randall Williams
> Email address:      randall.williams@analyteks.com
> PostgreSQL version: 12.3
> Operating system:   macOS 10.14.6
> Description:
>
> Here is the error message:
>
> ERROR:  could not load library
> "/Library/PostgreSQL/lib/postgresql/llvmjit.so":
> dlopen(/Library/PostgreSQL/lib/postgresql/llvmjit.so, 10):
> Library not loaded: @loader_path/../..//opt/local/lib/libncurses.6.dylib
> Referenced from: /Library/PostgreSQL/lib/postgresql/llvmjit.so
> Reason: image not found
>
> When the error occurs, I am running as a non-administrative user in macOS
> and as a non-administrative user in pgAdmin 4.
>
> PostgreSQL was installed using the EDB Mac OS X installer for PostgreSQL
> version 12.3. The pgAdmin 4 version is 4.21.0. The Materialized View was
> created using the Create Materialized View contextual menu and the
> Materialized View was successfully saved. When the command to Refresh
> Materialized View was issued using the contextual menu, the error was
> generated about in about 0.25 sec. and the status code shown is: Failed
> (exit code: 1). PgAdmin 4 was used to refresh 36 other Materialized Views
> without error. This was the only case where an error occurred.
>
> The files llvmjit.so and llvmjit_types.bc are both installed in
> /Library/PostgreSQL/lib/postgresql. File ownership for llvmjit.so is
> root:daemon and permissions are set to rwxr-xr-x.
>
>

-- 
Sandeep Thakkar

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-06-15 07:26 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-25 15:43 BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA; PG Bug reporting form <noreply@postgresql.org>
2020-05-26 00:38 ` Michael Paquier <michael@paquier.xyz>
2020-06-15 07:26 ` Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox