<div dir="ltr"><div>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></div><div>It mentions that disabling JIT could fix the issue</div><div><br></div><span style="font-family:monospace">show jit; --equals to ON<br>alter database top set jit=off;<br>-- reconnect to db<br>show jit; --equals to off</span><br><br><div>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.</div><div>Shall I open a bug?<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Joan <<a href="mailto:aseques@gmail.com">aseques@gmail.com</a>> del dia dt., 4 de juny 2024 a les 18:00:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><span style="color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:arial,sans-serif">I have recently upgraded the postgis and pgrouting extensions on a server via the </span><span style="color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:arial,sans-serif">pgdg repository from 3.3.1 to 3.4.2, this are my current versions</span><span style="color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:arial,sans-serif"> (the exact same versions are installed on another server with and older copy of the database without the same synthoms)<br></span></div><div>                                         <br><span style="font-family:monospace">       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><br></div><div><span style="font-family:monospace"><span style="color:rgb(0,0,0);background-color:rgb(255,255,255)"><br></span></span></div><div><font face="arial,sans-serif"><span style="color:rgb(0,0,0);background-color:rgb(255,255,255)">When I call this query</span></font></div><div><span style="font-family:monospace"></span></div><span style="font-family:monospace">
<br></span><div style="background-color:rgb(252,252,252);padding:0px 0px 0px 2px"><div style="color:rgb(35,38,39);background-color:rgb(252,252,252);font-family:"Monospace";white-space:pre-wrap"><font size="2"><span style="font-family:monospace">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></font></div><div style="color:rgb(35,38,39);background-color:rgb(252,252,252);font-family:"Monospace";white-space:pre-wrap"><font size="2"><span style="font-family:monospace"><br></span></font></div><div style="color:rgb(35,38,39);background-color:rgb(252,252,252);font-family:"Monospace";font-size:10pt;white-space:pre-wrap"><span style="font-family:monospace">On the sql program (even local console):</span></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">SQL Error [08006]: An I/O error occurred while sending to the backend.</blockquote><div style="color:rgb(35,38,39);background-color:rgb(252,252,252);font-family:"Monospace";font-size:10pt;white-space:pre-wrap"><span style="font-family:monospace">On the postgres logs I see this line though:<br></span></div><div style="color:rgb(35,38,39);background-color:rgb(252,252,252);font-family:"Monospace";font-size:10pt;white-space:pre-wrap"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span style="font-family:monospace"><span style="color:rgb(0,0,0);background-color:rgb(255,255,255)">error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')</span></span></blockquote><div><br></div><div><br></div><div><span style="font-family:arial,sans-serif">On a stackoverflow I found a mention that this could be related  to the JIT compilation </span></div><div><span style="font-family:arial,sans-serif">and suggested disabling it, but I'd like to investigate more before doing so </span></div><div><span style="font-family:arial,sans-serif"><br></span></div><div><span style="font-family:arial,sans-serif">Any pointers will be appreciated,</span></div><div><span style="font-family:arial,sans-serif"><br></span></div><div><span style="font-family:arial,sans-serif">Thanks, </span></div><div><span style="font-family:arial,sans-serif"><br></span></div><div><span style="font-family:arial,sans-serif">Joan<br></span></div><div><span style="font-family:arial,sans-serif"><br></span></div></div></div></div>
</blockquote></div>