[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 Osgeolive
mailing list