<div><div dir="auto">Hi Marc,</div></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Glad to hear you are using murano.</div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">[0] <a href="https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html">https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html</a></div><div dir="auto">[1] <a href="https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/47107-dml-command-rejected-when-pxc-mode-set-to-enforcing">https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/47107-dml-command-rejected-when-pxc-mode-set-to-enforcing</a></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Thanks,</div><div dir="auto">Rong Zhu</div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Marc Vorwerk <<a href="mailto:openstack@gmx.net">openstack@gmx.net</a>>于2019年4月18日 周四15:19写道：<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="DE" link="#0563C1" vlink="#954F72"><div class="m_1628968383262329388WordSection1"><p><span style="font-size:12.0pt;color:black">Hello,</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">uploading an application to Murano fails after upgrading "percona-xtradb-cluster-common-5.6" to "percona-xtradb-cluster-common-5.7":</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Importing package io.murano</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">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</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">If i looks on the galera table, i get the following information:</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">$ mysql -u murano -p</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">mysql> Use murano;</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">mysql> INSERT INTO package_to_tag (package_id, tag_id) VALUES (a345ab1fe4924aaf8ed32f954a6fe32d, 0cb3765d7fe1486ba9741f4eb9b2a437);</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">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</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">mysql> SHOW KEYS FROM package_to_tag WHERE Key_name = 'PRIMARY';</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Empty set (0.00 sec)</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">My package list:</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"> <u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">$pkg -l | grep -e mysql -e percona</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">root@control02ve:~# dpkg -l | grep -e mysql -e percona</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  libdbd-mysql-perl                     4.033-1ubuntu0.1                           amd64        Perl5 database interface to the MySQL database</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  libmysqlclient20:amd64                5.7.25-0ubuntu0.16.04.2                    amd64        MySQL database client library</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  mysql-common                          5.7.25-0ubuntu0.16.04.2                    all          MySQL database common files, e.g. /etc/mysql/my.cnf</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  percona-release                       1.0-11.generic                             all          Package to install Percona gpg key and APT repos</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  percona-xtrabackup-24                 2.4.13-1.xenial                            amd64        Open source backup tool for InnoDB and XtraDB</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  percona-xtradb-cluster-client-5.7     5.7.25-31.35-1.xenial                      amd64        Percona XtraDB Cluster database client binaries</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">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)</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  percona-xtradb-cluster-galera-3.x     3.32-1.xenial                              amd64        Galera components of Percona XtraDB Cluster</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  percona-xtradb-cluster-server-5.7     5.7.25-31.35-1.xenial                      amd64        Percona XtraDB Cluster database server binaries</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  python-mysqldb                        1.3.7-1build2                              amd64        Python interface to MySQL</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">ii  python-pymysql                        0.7.11-1~cloud0                            all          Pure-Python MySQL driver - Python 2.x</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Murano is installed in the latest version of queens (<a href="https://github.com/openstack/murano/tree/stable/queens" target="_blank">https://github.com/openstack/murano/tree/stable/queens</a>).</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Has anyone an idea?</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black"> </span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Best Regards,</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p style="font-variant-caps:normal;text-align:start;word-spacing:0px"><span style="font-size:12.0pt;color:black">Marc</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt"><u></u> <u></u></span></p></div></div>
</blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">Thanks,<br>Rong Zhu</div>