Troubleshooting
Problem
Error seen when running RUN_BG_SYNC -F
Note: This effects ubuntu18 clustered customers.
Cause
MySQL issue that has affected all our migrated Ubuntu18 clustered customers. The side effect is that the portal goes out of sync and you start to see this errors in the logs;
WD node: PDOException: SQLSTATE[HY000]: General error: 1105 [error]
Percona-XtraDB-Cluster prohibits use of DML command on a table
(sit1outboundtest.taxonomy_index) without an explicit primary key
with pxc_strict_mode = ENFORCING or MASTER: DELETE FROM {taxonomy_index}
Diagnosing The Problem
Please check: /var/log/devportal/background_sync.log for details on the error.
Resolving The Problem
APAR LI81994 is opened to provide fix in future however below workaround until then:
Workaround steps:
1: Login to the primary node of the cluster (the node where the customer run the restore_devportal -c -s backup_file_absolute_path during the migration process)
2: run: mysql -e “SET GLOBAL pxc_strict_mode=DISABLED;”
3: run the background sync for the site in question (run_bg_sync -f <site UUID>)
1: Login to the primary node of the cluster (the node where the customer run the restore_devportal -c -s backup_file_absolute_path during the migration process)
2: run: mysql -e “SET GLOBAL pxc_strict_mode=DISABLED;”
3: run the background sync for the site in question (run_bg_sync -f <site UUID>)
NOTE: the changes would not resist the node reboot. So if you rebooted any of the cluster nodes then you need to redo the workaround steps on the restarted node. This does not resist the node reboot, to make it resist please advise the customer to run the command below as a root user on all the nodes in the cluster.
echo -e "[mysqld]\npxc_strict_mode=DISABLED" >> /etc/mysql/my.cnf
echo -e "[mysqld]\npxc_strict_mode=DISABLED" >> /etc/mysql/my.cnf
Document Location
Worldwide
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSMNED","label":"IBM API Connect"},"ARM Category":[{"code":"a8m50000000Ce9QAAS","label":"API Connect->Developer Portal (MM)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.0.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
23 February 2021
UID
ibm16416239