On Sun, 6 Sep 2020 at 09:06, Brin Zhang(张百林) <zhangbailin@inspur.com> wrote:
Hi Brin,
the issue is that, per the bug report, MariaDB 10.1 cannot handle such changes to foreign keys: Cannot change column 'network_id': used in a foreign key constraint 'subnets_ibfk_1' It received support later.
Is there a particular reason you are trying to keep MariaDB 10.1?
No, we want to upgrade openstack release, but I don’t know upgrade MariaDB whether is necessary (used 10.1 now), your suggestion will be very helpful to our choice. Therefore, for features that are highly dependent, or bug fixes, further verification is required.
Hi Brin, as always it would be helpful to know exactly the problem you are facing, and if there is a reason why you are considering to choose a version of these key components that differs from the versions tested upstream. Are you using an external DB & MQ outside of kolla that you do not have control over?
Thanks.
-yoctozepto
On Sun, Sep 6, 2020 at 9:47 AM Brin Zhang(张百林) <zhangbailin@inspur.com> wrote:
Hi Radoslaw.
I have a doubt, https://review.opendev.org/#/c/677221 "op.alter_column('subnets','network_id', nullable=False, existing_type=sa.String(36))" altered ' network_id' attribute, but why does this make it necessary to upgrade the version of mariadb?
"op.alter_column('subnets','network_id', nullable=False, existing_type=sa.String(36))" run *-db sync" it will be upgrade our local project's db, I think it's ok to run even if I don't upgrade the mariadb from v10.1 to v 10.3, right?
brinzhang
Hi Sheldon,
On Sat, Sep 5, 2020 at 3:52 AM Sheldon Hu(胡玉鹏) <huyp@inspur.com> wrote:
Thx for reply
As of mysql compatibility, could you give me a 'for instance' to detail like 'which part of ussuri code must need mysql v10.3.x, if we use mysql v10.1, the code will not run correctly '.
I just reviewed this and it was even earlier - in Train: https://bugs.launchpad.net/kolla/+bug/1841907 afair, some other projects also introduced such incompatibilities due to testing against MySQL.
-yoctozepto