Skip to main content

analyze_statistics failing with error "Relation with OID ***** does not exist"

  • July 29, 2014
  • 2 replies
  • 11 views
kannan_1
Forum|alt.badge.img+1
Hi,

I am trying to run analyze_statistics on the entire Db(around 30TB) . The job runs for about 45 mins, but fails after that with "Relation with OID does not exist". Is there any particular reason for this error ?? Or if some one deleted any objects in between the statistics generation, cause this issue ??

    2 replies

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • July 29, 2014
    I advice you to check your vertica.log , analyze_statistics  break the execution to table level analyze_statistics  execution .  if you drop a table during the execution you should see on the vertica.log some related into about that .

    wwong2
    Forum|alt.badge.img
    • wwong2
    • Participating Frequently
    • July 30, 2014
    Hi Kannan, there is a known issue where if table is dropped, when running stats will throw this error.
    Instead, can you pass in specific tables instead of the default to do all?

    Regards
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement