Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-489

Sentry DB upgrade fails on Oracle with "ORA-00905: missing keyword"

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.0
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:
      None

      Description

      Schema Upgrade from 1.4 to 1.5 fails for Oracle backend

      Error: ORA-00905: missing keyword (state=42000,code=905)
      org.apache.sentry.SentryUserException: Upgrade FAILED! Metastore state would be inconsistent !!
      org.apache.sentry.SentryUserException: Upgrade FAILED! Metastore state would be inconsistent !!
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool.doUpgrade(SentrySchemaTool.java:272)
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool.doUpgrade(SentrySchemaTool.java:240)
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool$CommandImpl.run(SentrySchemaTool.java:555)
      	at org.apache.sentry.SentryMain.main(SentryMain.java:94)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
      Caused by: java.io.IOException: Schema script failed, errorcode 2
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool.runBeeLine(SentrySchemaTool.java:414)
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool.runBeeLine(SentrySchemaTool.java:387)
      	at org.apache.sentry.provider.db.tools.SentrySchemaTool.doUpgrade(SentrySchemaTool.java:267)
      	... 8 more
      *** Sentry schemaTool failed ***
      

        Attachments

        1. SENTRY-489.1.patch
          2 kB
          Prasad Suresh Mujumdar

          Issue Links

            Activity

              People

              • Assignee:
                prasadm Prasad Suresh Mujumdar
                Reporter:
                prasadm Prasad Suresh Mujumdar
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: