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

Re: BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets a PANIC.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets a PANIC.
Date: 2012-05-16 10:47:37
Message-ID: 4FB385C9.8050001@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 16.05.2012 13:39, katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp wrote:
> Now, I'm testing PostgreSQL 9.2 Beta 1.
> And I have a problem.
>
> Steps to procedure are bellow.
>
> 1. CREATE DATABASE
>    export LANG=C
>    initdb -D $PGDATA -E SQL_ASCII
>    pg_ctl start
>    createdb testdb
>
> 2. CREATE TABLE
>    psql -d testdb -f ./create_table_customer.sql
>
> 3. ALTER TABLE(fillfactor)
>    psql -d testdb -c "ALTER TABLE customer SET (fillfactor=90);"
>
> 4. LOAD DATA
>    (please set correct path to customer.data)
>    psql -d testdb -f ./customer.sql
>
> Then, I have a PANIC error.
> ==============================
> BEGIN
> TRUNCATE TABLE
> PANIC:  failed to add tuple to page
> CONTEXT:  COPY customer, line 296:
> "296>ALNGAT>alngat>EgBEEAyXVIAWBE>KCiDDFsqA8Kv>2586068>4067234479>ALNGAT(at)kuvkaEEyi>20100905>20101023>..."
> STATEMENT:  COPY customer FROM
> '/home/katsumata/work/2012/20120516_PG92beta1_bug1/copy_panic_dbt1/copy_panic/customer.data'
> WITH DELIMITER '>';
> psql:./customer.sql:3: PANIC:  failed to add tuple to page
> CONTEXT:  COPY customer, line 296:
> "296>ALNGAT>alngat>EgBEEAyXVIAWBE>KCiDDFsqA8Kv>2586068>4067234479>ALNGAT(at)kuvkaEEyi>20100905>20101023>..."
> PANIC:  failed to add tuple to page
> CONTEXT:  COPY customer, line 296:
> "296>ALNGAT>alngat>EgBEEAyXVIAWBE>KCiDDFsqA8Kv>2586068>4067234479>ALNGAT(at)kuvkaEEyi>20100905>20101023>..."
> psql:./customer.sql:3: connection to server was lost
> ==============================
>
> If I skip the 3rd step(ALTER TABLE(fillfactor)),
> I don't have any ERROR.
> And It's also OK on PostgreSQL 9.1.3.
>
> Are there any changes about this behavior ?

This sounds like a bug in the new page-at-a-time behavior in COPY. Can 
you send me a self-contained test, including the test data?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2012-05-16 11:14:49
Subject: Re: BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets a PANIC.
Previous:From: katsumata.tomonariDate: 2012-05-16 10:39:36
Subject: BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets aPANIC.

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