You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ranger.apache.org by Chaoran Wang <ch...@cask.co> on 2017/06/19 20:23:06 UTC
Could not setup range-admin 0.7.2, key was too long error
Hi,
I am trying to install ranger on a CentOS server.
While installing ranger 0.7.2's ranger-admin setup.sh script, I have
encountered the following error:
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
`upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
`password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`),
UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
`x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
(`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
`x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
(`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
`x_portal_user_email` (`email`), CONSTRAINT
`x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES
`x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN
KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2
ROW_FORMAT=DYNAMIC;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
was too long; max key length is 1000 bytes
SQLException : SQL state: 42000
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
was too long; max key length is 1000 bytes ErrorCode: 1071
2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
other process
2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "show tables like 'xa_access_audit';"
2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
database ranger
2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "delete from x_db_version_h where
version='CORE_DB_SCHEMA' and active='N' and updated_by='
ranger24355-1000.dev.continuuity.net';"
2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
Could you please take a look at error and give me some hints on solution?
Really appreciate!
Chaoran
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Anirudh Jonnadula <an...@gmail.com>.
Hi Chaoran,
Could you try updating MySQL to v5.7 and try? Or you can use CentOS 7 which
comes with MariaDB. Let me know if these solutions work.
Thanks
Regards,
Anirudh
On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>
wrote:
> Hello Chaoran:
>
> This seems to be related to Mysql config. Try setting the below before
> running install script as mentioned here -
> https://stackoverflow.com/questions/8746207/1071-
> specified-key-was-too-long-
> max-key-length-is-1000-bytes
>
> SET @@global.innodb_large_prefix = 1;
>
> I am adding Ranger dev list to see if there are any other solutions.
>
> Thank you,
> Vel
>
> From: Chaoran Wang <ch...@cask.co>
> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Date: Monday, June 19, 2017 at 3:23 PM
> To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Subject: Could not setup range-admin 0.7.2, key was too long error
>
> Hi,
>
> I am trying to install ranger on a CentOS server.
>
> While installing ranger 0.7.2's ranger-admin setup.sh script, I have
> encountered the following error:
>
>
> Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
> AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
> datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
> `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
> NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
> varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
> `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
> `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
> DEFAULT
> '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE
> KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
> `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
> (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
> `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
> (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
> `x_portal_user_email` (`email`), CONSTRAINT
> `x_portal_user_FK_added_by_id`
> FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT
> `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES
> `x_portal_user` (`id`) )AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
> was
> too long; max key length is 1000 bytes
> SQLException : SQL state: 42000
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
> was
> too long; max key length is 1000 bytes ErrorCode: 1071
> 2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
> 2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
> other process
> 2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/usr/local/
> ranger-0.7.2-SNAPSHOT-ad
> min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
> -trim
> -c \; -query "show tables like 'xa_access_audit';"
> 2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
> database ranger
> 2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/usr/local/
> ranger-0.7.2-SNAPSHOT-ad
> min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
> -trim
> -c \; -query "delete from x_db_version_h where version='CORE_DB_SCHEMA' and
> active='N' and updated_by='ranger24355-1000.dev.continuuity.net
> <http://ranger24355-1000.dev.continuuity.net> ';"
> 2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
>
> Could you please take a look at error and give me some hints on solution?
>
> Really appreciate!
>
> Chaoran
>
>
>
Re: Re: Could not setup range-admin 0.7.2, key was too long error
Posted by pe...@zte.com.cn.
SGkgQ2hhb3JhbiAmIFZlbDoNCg0KDQoNCg0KUGxlYXNlIHVzZSBmb2xsb3dpbmcgY29tbWFuZHMg
dG8gYXZvaWQgdGhpcyBwcm9ibGVtLg0KDQpteXNxbD4gc2hvdyB2YXJpYWJsZXMgbGlrZSAnJWNo
YXIlJw0KDQpteXNxbD5hbHRlciBkYXRhYmFzZSBkYm5hbWUgY2hhcmFjdGVyIHNldCBsYXRpbjEv
L2RibmFtZSBzaG91bGQgZXF1YWwgdG8gcmFuZ2VyIGluIHlvdXIgZW52aXJvbm1lbnQuDQoNCm15
c3FsPmZsdXNoIHByaXZpbGVnZXMNCg0KDQoNCg0KUGVuZyBKaWFuaHVhDQoNCg0KDQoNCg0KDQoN
Cg0KDQoNCg0KDQoNCuWOn+Wni+mCruS7tg0KDQoNCg0K5Y+R5Lu25Lq677yaIDx2cGVyaWFzYW15
QGhvcnRvbndvcmtzLmNvbT4NCuaUtuS7tuS6uu+8miA8dXNlckByYW5nZXIuYXBhY2hlLm9yZz4N
CuaKhOmAgeS6uu+8miA8ZGV2QHJhbmdlci5hcGFjaGUub3JnPg0K5pelIOacnyDvvJoyMDE35bm0
MDbmnIgyMeaXpSAwNjo0Ng0K5Li7IOmimCDvvJpSZTogQ291bGQgbm90IHNldHVwIHJhbmdlLWFk
bWluIDAuNy4yLCBrZXkgd2FzIHRvbyBsb25nIGVycm9yDQoNCg0KDQoNCg0KSGkgQ2hhb3JhbjoN
Cg0KVGhpcyBpcyBhIG15c3FsIGNvbmZpZyBwYXJhbWV0ZXIgYW5kIHNob3VsZCBiZSBzZXQgaW4g
bXlzcWwuIEkgdHJpZWQgaXQgbGlrZSBiZWxvdyBhbmQgaXQgd29ya2VkIGZpbmUuIE5vIGNoYW5n
ZSBmcm9tIHJhbmdlciBzY3JpcHQgc2hvdWxkIGJlIHJlcXVpcmVkLiBXaGF0IHZlcnNpb24gb2Yg
bXlzcWwgYXJlIHlvdSB1c2luZz8NCg0KbXlzcWw+IHNldCBAQGdsb2JhbC5pbm5vZGJfbGFyZ2Vf
cHJlZml4ID0gMQ0KUXVlcnkgT0ssIDAgcm93cyBhZmZlY3RlZCAoMC4wMCBzZWMpDQoNClRoYW5r
IHlvdSwNClZlbA0KDQoNCkZyb206IENoYW9yYW4gV2FuZyA8Y2hhb3JhbkBjYXNrLmNvPG1haWx0
bzpjaGFvcmFuQGNhc2suY28+Pg0KUmVwbHktVG86ICJ1c2VyQHJhbmdlci5hcGFjaGUub3JnPG1h
aWx0bzp1c2VyQHJhbmdlci5hcGFjaGUub3JnPiIgPHVzZXJAcmFuZ2VyLmFwYWNoZS5vcmc8bWFp
bHRvOnVzZXJAcmFuZ2VyLmFwYWNoZS5vcmc+Pg0KRGF0ZTogVHVlc2RheSwgSnVuZSAyMCwgMjAx
NyBhdCA1OjIyIFBNDQpUbzogInVzZXJAcmFuZ2VyLmFwYWNoZS5vcmc8bWFpbHRvOnVzZXJAcmFu
Z2VyLmFwYWNoZS5vcmc+IiA8dXNlckByYW5nZXIuYXBhY2hlLm9yZzxtYWlsdG86dXNlckByYW5n
ZXIuYXBhY2hlLm9yZz4+DQpDYzogImRldkByYW5nZXIuYXBhY2hlLm9yZzxtYWlsdG86ZGV2QHJh
bmdlci5hcGFjaGUub3JnPiIgPGRldkByYW5nZXIuYXBhY2hlLm9yZzxtYWlsdG86ZGV2QHJhbmdl
ci5hcGFjaGUub3JnPj4NClN1YmplY3Q6IFJlOiBDb3VsZCBub3Qgc2V0dXAgcmFuZ2UtYWRtaW4g
MC43LjIsIGtleSB3YXMgdG9vIGxvbmcgZXJyb3INCg0KUnVubmluZyByYW5nZXIgNy4xLXJlbGVh
c2UgdGFnZ2VkIGJyYW5jaCByZXN1bHQgaW4gdGhlIHNhbWUgZXJyb3IuDQpbWF1bWF1bWF1bWF1B
bnkgaWRlYXM/8J+YhQ0KDQpPbiBUdWUsIEp1biAyMCwgMjAxNyBhdCAzOjE2IFBNLCBDaGFvcmFu
IFdhbmcgPGNoYW9yYW5AY2Fzay5jbzxtYWlsdG86Y2hhb3JhbkBjYXNrLmNvPj4gd3JvdGU6DQpI
aSBWZWwsDQoNClRoYW5rIHlvdSBzbyBtdWNoIGZvciB0aGUgaGludC4NCkhvd2V2ZXIsIHdoZW4g
aSB0cnkgdG8gcnVuDQpTRVQgQEBnbG9iYWwuaW5ub2RiX2xhcmdlX3ByZWZpeCA9IDENCmluIG15
c3FsLCBnaXZlcyB0aGUgZm9sbG93aW5nIGVycm9yczoNCkVSUk9SIDExOTMgKEhZMDAwKTogVW5r
bm93biBzeXN0ZW0gdmFyaWFibGUgJ2lubm9kYl9sYXJnZV9wcmVmaXgnDQpXaGF0J3MgdGhlIHNj
aGVtYSBvZiB0aGUgdGFibGUgaSBuZWVkIHRvIHNldCBmb3IgcmFuZ2VyLWFkbWluLTAuNy4xPw0K
SXQgc2VlbXMgdGhlIHN0YWNrIG92ZXJmbG93IGxpbmsgaXMgbW9yZSBvZiBhIGdlbmVyYWwgcXVl
c3Rpb24gb2YgU3BlY2lmaWVkIGtleSB3YXMgdG9vIGxvbmcgbWF4IGtleSBsZW5ndGggaXMgMTAw
MCBieXRlcy4gRG8gaSBuZWVkIHRvIG1vZGlmeSB0aGUgc2V0dXAuc2ggc2NyaXB0IG9mIHJhbmdl
ci1hZG1pbi0wLjcuMSBpbiBvcmRlciB0byBhY2hpZXZlIHRoaXM/DQoNClJlYWxseSBhcHByZWNp
YXRlZCENCg0KQmVzdCwNCkNoYW9yYW4NCg0KT24gTW9uLCBKdW4gMTksIDIwMTcgYXQgMzowMCBQ
TSwgVmVsbXVydWdhbiBQZXJpYXNhbXkgPHZlbEBhcGFjaGUub3JnPG1haWx0bzp2ZWxAYXBhY2hl
Lm9yZz4+IHdyb3RlOg0KSGVsbG8gQ2hhb3JhbjoNCg0KVGhpcyBzZWVtcyB0byBiZSByZWxhdGVk
IHRvIE15c3FsIGNvbmZpZy4gVHJ5IHNldHRpbmcgdGhlIGJlbG93IGJlZm9yZSBydW5uaW5nIGlu
c3RhbGwgc2NyaXB0IGFzIG1lbnRpb25lZCBoZXJlIC0gaHR0cHM6Ly9zdGFja292ZXJmbG93LmNv
bS9xdWVzdGlvbnMvODc0NjIwNy8xMDcxLXNwZWNpZmllZC1rZXktd2FzLXRvby1sb25nLW1heC1r
ZXktbGVuZ3RoLWlzLTEwMDAtYnl0ZXMNCg0KU0VUIEBAZ2xvYmFsLmlubm9kYl9sYXJnZV9wcmVm
aXggPSAxDQoNCkkgYW0gYWRkaW5nIFJhbmdlciBkZXYgbGlzdCB0byBzZWUgaWYgdGhlcmUgYXJl
IGFueSBvdGhlciBzb2x1dGlvbnMuDQoNClRoYW5rIHlvdSwNClZlbA0KDQpGcm9tOiBDaGFvcmFu
IFdhbmcgPGNoYW9yYW5AY2Fzay5jbzxtYWlsdG86Y2hhb3JhbkBjYXNrLmNvPj4NClJlcGx5LVRv
OiAidXNlckByYW5nZXIuYXBhY2hlLm9yZzxtYWlsdG86dXNlckByYW5nZXIuYXBhY2hlLm9yZz4i
IDx1c2VyQHJhbmdlci5hcGFjaGUub3JnPG1haWx0bzp1c2VyQHJhbmdlci5hcGFjaGUub3JnPj4N
CkRhdGU6IE1vbmRheSwgSnVuZSAxOSwgMjAxNyBhdCAzOjIzIFBNDQpUbzogInVzZXJAcmFuZ2Vy
LmFwYWNoZS5vcmc8bWFpbHRvOnVzZXJAcmFuZ2VyLmFwYWNoZS5vcmc+IiA8dXNlckByYW5nZXIu
YXBhY2hlLm9yZzxtYWlsdG86dXNlckByYW5nZXIuYXBhY2hlLm9yZz4+DQpTdWJqZWN0OiBDb3Vs
ZCBub3Qgc2V0dXAgcmFuZ2UtYWRtaW4gMC43LjIsIGtleSB3YXMgdG9vIGxvbmcgZXJyb3INCg0K
SGksDQoNCkkgYW0gdHJ5aW5nIHRvIGluc3RhbGwgcmFuZ2VyIG9uIGEgQ2VudE9TIHNlcnZlci4N
Cg0KV2hpbGUgaW5zdGFsbGluZyByYW5nZXIgMC43LjIncyByYW5nZXItYWRtaW4gIHNldHVwLnNo
IHNjcmlwdCwgSSBoYXZlIGVuY291bnRlcmVkIHRoZSBmb2xsb3dpbmcgZXJyb3I6DQoNCg0KRXJy
b3IgZXhlY3V0aW5nOiBDUkVBVEUgVEFCTEUgYHhfcG9ydGFsX3VzZXJgICggICBgaWRgIGJpZ2lu
dCgyMCkgTk9UIE5VTEwgQVVUT19JTkNSRU1FTlQsICAgYGNyZWF0ZV90aW1lYCBkYXRldGltZSBE
RUZBVUxUIE5VTEwsICAgYHVwZGF0ZV90aW1lYCBkYXRldGltZSBERUZBVUxUIE5VTEwsICAgYGFk
ZGVkX2J5X2lkYCBiaWdpbnQoMjApIERFRkFVTFQgTlVMTCwgICBgdXBkX2J5X2lkYCBiaWdpbnQo
MjApIERFRkFVTFQgTlVMTCwgICBgZmlyc3RfbmFtZWAgdmFyY2hhcigxMDIyKSBERUZBVUxUIE5V
TEwsICAgYGxhc3RfbmFtZWAgdmFyY2hhcigxMDIyKSBERUZBVUxUIE5VTEwsICAgYHB1Yl9zY3Jf
bmFtZWAgdmFyY2hhcigyMDQ4KSBERUZBVUxUIE5VTEwsICAgYGxvZ2luX2lkYCB2YXJjaGFyKDc2
NykgREVGQVVMVCBOVUxMLCAgIGBwYXNzd29yZGAgdmFyY2hhcig1MTIpIE5PVCBOVUxMLCAgIGBl
bWFpbGAgdmFyY2hhcig1MTIpIERFRkFVTFQgTlVMTCwgICBgc3RhdHVzYCBpbnQoMTEpIE5PVCBO
VUxMIERFRkFVTFQgJzAnLCAgIGB1c2VyX3NyY2AgaW50KDExKSBOT1QgTlVMTCBERUZBVUxUICcw
JywgICBgbm90ZXNgIHZhcmNoYXIoNDAwMCkgREVGQVVMVCBOVUxMLCAgIFBSSU1BUlkgS0VZIChg
aWRgKSwgICBVTklRVUUgS0VZIGB4X3BvcnRhbF91c2VyX1VLX2xvZ2luX2lkYCAoYGxvZ2luX2lk
YCksICAgVU5JUVVFIEtFWSBgeF9wb3J0YWxfdXNlcl9VS19lbWFpbGAgKGBlbWFpbGApLCAgIEtF
WSBgeF9wb3J0YWxfdXNlcl9GS19hZGRlZF9ieV9pZGAgKGBhZGRlZF9ieV9pZGApLCAgIEtFWSBg
eF9wb3J0YWxfdXNlcl9GS191cGRfYnlfaWRgIChgdXBkX2J5X2lkYCksICAgS0VZIGB4X3BvcnRh
bF91c2VyX2NyX3RpbWVgIChgY3JlYXRlX3RpbWVgKSwgICBLRVkgYHhfcG9ydGFsX3VzZXJfdXBf
dGltZWAgKGB1cGRhdGVfdGltZWApLCAgIEtFWSBgeF9wb3J0YWxfdXNlcl9uYW1lYCAoYGZpcnN0
X25hbWVgKDc2NykpLCAgIEtFWSBgeF9wb3J0YWxfdXNlcl9lbWFpbGAgKGBlbWFpbGApLCAgIENP
TlNUUkFJTlQgYHhfcG9ydGFsX3VzZXJfRktfYWRkZWRfYnlfaWRgIEZPUkVJR04gS0VZIChgYWRk
ZWRfYnlfaWRgKSBSRUZFUkVOQ0VTIGB4X3BvcnRhbF91c2VyYCAoYGlkYCksICAgQ09OU1RSQUlO
VCBgeF9wb3J0YWxfdXNlcl9GS191cGRfYnlfaWRgIEZPUkVJR04gS0VZIChgdXBkX2J5X2lkYCkg
UkVGRVJFTkNFUyBgeF9wb3J0YWxfdXNlcmAgKGBpZGApIClBVVRPX0lOQ1JFTUVOVD0yIFJPV19G
T1JNQVQ9RFlOQU1JQw0KY29tLm15c3FsLmpkYmMuZXhjZXB0aW9ucy5qZGJjNC5NeVNRTFN5bnRh
eEVycm9yRXhjZXB0aW9uOiBTcGVjaWZpZWQga2V5IHdhcyB0b28gbG9uZyBtYXgga2V5IGxlbmd0
aCBpcyAxMDAwIGJ5dGVzDQpTUUxFeGNlcHRpb24gOiBTUUwgc3RhdGU6IDQyMDAwIGNvbS5teXNx
bC5qZGJjLmV4Y2VwdGlvbnMuamRiYzQuTXlTUUxTeW50YXhFcnJvckV4Y2VwdGlvbjogU3BlY2lm
aWVkIGtleSB3YXMgdG9vIGxvbmcgbWF4IGtleSBsZW5ndGggaXMgMTAwMCBieXRlcyBFcnJvckNv
ZGU6IDEwNzENCjIwMTctMDYtMTkgMjA6MDY6NDgsMjM3ICBbRV0geGFfY29yZV9kYi5zcWwgZmls
ZSBpbXBvcnQgZmFpbGVkIQ0KMjAxNy0wNi0xOSAyMDowNjo0OCwyMzcgIFtJXSBDT1JFX0RCX1ND
SEVNQSBtaWdodCBiZWluZyBpbXBvcnRlZCBieSBzb21lIG90aGVyIHByb2Nlc3MNCjIwMTctMDYt
MTkgMjA6MDg6NDgsMzM2ICBbSklTUUxdIC91c3IvbGliL2p2bS9qYXZhL2Jpbi9qYXZhICAtY3Ag
L3Vzci9zaGFyZS9qYXZhL215c3FsLWNvbm5lY3Rvci1qYXZhLmphcjovdXNyL2xvY2FsL3Jhbmdl
ci0wLjcuMi1TTkFQU0hPVC1hZG1pbi9qaXNxbC9saWIvKiBvcmcuYXBhY2hlLnV0aWwuc3FsLkpp
c3FsIC1kcml2ZXIgbXlzcWxjb25qIC1jc3RyaW5nIGpkYmM6bXlzcWw6Ly9sb2NhbGhvc3QvcmFu
Z2VyIC11ICdyYW5nZXJhZG1pbicgLXAgJyoqKioqKioqJyAtbm9oZWFkZXIgLXRyaW0gLWMgXCAt
cXVlcnkgInNob3cgdGFibGVzIGxpa2UgJ3hhX2FjY2Vzc19hdWRpdCciDQoyMDE3LTA2LTE5IDIw
OjA4OjQ4LDY1NyAgW0ldIFRhYmxlIHhhX2FjY2Vzc19hdWRpdCBkb2VzIG5vdCBleGlzdCBpbiBk
YXRhYmFzZSByYW5nZXINCjIwMTctMDYtMTkgMjA6MDg6NDgsNjU3ICBbSklTUUxdIC91c3IvbGli
L2p2bS9qYXZhL2Jpbi9qYXZhICAtY3AgL3Vzci9zaGFyZS9qYXZhL215c3FsLWNvbm5lY3Rvci1q
YXZhLmphcjovdXNyL2xvY2FsL3Jhbmdlci0wLjcuMi1TTkFQU0hPVC1hZG1pbi9qaXNxbC9saWIv
KiBvcmcuYXBhY2hlLnV0aWwuc3FsLkppc3FsIC1kcml2ZXIgbXlzcWxjb25qIC1jc3RyaW5nIGpk
YmM6bXlzcWw6Ly9sb2NhbGhvc3QvcmFuZ2VyIC11ICdyYW5nZXJhZG1pbicgLXAgJyoqKioqKioq
JyAtbm9oZWFkZXIgLXRyaW0gLWMgXCAtcXVlcnkgImRlbGV0ZSBmcm9tIHhfZGJfdmVyc2lvbl9o
IHdoZXJlIHZlcnNpb249J0NPUkVfREJfU0NIRU1BJyBhbmQgYWN0aXZlPSdOJyBhbmQgdXBkYXRl
ZF9ieT0ncmFuZ2VyMjQzNTUtMTAwMC5kZXYuY29udGludXVpdHkubmV0PGh0dHA6Ly9yYW5nZXIy
NDM1NS0xMDAwLmRldi5jb250aW51dWl0eS5uZXQ+JyINCjIwMTctMDYtMTkgMjA6MDg6NDgsOTYz
ICBbRV0gQ09SRV9EQl9TQ0hFTUEgaW1wb3J0IGZhaWxlZCENCg0KQ291bGQgeW91IHBsZWFzZSB0
YWtlIGEgbG9vayBhdCBlcnJvciBhbmQgZ2l2ZSBtZSBzb21lIGhpbnRzIG9uIHNvbHV0aW9uPw0K
DQpSZWFsbHkgYXBwcmVjaWF0ZSENCg0KQ2hhb3Jhbg==
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Chaoran Wang <ch...@cask.co>.
Hi Vel,
I was using mysql 5.1 and i have upgraded the version to 5.5.
The innodb_large_prefix configure seems only exists for mysql 5.5 and
above. I have set the configure now.
However, rerun the ranger-admin-0.7.1 setup.sh script seems spinning at:
2017-06-21 00:14:05,308 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.1-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "select version from x_db_version_h where version =
'CORE_DB_SCHEMA' and active = 'N';"
2017-06-21 00:14:05,587 [I] CORE_DB_SCHEMA is being imported by some other
process
2017-06-21 00:16:05,688 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.1-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "select version from x_db_version_h where version =
'CORE_DB_SCHEMA' and active = 'N';"
2017-06-21 00:16:05,954 [I] CORE_DB_SCHEMA is being imported by some other
process
infinitely.
Thanks,
Chaoran
On Tue, Jun 20, 2017 at 3:46 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:
> Hi Chaoran:
>
> This is a mysql config parameter and should be set in mysql. I tried it
> like below and it worked fine. No change from ranger script should be
> required. What version of mysql are you using?
>
> mysql> set @@global.innodb_large_prefix = 1;
> Query OK, 0 rows affected (0.00 sec)
>
> Thank you,
> Vel
>
>
> From: Chaoran Wang <ch...@cask.co>
> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Date: Tuesday, June 20, 2017 at 5:22 PM
> To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Cc: "dev@ranger.apache.org" <de...@ranger.apache.org>
> Subject: Re: Could not setup range-admin 0.7.2, key was too long error
>
> Running ranger 7.1-release tagged branch result in the same error.
> Any ideas?😅
>
> On Tue, Jun 20, 2017 at 3:16 PM, Chaoran Wang <ch...@cask.co> wrote:
>
>> Hi Vel,
>>
>> Thank you so much for the hint.
>> However, when i try to run
>> SET @@global.innodb_large_prefix = 1;
>> in mysql, gives the following errors:
>> ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
>> What's the schema of the table i need to set for ranger-admin-0.7.1?
>> It seems the stack overflow link is more of a general question of Specified
>> key was too long; max key length is 1000 bytes. Do i need to modify the
>> setup.sh script of ranger-admin-0.7.1 in order to achieve this?
>>
>> Really appreciated!
>>
>> Best,
>> Chaoran
>>
>> On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>
>> wrote:
>>
>>> Hello Chaoran:
>>>
>>> This seems to be related to Mysql config. Try setting the below before
>>> running install script as mentioned here - https://stackoverflow.com/qu
>>> estions/8746207/1071-specified-key-was-too-long-max-key-leng
>>> th-is-1000-bytes
>>>
>>> SET @@global.innodb_large_prefix = 1;
>>>
>>> I am adding Ranger dev list to see if there are any other solutions.
>>>
>>> Thank you,
>>> Vel
>>>
>>> From: Chaoran Wang <ch...@cask.co>
>>> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
>>> Date: Monday, June 19, 2017 at 3:23 PM
>>> To: "user@ranger.apache.org" <us...@ranger.apache.org>
>>> Subject: Could not setup range-admin 0.7.2, key was too long error
>>>
>>> Hi,
>>>
>>> I am trying to install ranger on a CentOS server.
>>>
>>> While installing ranger 0.7.2's ranger-admin setup.sh script, I have
>>> encountered the following error:
>>>
>>>
>>> Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT
>>> NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
>>> datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
>>> `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
>>> NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
>>> varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
>>> `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
>>> `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
>>> DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`),
>>> UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
>>> `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
>>> (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
>>> `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
>>> (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
>>> `x_portal_user_email` (`email`), CONSTRAINT
>>> `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES
>>> `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN
>>> KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2
>>> ROW_FORMAT=DYNAMIC;
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified
>>> key was too long; max key length is 1000 bytes
>>> SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>>> Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
>>> 2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
>>> 2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
>>> other process
>>> 2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
>>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0
>>> .7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>>> '********' -noheader -trim -c \; -query "show tables like
>>> 'xa_access_audit';"
>>> 2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
>>> database ranger
>>> 2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
>>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0
>>> .7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>>> '********' -noheader -trim -c \; -query "delete from x_db_version_h where
>>> version='CORE_DB_SCHEMA' and active='N' and updated_by='
>>> ranger24355-1000.dev.continuuity.net';"
>>> 2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
>>>
>>> Could you please take a look at error and give me some hints on solution?
>>>
>>> Really appreciate!
>>>
>>> Chaoran
>>>
>>
>>
>
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
Hi Chaoran:
This is a mysql config parameter and should be set in mysql. I tried it like below and it worked fine. No change from ranger script should be required. What version of mysql are you using?
mysql> set @@global.innodb_large_prefix = 1;
Query OK, 0 rows affected (0.00 sec)
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>>
Reply-To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Date: Tuesday, June 20, 2017 at 5:22 PM
To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Cc: "dev@ranger.apache.org<ma...@ranger.apache.org>" <de...@ranger.apache.org>>
Subject: Re: Could not setup range-admin 0.7.2, key was too long error
Running ranger 7.1-release tagged branch result in the same error.
[X][X][X][X]Any ideas?😅
On Tue, Jun 20, 2017 at 3:16 PM, Chaoran Wang <ch...@cask.co>> wrote:
Hi Vel,
Thank you so much for the hint.
However, when i try to run
SET @@global.innodb_large_prefix = 1;
in mysql, gives the following errors:
ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
What's the schema of the table i need to set for ranger-admin-0.7.1?
It seems the stack overflow link is more of a general question of Specified key was too long; max key length is 1000 bytes. Do i need to modify the setup.sh script of ranger-admin-0.7.1 in order to achieve this?
Really appreciated!
Best,
Chaoran
On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>> wrote:
Hello Chaoran:
This seems to be related to Mysql config. Try setting the below before running install script as mentioned here - https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-max-key-length-is-1000-bytes
SET @@global.innodb_large_prefix = 1;
I am adding Ranger dev list to see if there are any other solutions.
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>>
Reply-To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Date: Monday, June 19, 2017 at 3:23 PM
To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Subject: Could not setup range-admin 0.7.2, key was too long error
Hi,
I am trying to install ranger on a CentOS server.
While installing ranger 0.7.2's ranger-admin setup.sh script, I have encountered the following error:
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL, `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name` varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL, `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id` (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time` (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY `x_portal_user_email` (`email`), CONSTRAINT `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some other process
2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'xa_access_audit';"
2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in database ranger
2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "delete from x_db_version_h where version='CORE_DB_SCHEMA' and active='N' and updated_by='ranger24355-1000.dev.continuuity.net<http://ranger24355-1000.dev.continuuity.net>';"
2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
Could you please take a look at error and give me some hints on solution?
Really appreciate!
Chaoran
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
Hi Chaoran:
This is a mysql config parameter and should be set in mysql. I tried it like below and it worked fine. No change from ranger script should be required. What version of mysql are you using?
mysql> set @@global.innodb_large_prefix = 1;
Query OK, 0 rows affected (0.00 sec)
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>>
Reply-To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Date: Tuesday, June 20, 2017 at 5:22 PM
To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Cc: "dev@ranger.apache.org<ma...@ranger.apache.org>" <de...@ranger.apache.org>>
Subject: Re: Could not setup range-admin 0.7.2, key was too long error
Running ranger 7.1-release tagged branch result in the same error.
[X][X][X][X]Any ideas?😅
On Tue, Jun 20, 2017 at 3:16 PM, Chaoran Wang <ch...@cask.co>> wrote:
Hi Vel,
Thank you so much for the hint.
However, when i try to run
SET @@global.innodb_large_prefix = 1;
in mysql, gives the following errors:
ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
What's the schema of the table i need to set for ranger-admin-0.7.1?
It seems the stack overflow link is more of a general question of Specified key was too long; max key length is 1000 bytes. Do i need to modify the setup.sh script of ranger-admin-0.7.1 in order to achieve this?
Really appreciated!
Best,
Chaoran
On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>> wrote:
Hello Chaoran:
This seems to be related to Mysql config. Try setting the below before running install script as mentioned here - https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-max-key-length-is-1000-bytes
SET @@global.innodb_large_prefix = 1;
I am adding Ranger dev list to see if there are any other solutions.
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>>
Reply-To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Date: Monday, June 19, 2017 at 3:23 PM
To: "user@ranger.apache.org<ma...@ranger.apache.org>" <us...@ranger.apache.org>>
Subject: Could not setup range-admin 0.7.2, key was too long error
Hi,
I am trying to install ranger on a CentOS server.
While installing ranger 0.7.2's ranger-admin setup.sh script, I have encountered the following error:
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL, `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name` varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL, `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id` (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time` (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY `x_portal_user_email` (`email`), CONSTRAINT `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some other process
2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'xa_access_audit';"
2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in database ranger
2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "delete from x_db_version_h where version='CORE_DB_SCHEMA' and active='N' and updated_by='ranger24355-1000.dev.continuuity.net<http://ranger24355-1000.dev.continuuity.net>';"
2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
Could you please take a look at error and give me some hints on solution?
Really appreciate!
Chaoran
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Chaoran Wang <ch...@cask.co>.
So my mysql version is 5.1.73. The variable is introduced in 5.5. Is there
anyway i can use ranger 0.7.1-release to be compatible with a large_prefix
not supported mysql version(e.g. 5.1.73)? Thanks!
Quota
innodb_large_prefix
<https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_large_prefix>
was
introduced in MySQL 5.5 to disable large index key prefixes for
compatibility with earlier versions of InnoDB that do not support large
index key prefixes.
Best,
Chaoran
On Tue, Jun 20, 2017 at 3:22 PM, Chaoran Wang <ch...@cask.co> wrote:
> Running ranger 7.1-release tagged branch result in the same error.
> Any ideas?😅
>
> On Tue, Jun 20, 2017 at 3:16 PM, Chaoran Wang <ch...@cask.co> wrote:
>
>> Hi Vel,
>>
>> Thank you so much for the hint.
>> However, when i try to run
>> SET @@global.innodb_large_prefix = 1;
>> in mysql, gives the following errors:
>> ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
>> What's the schema of the table i need to set for ranger-admin-0.7.1?
>> It seems the stack overflow link is more of a general question of Specified
>> key was too long; max key length is 1000 bytes. Do i need to modify the
>> setup.sh script of ranger-admin-0.7.1 in order to achieve this?
>>
>> Really appreciated!
>>
>> Best,
>> Chaoran
>>
>> On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>
>> wrote:
>>
>>> Hello Chaoran:
>>>
>>> This seems to be related to Mysql config. Try setting the below before
>>> running install script as mentioned here - https://stackoverflow.com/qu
>>> estions/8746207/1071-specified-key-was-too-long-max-key-leng
>>> th-is-1000-bytes
>>>
>>> SET @@global.innodb_large_prefix = 1;
>>>
>>> I am adding Ranger dev list to see if there are any other solutions.
>>>
>>> Thank you,
>>> Vel
>>>
>>> From: Chaoran Wang <ch...@cask.co>
>>> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
>>> Date: Monday, June 19, 2017 at 3:23 PM
>>> To: "user@ranger.apache.org" <us...@ranger.apache.org>
>>> Subject: Could not setup range-admin 0.7.2, key was too long error
>>>
>>> Hi,
>>>
>>> I am trying to install ranger on a CentOS server.
>>>
>>> While installing ranger 0.7.2's ranger-admin setup.sh script, I have
>>> encountered the following error:
>>>
>>>
>>> Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT
>>> NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
>>> datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
>>> `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
>>> NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
>>> varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
>>> `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
>>> `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
>>> DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`),
>>> UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
>>> `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
>>> (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
>>> `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
>>> (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
>>> `x_portal_user_email` (`email`), CONSTRAINT
>>> `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES
>>> `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN
>>> KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2
>>> ROW_FORMAT=DYNAMIC;
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified
>>> key was too long; max key length is 1000 bytes
>>> SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>>> Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
>>> 2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
>>> 2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
>>> other process
>>> 2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
>>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0
>>> .7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>>> '********' -noheader -trim -c \; -query "show tables like
>>> 'xa_access_audit';"
>>> 2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
>>> database ranger
>>> 2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
>>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0
>>> .7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>>> '********' -noheader -trim -c \; -query "delete from x_db_version_h where
>>> version='CORE_DB_SCHEMA' and active='N' and updated_by='
>>> ranger24355-1000.dev.continuuity.net';"
>>> 2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
>>>
>>> Could you please take a look at error and give me some hints on solution?
>>>
>>> Really appreciate!
>>>
>>> Chaoran
>>>
>>
>>
>
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Chaoran Wang <ch...@cask.co>.
Running ranger 7.1-release tagged branch result in the same error.
Any ideas?😅
On Tue, Jun 20, 2017 at 3:16 PM, Chaoran Wang <ch...@cask.co> wrote:
> Hi Vel,
>
> Thank you so much for the hint.
> However, when i try to run
> SET @@global.innodb_large_prefix = 1;
> in mysql, gives the following errors:
> ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
> What's the schema of the table i need to set for ranger-admin-0.7.1?
> It seems the stack overflow link is more of a general question of Specified
> key was too long; max key length is 1000 bytes. Do i need to modify the
> setup.sh script of ranger-admin-0.7.1 in order to achieve this?
>
> Really appreciated!
>
> Best,
> Chaoran
>
> On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>
> wrote:
>
>> Hello Chaoran:
>>
>> This seems to be related to Mysql config. Try setting the below before
>> running install script as mentioned here - https://stackoverflow.com/qu
>> estions/8746207/1071-specified-key-was-too-long-max-key-
>> length-is-1000-bytes
>>
>> SET @@global.innodb_large_prefix = 1;
>>
>> I am adding Ranger dev list to see if there are any other solutions.
>>
>> Thank you,
>> Vel
>>
>> From: Chaoran Wang <ch...@cask.co>
>> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
>> Date: Monday, June 19, 2017 at 3:23 PM
>> To: "user@ranger.apache.org" <us...@ranger.apache.org>
>> Subject: Could not setup range-admin 0.7.2, key was too long error
>>
>> Hi,
>>
>> I am trying to install ranger on a CentOS server.
>>
>> While installing ranger 0.7.2's ranger-admin setup.sh script, I have
>> encountered the following error:
>>
>>
>> Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT
>> NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
>> datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
>> `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
>> NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
>> varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
>> `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
>> `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
>> DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`),
>> UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
>> `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
>> (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
>> `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
>> (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
>> `x_portal_user_email` (`email`), CONSTRAINT
>> `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES
>> `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN
>> KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2
>> ROW_FORMAT=DYNAMIC;
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
>> was too long; max key length is 1000 bytes
>> SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>> Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
>> 2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
>> 2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
>> other process
>> 2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-
>> 0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>> '********' -noheader -trim -c \; -query "show tables like
>> 'xa_access_audit';"
>> 2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
>> database ranger
>> 2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
>> /usr/share/java/mysql-connector-java.jar:/usr/local/ranger-
>> 0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
>> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
>> '********' -noheader -trim -c \; -query "delete from x_db_version_h where
>> version='CORE_DB_SCHEMA' and active='N' and updated_by='
>> ranger24355-1000.dev.continuuity.net';"
>> 2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
>>
>> Could you please take a look at error and give me some hints on solution?
>>
>> Really appreciate!
>>
>> Chaoran
>>
>
>
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Chaoran Wang <ch...@cask.co>.
Hi Vel,
Thank you so much for the hint.
However, when i try to run
SET @@global.innodb_large_prefix = 1;
in mysql, gives the following errors:
ERROR 1193 (HY000): Unknown system variable 'innodb_large_prefix'
What's the schema of the table i need to set for ranger-admin-0.7.1?
It seems the stack overflow link is more of a general question of Specified
key was too long; max key length is 1000 bytes. Do i need to modify the
setup.sh script of ranger-admin-0.7.1 in order to achieve this?
Really appreciated!
Best,
Chaoran
On Mon, Jun 19, 2017 at 3:00 PM, Velmurugan Periasamy <ve...@apache.org>
wrote:
> Hello Chaoran:
>
> This seems to be related to Mysql config. Try setting the below before
> running install script as mentioned here - https://stackoverflow.com/
> questions/8746207/1071-specified-key-was-too-long-
> max-key-length-is-1000-bytes
>
> SET @@global.innodb_large_prefix = 1;
>
> I am adding Ranger dev list to see if there are any other solutions.
>
> Thank you,
> Vel
>
> From: Chaoran Wang <ch...@cask.co>
> Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Date: Monday, June 19, 2017 at 3:23 PM
> To: "user@ranger.apache.org" <us...@ranger.apache.org>
> Subject: Could not setup range-admin 0.7.2, key was too long error
>
> Hi,
>
> I am trying to install ranger on a CentOS server.
>
> While installing ranger 0.7.2's ranger-admin setup.sh script, I have
> encountered the following error:
>
>
> Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
> AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
> datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
> `upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
> NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
> varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
> `password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
> `status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL
> DEFAULT '0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`),
> UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
> `x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
> (`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
> `x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
> (`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
> `x_portal_user_email` (`email`), CONSTRAINT
> `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES
> `x_portal_user` (`id`), CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN
> KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) )AUTO_INCREMENT=2
> ROW_FORMAT=DYNAMIC;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
> was too long; max key length is 1000 bytes
> SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Specified key was too long; max key length is 1000 bytes ErrorCode: 1071
> 2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
> 2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
> other process
> 2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/usr/local/
> ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
> '********' -noheader -trim -c \; -query "show tables like
> 'xa_access_audit';"
> 2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
> database ranger
> 2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/usr/local/
> ranger-0.7.2-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver
> mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p
> '********' -noheader -trim -c \; -query "delete from x_db_version_h where
> version='CORE_DB_SCHEMA' and active='N' and updated_by='ranger24355-1000.
> dev.continuuity.net';"
> 2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
>
> Could you please take a look at error and give me some hints on solution?
>
> Really appreciate!
>
> Chaoran
>
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Velmurugan Periasamy <ve...@apache.org>.
Hello Chaoran:
This seems to be related to Mysql config. Try setting the below before
running install script as mentioned here -
https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-
max-key-length-is-1000-bytes
SET @@global.innodb_large_prefix = 1;
I am adding Ranger dev list to see if there are any other solutions.
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>
Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
Date: Monday, June 19, 2017 at 3:23 PM
To: "user@ranger.apache.org" <us...@ranger.apache.org>
Subject: Could not setup range-admin 0.7.2, key was too long error
Hi,
I am trying to install ranger on a CentOS server.
While installing ranger 0.7.2's ranger-admin setup.sh script, I have
encountered the following error:
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
`upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
`password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL DEFAULT
'0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE
KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
`x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
(`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
`x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
(`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
`x_portal_user_email` (`email`), CONSTRAINT `x_portal_user_FK_added_by_id`
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT
`x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES
`x_portal_user` (`id`) )AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 1000 bytes
SQLException : SQL state: 42000
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 1000 bytes ErrorCode: 1071
2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
other process
2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-ad
min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim
-c \; -query "show tables like 'xa_access_audit';"
2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
database ranger
2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-ad
min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim
-c \; -query "delete from x_db_version_h where version='CORE_DB_SCHEMA' and
active='N' and updated_by='ranger24355-1000.dev.continuuity.net
<http://ranger24355-1000.dev.continuuity.net> ';"
2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
Could you please take a look at error and give me some hints on solution?
Really appreciate!
Chaoran
Re: Could not setup range-admin 0.7.2, key was too long error
Posted by Velmurugan Periasamy <ve...@apache.org>.
Hello Chaoran:
This seems to be related to Mysql config. Try setting the below before
running install script as mentioned here -
https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-
max-key-length-is-1000-bytes
SET @@global.innodb_large_prefix = 1;
I am adding Ranger dev list to see if there are any other solutions.
Thank you,
Vel
From: Chaoran Wang <ch...@cask.co>
Reply-To: "user@ranger.apache.org" <us...@ranger.apache.org>
Date: Monday, June 19, 2017 at 3:23 PM
To: "user@ranger.apache.org" <us...@ranger.apache.org>
Subject: Could not setup range-admin 0.7.2, key was too long error
Hi,
I am trying to install ranger on a CentOS server.
While installing ranger 0.7.2's ranger-admin setup.sh script, I have
encountered the following error:
Error executing: CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL
AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `update_time`
datetime DEFAULT NULL, `added_by_id` bigint(20) DEFAULT NULL,
`upd_by_id` bigint(20) DEFAULT NULL, `first_name` varchar(1022) DEFAULT
NULL, `last_name` varchar(1022) DEFAULT NULL, `pub_scr_name`
varchar(2048) DEFAULT NULL, `login_id` varchar(767) DEFAULT NULL,
`password` varchar(512) NOT NULL, `email` varchar(512) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT '0', `user_src` int(11) NOT NULL DEFAULT
'0', `notes` varchar(4000) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE
KEY `x_portal_user_UK_login_id` (`login_id`), UNIQUE KEY
`x_portal_user_UK_email` (`email`), KEY `x_portal_user_FK_added_by_id`
(`added_by_id`), KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), KEY
`x_portal_user_cr_time` (`create_time`), KEY `x_portal_user_up_time`
(`update_time`), KEY `x_portal_user_name` (`first_name`(767)), KEY
`x_portal_user_email` (`email`), CONSTRAINT `x_portal_user_FK_added_by_id`
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), CONSTRAINT
`x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES
`x_portal_user` (`id`) )AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 1000 bytes
SQLException : SQL state: 42000
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 1000 bytes ErrorCode: 1071
2017-06-19 20:06:48,237 [E] xa_core_db.sql file import failed!
2017-06-19 20:06:48,237 [I] CORE_DB_SCHEMA might being imported by some
other process
2017-06-19 20:08:48,336 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-ad
min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim
-c \; -query "show tables like 'xa_access_audit';"
2017-06-19 20:08:48,657 [I] Table xa_access_audit does not exist in
database ranger
2017-06-19 20:08:48,657 [JISQL] /usr/lib/jvm/java/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/usr/local/ranger-0.7.2-SNAPSHOT-ad
min/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim
-c \; -query "delete from x_db_version_h where version='CORE_DB_SCHEMA' and
active='N' and updated_by='ranger24355-1000.dev.continuuity.net
<http://ranger24355-1000.dev.continuuity.net> ';"
2017-06-19 20:08:48,963 [E] CORE_DB_SCHEMA import failed!
Could you please take a look at error and give me some hints on solution?
Really appreciate!
Chaoran