[postgis-users] Postgresql crashing while using Postgis 1.4 on Postgresql 8.4

[Paul Ramsey]

Emilie,

We need to figure what function is taking down the server. First
remove the ST_IsValidReason from the query and see if it crashes. Then
try with only the ST_IsValidReason. Now you know which function is the
problem.

Next, we need to know what data is causing the problem. Do a binary
search in your data (use a WHERE clause to restrict to just the first
half. Then the second half. Repeat the process on the half that causes
the crash. Keep going until you get to a minimum set of data that
causes a crash. now create a new table with just that data, dump it,
and send it to me.

Thanks!

Paul

On Wed, Sep 16, 2009 at 2:37 PM, Emilie Laffray
<emilie.laffray at gmail.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> I am writing to see if I can get help with some crash that is happening
> with the latest version of Postgis.
> I have tried Postgis 1.4 with 8.3 and 8.4 and every time the crash is
> happening.
> In the error log, I have found the following information:
> 2009-09-16 22:28:20 BSTLOG:  server process (PID 5748) was terminated by
> exception 0xC0000005
>
> The query that is creating that crash is the following:
> SELECT  "name",
>        ST_IsValid(way),
>        ST_IsValidReason(way)
> FROM    planet_osm_polygon
> WHERE   osm_id < 0
>        AND NOT ST_IsValid(way)
>
> I am currently working on an import into OpenStreetmap to perform some
> overlap calculation, but I realized that we had some problems with
> invalid geometries due to the import program and due to input geometries
> being wrong.
> The goal of that query and installing postgis 1.4 was to get the ids of
> the faulty geometries. Some can be cleaned with the clean geometry
> function, some have to be fixed manually.
>
> I hope someone can help me here. I will provide any help on trying to
> resolve that issue.
>
> Emilie Laffray
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (MingW32)
>
> iEUEARECAAYFAkqxWqsACgkQ7H1ne0ugLJnzwwCcDsUNCyMhp/1MhZz75lDm+Tvh
> N/kAl0g1QPLlukMvn9ZG5Vcl2TcjsxM=
> =B3w4
> -----END PGP SIGNATURE-----
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>