Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-99042

Clustering fails silently when JDBC_PING cannot connect with the new Mysql driver

Details

    Description

      Liferay 7.1 does not currently have these changes backported: https://issues.liferay.com/browse/LPS-92491 which allow Liferay to use the latest Mysql v8.0.16 JDBC driver in the JDBC_PING context

      When trying to setup a LIferay 7.1 cluster with the latest Mysql driver, no error messages are generated in the logs but the cluster is not actually formed. Instead each node functions as its own master.

      Ideally there should be a log message indicating that the JDBC_PING connection failed.

      Steps to reproduce:

      1. Set up a liferay cluster with 7.1 but using the latest mysql driver (e.g. v.8.0.16)
      2. Configure the cluster to use JDBC_PING e.g.:

          <JDBC_PING connection_url="jdbc:mysql://database/lportal?useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false"
                     connection_username="dxpcloud" connection_password="zzz" connection_driver="com.mysql.jdbc.Driver" />
      

      3. Start the cluster.

      Expected behavior:

      An error message appears in the logs explaining that it was not possible to establish a connection to the database

      Actual behavior:

      No error is displayed and the cluster is not formed.

      Attachments

        Issue Links

          Activity

            People

              summer.zhang Summer Zhang
              allen.ziegenfus Allen Ziegenfus
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                2 years, 2 weeks, 4 days ago

                Packages

                  Version Package
                  7.0.0 DXP FP97
                  7.0.X
                  7.1.10 DXP FP17
                  7.1.10.4 SP4
                  7.1.X