Open Stack

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

Thanks.

-yoctozepto

On Sun, Sep 6, 2020 at 9:47 AM Brin Zhang(张百林) <zhangbailin at 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 at 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
>