Re: Some pgq table rewrite incompatibility with logical decoding?

On 01/09/18 18:25, Jeremy Finzel wrote: > > Interesting. > > So you were running 9.6.9 before, it triggered the issue (and was not > able to recover). You took a filesystem snapshot, started a 9.6.10 on > the snapshot, and it recovered without hitting the issue? > > > I am

Re: Some pgq table rewrite incompatibility with logical decoding?

> > Interesting. > > So you were running 9.6.9 before, it triggered the issue (and was not > able to recover). You took a filesystem snapshot, started a 9.6.10 on > the snapshot, and it recovered without hitting the issue? > I am resposting this to the list and not only to Tomas. Tomas, I can’t

Re: Some pgq table rewrite incompatibility with logical decoding?

Hi, On 08/29/2018 12:01 AM, Tomas Vondra wrote: > On 08/28/2018 07:41 PM, Jeremy Finzel wrote: >> Jeremy, are you able to reproduce the issue locally, using pgq? >> That would be very valuable. >> >> >> Tomas et al: >> >> We have hit this error again, and we plan to snapshot the

Re: Some pgq table rewrite incompatibility with logical decoding?

On 08/28/2018 07:41 PM, Jeremy Finzel wrote: > Jeremy, are you able to reproduce the issue locally, using pgq? > That would be very valuable. > > > Tomas et al: > > We have hit this error again, and we plan to snapshot the database as to > be able to do whatever troubleshooting

Re: Some pgq table rewrite incompatibility with logical decoding?

Hi Jeremy, On 08/28/2018 10:46 PM, Jeremy Finzel wrote: > We have hit this error again, and we plan to snapshot the database > as to be able to do whatever troubleshooting we can.  > > > I am happy to report that we were able to get replication working again > by running snapshots of

Re: Some pgq table rewrite incompatibility with logical decoding?

> > We have hit this error again, and we plan to snapshot the database as to > be able to do whatever troubleshooting we can. > I am happy to report that we were able to get replication working again by running snapshots of the systems in question on servers running the latest point release

Re: Some pgq table rewrite incompatibility with logical decoding?

> > Jeremy, are you able to reproduce the issue locally, using pgq? That would >> be very valuable. > > Tomas et al: We have hit this error again, and we plan to snapshot the database as to be able to do whatever troubleshooting we can. If someone could provide me guidance as to what exactly you

Re: Some pgq table rewrite incompatibility with logical decoding?

> > I don't think that's true, for two reasons. > > Firstly, I don't think pgq updates catalogs directly, it simply truncates > the queue tables when rotating them (which updates the relfilenode in > pg_class, of course). > > Secondly, we're occasionally seeing this on systems that do not use pgq,

Re: Some pgq table rewrite incompatibility with logical decoding?

On 06/25/2018 07:48 PM, Jeremy Finzel wrote: On Mon, Jun 25, 2018 at 12:41 PM, Andres Freund > wrote: Hi, On 2018-06-25 10:37:18 -0500, Jeremy Finzel wrote: > I am hoping someone here can shed some light on this issue - I apologize if > this isn't

Re: Some pgq table rewrite incompatibility with logical decoding?

Hi, On 2018-06-25 10:37:18 -0500, Jeremy Finzel wrote: > I am hoping someone here can shed some light on this issue - I apologize if > this isn't the right place to ask this but I'm almost some of you all were > involving in pgq's dev and might be able to answer this. > > We are actually running

Some pgq table rewrite incompatibility with logical decoding?

I am hoping someone here can shed some light on this issue - I apologize if this isn't the right place to ask this but I'm almost some of you all were involving in pgq's dev and might be able to answer this. We are actually running 2 replication technologies on a few of our dbs, skytools and