Read-Writer Database Configuration doesn't work

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, 7.3.X, Master
• Fix Version/s: 7.2.10 DXP FP14, 7.2.10.5 DXP SP5, 7.2.X, 7.3.7 CE GA8, 7.3.10 DXP FP2, 7.3.X, 7.4.1 CE GA2, Master
• Component/s: Core Infrastructure, Portal Services
• Labels:
  • ee-ts
  • liferay-dxp-72-sp5
  • liferay-fixpack-dxp-14-7210
  • liferay-fixpack-dxp-2-7310
• Branch Version/s:
  7.3.x, 7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/shuyangzhou/liferay-portal/pull/9994

Steps to Reproduce:

1. Configure the portal for Read-Writer MySQL Database following these steps: https://help.liferay.com/hc/en-us/articles/360029123851-Point-all-Nodes-to-the-Same-Liferay-DXP-Database#read-writer-database-configuration
2. Start the portal.
3. Perform an operation like creating a web content.

 

Expected Results:

No MySQL errors should be obtained.

 

Actual Results:

Several MySQL syntax errors are obtained.