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 2022/08/24 03:38:47 UTC
[GitHub] [cloudstack] itsmdev opened a new issue, #6670: Work with MySQL group replication
itsmdev opened a new issue, #6670:
URL: https://github.com/apache/cloudstack/issues/6670
<!--
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.
-->
Error log:
```
2022-08-24 02:14:35,802 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) cleanupForServer:Exception:The table does not comply with the requirements by an external plugin.
2022-08-24 02:14:35,909 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) cleanupForServer:Exception:cleanupForServer:Exception:The table does not comply with the requirements by an external plugin.
```
seem caused by `op_lock` and `op_nwgrp_work` use `MEMORY` engine:
```
| def | cloud | op_lock | MEMORY |
| def | cloud | op_nwgrp_work | MEMORY |
+---------------+--------------------+------------------------------------------------------+--------------------+
```
any solution?
in `./engine/schema/src/main/resources/META-INF/db/schema-490to4910.sql`:, engine will be set to innodb：
```
ALTER TABLE cloud.op_nwgrp_work ENGINE=INNODB;
```
So, can I use InnoDB from the start？
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Bug Report
##### COMPONENT NAME
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on main branch.
-->
4.16.1.0
~~~
~~~
##### 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
-->
##### SUMMARY
<!-- Explain the problem/feature briefly -->
##### 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 -->
~~~
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
~~~
~~~
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] boring-cyborg[bot] commented on issue #6670: Work with MySQL group replication
Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #6670:
URL: https://github.com/apache/cloudstack/issues/6670#issuecomment-1225143421
Thanks for opening your first issue here! Be sure to follow the issue template!
--
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] rohityadavcloud commented on issue #6670: Work with MySQL group replication
Posted by GitBox <gi...@apache.org>.
rohityadavcloud commented on issue #6670:
URL: https://github.com/apache/cloudstack/issues/6670#issuecomment-1229888629
@itsmdev thanks for reporting, I think they all should be INNODB unless there is any reason not to. Can you check latest main or 4.17 branch incase this is already fixed those cc @nvazquez if you remember we fixed them?
--
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] DaanHoogland commented on issue #6670: Work with MySQL group replication
Posted by GitBox <gi...@apache.org>.
DaanHoogland commented on issue #6670:
URL: https://github.com/apache/cloudstack/issues/6670#issuecomment-1330316668
according to https://github.com/apache/cloudstack/blob/4.17/engine/schema/src/main/resources/META-INF/db/schema-490to4910.sql#L30-L31 this has long been changed and will be automatically be updated on every installation after 4.9
--
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] itsmdev commented on issue #6670: Work with MySQL group replication
Posted by GitBox <gi...@apache.org>.
itsmdev commented on issue #6670:
URL: https://github.com/apache/cloudstack/issues/6670#issuecomment-1233677328
@rohityadavcloud
https://github.com/apache/cloudstack/blob/c58118148e1a579efc1d59dba27f54463222c843/setup/db/create-schema.sql#L401
https://github.com/apache/cloudstack/blob/c58118148e1a579efc1d59dba27f54463222c843/setup/db/create-schema.sql#L1796
--
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] DaanHoogland commented on issue #6670: Work with MySQL group replication
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #6670:
URL: https://github.com/apache/cloudstack/issues/6670#issuecomment-1603876739
@itsmdev I am closing this issue. If you feel this is invalid please reopen or create a new one
--
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] DaanHoogland closed issue #6670: Work with MySQL group replication
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland closed issue #6670: Work with MySQL group replication
URL: https://github.com/apache/cloudstack/issues/6670
--
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