[OSM-dev] ROMA servers down - osmosis large way problem

Florian Lohoff flo at rfc822.org
Sun Dec 28 19:53:37 GMT 2008


On Mon, Dec 29, 2008 at 03:43:27AM +0800, D Tucny wrote:
> 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
> 
> So, perhaps following Flo's lead and changing the smallint to int would be
> the best approach for dealing with getting the ROMA servers back up and
> running...

Both of my databases broke down again as i dropped the databases and
recreated them - right now converting again ...

I have no clue if this solves it - forgot already what i did last time ;)

ALTER TABLE way_nodes ALTER COLUMN sequence_id TYPE integer;

Hopefully postgres is clever enough to take over the old content and
recreate the index ...

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/20081228/0a634bde/attachment.pgp>


More information about the dev mailing list