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 20:37:20 |
Message-ID: | AANLkTinSYShe9AAuzbxiMyBPRaZT_D0T93pYTN0FG3zm@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Running the server in debug mode, I see the following before the
server crashes -- it looks like something goes wrong with
autovac_balance_cost when trying to analyze the collection table (that
was the table the inserts were being done into).
Thanks
Andrew
2010-09-21 16:27:40 EDTDEBUG: collection: vac: 0 (threshold 50), anl:
76 (threshold 50)
2010-09-21 16:27:40 EDTDEBUG: autovac_balance_cost(pid=5896
db=4329981, rel=4331344, cost_limit=200, cost_delay=20)
2010-09-21 16:27:40 EDTDEBUG: CommitTransaction
2010-09-21 16:27:40 EDTDEBUG: name: unnamed; blockState:
STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2010-09-21 16:27:40 EDTDEBUG: StartTransaction
2010-09-21 16:27:40 EDTDEBUG: name: unnamed; blockState:
DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2010-09-21 16:27:40 EDTDEBUG: analyzing "public.collection"
2010-09-21 16:27:41 EDTDEBUG: reaping dead processes
2010-09-21 16:27:41 EDTDEBUG: server process (PID 5896) was
terminated by exception 0xC0000005
2010-09-21 16:27:41 EDTHINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-09-21 16:27:41 EDTLOG: server process (PID 5896) was terminated
by exception 0xC0000005
2010-09-21 16:27:41 EDTHINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-09-21 16:27:41 EDTLOG: terminating any other active server processes
On Tue, Sep 21, 2010 at 3:12 PM, Andrew Geery <andrew(dot)geery(at)gmail(dot)com> wrote:
> 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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jairo Carrillo | 2010-09-21 20:54:55 | BUG #5671: ERROR: out of memory |
Previous Message | Craig Ringer | 2010-09-21 19:35:12 | Re: BUG #5667: install failure |