You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by "Anne Yu (JIRA)" <ji...@apache.org> on 2015/04/02 00:46:53 UTC
[jira] [Assigned] (SENTRY-691) upgrade schema tool: when upgrade
oracle backed db from 1.4.0 - 1.5.0, gets syntax error
[ https://issues.apache.org/jira/browse/SENTRY-691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anne Yu reassigned SENTRY-691:
------------------------------
Assignee: guoquan (was: Prasad Mujumdar)
> upgrade schema tool: when upgrade oracle backed db from 1.4.0 - 1.5.0, gets syntax error
> ----------------------------------------------------------------------------------------
>
> Key: SENTRY-691
> URL: https://issues.apache.org/jira/browse/SENTRY-691
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.5.0
> Environment: [root@anneyu-sentry-ha-10-1 incubator-sentry]# hostname
> anneyu-sentry-ha-10-1.ent.cloudera.com
> [root@anneyu-sentry-ha-10-1 incubator-sentry]# pwd
> /root/apache-sentry/1.5.0/incubator-sentry
> Reporter: Anne Yu
> Assignee: guoquan
> Fix For: 1.5.0
>
>
> {code}
> Sentry store connection URL: jdbc:oracle:thin:@//anneyu-sentry-cdh60-3.ent.cloudera.com:1521/xe
> Sentry store Connection Driver : oracle.jdbc.OracleDriver
> Sentry store connection User: sentryserver3ed186ace216a5ba8c
> Starting upgrade sentry store schema from version 1.4.0 to 1.5.0
> Upgrade script sentry-upgrade-oracle-1.4.0-to-1.5.0.sql
> Connecting to jdbc:oracle:thin:@//anneyu-sentry-cdh60-3.ent.cloudera.com:1521/xe
> Connected to: Oracle (version Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production)
> Driver: Oracle JDBC driver (version 11.2.0.3.0)
> Error: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels (state=99999,code=17030)
> ...
> {code}
> ./sentry-provider/sentry-provider-db/src/main/resources/005-SENTRY-398.oracle.sql
> Error:
> {code}
> 0: jdbc:oracle:thin:@//anneyu-sentry-cdh60-3.> CREATE TABLE "SENTRY_GM_PRIVILEGE" ( "GM_PRIVILEGE_ID" NUMBER NOT NULL, "COMPONENT_NAME" VARCHAR2(32) NOT NULL, "CREATE_TIME" NUMBER NOT NULL, "WITH_GRANT_OPTION" CHAR(1) NOT NULL DEFAULT 'N' "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', "ACTION" VARCHAR2(32) NOT NULL, "scope" VARCHAR2(128) NOT NULL, "SERVICE_NAME" VARCHAR2(64) NOT NULL, )
> Error: ORA-00907: missing right parenthesis (state=42000,code=907)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)