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

              Assignee:
              summer.zhang Summer Zhang
              Reporter:
              allen.ziegenfus Allen Ziegenfus
              Participants of an Issue:
              Recent user:
              Yunlin "Steven" Sun
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                47 weeks, 5 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