Hola,<br><br>estoy realizando unas pruebas de calculos de rutas TSP PostGis/PGRouting, para una IDE desarrollada con Java y Openlayers. <br><br>Utilizo Debian Lenny, Postgresql <code></code>8.3.11, Postgis 1.3.3-3 y pgRouting-1.03. Teniendo instalado pgRouting desde los fuentes correctamente como se indica en esta guia <a href="http://www.lintips.com/?q=node/101">http://www.lintips.com/?q=node/101</a>. <br>
<br>La documentación sobre las funciones de pgrouting que he seguido es la siguiente: <a href="http://www.davidgis.fr/documentation/pgrouting-1.02/#d0e293">http://www.davidgis.fr/documentation/pgrouting-1.02/#d0e293</a><br>
<br>Mi problema es que en bastantes ocasiones, al lanzar la SQL para un conjunto de vertices concreto, el servidor de BDD se cuelga e inmediatamente se vueve a levantar. El metodo que utilizo es tsp_astar_directed, de esta forma:<br>
<br>SELECT * FROM tsp_astar_directed('tramo','5390,7289,5546,7757,6511,862,3578,1242,129,5015,6525,2773,6778,129,5851,4726,3208,6130,1243,3208,5544,3230,7105,5014', 5390,3,true,true);<br><br><br>y el error me lo da tanto si lo ejecuto desde la aplicación JAVA:<br>
<br><i><span style="color: rgb(153, 0, 0);">11:47:45,484 ERROR [STDERR] org.postgresql.util.PSQLException: Un error de E/S ha ocurrido mientras se enviaba al backend.</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,485 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,485 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,485 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,485 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,485 ERROR [STDERR] at com.ide.CalculoRutas.calcularRutaTSP(AlgoritmoCalculoRutas.java:85)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,486 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,487 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,488 ERROR [STDERR] Caused by: java.io.EOFException</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,488 ERROR [STDERR] at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:261)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,488 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1620)</span><br style="color: rgb(153, 0, 0);"><span style="color: rgb(153, 0, 0);">11:47:45,488 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</span><br style="color: rgb(153, 0, 0);">
<span style="color: rgb(153, 0, 0);">11:47:45,488 ERROR [STDERR] ... 29 more</span></i><br><br>como si lanzo directamente la SQL desde postgresql:<br><br><i><span style="color: rgb(204, 0, 0);">$ psql -h localhost -U miuser -d mibdd</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);">Bienvenido a psql 8.3.11 (servidor 8.3.7), la terminal interactiva de PostgreSQL.</span><br style="color: rgb(204, 0, 0);"><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);">Digite: \copyright para ver los términos de distribución</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);"> \h para ayuda de órdenes SQL</span><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);"> \? para ayuda de órdenes psql</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);"> \g o punto y coma («;») para ejecutar la consulta</span><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);"> \q para salir</span><br style="color: rgb(204, 0, 0);">
<br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);">conexión SSL (cifrado: DHE-RSA-AES256-SHA, bits: 256)</span><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);">mibdd=# SELECT * FROM tsp_astar_directed('tramo','5390,7289,5546,7757,6511,862,3578,1242,129,5015,6525,2773,6778,129,5851,4726,3208,6130,1243,3208,5544,3230,7105,5014', 5390,3,true,true);</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);">server closed the connection unexpectedly</span><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);"> This probably means the server terminated abnormally</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);"> before or while processing the request.</span><br style="color: rgb(204, 0, 0);"><span style="color: rgb(204, 0, 0);">La conexión al servidor se ha perdido. Intentando reiniciar: falló.</span><br style="color: rgb(204, 0, 0);">
<span style="color: rgb(204, 0, 0);">!> </span></i><br><br><br>Si alguién tiene experiencia en el uso de PGRouting para calculos TSP, y puede darme alguna indicación sobre el problema, os lo agradeceria mucho.<br><br><br>
<br>