Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-392

Aurora cluster endpoint detection fails when time_zone doesn't match system_time_zone

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.5.5
    • 1.5.8
    • Failover
    • None

    Description

      The query to find cluster endpoints filters on a last update time. It uses the system_time_zone to create a string of the current time, but the query operates based on the time_zone parameter. In our case, the system_time_zone is UTC and time_zone is US/Central. This results in no endpoints being returned.

      Could probably fix by using the time_zone server data parameter or using a time function in the query.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jsteinich Jon Steinich created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Fix Version/s 1.5.6 [ 22403 ]
          diego dupin Diego Dupin made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          jsteinich Jon Steinich made changes -
          Attachment db endpoint query.png [ 43233 ]
          jsteinich Jon Steinich added a comment -

          I just tried out 1.5.6 and the issue is not fixed. The query is still not returning any results because of the time check.

          jsteinich Jon Steinich added a comment - I just tried out 1.5.6 and the issue is not fixed. The query is still not returning any results because of the time check.
          diego dupin Diego Dupin added a comment -

          to be checked back

          diego dupin Diego Dupin added a comment - to be checked back
          diego dupin Diego Dupin made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          diego dupin Diego Dupin made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          diego dupin Diego Dupin made changes -
          Fix Version/s 1.5.7 [ 22500 ]
          Fix Version/s 1.5.6 [ 22403 ]
          diego dupin Diego Dupin added a comment -

          Correction is available throught snapshot using :

                  <repositories>
          		 
                      <repository>
          		 
                          <id>sonatype-nexus-snapshots</id>
          		 
                          <name>Sonatype Nexus Snapshots</name>
          		 
                          <url>https://oss.sonatype.org/content/repositories/snapshots</url>
          		 
                      </repository>
          		 
                  </repositories>
          		 
           
          		 
           
          		 
                  <dependency>
          		 
                      <groupId>org.mariadb.jdbc</groupId>
          		 
                      <artifactId>mariadb-java-client</artifactId>
          		 
                      <version>1.5.8-SNAPSHOT</version>
          		 
                  </dependency>

          Could you validate this solve your issue ?

          diego dupin Diego Dupin added a comment - Correction is available throught snapshot using : <repositories> <repository> <id>sonatype-nexus-snapshots</id> <name>Sonatype Nexus Snapshots</name> <url>https: //oss.sonatype.org/content/repositories/snapshots</url> </repository> </repositories>     <dependency> <groupId>org.mariadb.jdbc</groupId> <artifactId>mariadb-java-client</artifactId> <version> 1.5 . 8 -SNAPSHOT</version> </dependency> Could you validate this solve your issue ?
          diego dupin Diego Dupin made changes -
          Fix Version/s 1.5.8 [ 22509 ]
          Fix Version/s 1.5.7 [ 22500 ]
          jsteinich Jon Steinich added a comment -

          I can confirm this now works for a single instance cluster. If I get some more free time I can add a second instance to our test cluster and check again.

          jsteinich Jon Steinich added a comment - I can confirm this now works for a single instance cluster. If I get some more free time I can add a second instance to our test cluster and check again.
          diego dupin Diego Dupin made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 78437 ] MariaDB v4 [ 134931 ]

          People

            diego dupin Diego Dupin
            jsteinich Jon Steinich
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.