<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt'>Which system are you on? A apt or Yum based?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>It sounds like maybe you are picking up LLVM from your OS repo, and bits from the PGDG repo.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>You should probably disable your OS repo LLVM<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>Or report issue to<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><a href="https://www.postgresql.org/list/pgsql-pkg-yum/">https://www.postgresql.org/list/pgsql-pkg-yum/</a> (CentOS / Redhat / Rocky)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>or<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><a href="https://www.postgresql.org/list/pgsql-pkg-debian/">https://www.postgresql.org/list/pgsql-pkg-debian/</a> (Debian/Ubuntu)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>At anyrate I don’t think PostGIS group can do anything about this as we don’t explicitly turn on/off JIT.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>As far as PostGIS workload is concerned, so people have mentioned JIT is pretty useless, and often better to keep it off to not make it try to optimize stupid things.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>But what I heard was way back when it was a new thing, so I think at least now, it’s less likely to do harm turned on.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>Hope that helps,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Joan <aseques@gmail.com> <br><b>Sent:</b> Wednesday, June 5, 2024 4:51 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> Re: Issue after upgrading postgis to 3.4.2<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>I tried the workaround that was mentioned on the stack overflow thread here <a href="https://stackoverflow.com/q/76192816/322049">https://stackoverflow.com/q/76192816/322049</a><o:p></o:p></p></div><div><p class=MsoNormal>It mentions that disabling JIT could fix the issue<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Courier New"'>show jit; --equals to ON<br>alter database top set jit=off;<br>-- reconnect to db<br>show jit; --equals to off</span><o:p></o:p></p><div><p class=MsoNormal>With jit == off the query runs without issues, still i doesn't seem the appropiate thing to do, and on the replica system there's no need to disable the JIT.<o:p></o:p></p></div><div><p class=MsoNormal>Shall I open a bug?<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Missatge de Joan <<a href="mailto:aseques@gmail.com">aseques@gmail.com</a>> del dia dt., 4 de juny 2024 a les 18:00:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:black;background:white'>I have recently upgraded the postgis and pgrouting extensions on a server via the pgdg repository from 3.3.1 to 3.4.2, this are my current versions (the exact same versions are installed on another server with and older copy of the database without the same synthoms)</span><o:p></o:p></p></div><div><p class=MsoNormal> <br><span style='font-family:"Courier New"'> Name | Version | Schema <br>------------------+---------+-------------<br> pgrouting | 3.6.2 | public <br> plpgsql | 1.0 | pg_catalog <br> postgis | 3.4.2 | public <br> postgis_raster | 3.4.2 | public <br> postgis_topology | 3.4.2 | topology <br> tds_fdw | 2.0.3 | public </span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif;color:black;background:white'>When I call this query</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'>select *<br>FROM topo.arcs t,<br>topo.nodes n<br>where<br>t.geom is not null<br>and n.geom is not null<br>and ST_DWithin(ST_StartPoint(t.geom), n.geom, 0.01)</span><span style='font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'>On the sql program (even local console):<o:p></o:p></span></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal style='background:#FCFCFC'><span style='color:black'>SQL Error [08006]: An I/O error occurred while sending to the backend.</span><o:p></o:p></p></blockquote><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'>On the postgres logs I see this line though:<o:p></o:p></span></p></div><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')</span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></blockquote><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#232627'>On a stackoverflow I found a mention that this could be related to the JIT compilation </span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#232627'>and suggested disabling it, but I'd like to investigate more before doing so </span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#232627'>Any pointers will be appreciated,</span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#232627'>Thanks, </span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#232627'>Joan</span><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#FCFCFC'><span style='font-size:10.0pt;font-family:"Courier New";color:#232627'><o:p> </o:p></span></p></div></div></div></div></blockquote></div></div></div></body></html>