Skip site navigation (1) Skip section navigation (2)

Re: BUG #5669: server process was terminated by exception 0xC0000005

From: Andrew Geery <andrew(dot)geery(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005
Date: 2010-09-21 19:12:16
Message-ID: AANLkTikEOM_FdssE5LOAX04YAU0Kp52FL1RH6U1=yb2V@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I'm just doing insert statements via JDBC.  Here's the table definition:

CREATE TABLE collection
(
  id serial NOT NULL,
  app_uid character(36) NOT NULL DEFAULT uuid_generate_v4(),
  lock_rev integer NOT NULL DEFAULT 0,
  collection_type_code character(3) NOT NULL,
  asset_type_code character(3) NOT NULL,
  code character varying(10),
  "name" character varying(128) NOT NULL,
  title_prefix character varying(128),
  item_count integer,
  is_fixed_count boolean NOT NULL DEFAULT false,
  is_active boolean NOT NULL DEFAULT true,
  CONSTRAINT pk_collection PRIMARY KEY (id),
  CONSTRAINT collection_collection_type_code_fkey FOREIGN KEY
(collection_type_code)
      REFERENCES collection_type (code) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT collection_type_code_fkey FOREIGN KEY (asset_type_code)
      REFERENCES asset_type (code) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT collection_app_uid_key UNIQUE (app_uid)
)
WITH (
  OIDS=FALSE
);

Thanks
Andrew

On Tue, Sep 21, 2010 at 3:00 PM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> On 21/09/10 21:57, Andrew Geery wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference:      5669
>> Logged by:          Andrew Geery
>> Email address:      andrew(dot)geery(at)gmail(dot)com
>> PostgreSQL version: 9.0
>> Operating system:   Windows Vista
>> Description:        server process was terminated by exception 0xC0000005
>> Details:
>>
>> My PG 9.0 DB (EnterpriseDB edition 32-bit) on Windows Vista SP1 crashes
>> pretty predictably.
>>
>> I executed some SQL and the server crashes.
>>
>> Actually, the SQL completes successfully and then the server crashes.
>
> What's the query that causes the crash?
>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-09-21 19:35:12
Subject: Re: BUG #5667: install failure
Previous:From: Andrew GeeryDate: 2010-09-21 19:10:26
Subject: Re: BUG #5670: installer crashes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group