You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/06/30 18:54:37 UTC
[GitHub] [cloudstack] GabrielBrascher opened a new issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
GabrielBrascher opened a new issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and main branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete the comments.
-->
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Enhancement Request
##### COMPONENT NAME
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
DB
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on main branch.
-->
~~~
4.15.0.0, 4.15.1.0-RC3, 4.16
~~~
##### CONFIGURATION
<!--
Information about the configuration if relevant, e.g. basic network, advanced networking, etc. N/A otherwise
-->
##### OS / ENVIRONMENT
<!--
Information about the environment if relevant, N/A otherwise
-->
```
mysql --version
mysql Ver 14.14 Distrib 5.7.34, for Linux (x86_64)
```
##### SUMMARY
<!-- Explain the problem/feature briefly -->
Seems to be related to MySQL only; MariaDB looks to be working fine. After some MySQL configurations to "disable" `only_full_group_by` then the select works.
This might be more a documentation than a cloudstack issue, but it is important to raise and track alternatives to solve/mitigate it.
This could bring problems to unaware users.
Bear in mind that the CloudStack mgmt/UI seems to be all good, even with the selects that failed; thus this is a minor issue.
##### STEPS TO REPRODUCE
<!--
For bugs, show exactly how to reproduce the problem, using a minimal test-case. Use Screenshots if accurate.
For new features, show how the feature would be used.
-->
<!-- Paste example playbooks or commands between quotes below -->
~~~
Run a MySQL 'select' query on disk_offering_view or service_offering_view
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
Select offerings views in MySQL
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
~~~
mysql> select * from disk_offering_view limit 1;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql> select * from service_offering_view limit 1;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
~~~
Might be related to [schema-41400to41500.sql#L423](https://github.com/apache/cloudstack/blob/bf6266188c89a5487383f216333ae10e878d2c10/engine/schema/src/main/resources/META-INF/db/schema-41400to41500.sql#L423).
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] harikrishna-patnala commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-912217123
Thanks @weizhouapache .
I've created doc PR as a short note to change the SQL mode.
Let me know if this is fine 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-912449451
Closing this as we've the doc PR now 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache edited a comment on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
weizhouapache edited a comment on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-911757856
@nvazquez
I think it is not a bug in cloudstack. cloudstack has already set sql_mode in ./client/conf/db.properties.in
```
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&prepStmtCacheSqlLimit=4096&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
```
to fix the issue , users have to change the mysql setting in mysql.conf , or change mysql global setting by queries if mysql cannot be restarted.
here is an example
```
mysql> select * from service_offering_view;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql> select @@sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select @@global.sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
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)
mysql>
mysql> select * from service_offering_view limit 1;
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| id | uuid | name | display_text | provisioning_type | created | tags | removed | use_local_storage | system_use | customized_iops | min_iops | max_iops | hv_ss_reserve | bytes_read_rate | bytes_read_rate_max | bytes_read_rate_max_length | bytes_write_rate | bytes_write_rate_max | bytes_write_rate_max_length | iops_read_rate | iops_read_rate_max | iops_read_rate_max_length | iops_write_rate | iops_write_rate_max | iops_write_rate_max_length | cache_mode | root_disk_size | cpu | speed | ram_size | nw_rate | mc_rate | ha_enabled | limit_cpu_use | host_tag | default_use | vm_type | sort_key | is_volatile | deployment_planner | dynamic_scaling_enabled | vsphere_storage_policy | domain_id | domain_uuid | domain_name | domain_path | zone_id | zone_uuid | zone_name | min_cpu | max_cpu | min_memory | max_memory |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| 1 | 5a79c934-c955-4681-b479-6ae76e29d7bb | Small Instance | Small Instance | thin | 2021-08-23 06:26:32 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 1 | 500 | 512 | NULL | NULL | 0 | 0 | NULL | 0 | NULL | 0 | 0 | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 512 | 512 |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
1 row in set (0.01 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-899186570
@harikrishna-patnala any ideas?
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache edited a comment on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
weizhouapache edited a comment on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-911757856
@nvazquez
I think it is not a bug in cloudstack. cloudstack has already set sql_mode in ./client/conf/db.properties.in
```
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
```
to fix the issue , users have to change the mysql setting in mysql.conf , or change mysql global setting by queries if mysql cannot be restarted.
here is an example
```
mysql> select * from service_offering_view;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql> select @@sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select @@global.sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
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)
mysql>
mysql> select * from service_offering_view limit 1;
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| id | uuid | name | display_text | provisioning_type | created | tags | removed | use_local_storage | system_use | customized_iops | min_iops | max_iops | hv_ss_reserve | bytes_read_rate | bytes_read_rate_max | bytes_read_rate_max_length | bytes_write_rate | bytes_write_rate_max | bytes_write_rate_max_length | iops_read_rate | iops_read_rate_max | iops_read_rate_max_length | iops_write_rate | iops_write_rate_max | iops_write_rate_max_length | cache_mode | root_disk_size | cpu | speed | ram_size | nw_rate | mc_rate | ha_enabled | limit_cpu_use | host_tag | default_use | vm_type | sort_key | is_volatile | deployment_planner | dynamic_scaling_enabled | vsphere_storage_policy | domain_id | domain_uuid | domain_name | domain_path | zone_id | zone_uuid | zone_name | min_cpu | max_cpu | min_memory | max_memory |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| 1 | 5a79c934-c955-4681-b479-6ae76e29d7bb | Small Instance | Small Instance | thin | 2021-08-23 06:26:32 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 1 | 500 | 512 | NULL | NULL | 0 | 0 | NULL | 0 | NULL | 0 | 0 | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 512 | 512 |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
1 row in set (0.01 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd closed issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
rhtyd closed issue #5175:
URL: 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-911757856
@nvazquez
I think it is not a bug in cloudstack. cloudstack has already set sql_mode in utils/conf/db.properties
```
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&prepStmtCacheSqlLimit=4096&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
```
to fix the issue , users have to change the mysql setting in mysql.conf , or change mysql global setting by queries if mysql cannot be restarted.
here is an example
```
mysql> select * from service_offering_view;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql> select @@sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select @@global.sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
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)
mysql>
mysql> select * from service_offering_view limit 1;
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| id | uuid | name | display_text | provisioning_type | created | tags | removed | use_local_storage | system_use | customized_iops | min_iops | max_iops | hv_ss_reserve | bytes_read_rate | bytes_read_rate_max | bytes_read_rate_max_length | bytes_write_rate | bytes_write_rate_max | bytes_write_rate_max_length | iops_read_rate | iops_read_rate_max | iops_read_rate_max_length | iops_write_rate | iops_write_rate_max | iops_write_rate_max_length | cache_mode | root_disk_size | cpu | speed | ram_size | nw_rate | mc_rate | ha_enabled | limit_cpu_use | host_tag | default_use | vm_type | sort_key | is_volatile | deployment_planner | dynamic_scaling_enabled | vsphere_storage_policy | domain_id | domain_uuid | domain_name | domain_path | zone_id | zone_uuid | zone_name | min_cpu | max_cpu | min_memory | max_memory |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
| 1 | 5a79c934-c955-4681-b479-6ae76e29d7bb | Small Instance | Small Instance | thin | 2021-08-23 06:26:32 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 1 | 500 | 512 | NULL | NULL | 0 | 0 | NULL | 0 | NULL | 0 | 0 | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 512 | 512 |
+----+--------------------------------------+----------------+----------------+-------------------+---------------------+------+---------+-------------------+------------+-----------------+----------+----------+---------------+-----------------+---------------------+----------------------------+------------------+----------------------+-----------------------------+----------------+--------------------+---------------------------+-----------------+---------------------+----------------------------+------------+----------------+------+-------+----------+---------+---------+------------+---------------+----------+-------------+---------+----------+-------------+--------------------+-------------------------+------------------------+-----------+-------------+-------------+-------------+---------+-----------+-----------+---------+---------+------------+------------+
1 row in set (0.01 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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-911211071
Ping @harikrishna-patnala @nvazquez
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-885724209
@harikrishna-patnala seems like `vsphere_storage_policy` may be conflicting here, any input?
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #5175: MySQL error when SELECT disk_offering_view / service_offering_view
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175#issuecomment-911704100
@harikrishna-patnala please provide your input after your investigation, thanks
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org