[postgis-users] St_Union crashing
David Rowley
dgrowleyml at gmail.com
Wed Jul 31 11:43:10 PDT 2013
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130801/88b66810/attachment.html>
More information about the postgis-users
mailing list