CODEWITHSUNDEEP
amazon-web-servicesaws-lambdaamazon-redshift
john.new.1998
john.new.1998

Reputation: 11

AWS - Lambda - OID - could not open relation with OID 26223345

I am new to aws, and I have the following problem. I have a lambda configured to launch a redshift process every hour. And from time to time it fails, and in cloudwatch I detect this "could not open relation with OID 26223345". I have read about the subject, and the redshift OIDs if I can detect them with a query, but that number never appears or another that cloudwatch reports to me. is this OID from a redshift object or is it from the lambda? I would really like to know what is OID, what is happening and to be able to solve it. Thank you

Upvotes: 1

Views: 1769

Answers (1)

Bill Weiner
Bill Weiner

Reputation: 11092

An OID is an Object ID from inside of Redshift. Everything in Redshift has an OID. A table has a table ID but also an OID. A database has a database ID and an OID. A schema has an OID, so do views. You get the idea. So this error is says that the "thing" with OID 26223345 could not be opened.

You will want to identify what that thing is and what type of thing it is. Likely a table but you will want to look it up. The system table pg_class is the root reference for all OIDs and you can look up what this object (thing) is that this error is referencing there.

Upvotes: 1

Related Questions