[Live-demo] [OSGeo] #1187: pgRouting database load trouble: "value is out of range for type smallint"

[OSGeo]

#1187: pgRouting database load trouble: "value is out of range for type smallint"
---------------------+------------------------------------------------------
 Reporter:  hamish   |       Owner:  live-demo@…              
     Type:  defect   |      Status:  new                      
 Priority:  normal   |   Milestone:  OSGeoLive7.0             
Component:  LiveDVD  |    Keywords:  pgrouting                
---------------------+------------------------------------------------------
 r105556:

 maybe related to version upgrade, maybe related to new larger CBD osm file
 extract (should I shrink the area now that there is more detail?)

 {{{
 Setting up osm2pgrouting (2.0.0-beta-ppa4) ...
 create pgrouting database with PostGIS and pgRouting
 CREATE EXTENSION
 CREATE EXTENSION
 unpack sample data
 Run osm2pgrouting converter (this may take a while)
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
 "nodes_pkey" for table "nodes"
 2create ways failed:
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
 "types_pkey" for table "types"
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
 "classes_pkey" for table "classes"
 ERROR:  value "45028" is out of range for type smallint
 CONTEXT:  COPY nodes, line 115830, column numofuse: "45028"
 NOTICE:  table "vertices_tmp" does not exist, skipping
 CONTEXT:  SQL statement "DROP TABLE IF EXISTS vertices_tmp"
 PL/pgSQL function "pgr_createtopology" line 44 at SQL statement
 NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq"
 for serial column "vertices_tmp.id"
 CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id bigserial)"
 PL/pgSQL function "pgr_createtopology" line 45 at SQL statement
 NOTICE:  0 out of 21142 edges processed
 NOTICE:  10000 out of 21142 edges processed
 NOTICE:  20000 out of 21142 edges processed
 VACUUM
 }}}


 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1187>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.