[postgis-users] St_Union crashing
David Rowley
dgrowleyml at gmail.com
Wed Jul 31 12:09:06 PDT 2013
On Thu, Aug 1, 2013 at 7:00 AM, Bborie Park <dustymugs at gmail.com> wrote:
> Are you using the latest version of PostGIS 2.0? What's the minor version?
>
> SELECT postgis_full_version()
>
>
Full version is:
POSTGIS="2.0.3 r11132" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March
2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY
(topology procs from "2.0.1 r9979" need upgrade) RASTER
Regards
David
> The exception 0xC0000005 is indicative of a memory access error. The
> memory required for the query isn't crazy ( ~ 200 MB).
>
> select st_union(rast) from demelevation limit 1;
>
> -bborie
>
>
> On Wed, Jul 31, 2013 at 11:53 AM, David Rowley <dgrowleyml at gmail.com>wrote:
>
>>
>> On Thu, Aug 1, 2013 at 6:47 AM, Bborie Park <dustymugs at gmail.com> wrote:
>>
>>> David,
>>>
>>> How much RAM does the server have? How many records are there in the "demelevation"
>>> table?
>>>
>>> -bborie
>>>
>>>
>> I'm testing on my laptop which has 8GB of RAM.
>>
>> test=# select count(*) from demelevation;
>> count
>> --------
>> 375440
>> (1 row)
>>
>> test=# show work_mem;
>> work_mem
>> ----------
>> 16MB
>> (1 row)
>>
>>
>> test=# show shared_buffers;
>> shared_buffers
>> ----------------
>> 128MB
>> (1 row)
>>
>>
>>
>>
>>>
>>> On Wed, Jul 31, 2013 at 11:43 AM, David Rowley <dgrowleyml at gmail.com>wrote:
>>>
>>>> I'm experiencing a crash with PostgreSQL 9.2 on windows 64 bit.
>>>>
>>>> psql 1060 idle 2013-08-01 06:34:21 NZST 0 LOG: statement: select
>>>> st_union(rast) from demelevation limit 1;
>>>> 4124 2013-08-01 06:35:07 NZST 0 LOG: server process (PID 1060) was
>>>> terminated by exception 0xC0000005
>>>> 4124 2013-08-01 06:35:07 NZST 0 DETAIL: Failed process was running:
>>>> select st_union(rast) from demelevation limit 1;
>>>> 4124 2013-08-01 06:35:07 NZST 0 HINT: See C include file
>>>> "ntstatus.h" for a description of the hexadecimal value.
>>>> 4124 2013-08-01 06:35:07 NZST 0 LOG: terminating any other active
>>>> server processes
>>>> 3612 2013-08-01 06:35:07 NZST 0 WARNING: terminating connection
>>>> because of crash of another server process
>>>> 3612 2013-08-01 06:35:07 NZST 0 DETAIL: The postmaster has commanded
>>>> this server process to roll back the current transaction and exit, because
>>>> another server process exited abnormally and possibly corrupted shared
>>>> memory.
>>>> 3612 2013-08-01 06:35:07 NZST 0 HINT: In a moment you should be able
>>>> to reconnect to the database and repeat your command.
>>>> 4124 2013-08-01 06:35:07 NZST 0 LOG: all server processes
>>>> terminated; reinitializing
>>>>
>>>>
>>>> test=# select version();
>>>> version
>>>> -------------------------------------------------------------
>>>> PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit
>>>>
>>>> test=# select postgis_version();
>>>> postgis_version
>>>> ---------------------------------------
>>>> 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>
>>>> I can supply a full recreation script if required. In the meantime here
>>>> is the table definition of demelevation
>>>>
>>>>
>>>> Table "public.demelevation"
>>>> Column | Type | Modifiers
>>>>
>>>> ----------+---------+------------------------------------------------------------
>>>> rid | integer | not null default
>>>> nextval('demelevation_rid_seq'::regclass)
>>>> rast | raster |
>>>> filename | text |
>>>> Indexes:
>>>> "demelevation_pkey" PRIMARY KEY, btree (rid)
>>>> "demelevation_rast_gist" gist (st_convexhull(rast))
>>>> Check constraints:
>>>> "enforce_height_rast" CHECK (st_height(rast) = 16)
>>>> "enforce_max_extent_rast" CHECK (st_coveredby(st_convexhull(rast),
>>>> '0103000020E6100000010000000C00000063C92F96FCDF64400E74DA40A70148C063C92F96FCBF64400E74DA4
>>>>
>>>> 0A78147C063C92F96FCBF64408C25BF58F27F46C063C92F96FC7F65408C25BF58F2FF40C0039D36D069C065408C25BF58F2FF40C0039D36D0690066408C25BF58F27F41C0039D36D0696066408C25BF58
>>>>
>>>> F27F42C0039D36D0696066400E74DA40A70144C0039D36D0692066400E74DA40A70145C0039D36D0696065400E74DA40A78147C0039D36D0692065400E74DA40A70148C063C92F96FCDF64400E74DA40A
>>>> 70148C0'::geometry))
>>>> "enforce_nodata_values_rast" CHECK
>>>> (_raster_constraint_nodata_values(rast)::numeric(16,10)[] =
>>>> '{-32768}'::numeric(16,10)[])
>>>> "enforce_num_bands_rast" CHECK (st_numbands(rast) = 1)
>>>> "enforce_out_db_rast" CHECK (_raster_constraint_out_db(rast) =
>>>> '{f}'::boolean[])
>>>> "enforce_pixel_types_rast" CHECK
>>>> (_raster_constraint_pixel_types(rast) = '{16BSI}'::text[])
>>>> "enforce_same_alignment_rast" CHECK (st_samealignment(rast,
>>>> '01000000004F1BE8B4814E4B3F4F1BE8B4814E4BBF63C92F96FC7F65408C25BF58F2FF40C00000000000000000000000
>>>> 0000000000E610000001000100'::raster))
>>>> "enforce_scalex_rast" CHECK (st_scalex(rast)::numeric(16,10) =
>>>> 0.000833333333333333::numeric(16,10))
>>>> "enforce_scaley_rast" CHECK (st_scaley(rast)::numeric(16,10) =
>>>> (-0.000833333333333333)::numeric(16,10))
>>>> "enforce_srid_rast" CHECK (st_srid(rast) = 4326)
>>>> "enforce_width_rast" CHECK (st_width(rast) = 16)
>>>>
>>>> Regards
>>>>
>>>> David
>>>>
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130801/c27ddfdb/attachment.html>
More information about the postgis-users
mailing list