Work with MySQL group replication

[itsmdev]

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

• Bug Report

COMPONENT NAME

CLOUDSTACK VERSION

4.16.1.0

CONFIGURATION

OS / ENVIRONMENT

SUMMARY

STEPS TO REPRODUCE

EXPECTED RESULTS

ACTUAL RESULTS

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template!

[rohityadavcloud]

@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?

[itsmdev]

@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

[DaanHoogland]

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

Not sure what you require. does installation fail? or upgrade?

[DaanHoogland]

@itsmdev I am closing this issue. If you feel this is invalid please reopen or create a new one