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