Opened 10 years ago

Closed 10 years ago

#525 closed defect (fixed)

pgrouting data import off

Reported by: wildintellect Owned by: live-demo@…
Priority: major Milestone:
Component: OSGeoLive Keywords: pgrouting 3.0RC1
Cc:

Description

pgrouting seems to build ok but the data import doesn't work out, for some reason the make install isn't putting the pgrouting .sql files into /usr/share/postlbs. Log is attached to ticket.

Attachments (1)

pgrouting3truncated.log.tar.gz (65.4 KB) - added by wildintellect 10 years ago.
pgrouting build log live 3.0alpha

Download all attachments as: .zip

Change history (4)

Changed 10 years ago by wildintellect

pgrouting build log live 3.0alpha

comment:1 Changed 10 years ago by wildintellect

Keywords: 3.0RC1 added; 3.0-alpha4 removed

More info on the build error, should forward to pgrouting contact:

[ 25%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c: In function ‘fetch_vertices_columns’:
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: ‘INT4OID’ undeclared (first use in this function)
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: (Each undeclared identifier is reported only once
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: for each function it appears in.)
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:138: error: ‘FLOAT8OID’ undeclared (first use in this function)
make[2]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o] Error 1
make[1]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/all] Error 2
make: *** [all] Error 2

comment:2 Changed 10 years ago by hamish

these errors in the 3.0rc1a build log:

...
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
COMMIT
ANALYZE
/usr/share/postlbs/routing_core.sql: No such file or directory
/usr/share/postlbs/routing_core_wrappers.sql: No such file or directory
/usr/share/postlbs/routing_topology.sql: No such file or directory
/usr/share/postlbs/routing_tsp.sql: No such file or directory
/usr/share/postlbs/routing_tsp_wrappers.sql: No such file or directory
/usr/share/postlbs/routing_dd.sql: No such file or directory
/usr/share/postlbs/routing_dd_wrappers.sql: No such file or directory
DROP TABLE
psql:schema.sql:76: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "geometry_columns_pk" for table "geometry_columns"
ERROR:  function dijkstra_sp_delta(unknown, integer, integer, numeric) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM dijkstra_sp_de...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
ERROR:  function astar_sp_delta(unknown, integer, integer, numeric) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM astar_sp_delta...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
ERROR:  function shootingstar_sp(unknown, integer, integer, numeric, unknown, boolean, boolean) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM shootingstar_s...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Finished: ./install_pgrouting.sh

(any way to make those INSERTs go quietly?)

also, install_pgrouting.sh script does not clean up the -dev packages it pulls in, and that's hundreds of megabytes.

Hamish

comment:3 Changed 10 years ago by wildintellect

Resolution: fixed
Status: newclosed

Was a compile issue, package was updated and issue resolved.

Note: See TracTickets for help on using tickets.