英文:
AWS Babelfish with Postgres is throwing sporadic error
问题
我们正在使用启用了Postgres的AWS Babelfish，理想情况下它是一个Postgres数据库。经常出现与“无法打开关系”相关的错误。相同的存储过程有时执行良好，有时却出现错误，如果不是更频繁地出现错误。我找到了一篇文章[https://www.postgresql.org/message-id/12791.1310599941%40sss.pgh.pa.us]讨论了这个错误，但没有指出确切的问题。其他文章也没有帮助我理解错误的模式。我已经向所有表添加了“.dbo”作为可能的修复之一，并在SP的末尾删除了所有临时表。
级别16，状态1，第4行
无法打开OID为54505的关系。
英文:
we are using AWS Babelfish with Postgres enabled DB, ideally it's a Postgres DB. There are frequent errors related to could not open relation. The same SP executes fine sometimes and same one fails with error sporadically if not more frequently. I have found a article[https://www.postgresql.org/message-id/12791.1310599941%40sss.pgh.pa.us] which discuss about the error, but it doesn't point the exact issue. And other articles doesn't help me understand the pattern of the error. I have added .dbo to all the tables as one of the possible fix and dropped all the temp tables at end of the SP as well.
Level 16, State 1, Line 4
could not open relation with OID 54505
答案1
得分: 1
请始终包括Babelfish版本（SELECT CAST(SERVERPROPERTY('BabelfishVersion') AS VARCHAR)）。即将发布的v.2.4.0修复了引发此错误的错误。
英文:
Please always include the Babelfish version (SELECT CAST(SERVERPROPERTY('BabelfishVersion') AS VARCHAR) ). The upcoming v.2.4.0 had a bug fixed which raised this error.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论