osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20190418/f6a140a6/attachment.html>