From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: randall.williams@analyteks.com
Subject: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
Date: Mon, 25 May 2020 15:43:14 +0000
Message-ID: <16460-10eb2aec093f5967@postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, randall.williams@analyteks.com
Subject: Re: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;
In-Reply-To: <16460-10eb2aec093f5967@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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