gin index trouble

[Rob Sargent <rsargent@xxxxxxxxxxxx>]

I’ve hit this same message 

Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN page is of different type

in a couple of contexts and I’m starting to get worried. 

• I’ve rebuilt the index, but will that help? 
• Is there a way to see what the ‘different type’ is? 
• Is it caught/clean-up by vacuum analyse or some such?

I’ve had good results using “<@" and “@>” and believe I've defended the use of an array, but I can’t loose three days worth of simulations to this dang wrong sibling.

select version(); — will use production release of 10 next week.
                                                  version                                                   
------------------------------------------------------------------------------------------------------------
 PostgreSQL 10beta3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit

The only gin index I have is in this table definition:

\d sui.probandset

           Table "sui.probandset"

   Column    |       Type       | Modifiers 

-------------+------------------+-----------

 id          | uuid             | not null

 name        | text             | 

 probands    | uuid[]           | not null

 meioses     | integer          | 

 min_kincoef | double precision | 

 max_kincoef | double precision | 

 people_id   | uuid             | not null

Indexes:

    "probandset_pkey" PRIMARY KEY, btree (id)

    "probandsetunique" gin (probands)

Check constraints:

    "sortedset" CHECK (issorteduuids(probands))

Foreign-key constraints:

    "probandset_people_id_fkey" FOREIGN KEY (people_id) REFERENCES base.people(id)

Referenced by:

    TABLE "sui.probandset_group_member" CONSTRAINT "probandset_group_member_member_id_fkey" FOREIGN KEY (member_id) REFERENCES sui.probandset(id)

    TABLE "sui.segment" CONSTRAINT "segment_probandset_id_fkey" FOREIGN KEY (probandset_id) REFERENCES sui.probandset(id)

and I um, er, enabled gin on uuid by copying from a thread in this list, as follows:

create operator class _uuid_ops

default for type _uuid

using gin as

operator 1 &&(anyarray, anyarray)

,operator 2 @>(anyarray, anyarray)

,operator 3 <@(anyarray, anyarray)

,operator 4 =(anyarray, anyarray)

,function 1 uuid_cmp(uuid, uuid)

,function 2 ginarrayextract(anyarray, internal, internal)

,function 3 ginqueryarrayextract(anyarray, internal, smallint, internal, internal, internal, internal)

,function 4 ginarrayconsistent(internal, smallint, anyarray, integer, internal, internal, internal, internal)

,storage uuid;