From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: buschmann@nidsa.net
Subject: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
Date: Wed, 24 May 2023 13:28:46 +0000
Message-ID: <17943-56bb8c6bd4409b9f@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17943
Logged by: Hans Buschmann
Email address: buschmann@nidsa.net
PostgreSQL version: 15.3
Operating system: Fedora 38 x86-64
Description:
I tried to restore our standard db from a recent dump on PostgreSQL 15.3
installed from PGDG repositories with dnf.
During pg_restore I got the following error message:
pg_restore: error: could not execute query: ERROR: could not load library
"/usr/pgsql-15/lib/llvmjit.so": /usr/pgsql-15/lib/llvmjit.so: undefined
symbol: LLVMBuildGEP
Command was: REFRESH MATERIALIZED VIEW archiv.mv_max_fac_order;
pg_restore: warning: errors ignored on restore: 1
For our system, jit isn't really important, but enabled in configuration.
So the error occurs only occasional here.
At the first attempt the following postgres / llvm packages where
installed:
postgresql15.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-contrib.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-devel.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-docs.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-libs.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-llvmjit.x86_64
15.3-1PGDG.f38 @pgdg15
postgresql15-server.x86_64
15.3-1PGDG.f38 @pgdg15
llvm.x86_64
16.0.3-1.fc38 @updates
llvm-devel.x86_64
16.0.3-1.fc38 @updates
llvm-libs.i686
16.0.3-1.fc38 @updates
llvm-libs.x86_64
16.0.3-1.fc38 @updates
llvm-static.x86_64
16.0.3-1.fc38 @updates
llvm-test.x86_64
16.0.3-1.fc38 @updates
llvm15-libs.x86_64
15.0.7-4.fc38 @fedora
Even after dnf remove llvm15-libs (leftover from a system upgrade from
Fedora 37) the same error persisted.
Any clues?
Hans Buschmann
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, buschmann@nidsa.net
Subject: Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
In-Reply-To: <17943-56bb8c6bd4409b9f@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