Return
-
Title
Cannot enable PI if the parameter sql_require_primary_key is set to 1 in mysql configuration. -
Description
A MySQL database has the parameter sql_require_primary_key set to 1 which would ensure that no table can be created without a primary key. After enabling this parameter PI cannot be enabled on MySQL database and it fails with following error:
The parameter sql_require_primary_key to 1 is set in the MySQL database which would ensure that no table can be created without a primary key. After enabling this parameter PI cannot be enabled on MySQL database and it fails with below error. Unable to create or change a table without a primary key when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.' -
Resolution
WORKAROUND
Change the mysql.ini or mysql.conf parameter sql_require_primary_key to 0, then proceed with enabling PI. After PI has been enabled, revert the change to the mysql configuration file.
STATUS
This issue has been logged as defect FOG-8464 and will be fixed in a future release of the MySQL PI cartridge. -
Defect ID
FOG-8464