[mq][mariadb] What kind of reasons are considered when choosing the mq/mariadb version

Radosław Piliszek radoslaw.piliszek at gmail.com
Sun Sep 6 07:52:51 UTC 2020


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



More information about the openstack-discuss mailing list