[
https://issues.apache.org/jira/browse/CLOUDSTACK-1017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13557866#comment-13557866
]
Prachi Damle commented on CLOUDSTACK-1017:
------------------------------------------
The key-length limit is put by the engine – MYISAM.
MySql log was showing this error (/var/log/mysqld.log). On error, MySQL
defaults to MYISAM and disables InnoDb
130118 16:04:20 mysqld started
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibAK6cdy' (Errcode: 13)
130118 16:04:20 InnoDB: Error: unable to create temporary file; errno: 13
After fixing the /tmp folder write permissions (they were root only) ,
restarted mysql. InnoDB is now enabled.
[root@vl-sjc-cloud-qa06 log]# chmod 777 /data -R
[root@vl-sjc-cloud-qa06 log]# ls -lt /data/
total 40
drwxrwxrwx 46 root root 4096 Jan 18 16:04 tmp
drwxrwxrwx 3 root root 4096 Jan 18 15:20 arch
drwxrwxrwx 3 root root 4096 Nov 1 16:25 Repo
drwxrwxrwx 2 root root 16384 Nov 1 16:10 lost+found
[root@vl-sjc-cloud-qa06 log]# service mysqld restart
130118 17:46:42 mysqld started
130118 17:46:42 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
> Cloud-setup-databases operation failed in RHEL5
> -------------------------------------------------
>
> Key: CLOUDSTACK-1017
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1017
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Install and Setup
> Affects Versions: 4.1.0
> Environment: RHEL : 5.3
> MYSQL : Server version: 5.0.95 Source distribution
> Reporter: Rayees Namathponnan
> Assignee: Prachi Damle
>
> Steps to reproduce
> Install MS from network refactor code base
> run setup command > cloud-setup-databases cloud:password@localhost
> --deploy-as=root:password
> cloudsetup command failed with below error
> We apologize for below error:
> ***************************************************************
> Encountering an error when executing mysql script
> ----------------------------------------------------------------------
> table:
> /usr/share/cloud/setup/create-schema.sql
> Error:
> ERROR 1071 (42000) at line 1966: Specified key was too long; max key length
> is 1000 bytes
> Sql parameters:
> {'passwd': 'password', 'host': 'localhost', 'user': 'root', 'port': 3306}
> ----------------------------------------------------------------------
>
> ***************************************************************
> Please run:
> cloud-setup-database -h
> for full help
> [root@vl-sjc-cloud-qa02 CloudStack-non-OSS-8-rhel5]# cat /etc/redhat-release
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
