Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting
Mailing Lists: postgresql.org > pgsql-bugs > 07 > 111134.html (Request Expert postgresql.org Support)

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

From: <admin(at)abp.pl>
Date: Tue Nov 20 2007 - 09:22:32 EST

Dnia Wt Listopada 20 2007, 15:02, Zdenek Kotala napisa³(a):
> admin@abp.pl wrote:

>> Dnia Wt Listopada 20 2007, 14:20, Simon Riggs napisał(a):
>>> On Tue, 2007-11-20 at 11:46 +0000, Heikki Linnakangas wrote:
>>>>>> 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[32731]: [2-1] >LOG:  server process
>>>>>> (PID
>>>> 32757)
>>>>>> was terminated by signal 11
>>>
>>>> To me it does look like it was the CREATE TABLE that crashed. The
>>>> NOTICE
>>>>   shows that it's process ID 32757 that's running the CREATE TABLE,
>>>> and
>>>> the LOG line later on says that that's the process that crashed.
>>> Yep, agreed. :-(
>>>
>> OK so what we can do now?
>

> Do you have core file? It is usually stored in data postgreSQL
> directory. Can you provide stack trace to determine which function
> fails? It is very important.

I cant get core file now.

wolni=> 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); CREATE TABLE ...
> what's happen when you create primary key by alter table command?

wolni=> ALTER TABLE phpbb_acl_roles_data add PRIMARY KEY (role_id, auth_option_id);
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "phpbb_acl_roles_data_pkey" for table "phpbb_acl_roles_data" WARNING: you don't own a lock of type RowExclusiveLock 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.

but when
> what's happen when you create unique index on (role_id, auth_option_id)?

wolni=> CREATE UNIQUE INDEX indeks ON phpbb_acl_roles_data (role_id, auth_option_id);
CREATE INDEX
> Is it fresh database? Can you reproduce it on the same machine with the
> same postgreSQL installation on new created database cluster?

Yes, its fresh database (without tables).

Do you need help?X

Regards 

-- 
Tomasz


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
Received on Tue Nov 20 10:01:12 2007

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:49:41 EDT

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library