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

[Emilie Laffray]

Paul Ramsey wrote:
> 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.
>

The crash is happening on ST_IsValidReason.


> 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.

The behavior seems erratic. I thought I had it narrowed down to one
line, but it wasn't the one line. However, I think I have found a subset
that is making postgresql crash every time. There are only 23 entries.
I hope it will be useful.

Emilie Laffray

Emilie  Laffray
-------------- next part --------------
A non-text attachment was scrubbed...
Name: errortable.backup
Type: application/octet-stream
Size: 102173 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090916/7fc33c0d/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090916/7fc33c0d/attachment.pgp>