cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d...@apache.org
Subject [39/44] git commit: updated refs/heads/4.9-bountycastle-daan to a001d75
Date Mon, 02 May 2016 14:37:00 GMT
Merge pull request #1517 from shapeblue/mysql-5.7-upgradefix

engine/schema: fix upgrade path to work with MySQL 5.7Found this issue when using MySQL 5.7
with Ubuntu 16.04. The upgrade path fix removes an invalid `IGNORE` param that is deprecated
now, in the upgrade path we run the alter statement to add an index only if it does not exist
so we're good.

For MySQL 5.7, we'll also need to update the docs at some point to include `server-id` along
with other parameters. Some of the SQL statements used throughout engine/schema don't adhere
to SQL 99 standard which is enforced by default in MySQL 5.7, therefore the following sql-mode
(for backward compatibility with mysql 5.6 modes) will be necessary for anyone willing to
use MySQL 5.7 (until we fix codebase wide raw and generated sql statements to be SQL99 compliant):

sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION"
server-id   = 1
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=350
log-bin=mysql-bin
binlog-format = 'ROW'

/cc @swill @jburwell @agneya2001 @wido @DaanHoogland  and others

* pr/1517:
  engine/schema: fix upgrade path to work with MySQL 5.7

Signed-off-by: Will Stevens <williamstevens@gmail.com>


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/ad138a15
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/ad138a15
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/ad138a15

Branch: refs/heads/4.9-bountycastle-daan
Commit: ad138a15d7cf62306ad827c404167716dd5fed3e
Parents: 12d8e53 c63ea0a
Author: Will Stevens <williamstevens@gmail.com>
Authored: Thu Apr 28 16:06:20 2016 -0400
Committer: Will Stevens <williamstevens@gmail.com>
Committed: Thu Apr 28 16:06:20 2016 -0400

----------------------------------------------------------------------
 engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------



Mime
View raw message