You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/09/03 03:01:33 UTC
[GitHub] [cloudstack-documentation] harikrishna-patnala opened a new pull request #239: MySQL sql_mode change
harikrishna-patnala opened a new pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239
MySQL sql_mode has changed and 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)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912236783
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] rhtyd commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
rhtyd commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912342763
+1
@harikrishna-patnala I think we should advise admin to just fix the global my.cnf? See install/admin section?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] rhtyd commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
rhtyd commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912450241
PR merged cc @GabrielBrascher
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] harikrishna-patnala commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912217271
This addresses the issue https://github.com/apache/cloudstack/issues/5175
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912220606
@harikrishna-patnala a Jenkins job has been kicked to build the document. I'll keep you posted as I make progress.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] kricud commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
kricud commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912449019
@rhtyd @weizhouapache Unpopular opinion: I would not decrease strictness of sql globally if its absolutely not needed.
Someone has com to conclusion that it must be stricter globally and there probably are arguments why in context of
enabling ONLY_FULL_GROUP_BY. Approach of allowing it to each client/connection in my opinion is better.
Mentioning it in documentation in my opinion is enough.
https://www.percona.com/blog/2019/05/13/solve-query-failures-regarding-only_full_group_by-sql-mode/
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] weizhouapache commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912310190
@harikrishna-patnala
would it be better to add few lines for persistent mysql setting ?
users need to change /etc/mysql/my.cnfand restart mysql
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] harikrishna-patnala commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912220193
@blueorangutan docbuild
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912221138
Doc build preview: http://qa.cloudstack.cloud/docs/WIP-PROOFING/pr/239. (SL-JID 137)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] rhtyd merged pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
rhtyd merged pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] blueorangutan commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
blueorangutan commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912237137
Doc build preview: http://qa.cloudstack.cloud/docs/WIP-PROOFING/pr/239. (SL-JID 139)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] harikrishna-patnala commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912236086
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-documentation] rhtyd commented on pull request #239: MySQL sql_mode change
Posted by GitBox <gi...@apache.org>.
rhtyd commented on pull request #239:
URL: https://github.com/apache/cloudstack-documentation/pull/239#issuecomment-912449995
I suppose with your comment @kricud, the changes can be accepted then.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org