[SENTRY-489] Sentry DB upgrade fails on Oracle with "ORA-00905: missing keyword"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.5.0
• Assignee: Prasad Suresh Mujumdar
• Reporter: Prasad Suresh Mujumdar
• Created: 04/Oct/14 06:50
• Updated: 04/Oct/14 12:48
• Resolved: 04/Oct/14 12:48

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 ***

Issue Links

• links to: Review #26337