Title: Work with MySQL group replication · Issue #6670 · apache/cloudstack · GitHub
Open Graph Title: Work with MySQL group replication · Issue #6670 · apache/cloudstack
X Title: Work with MySQL group replication · Issue #6670 · apache/cloudstack
Description: 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] (...
Open Graph Description: 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:...
X Description: 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:...
Opengraph URL: https://github.com/apache/cloudstack/issues/6670
X: @github
Domain: patch-diff.githubusercontent.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Work with MySQL group replication","articleBody":"\u003c!--\r\nVerify first that your issue/request is not already reported on GitHub.\r\nAlso test if the latest release and main branch are affected too.\r\nAlways add information AFTER of these HTML comments, but no need to delete the comments.\r\n--\u003e\r\n\r\nError log:\r\n```\r\n2022-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.\r\n2022-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.\r\n```\r\nseem caused by `op_lock` and `op_nwgrp_work` use `MEMORY` engine:\r\n\r\n```\r\n| def | cloud | op_lock | MEMORY |\r\n| def | cloud | op_nwgrp_work | MEMORY |\r\n+---------------+--------------------+------------------------------------------------------+--------------------+\r\n```\r\n\r\nany solution? \r\n\r\nin `./engine/schema/src/main/resources/META-INF/db/schema-490to4910.sql`:, engine will be set to innodb:\r\n```\r\nALTER TABLE cloud.op_nwgrp_work ENGINE=INNODB;\r\n```\r\n\r\nSo, can I use InnoDB from the start?\r\n\r\n##### ISSUE TYPE\r\n\u003c!-- Pick one below and delete the rest --\u003e\r\n * Bug Report\r\n\r\n##### COMPONENT NAME\r\n\u003c!--\r\nCategorize the issue, e.g. API, VR, VPN, UI, etc.\r\n--\u003e\r\n~~~\r\n\r\n~~~\r\n\r\n##### CLOUDSTACK VERSION\r\n\u003c!--\r\nNew line separated list of affected versions, commit ID for issues on main branch.\r\n--\u003e\r\n4.16.1.0\r\n\r\n~~~\r\n\r\n~~~\r\n\r\n##### CONFIGURATION\r\n\u003c!--\r\nInformation about the configuration if relevant, e.g. basic network, advanced networking, etc. N/A otherwise\r\n--\u003e\r\n\r\n\r\n##### OS / ENVIRONMENT\r\n\u003c!--\r\nInformation about the environment if relevant, N/A otherwise\r\n--\u003e\r\n\r\n\r\n##### SUMMARY\r\n\u003c!-- Explain the problem/feature briefly --\u003e\r\n\r\n\r\n##### STEPS TO REPRODUCE\r\n\u003c!--\r\nFor bugs, show exactly how to reproduce the problem, using a minimal test-case. Use Screenshots if accurate.\r\n\r\nFor new features, show how the feature would be used.\r\n--\u003e\r\n\r\n\u003c!-- Paste example playbooks or commands between quotes below --\u003e\r\n~~~\r\n\r\n~~~\r\n\r\n\u003c!-- You can also paste gist.github.com links for larger files --\u003e\r\n\r\n##### EXPECTED RESULTS\r\n\u003c!-- What did you expect to happen when running the steps above? --\u003e\r\n\r\n~~~\r\n\r\n~~~\r\n\r\n##### ACTUAL RESULTS\r\n\u003c!-- What actually happened? --\u003e\r\n\r\n\u003c!-- Paste verbatim command output between quotes below --\u003e\r\n~~~\r\n\r\n~~~\r\n","author":{"url":"https://github.com/itsmdev","@type":"Person","name":"itsmdev"},"datePublished":"2022-08-24T03:38:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":11},"url":"https://github.com/6670/cloudstack/issues/6670"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:d9bf8413-b84e-7bb9-69ec-0b9e75fd8cf9 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9EF8:38388E:A3F3A:E0B30:696E6082 |
| html-safe-nonce | 754578c4313647d6fd5cdee93fd9e0a69b9715b8c49ba22fb33d6a8a504ca83a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RUY4OjM4Mzg4RTpBM0YzQTpFMEIzMDo2OTZFNjA4MiIsInZpc2l0b3JfaWQiOiI4ODgwNzM5NDU3OTU2ODI0MzQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 74c174e9af40e5b17ca18e30100a7803eedb8417a9b359f56256e6537454768a |
| hovercard-subject-tag | issue:1348802698 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/apache/cloudstack/6670/issue_layout |
| twitter:image | https://opengraph.githubassets.com/8d71cf8043ee60a39eab41171f859ca878b66cad70cc7996ff615b1bfc558b55/apache/cloudstack/issues/6670 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/8d71cf8043ee60a39eab41171f859ca878b66cad70cc7996ff615b1bfc558b55/apache/cloudstack/issues/6670 |
| og:image:alt | 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:... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | itsmdev |
| hostname | github.com |
| expected-hostname | github.com |
| None | f68b42d371252b0f236260d6234f4304a806fe5ac43d59faa21fb59d80df103b |
| turbo-cache-control | no-preview |
| go-import | github.com/apache/cloudstack git https://github.com/apache/cloudstack.git |
| octolytics-dimension-user_id | 47359 |
| octolytics-dimension-user_login | apache |
| octolytics-dimension-repository_id | 9759448 |
| octolytics-dimension-repository_nwo | apache/cloudstack |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 9759448 |
| octolytics-dimension-repository_network_root_nwo | apache/cloudstack |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 6b74bc8dbcd10b5d69fd9ee9d2cfdc8b35e18a4c |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width