Open Stack

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