From: | katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets a PANIC. |
Date: | 2012-05-16 10:39:36 |
Message-ID: | E1SUbdo-0004kB-OT@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6643
Logged by: Tomonari Katsumata
Email address: katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp
PostgreSQL version: Unsupported/Unknown
Operating system: RHEL 6.2 x86_64
Description:
Hi,
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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2012-05-16 10:47:37 | Re: BUG #6643: [PostgreSQL9.2beta1] COPY after changing fillfactor gets a PANIC. |
Previous Message | tulio.carrasco | 2012-05-16 01:45:00 | BUG #6642: Spanish collation fault |