Re: invalid non-zero objectSubId for object class

2020-07-10 Thread Adrian Klaver
On 7/10/20 8:06 AM, Michel Pelletier wrote: On Fri, Jul 10, 2020 at 5:37 AM Alvaro Herrera > wrote: On 2020-Jul-09, Michel Pelletier wrote: > I restored a snapshot and I can drop the tables there, so we'll likely > proceed  to swap the replicas

Re: invalid non-zero objectSubId for object class

2020-07-10 Thread Michel Pelletier
On Fri, Jul 10, 2020 at 5:37 AM Alvaro Herrera wrote: > On 2020-Jul-09, Michel Pelletier wrote: > > > I restored a snapshot and I can drop the tables there, so we'll likely > > proceed to swap the replicas over tomorrow. I have this corrupted > > instance i can continue to debug on if necessary

Re: invalid non-zero objectSubId for object class

2020-07-10 Thread Alvaro Herrera
On 2020-Jul-09, Michel Pelletier wrote: > I restored a snapshot and I can drop the tables there, so we'll likely > proceed to swap the replicas over tomorrow. I have this corrupted > instance i can continue to debug on if necessary. There seem to be some > other issues now that we're investigat

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Michel Pelletier
I restored a snapshot and I can drop the tables there, so we'll likely proceed to swap the replicas over tomorrow. I have this corrupted instance i can continue to debug on if necessary. There seem to be some other issues now that we're investigating, like a max(timestamp) query on the old insta

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Michel Pelletier
On Thu, Jul 9, 2020 at 5:32 PM Tom Lane wrote: > Alvaro Herrera writes: > > On 2020-Jul-09, Michel Pelletier wrote: > >> I don't seem to have either: > >> > >> dev=> select * from pg_depend where classid = 297108 or refclassid = > 297108; > >> classid | objid | objsubid | refclassid | refobjid |

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Michel Pelletier
On Thu, Jul 9, 2020 at 5:26 PM Alvaro Herrera wrote: > On 2020-Jul-09, Michel Pelletier wrote: > > > Hi Tom, thanks for getting back so quick: > > > > I don't seem to have either: > > > > dev=> select * from pg_depend where classid = 297108 or refclassid = > 297108; > > classid | objid | objsubi

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Tom Lane
Alvaro Herrera writes: > On 2020-Jul-09, Michel Pelletier wrote: >> I don't seem to have either: >> >> dev=> select * from pg_depend where classid = 297108 or refclassid = 297108; >> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype >> -+---+--+---

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Alvaro Herrera
On 2020-Jul-09, Michel Pelletier wrote: > Hi Tom, thanks for getting back so quick: > > I don't seem to have either: > > dev=> select * from pg_depend where classid = 297108 or refclassid = 297108; > classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype > -+---+

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Michel Pelletier
On Thu, Jul 9, 2020 at 4:18 PM Tom Lane wrote: > Michel Pelletier writes: > > On a 12.3 AWS RDS instance, I get the following error when trying to drop > > either of two tables: > > > dev=> drop table current_flight; > > ERROR: invalid non-zero objectSubId for object class 297108 > > dev=> drop

Re: invalid non-zero objectSubId for object class

2020-07-09 Thread Tom Lane
Michel Pelletier writes: > On a 12.3 AWS RDS instance, I get the following error when trying to drop > either of two tables: > dev=> drop table current_flight; > ERROR: invalid non-zero objectSubId for object class 297108 > dev=> drop table flight; > ERROR: invalid non-zero objectSubId for obje