Opened 15 years ago

Last modified 15 years ago

#238 closed defect

Internal error: 7 ERROR: GEOS union() threw an error! — at Version 1

Reported by: julich Owned by: geos-devel@…
Priority: major Milestone: 3.1.1
Component: Default Version: 3.0.3
Severity: Unassigned Keywords:
Cc:

Description (last modified by mloskot)

When trying to merge several geom using ST_Union() function, I sometimes get an exception / internal error:

SQLSTATE[XX000]: Internal error: 7 ERROR:  GEOS union() threw an error!

Here is the SQL query (which perfectly works on thousands of other ST_Union() I did using the very same method) :

SELECT
    ST_SetSRID(ST_Multi(ST_Union(place_geom)), 4326) AS place_geom
FROM
    geo_place
WHERE
    place_id IN (3169600,3169596,3169647,3169665,3169562,3169564,3169595,3169597,3169598,3169618,3169619,3169648,3169674,3169675,3169676,3169677,3169649,3169599,3169604,3169605,3169633,3169634,3169635,3169650,3169658,3169678,3169563,3169567,3169569,3169575,3169565,3169561,3169615,3169616,3169617,3169672,3169607,3169620,3169668,3169669,3169670,3169673,3169566,3169585,3169588,3169601,3169602,3169603,3169606,3169659,3169664,3169651,3169591,3169632,3169637,3169638,3169703,3169636,3169662,3169663,3169568,3169570,3169574,3169559,3169560,3169518,3169594,3169625,3169671,3169630,3169586,3169587,3169584,3169589,3169581,3169709,3169720,3169705,3169504,3169505,3169507,3169508,3169509,3169510,3169517,3169519,3169520,3169521,3169522,3169542,3169544,3169549,3169554,3169556,3169557,3169609,3169627,3169657,3169624,3169628,3169629,3169583,3169710,3169707,3169721,3169506,3169626,3169536,3169537,3169538,3169539,3169543,3169545,3169546,3169547,3169548,3169550,3169551,3169553,3169555,3169558,3169511,3169512,3169513,3169514,3169515,3169516,3169540,3169541,3169610,3169656,3169704,3169706,3169708,3169801,3169803,3169804,3169579,3169623,3169531,3169532,3169533,3169552,3169525,3169530,3169593,3169654,3169655,3169700,3169722,3169802,3169701,3169876,3169877,3169878,3169880,3169577,3169879,3169576,3169534,3169526,3169527,3169503,3169523,3169535,3169798,3169799,3169702,3169872,3169875,3169578,3169582,3169498,3169499,3169500,3169501,3169502,3169524,3169528,3169529,3169571,3169572,3169871,3169874,3169895,3169896,3169903,3169897,3169873,3169573,3169580,3169590,3169894,3169898,3169899)

Attached hex-polygons-ticket-238.txt file is the dataset of polygons I am trying to merge which generates this internal error.

And here is my technical environment:

SELECT postgis_full_version(), version()

postgis_full_version :
======================
POSTGIS="1.3.5" GEOS="3.0.3-CAPI-1.4.2" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

version:
========
PostgreSQL 8.3.6 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu3)

Change History (2)

comment:1 by mloskot, 15 years ago

Description: modified (diff)

by mloskot, 15 years ago

Attachment: hex-polygons-ticket-238.txt added

Polygons I am trying to merge which generates this internal error.

Note: See TracTickets for help on using tickets.