[murano] Galera Table package_to_tag has no PRIMARY_KEY
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@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
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-stric... [1] https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/... Thanks, Rong Zhu Marc Vorwerk <openstack@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@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
Hi Rong, thank you for your answer! I will test it with changing the pxc_strict_mode. But in your second link I can read that it would be better to add a PRIMARY_KEY to the table? Best regards, Marc Von: Rong Zhu <aaronzhu1121@gmail.com> Datum: Donnerstag, 18. April 2019 um 09:40 An: <openstack-discuss@lists.openstack.org> Betreff: Re: [murano] Galera Table package_to_tag has no PRIMARY_KEY 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-stric... [1] https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/... Thanks, Rong Zhu Marc Vorwerk <openstack@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@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
participants (2)
-
Marc Vorwerk
-
Rong Zhu