Open Stack

Hi Marc,


Glad to hear you are using murano.
I googled this, the reason is Percona using pxc_strict_mode = ENFORCING
will catch error when table without primary keys. package_to_tag table
don't have a primary key. I think you can set the mode Permissive.

[0]
https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html
[1]
https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/47107-dml-command-rejected-when-pxc-mode-set-to-enforcing


Thanks,
Rong Zhu

Marc Vorwerk <openstack at gmx.net>于2019年4月18日 周四15:19写道：

> Hello,
>
>
>
> uploading an application to Murano fails after upgrading
> "percona-xtradb-cluster-common-5.6" to "percona-xtradb-cluster-common-5.7":
>
>
>
> Importing package io.murano
>
> Error {"explanation": "The server has either erred or is incapable of
> performing the requested operation.", "code": 500, "error": {"message":
> "(pymysql.err.InternalError) (1105, u'Percona-XtraDB-Cluster prohibits use
> of DML command on a table (murano.package_to_tag) without an explicit
> primary key with pxc_strict_mode = ENFORCING or MASTER') [SQL: u'INSERT
> INTO package_to_tag (package_id, tag_id) VALUES (%(package_id)s,
> %(tag_id)s)'] [parameters: {'package_id':
> 'a345ab1fe4924aaf8ed32f954a6fe32d', 'tag_id':
> '0cb3765d7fe1486ba9741f4eb9b2a437'}]", "traceback": null, "type":
> "DBError"}, "title": "Internal Server Error"} (HTTP 500) occurred while
> installing package io.murano
>
>
>
> If i looks on the galera table, i get the following information:
>
>
>
> $ mysql -u murano -p
>
>
>
> mysql> Use murano;
>
> mysql> INSERT INTO package_to_tag (package_id, tag_id) VALUES
> (a345ab1fe4924aaf8ed32f954a6fe32d, 0cb3765d7fe1486ba9741f4eb9b2a437);
>
> ERROR 1105 (HY000): Percona-XtraDB-Cluster prohibits use of DML command on
> a table (murano.package_to_tag) without an explicit primary key with
> pxc_strict_mode = ENFORCING or MASTER
>
> mysql> SHOW KEYS FROM package_to_tag WHERE Key_name = 'PRIMARY';
>
> Empty set (0.00 sec)
>
>
>
> My package list:
>
>
>
> $pkg -l | grep -e mysql -e percona
>
> root at control02ve:~# dpkg -l | grep -e mysql -e percona
>
> ii  libdbd-mysql-perl
> 4.033-1ubuntu0.1                           amd64        Perl5 database
> interface to the MySQL database
>
> ii  libmysqlclient20:amd64
> 5.7.25-0ubuntu0.16.04.2                    amd64        MySQL database
> client library
>
> ii  mysql-common
> 5.7.25-0ubuntu0.16.04.2                    all          MySQL database
> common files, e.g. /etc/mysql/my.cnf
>
> ii  percona-release
> 1.0-11.generic                             all          Package to install
> Percona gpg key and APT repos
>
> ii  percona-xtrabackup-24
> 2.4.13-1.xenial                            amd64        Open source backup
> tool for InnoDB and XtraDB
>
> ii  percona-xtradb-cluster-client-5.7
> 5.7.25-31.35-1.xenial                      amd64        Percona XtraDB
> Cluster database client binaries
>
> ii  percona-xtradb-cluster-common-5.7
> 5.7.25-31.35-1.xenial                      amd64        Percona XtraDB
> Cluster database common files (e.g. /etc/mysql/my.cnf)
>
> ii  percona-xtradb-cluster-galera-3.x
> 3.32-1.xenial                              amd64        Galera components
> of Percona XtraDB Cluster
>
> ii  percona-xtradb-cluster-server-5.7
> 5.7.25-31.35-1.xenial                      amd64        Percona XtraDB
> Cluster database server binaries
>
> ii  python-mysqldb
> 1.3.7-1build2                              amd64        Python interface to
> MySQL
>
> ii  python-pymysql
> 0.7.11-1~cloud0                            all          Pure-Python MySQL
> driver - Python 2.x
>
>
>
> Murano is installed in the latest version of queens (
> https://github.com/openstack/murano/tree/stable/queens).
>
>
>
> Has anyone an idea?
>
>
>
> Best Regards,
>
> Marc
>
>
>
-- 
Thanks,
Rong Zhu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20190418/0c3e2c61/attachment-0001.html>