pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
2+ messages / 1 participants
[nested] [flat]

* AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-05-25 07:12  Hans Buschmann <buschmann@nidsa.net>
  1 sibling, 0 replies; 2+ messages in thread

From: Hans Buschmann @ 2023-05-25 07:12 UTC (permalink / raw)
  To: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>; PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>




________________________________
Von: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
Gesendet: Mittwoch, 24. Mai 2023 19:27
An: Hans Buschmann
Betreff: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore


> 1. is the restore user the owner of the view (have to be owner to refresh) and do they have SELECT on the view's table(s)?

For clarification, this is a pg_restore of a full database dump as practiced for about 7 years now.
The test was under the builtin postgres role, so there seem no missing create role problems.

The sequence of commands is (abbreviated):

create database target_db;
(in another cmd window)
pg_restore -d target_db full_compressed_dump_from_pg15.dmp

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

* AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
@ 2023-05-25 07:30  Hans Buschmann <buschmann@nidsa.net>
  1 sibling, 0 replies; 2+ messages in thread

From: Hans Buschmann @ 2023-05-25 07:30 UTC (permalink / raw)
  To: Thomas Munro <thomas.munro@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

Hello Thomas,


Thank you for your information about LLVM16 support.

I noticed the discussion in hackers.


I wanted to point out that I used the standard repositories from PGDG15.

As to my knowledge they are packaged by Devrim, so this is the standard distribution for RedHat-style Linux on PGDG.

(This is shown by the dnf list lines in my OM)


I am not trying to use LLVM on my platform (tiny data, optimized SQL etc.) but I wanted to notice everybody that there are unreferenced symbols in llvmjit.so, something that should not happen.


I have no idea where this come from nor where it is used, but the unreferenced symbols should be at least masked with dummy rountines (or avoided) to prevent the error for other users where the problem matters much more!


Unfortunately this occurs on pg_restore, the ultimate backup/restore of a database, and data are not restored correctly and must be corrected manually afterwords.


Perhaps you could contact Devrim for clarification...


Hans Buschmann

________________________________

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

end of thread, other threads:[~2023-05-25 07:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-25 07:12 ` Hans Buschmann <buschmann@nidsa.net>
2023-05-25 07:30 ` Hans Buschmann <buschmann@nidsa.net>

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