[pgrouting-users] Problem using osm2pgrouting: value too large

[Andrew J Perrin]

Greetings-

I have postgis 2.0 installed under postgresql 9.1 on a Debian server. I 
am seeking to use pgRouting for a research task: we will ultimately need 
to be able to locate the three nearest locations (by routing, not 
geography) in our database to a list of addresses we will provide.

I am working on importing OSM data on North Carolina, which will include 
all the routing information we need. I downloaded the file from 
http://download.geofabrik.de/north-america/us/north-carolina-latest.osm.bz2 
and uncompressed it.

I then ran:

/usr/src/osm2pgrouting-master/osm2pgrouting -file 
./north-carolina-latest.osm -conf 
/usr/src/osm2pgrouting-master/mapconfig.xml -dbname lenoir -user 
postgres -passwd *******

The output was:
host=127.0.0.1 user=postgres dbname=lenoir port=5432 password=*******
connection success
Trying to load config file /usr/src/osm2pgrouting-master/mapconfig.xml
Trying to parse config
Trying to load data
Trying to parse data
Split ways
Adding tag types and classes to database...
Adding relations to database...
Adding nodes to database...
SSL error: sslv3 alert unexpected message
Adding ways to database...
Creating topology...
#########################
size of streets: 484625
size of splitted ways : 1080943
finished

HOWEVER, no records are in the "ways" or "nodes" tables afterward:
lenoir=# select count(*) from nodes;
  count
-------
      0
(1 row)

lenoir=# select count(*) from ways;
  count
-------
      0
(1 row)


...and the postgresql log shows:
2013-03-18 13:41:12 EDT ERROR:  value "2147643707" is out of range for 
type integer
2013-03-18 13:41:12 EDT CONTEXT:  COPY nodes, line 31000313, column id: 
"2147643707"
2013-03-18 13:41:12 EDT STATEMENT:  COPY nodes(id, lon, lat) from STDIN
2013-03-18 13:41:13 EDT LOG:  SSL renegotiation failure
2013-03-18 13:41:13 EDT STATEMENT:  COPY nodes(id, lon, lat) from STDIN
2013-03-18 13:41:13 EDT LOG:  SSL error: unexpected record
2013-03-18 13:41:13 EDT STATEMENT:  COPY nodes(id, lon, lat) from STDIN
2013-03-18 13:41:13 EDT LOG:  could not send data to client: Connection 
reset by peer
2013-03-18 13:41:13 EDT STATEMENT:  COPY nodes(id, lon, lat) from STDIN
2013-03-18 13:41:13 EDT LOG:  SSL error: unexpected record
2013-03-18 13:41:13 EDT LOG:  could not receive data from client: 
Connection reset by peer
2013-03-18 13:41:13 EDT LOG:  unexpected EOF on client connection


Thanks for any advice.




-- 
--

----------------------------------------------------------------------
Andrew J Perrin - Associate Professor of Sociology
University of North Carolina - CB#3210, Chapel Hill, NC 27599-3210 USA
andrew_perrin at unc.edu - http://perrin.socsci.unc.edu - (919) 962-6876