-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: Master
-
Fix Version/s: 7.0.0 DXP FP35, 7.0.0 DXP SP7, 7.0.5 CE GA6, 7.0.X, 7.1.0 M1, 7.1.X, Master
-
Component/s: Fault Tolerance > Clustering Framework
-
Branch Version/s:7.0.x
-
Backported to Branch:Committed
-
Story Points:1
-
Fix Priority:3
-
Git Pull Request:
Description:
Clustering no longer works with JDBC_PING after patching to DE-34.
Steps To Reproduce:
- Download and unzip Liferay DXP SP6
- Prepare a MySQL database
- Configure JDBC PING Unicast Cluster using the following steps (more information available here):
- Acquire a tcp.xml file and rename it to "jdbc_ping_config.xml"
- Replace the "<TCPPING" tag information with the following in the jdbc_ping_config.xml file:
<JDBC_PING connection_url="jdbc:mysql://ipaddress/databaseName?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false" connection_username="yourusername" connection_password="yourpassword" connection_driver="com.mysql.jdbc.Driver"/>
-
- Add the following properties to the portal-ext.properties file to point to the jdbc_ping_config.xml file:
cluster.link.channel.properties.control=pathToXml/jdbc_ping_config.xml cluster.link.channel.properties.transport.0=pathToXml/jdbc_ping_config.xml
- Add the following properties to the portal-ext.properties file to point to the jdbc_ping_config.xml file:
-
- Add the following to the portal-ext.properties file:
cluster.link.enabled=true
- Add the following to the portal-ext.properties file:
-
- Add the following to the JVM parameters in the setenv.sh/bat file for each node:
-Djgroups.bind_addr=<node_address>
- Add the following to the JVM parameters in the setenv.sh/bat file for each node:
- Startup Liferay and confirm that the no errors occur
- Shut down Liferay and patch to DE34
- Clear temp and work and osgi/state
- Restart Liferay
Expected Results:
Liferay starts up normally and the cluster works as expected (you can see the cluster section in the log)
Actual Results:
The following appears in the logs:
Caused by: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver' at org.jgroups.protocols.JDBC_PING.loadDriver(JDBC_PING.java:327) at org.jgroups.protocols.JDBC_PING.init(JDBC_PING.java:127) at org.jgroups.stack.ProtocolStack.initProtocolStack(ProtocolStack.java:860) at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:481) at org.jgroups.JChannel.init(JChannel.java:854) at org.jgroups.JChannel.<init>(JChannel.java:159) at org.jgroups.JChannel.<init>(JChannel.java:139) at com.liferay.portal.cluster.multiple.internal.jgroups.JGroupsClusterChannel.<init>(JGroupsClusterChannel.java:62) ... 145 more
- relates
-
LPS-92491 JDBC Driver required for JDBC_PING protocol could not be loaded
- Closed