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

OSGeo trac_osgeo at osgeo.org
Thu Aug 1 07:45:30 PDT 2013


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

Comment(by dkastl):

 I have just checked where the "smallint" comes from and it was
 "introduced" with a pull request that added a bunch of useful stuff ...
 but it seems also a little bit of not so useful things ;-)

 It's probably something easy to fix, but it only affects the "nodes" table
 and in this table some counter attribute, which I first need to look at in
 details to understand what it is for. But anyway, it doesn't affect the
 routing part at all, so I would just ignore this error for now.

 About the size of the OSM extract: if the size doesn't harm the total size
 of the LiveDVD, you only need to worry about your build server and not the
 netbooks. osm2pgrouting may eat up your RAM memory (and SWAP memory) if
 the area is too big. But 20.000 records is pretty small. From half a
 million records we probably should think about a smaller extract.

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


More information about the Live-demo mailing list