Error with index on unlogged table

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Error with index on unlogged table
Date: 2015-03-24 08:53:06
Message-ID: CAA-aLv7T3dK0TPL8hkQBfgZghgDz_azbAhE_PSm3Ania-=UCKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I was attempting to set up a data set to test pg_rewind, when I encountered
an error. I created a primary and standby, then:

# create table test (id serial primary key, thing text);
CREATE TABLE

# create unlogged table utest (id serial primary key, thing text);
CREATE TABLE

# insert into test (thing) values ('jifj');
INSERT 0 1

# insert into utest (thing) values ('jifj');
INSERT 0 1

$ pg_ctl -D standby1 promote

$ psql -p 5531 postgres # standby

# insert into test (thing) values ('moomoo');
INSERT 0 1

# insert into utest (thing) values ('moomoo');
ERROR: index "utest_pkey" contains unexpected zero page at block 0
HINT: Please REINDEX it.

This is built on commit e5f455f59fed0632371cddacddd79895b148dc07.
--
Thom

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Venkata Balaji N 2015-03-24 10:12:03 Re: recovery_target_time ignored ?
Previous Message David Rowley 2015-03-24 07:16:06 Re: Order of enforcement of CHECK constraints?