You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ha...@apache.org on 2021/09/03 03:00:20 UTC

[cloudstack-documentation] branch mysql_sql_mode updated (0731ab4 -> 5e44f98)

This is an automated email from the ASF dual-hosted git repository.

harikrishna pushed a change to branch mysql_sql_mode
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git.


 discard 0731ab4  MySQL sql_mode change
     new 5e44f98  MySQL sql_mode change

This update added new revisions after undoing existing revisions.
That is to say, some revisions that were in the old version of the
branch are not in the new version.  This situation occurs
when a user --force pushes a change and generates a repository
containing something like this:

 * -- * -- B -- O -- O -- O   (0731ab4)
            \
             N -- N -- N   refs/heads/mysql_sql_mode (5e44f98)

You should already have received notification emails for all of the O
revisions, and so the following emails describe only the N revisions
from the common base, B.

Any revisions marked "omit" are not gone; other references still
refer to them.  Any revisions marked "discard" are gone forever.

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.


Summary of changes:
 source/upgrading/upgrade/upgrade_notes.rst | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

[cloudstack-documentation] 01/01: MySQL sql_mode change

Posted by ha...@apache.org.
This is an automated email from the ASF dual-hosted git repository.

harikrishna pushed a commit to branch mysql_sql_mode
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git

commit 5e44f987753195706e4bdcec6ddf78bbcce43bc3
Author: Harikrishna Patnala <ha...@gmail.com>
AuthorDate: Fri Sep 3 08:26:35 2021 +0530

    MySQL sql_mode change
---
 source/upgrading/upgrade/upgrade_notes.rst | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/source/upgrading/upgrade/upgrade_notes.rst b/source/upgrading/upgrade/upgrade_notes.rst
index 55a6288..ef43a11 100644
--- a/source/upgrading/upgrade/upgrade_notes.rst
+++ b/source/upgrading/upgrade/upgrade_notes.rst
@@ -101,3 +101,18 @@ added in CloudStack's db.properties file:
    db.cloud.driver=jdbc:mysql
 
    db.usage.driver=jdbc:mysql
+
+
+MySQL 8.0 sql mode change
+-------------------------
+
+MySQL mode (sql_mode) has changed in CloudStack db.properties to "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION".
+This gets automatically applies to the MySQL session used by CloudStack management server.
+
+If the admin uses MySQL directly and wants to query tables it is advised to change the sql_mode in the corresponding session or globally.
+
+Eg. mysql> set global sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";
+    Query OK, 0 rows affected (0.00 sec)
+
+    mysql> set sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";
+    Query OK, 0 rows affected (0.00 sec)
\ No newline at end of file