[OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

[Florian Lohoff]

On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote:
> Hi,
> i just discovered that osmosis was not able to apply the hourly osc file
> starting 2008-10-29T20:00:00Z - It failed with:
> 
> 2008-10-31 11:09:52 CET ERROR:  smallint out of range
> 2008-10-31 11:09:52 CET STATEMENT:  INSERT INTO way_nodes (way_id, node_id, sequence_id) VALUES ($1, $2, $3)
> 
> Is there a way with >2^16 aka 65536 nodes?
> 
> Or did someone manage to enter a completely broken sequence number?

Its 2^15 because it signed - and yes - somebody managed to get abovE:

osm=> select max(sequence_id) from way_nodes;
  max  
  -------
   39767
  (1 row)

osm=> select * from way_nodes where sequence_id = 39767;
  way_id  |  node_id  | sequence_id 
  ----------+-----------+-------------
   28098452 | 308532457 |       39767

I converted the smallint to int ...

Flo
-- 
Florian Lohoff                  flo at rfc822.org             +49-171-2280134
	Those who would give up a little freedom to get a little 
          security shall soon have neither - Benjamin Franklin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081031/04184e30/attachment.pgp>