You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2015/10/20 17:39:27 UTC
[jira] [Commented] (AMBARI-13489) MySQL Ambari Repository gives Key
Too Long error messages for hostcomponentdesiredstate table.
[ https://issues.apache.org/jira/browse/AMBARI-13489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14965267#comment-14965267 ]
Hudson commented on AMBARI-13489:
---------------------------------
FAILURE: Integrated in Ambari-trunk-Commit #3677 (See [https://builds.apache.org/job/Ambari-trunk-Commit/3677/])
AMBARI-13489. MySQL Ambari Repository gives Key Too Long error messages (dlysnichenko: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=99de0edb7f33a3e878032a5bb0d95466087ec408])
* ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
> MySQL Ambari Repository gives Key Too Long error messages for hostcomponentdesiredstate table.
> ----------------------------------------------------------------------------------------------
>
> Key: AMBARI-13489
> URL: https://issues.apache.org/jira/browse/AMBARI-13489
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Reporter: Dmitry Lysnichenko
> Assignee: Dmitry Lysnichenko
> Attachments: AMBARI-13489.patch
>
>
> Problem:
> MySQL Ambari Repository gives Key Too Long error messages for hostcomponentdesiredstate table.
> Steps To Reproduce:
> The comment in the Ambari-DDL-MySQL-CREATE.sql file indicates that the script was generated on a MySQL DB with UTF8 as the character set.
> The default collation name for the DB is utf8_general_ci
> I suspect that this is preventing me from creating the Ambari database schema and giving the message that the maximum key size is 1000 bytes.
> If the VARCHAR fields use more than one byte per character then two VARCHAR(255) fields in the key is going to exceed 1000 bytes.
> CREATE TABLE hostcomponentdesiredstate (
> cluster_id BIGINT NOT NULL,
> component_name VARCHAR(255) NOT NULL,
> desired_stack_id BIGINT NOT NULL,
> desired_state VARCHAR(255) NOT NULL,
> host_id BIGINT NOT NULL,
> service_name VARCHAR(255) NOT NULL,
> admin_state VARCHAR(32),
> maintenance_state VARCHAR(32) NOT NULL DEFAULT 'ACTIVE',
> security_state VARCHAR(32) NOT NULL DEFAULT 'UNSECURED',
> restart_required TINYINT(1) NOT NULL DEFAULT 0,
> PRIMARY KEY (cluster_id, component_name, host_id, service_name)
> );
> Their is a work around of using MySQL 5.6 which is not the default for Cent OS 6. You also need to make a manual configuration change of innodb_large_prefix property. This is very ugly for installation process.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)