ERROR: failed to add item to the index page

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: ERROR: failed to add item to the index page
Date: 2019-04-30 09:03:15
Message-ID: VisenaEmail.c5.3ee7fe277d514162.16a6d785bea@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

With master (3dbb317d32f4f084ef7badaed8ef36f5c9b85fe6) I'm getting this:
visena=# CREATE INDEX origo_email_part_hdrvl_value_idx ON
public.origo_email_part_headervalue USING btree
(lower(substr((header_value)::text, 0, 1000)) varchar_pattern_ops);
psql: ERROR: failed to add item to the index page
The schema looks like this: create table origo_email_part_headervalue (
entity_idBIGSERIAL PRIMARY KEY, version int8 not null, header_value varchar NOT
NULL, header_id int8 references origo_email_part_header (entity_id), value_index
int NOT NULL DEFAULT0, UNIQUE (header_id, value_index) ); CREATE INDEX
origo_email_part_hdrvl_hdr_id_idxON origo_email_part_headervalue (header_id);
CREATE INDEXorigo_email_part_hdrvl_value_idx ON origo_email_part_headervalue (
lower(substr(header_value, 0, 1000)) varchar_pattern_ops); (haven't tried any
other version so I'm not sure when this started to happen) -- Andreas Joseph


Browse pgsql-hackers by date

  From Date Subject
Next Message nickb 2019-04-30 09:26:32 ERROR: tuple concurrently updated when modifying privileges
Previous Message Andres Freund 2019-04-30 07:13:37 Re: performance regression when filling in a table