Re: logical replication - negative bitmapset member not allowed - Mailing list pgsql-general

From Tim Clarke
Subject Re: logical replication - negative bitmapset member not allowed
Date
Msg-id 6ba2356b-d6ad-abb5-e8ab-d4d9d3f7b0c7@minerva.info
Whole thread Raw
In response to Re: logical replication - negative bitmapset member not allowed  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-general
On 04/04/2019 22:37, Peter Intrauterine wrote:
> On 2019-04-01 23:43, Alvaro Herrera wrote:
>> Maybe the replica identity of a table got set to a unique index on oid?
>> Or something else involving system columns?  (If replication is
>> otherwise working, the I suppose there's a separate publication that's
>> having the error; the first thing to isolate would be to see what tables
>> are involved in that publication).
> Looking through the code, the bms_add_member() call in
> logicalrep_read_attrs() does not use the usual
> FirstLowInvalidHeapAttributeNumber offset, so that seems like a possible
> problem.
>
> However, I can't quite reproduce this.  There are various other checks
> that prevent this scenario, but it's plausible that with a bit of
> whacking around you could hit this error message.
>

Promise I've not been whacking around......


Tim Clarke



Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Web: https://www.manifest.co.uk/



Minerva Analytics Ltd
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | England


----------------------------------------------------------------------------------------------------------------------------

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee
youmust not use or disclose such information, instead please report it to
admin@minerva.info<mailto:admin@minerva.info>
Legal:  Minerva Analytics is the trading name of: Minerva Analytics
Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820
RegisteredOffice at above address. Please Click Here >><https://www.manifest.co.uk/legal/> for further information.
 

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Seeded Replication
Next
From: Rob Northcott
Date:
Subject: Query much slower on 9.6.5 than on 9.3.5