[OSM-dev] generate_xml.py is not running

Parveen Arora parveenaroraosm at gmail.com
Sun Jan 30 10:21:22 GMT 2011


On Sun, Jan 30, 2011 at 3:38 PM, Graham Jones <grahamjones139 at gmail.com> wrote:
> Parveen,
> It sounds as though either the osm2pgsql import did not work, or you
> imported the data into a different database to the one mapnik is using (I
> did that once and got very confused...).
> I would check what is in your database with a few simple queries from the
> command line.
> Try:
> psql -d gis   <assuming gis is the database you used for the osm2pgsql
> import>
> \d
> \d should list all the tables in the database - on my computer I get:
>           List of relations
>  Schema |        Name        |   Type   | Owner
> --------+--------------------+----------+--------
>  public | contours           | table    | graham
>  public | contours_gid_seq   | sequence | graham
>  public | geometry_columns   | table    | graham
>  public | planet_osm_line    | table    | graham
>  public | planet_osm_nodes   | table    | graham
>  public | planet_osm_point   | table    | graham
>  public | planet_osm_polygon | table    | graham
>  public | planet_osm_rels    | table    | graham
>  public | planet_osm_roads   | table    | graham
>  public | planet_osm_ways    | table    | graham
>  public | spatial_ref_sys    | table    | graham
> (11 rows)
Here I hot like this:
gis=# \d
              List of relations
 Schema |       Name       | Type  |  Owner
--------+------------------+-------+---------
 public | geometry_columns | table | parveen
 public | spatial_ref_sys  | table | parveen
(2 rows)

> (but you will not have the contours ones).
> If you do not have something like this, then osm2pgsql has failed - I would
I have installed osm2pgsql using some files of previous 3.0.0 version
after compilation

> try the import again with a very small area - just download a bit of a local
> town and import that so it is quicker than a whole country - and look out
> for any errors.
I also have tried to that but it has only imported country's file
instead of small area
then error was like this:
Going over pending ways
processing way (0k)*** glibc detected *** ./osm2pgsql: double free or
corruption (out): 0x00007fffed43dd70 ***
======= Backtrace: =========
/lib/libc.so.6(+0x775b6)[0x7fe3a0cbd5b6]
/lib/libc.so.6(cfree+0x73)[0x7fe3a0cc3e83]
/usr/lib/libgeos-3.1.0.so(_ZNK4geos4geom7Polygon8apply_roEPNS0_23GeometryComponentFilterE+0x1c)[0x7fe3a1c5fa9c]
./osm2pgsql[0x40551e]
./osm2pgsql[0x40a22e]
./osm2pgsql[0x40d9f1]
./osm2pgsql[0x40817d]
./osm2pgsql[0x4104d5]
/lib/libc.so.6(__libc_start_main+0xfd)[0x7fe3a0c64c4d]
./osm2pgsql[0x404309]
======= Memory map: ========
00400000-00420000 r-xp 00000000 08:01 8526402
  /home/parveen/bin/osm2pgsql/osm2pgsql


> If the tables do exist you can do some simple queries like:
> select osm_id,name from planet_osm_polygon where leisure='playground';
> to see if the data looks reasonable.
It has not worked,
may be you are right osm2pgsql installation is not correct.




-- 
With Kind Regards
Parveen Arora



More information about the dev mailing list