sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Colin Ma (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SENTRY-407) Add schema upgrade script to handle schema changes in 1.5
Date Wed, 10 Sep 2014 06:13:29 GMT

    [ https://issues.apache.org/jira/browse/SENTRY-407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14128119#comment-14128119
] 

Colin Ma commented on SENTRY-407:
---------------------------------

Hi, I update the sentry DB with this patch. My DB is mysql and I got the following error about
length when executed the script sentry-mysql-1.5.0.sql:

mysql> ALTER TABLE `SENTRY_DB_PRIVILEGE`
       ->   ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`);
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes


> Add schema upgrade script to handle schema changes in 1.5
> ---------------------------------------------------------
>
>                 Key: SENTRY-407
>                 URL: https://issues.apache.org/jira/browse/SENTRY-407
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Prasad Mujumdar
>            Assignee: Prasad Mujumdar
>         Attachments: SENTRY-407.1.patch, SENTRY-407.1.patch, SENTRY-407.1.patch, SENTRY-407.2.patch
>
>
> In Sentry 1.5, we have new features that has changed DB store schema. We need to include
the schema upgrade scripts and add some test cases to make sure the that upgrade via schema
tool works correctly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message