[OSM-dev] osm2pgsql: "unexpected chunk size"

Jon Burgess jburgess777 at googlemail.com
Thu Jun 5 22:13:03 BST 2008


On Thu, 2008-06-05 at 11:05 +0200, Frederik Ramm wrote:
> Writing way(1340k)
> ANALYZE planet_osm_line;
> CREATE TABLE tmp AS SELECT * FROM planet_osm_line ORDER BY way;
> DROP TABLE planet_osm_line;
> ALTER TABLE tmp RENAME TO planet_osm_line;
> CREATE INDEX planet_osm_line_index ON planet_osm_line USING GIST (way 
> GIST_GEOMETRY_OPS);
> GRANT SELECT ON planet_osm_line TO PUBLIC;
> ANALYZE planet_osm_line;
>   failed: ERROR:  unexpected chunk size 178401435 in chunk 0 for
> toast 
> value 1969418

I noticed that the table name "tmp" is being used by multiple
connections simultaneously. I've just committed some updates to the code
which will make it use a thread specific name now. I'm not sure if this
is the cause -- I'd expect Postgres to complain directly about this if
it was causing the problem.

	Jon






More information about the dev mailing list