Uploaded image for project: 'VIVO (LEGACY)'
  1. VIVO (LEGACY)
  2. VIVO-1478

MySQL driver throws InvalidConnectionAttributeException

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: v1.10
    • Fix Version/s: v1.10
    • Component/s: External services
    • Labels:
      None
    • Attachments:
      0
    • Comments:
      10
    • Sprint:
      VIVO Sprint 1

      Description

      The release candidate fails at startup with an exception in the log. The root cause is as shown below. 

      This is a known bug in the MySQL JDBC driver. A workaround is to specify additional parameters in the JDBC URL in runtime.properties.

      I wonder whether we could use a newer (or older) version of the JDBC driver that does not have this bug.

      End of stack trace follows:

      Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.{{ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)}}{{ at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)}}{{ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)}}{{ at java.lang.reflect.Constructor.newInstance(Constructor.java:423)}}{{ at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)}}{{ at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)}}{{ at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)}}{{ at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)}}{{ at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)}}{{ at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)}}{{ at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)}}{{ ... 28 more}}

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              j2blake Jim Blake
              Reporter:
              j2blake Jim Blake
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: