pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
6+ messages / 4 participants
[nested] [flat]
* BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-05-24 13:28 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: PG Bug reporting form @ 2023-05-24 13:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: buschmann@nidsa.net
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-05-25 03:20 Thomas Munro <thomas.munro@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: Thomas Munro @ 2023-05-25 03:20 UTC (permalink / raw)
To: buschmann@nidsa.net; pgsql-bugs@lists.postgresql.org
On Thu, May 25, 2023 at 4:19 AM PG Bug reporting form
<noreply@postgresql.org> wrote:>
> Any clues?
Is it possible that whoever packaged that compiled it against LLVM 15
but then put LLVM 16 into the package depencencies? I'm not a Fedora
user so that might be a silly question... but do you still have the
ability to install LLVM 15? Unfortunately PostgreSQL can't use LLVM16
yet, because we need to make some changes (hopefully in the next point
release):
https://www.postgresql.org/message-id/flat/CA+hUKGKNX_=f+1C4r06WETKTq0G4Z_7q4L4Fxn5WWpMycDj9Fw@mail....
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-05-25 17:21 Devrim Gündüz <devrim@gunduz.org>
parent: Thomas Munro <thomas.munro@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2023-05-25 17:21 UTC (permalink / raw)
To: Thomas Munro <thomas.munro@gmail.com>; buschmann@nidsa.net; pgsql-bugs@lists.postgresql.org
Hi,
On Thu, 2023-05-25 at 15:20 +1200, Thomas Munro wrote:
> Is it possible that whoever packaged that compiled it against LLVM 15
> but then put LLVM 16 into the package depencencies?
Me. The answer is yes.
I hit the same issue on my laptop a couple of days ago. Will rebuild
RPMs against LLVM15 (which is a separate package), and will release
until Monday.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-09-15 07:06 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Devrim Gündüz <devrim@gunduz.org>
0 siblings, 1 reply; 6+ messages in thread
From: Laurenz Albe @ 2023-09-15 07:06 UTC (permalink / raw)
To: Devrim Gündüz <devrim@gunduz.org>; pgsql-pkg-yum@lists.postgresql.org
On Thu, 2023-05-25 at 18:21 +0100, Devrim Gündüz wrote:
> On Thu, 2023-05-25 at 15:20 +1200, Thomas Munro wrote:
> > Is it possible that whoever packaged that compiled it against LLVM 15
> > but then put LLVM 16 into the package depencencies?
>
> Me. The answer is yes.
>
> I hit the same issue on my laptop a couple of days ago. Will rebuild
> RPMs against LLVM15 (which is a separate package), and will release
> until Monday.
I still see that error with the 16.0 packages on Fedora 38.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-09-15 11:28 Devrim Gündüz <devrim@gunduz.org>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2023-09-15 11:28 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-pkg-yum@lists.postgresql.org
Hi Laurenz,
On Fri, 2023-09-15 at 09:06 +0200, Laurenz Albe wrote:
> I still see that error with the 16.0 packages on Fedora 38.
Unfortunately Fedora 38 does not have clang15 package, so we'll need to
wait until PostgreSQL supports LLVM 16.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-09-15 16:09 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Devrim Gündüz <devrim@gunduz.org>
0 siblings, 0 replies; 6+ messages in thread
From: Laurenz Albe @ 2023-09-15 16:09 UTC (permalink / raw)
To: Devrim Gündüz <devrim@gunduz.org>; pgsql-pkg-yum@lists.postgresql.org
On Fri, 2023-09-15 at 12:28 +0100, Devrim Gündüz wrote:
> On Fri, 2023-09-15 at 09:06 +0200, Laurenz Albe wrote:
> > I still see that error with the 16.0 packages on Fedora 38.
>
> Unfortunately Fedora 38 does not have clang15 package, so we'll need to
> wait until PostgreSQL supports LLVM 16.
I see.
Wouldn't it be better not to ship postgresql16-llvmjit, or at least to
ship PostgreSQL with "jit = off"?
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-09-15 16:09 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-24 13:28 BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore PG Bug reporting form <noreply@postgresql.org>
2023-05-25 03:20 ` Thomas Munro <thomas.munro@gmail.com>
2023-05-25 17:21 ` Devrim Gündüz <devrim@gunduz.org>
2023-09-15 07:06 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-15 11:28 ` Devrim Gündüz <devrim@gunduz.org>
2023-09-15 16:09 ` Laurenz Albe <laurenz.albe@cybertec.at>
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