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: | |
---|---|---|---|
Priority: | major | Milestone: | 3.1.1 |
Component: | Default | Version: | 3.0.3 |
Severity: | Unassigned | Keywords: | |
Cc: |
Description (last modified by )
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 , 15 years ago
Description: | modified (diff) |
---|
by , 15 years ago
Attachment: | hex-polygons-ticket-238.txt added |
---|
Note:
See TracTickets
for help on using tickets.
Polygons I am trying to merge which generates this internal error.