<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"><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"><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"><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"><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"><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>