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

Re: BUG #3763: crash after create table with primary keydefined

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: migo <admin(at)abp(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3763: crash after create table with primary keydefined
Date: 2007-11-20 11:12:34
Message-ID: 1195557154.4217.194.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 2007-11-20 at 10:12 +0000, migo wrote:
> The following bug has been logged online:
> 
> Bug reference:      3763
> Logged by:          migo
> Email address:      admin(at)abp(dot)pl
> PostgreSQL version: 8.2.4
> Operating system:   Gentoo
> Description:        crash after create table with primary key defined
> Details: 
> 
> On psql console:
> 
> =>  CREATE TABLE phpbb_acl_roles_data ( role_id INT4 DEFAULT '0' NOT NULL
> CHECK (role_id >= 0), auth_option_id INT4 DEFAULT '0' NOT NULL CHECK
> (auth_option_id >= 0), auth_setting INT2 DEFAULT '0' NOT NULL, PRIMARY KEY
> (role_id, auth_option_id) );
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> wolni=>
> 
> 
> In logs after this:
> Nov 20 11:02:04 www postgres[32757]: [4-1] wolni>NOTICE:  CREATE TABLE /
> PRIMARY KEY will create implicit index "phpbb_acl_roles_data_pkey" for
> table
> Nov 20 11:02:04 www postgres[32757]: [4-2]  "phpbb_acl_roles_data"
> Nov 20 11:02:04 www postgres[32758]: [2-1] [unknown]>LOG:  connection
> received: host=[local]
> Nov 20 11:02:04 www postgres[32758]: [3-1] wolni>LOG:  connection
> authorized: user=wolni database=wolni
> Nov 20 11:02:04 www postgres[32731]: [2-1] >LOG:  server process (PID 32757)
> was terminated by signal 11
> Nov 20 11:02:04 www postgres[32731]: [3-1] >LOG:  terminating any other
> active server processes
> Nov 20 11:02:04 www postgres[32758]: [4-1] wolni>WARNING:  terminating
> connection because of crash of another server process

Looks to me that the process that crashed was not the process that
issued the CREATE TABLE command. So it could be something else entirely.

Is this behaviour repeatable?

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


In response to

Responses

pgsql-bugs by date

Next:From: adminDate: 2007-11-20 11:45:28
Subject: Re: BUG #3763: crash after create table with primary key defined
Previous:From: migoDate: 2007-11-20 10:12:49
Subject: BUG #3763: crash after create table with primary key defined

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