David, How much RAM does the server have? How many records are there in the "demelevation" table?
-bborie On Wed, Jul 31, 2013 at 11:43 AM, David Rowley <dgrowle...@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@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users