What steps will reproduce the problem?
1. Set up MySQL database connection to a Percona XtraDB Cluster
2. Attempt to use `prosodyctl adduser`
What is the expected output?
Prosody should execute the SQL statements without producing any errors, initialize the database and create the users.
What do you see instead?
`sql error Error in SQL transaction: /usr/lib64/prosody/util/sql.lua:163: Error preparing statement handle: Percona-XtraDB-Cluster prohib
its use of DML command on a table (prosody.prosody) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
/usr/lib64/prosody/util/sql.lua:163: Error preparing statement handle: Percona-XtraDB-Cluster prohibits use of DML command on a table (prosody.prosody) withou
t an explicit primary key with pxc_strict_mode = ENFORCING or MASTER`
What version of the product are you using? On what operating system?
Prosody 0.11.8 on openSUSE 15.3
Please provide any additional information below.
I worked around by manually adding an `id` column:
`mysql> ALTER TABLE prosody ADD id INT PRIMARY KEY AUTO_INCREMENT;`
In my case it seems to work after the manual intervention, however I do not know, whether I am in risk of Prosody possibly getting in conflict with the additional column or if it will overwrite it in the future. A clarification on this would be much appreciated.
Furthermore, a user should not be lead to dangerously disabling the ENFORCING mode in Percona XtraDB. This is unfortunately often suggested on the internet as a "solution" to the SQL error produced by Percona.
What steps will reproduce the problem? 1. Set up MySQL database connection to a Percona XtraDB Cluster 2. Attempt to use `prosodyctl adduser` What is the expected output? Prosody should execute the SQL statements without producing any errors, initialize the database and create the users. What do you see instead? `sql error Error in SQL transaction: /usr/lib64/prosody/util/sql.lua:163: Error preparing statement handle: Percona-XtraDB-Cluster prohib its use of DML command on a table (prosody.prosody) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER /usr/lib64/prosody/util/sql.lua:163: Error preparing statement handle: Percona-XtraDB-Cluster prohibits use of DML command on a table (prosody.prosody) withou t an explicit primary key with pxc_strict_mode = ENFORCING or MASTER` What version of the product are you using? On what operating system? Prosody 0.11.8 on openSUSE 15.3 Please provide any additional information below. I worked around by manually adding an `id` column: `mysql> ALTER TABLE prosody ADD id INT PRIMARY KEY AUTO_INCREMENT;` In my case it seems to work after the manual intervention, however I do not know, whether I am in risk of Prosody possibly getting in conflict with the additional column or if it will overwrite it in the future. A clarification on this would be much appreciated. Furthermore, a user should not be lead to dangerously disabling the ENFORCING mode in Percona XtraDB. This is unfortunately often suggested on the internet as a "solution" to the SQL error produced by Percona.