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 <[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
