Re: Failed assertion on cluster

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Failed assertion on cluster
Date: 2005-02-06 17:16:38
Message-ID: Pine.uw2.4.61.0502061115010.2999@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 6 Feb 2005, Larry Rosenman wrote:

> I get the following:
>
> $ TRAP: FailedAssertion("!(!(tup->t_data->t_infomask & 0x0010))", File:
> "heapam.c", Line: 1133)
>
>
> when I try to cluster this table:
>
> CREATE TABLE virtusers (
> lhs text,
> rhs text,
> insert_date timestamp(0) with time zone DEFAULT now(),
> insert_who text DEFAULT "current_user"(),
> "comment" text
> );
> ALTER TABLE ONLY virtusers ALTER COLUMN lhs SET STATISTICS 100;
>
> --
> -- Name: vu_lhs_index; Type: INDEX; Schema: public; Owner: ler; Tablespace:
> --
>
> CREATE UNIQUE INDEX vu_lhs_index ON virtusers USING btree (lhs);
>
>
> ALTER INDEX public.vu_lhs_index OWNER TO ler;
>
>
> When I issue the cluster vu_lhs_index on virtusers, I get the above
> assertion.
>
> 8.0.1 on UnixWare 7.1.4
>
>
>
I had done the following, which I think is what's doing it:

1) alter table virtusers (and all the others in that db) set without oids;
2) changed postgresql.conf's default_with_oids to false.

Based on my read, this case is what's causing the grief.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-06 17:24:58 Re: Fixing flat user/group files at database startup
Previous Message Larry Rosenman 2005-02-06 17:10:47 Failed assertion on cluster