Errors in the process of installing Magento 2 on Percona XtraDB Cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi, this might be helpful to someone.

Tried to install Magento 2 in Kubernetes using Helm chart Bitnami with an external database.

As a database I used Percona XtraDB with default installation with Percona Operator for MySQL.

Magento installation failed with errors “General error: 1105 Percona-XtraDB-Cluster prohibits use of DML command on a table” in several tables.

[Progress: 547 / 1331]
Module 'Magento_MessageQueue':

In Mysql.php line 109:

  SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use o
  f DML command on a table (magento3.queue_poison_pill) without an explicit p
  rimary key with pxc_strict_mode = ENFORCING or MASTER, query was: INSERT IN
  TO `queue_poison_pill` (`version`) VALUES (?)


In Mysql.php line 90:

  SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use o
  f DML command on a table (magento3.queue_poison_pill) without an explicit p
  rimary key with pxc_strict_mode = ENFORCING or MASTER
1 Like
2

The installation was successful after changing the pxc_strict_mode parameter to PERMISSIVE or DISABLED

SET GLOBAL pxc_strict_mode=PERMISSIVE;
1 Like