From: Hans Buschmann <buschmann@nidsa.net>
To: Thomas Munro <thomas.munro@gmail.com>, "pgsql-bugs@lists.postgresql.org"
	<pgsql-bugs@lists.postgresql.org>
Subject: AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during
 pg_restore
Thread-Topic: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during
 pg_restore
Thread-Index: AQHZjkO5ermnUca6mkyX9srS7AwBB69qMbkAgABicas=
Date: Thu, 25 May 2023 07:30:58 +0000
Message-ID: <69c59ffd5f8548dfa2d3f12ea5303551@nidsa.net>
References: 
 <17943-56bb8c6bd4409b9f@postgresql.org>,<CA+hUKGLXzYAhYjXETo881LqabH9eaAzqGT2GMkdvEkNMp9MUWA@mail.gmail.com>
In-Reply-To: 
 <CA+hUKGLXzYAhYjXETo881LqabH9eaAzqGT2GMkdvEkNMp9MUWA@mail.gmail.com>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: multipart/alternative;
	boundary="_000_69c59ffd5f8548dfa2d3f12ea5303551nidsanet_"
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/69c59ffd5f8548dfa2d3f12ea5303551%40nidsa.net>
Precedence: bulk

--_000_69c59ffd5f8548dfa2d3f12ea5303551nidsanet_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 dis=
tribution 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 llv=
mjit.so, something that should not happen.


I have no idea where this come from nor where it is used, but the unreferen=
ced 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 d=
atabase, and data are not restored correctly and must be corrected manually=
 afterwords.


Perhaps you could contact Devrim for clarification...


Hans Buschmann

________________________________

--_000_69c59ffd5f8548dfa2d3f12ea5303551nidsanet_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hello Thomas,</p>
<p><br>
</p>
<p>Thank you for your information about LLVM16 support.</p>
<p>I noticed the discussion in hackers.</p>
<p><br>
</p>
<p>I wanted to point out that I used the standard repositories from PGDG15.=
</p>
<p>As to my knowledge they are packaged by Devrim, so this is the standard =
distribution for RedHat-style Linux on PGDG.</p>
<p>(This is shown by the dnf list lines in my OM)</p>
<p><br>
</p>
<p>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.</p>
<p><br>
</p>
<p>I have no idea where this come from nor where it is used, but the unrefe=
renced symbols should be at least masked with dummy rountines (or avoided) =
to prevent the error for other users where the problem matters much more!</=
p>
<p><br>
</p>
<p>Unfortunately this occurs on pg_restore, the ultimate backup/restore of =
a database, and data are not restored correctly and must be corrected manua=
lly afterwords.</p>
<p><br>
</p>
<p>Perhaps you could contact Devrim for clarification...</p>
<p><br>
</p>
<p>Hans Buschmann</p>
<br>
<div style=3D"color: rgb(0, 0, 0);">
<div>
<hr tabindex=3D"-1" style=3D"display:inline-block; width:98%">
</div>
</div>
</div>
</body>
</html>

--_000_69c59ffd5f8548dfa2d3f12ea5303551nidsanet_--