Repeated "Node is no longer available in the topology" when the node is up and running #1091

efenderbosch-atg · 2024-08-19T12:48:31Z

efenderbosch-atg
Aug 19, 2024

Can anyone explain why this is happening? Is it a sign of something being mis-configured? Can we safely ignore it?

Trace level logs from a login request. :

08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:12.451 DEBUG [      Finalizer] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:12.453 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:12.453 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.453 TRACE [nio-8084-exec-2] s.a.j.t.TargetDriverDialectManager       [request-id: agiwvhon3f7rrgfbjint7i477u] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:12.453 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:12.453 TRACE [nio-8084-exec-2] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: agiwvhon3f7rrgfbjint7i477u] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:12.453 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.453 TRACE [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.453 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.453 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:12.662 TRACE [ool-10-thread-2] software.amazon.jdbc.Driver              [request-id: null] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:12.662 TRACE [ool-10-thread-2] software.amazon.jdbc.Driver              [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.662 TRACE [ool-10-thread-2] s.a.j.t.TargetDriverDialectManager       [request-id: null] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:12.662 TRACE [ool-10-thread-2] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:12.662 TRACE [ool-10-thread-2] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: null] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:12.663 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.663 TRACE [ool-10-thread-2] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.663 TRACE [ool-10-thread-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.663 TRACE [ool-10-thread-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:12.723 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:12.777 TRACE [ool-10-thread-3] software.amazon.jdbc.Driver              [request-id: null] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:12.777 TRACE [ool-10-thread-3] software.amazon.jdbc.Driver              [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.777 TRACE [ool-10-thread-3] s.a.j.t.TargetDriverDialectManager       [request-id: null] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:12.777 TRACE [ool-10-thread-3] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:12.778 TRACE [ool-10-thread-3] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: null] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:12.778 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.778 TRACE [ool-10-thread-3] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.778 TRACE [ool-10-thread-3] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:12.778 TRACE [ool-10-thread-3] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:12.780 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.780 DEBUG [nio-8084-exec-2] s.a.j.p.f.FailoverConnectionPlugin       [request-id: agiwvhon3f7rrgfbjint7i477u] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:12.780 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.831 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.859 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.885 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.885 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.886 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:12.938 TRACE [ool-10-thread-2] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.023 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.876251]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.023 DEBUG [ool-10-thread-2] s.a.j.p.f.FailoverConnectionPlugin       [request-id: null] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.023 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.876251]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.221 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.876251]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.303 TRACE [ool-10-thread-3] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.303 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.331 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.338 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.338 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.339 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.356 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.356 DEBUG [ool-10-thread-3] s.a.j.p.f.FailoverConnectionPlugin       [request-id: null] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.356 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.360 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.366 TRACE [ool-10-thread-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.388 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.393 DEBUG [ool-10-thread-2] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:13.393 DEBUG [ool-10-thread-2] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:13.394 TRACE [ool-10-thread-2] software.amazon.jdbc.Driver              [request-id: null] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:13.394 TRACE [ool-10-thread-2] software.amazon.jdbc.Driver              [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.394 TRACE [ool-10-thread-2] s.a.j.t.TargetDriverDialectManager       [request-id: null] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:13.394 TRACE [ool-10-thread-2] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.394 TRACE [ool-10-thread-2] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: null] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:13.394 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.394 TRACE [ool-10-thread-2] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.395 TRACE [ool-10-thread-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.395 TRACE [ool-10-thread-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:13.410 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.416 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.437 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.442 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1408, 2024-08-19 12:30:12.695446]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:12.752452]
08:30:13.463 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.463 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.463 TRACE [ool-10-thread-3] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> (blank)
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.463 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.470 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.490 TRACE [ool-10-thread-3] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> false
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.490 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.496 DEBUG [nio-8084-exec-2] s.amazon.jdbc.ConnectionPluginManager    [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.
08:30:13.496 DEBUG [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.
08:30:13.517 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.543 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.571 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.158026]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.597 TRACE [ool-10-thread-3] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> true
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.597 TRACE [ool-10-thread-3] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> true
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.624 DEBUG [ool-10-thread-3] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:13.624 DEBUG [ool-10-thread-3] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:13.624 TRACE [ool-10-thread-3] software.amazon.jdbc.Driver              [request-id: null] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:13.624 TRACE [ool-10-thread-3] software.amazon.jdbc.Driver              [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.624 TRACE [ool-10-thread-3] s.a.j.t.TargetDriverDialectManager       [request-id: null] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:13.624 TRACE [ool-10-thread-3] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.624 TRACE [ool-10-thread-3] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: null] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:13.625 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.625 TRACE [ool-10-thread-3] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.625 TRACE [ool-10-thread-3] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.625 TRACE [ool-10-thread-3] s.amazon.jdbc.DriverConnectionProvider   [request-id: null] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:13.665 TRACE [ool-10-thread-2] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.717 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.580942]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.718 DEBUG [ool-10-thread-2] s.a.j.p.f.FailoverConnectionPlugin       [request-id: null] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.718 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.580942]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.719 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:13.719 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.720 TRACE [nio-8084-exec-2] s.a.j.t.TargetDriverDialectManager       [request-id: agiwvhon3f7rrgfbjint7i477u] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:13.720 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.720 TRACE [nio-8084-exec-2] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: agiwvhon3f7rrgfbjint7i477u] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:13.720 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.720 TRACE [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.720 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:13.720 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:13.771 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.580942]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.798 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.824 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.824 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.824 TRACE [ool-10-thread-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> (blank)
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.824 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.850 TRACE [ool-10-thread-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> false
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.853 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.879 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.889 TRACE [ool-10-thread-3] s.amazon.jdbc.dialect.DialectManager     [request-id: null] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.906 TRACE [ool-10-thread-2] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1601, 2024-08-19 12:30:13.761987]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=4, 2024-08-19 12:30:13.329026]
08:30:13.934 TRACE [ool-10-thread-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> true
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.934 TRACE [ool-10-thread-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: true -> true
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:13.942 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:13.942 DEBUG [ool-10-thread-3] s.a.j.p.f.FailoverConnectionPlugin       [request-id: null] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:13.942 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:13.960 DEBUG [ool-10-thread-2] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:13.960 DEBUG [ool-10-thread-2] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:13.992 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:13.993 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.021 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.045 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:14.008876]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.045 DEBUG [nio-8084-exec-2] s.a.j.p.f.FailoverConnectionPlugin       [request-id: agiwvhon3f7rrgfbjint7i477u] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:14.045 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:14.008876]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.046 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.046 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.046 TRACE [ool-10-thread-3] s.a.j.h.RdsHostListProvider              [request-id: null] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:13.882665]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.072 TRACE [ool-10-thread-3] s.a.jdbc.states.SessionStateServiceImpl  [request-id: null] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: (blank) -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.096 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1607, 2024-08-19 12:30:14.008876]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.098 DEBUG [ool-10-thread-3] s.amazon.jdbc.ConnectionPluginManager    [request-id: null] : Releasing resources.
08:30:14.098 DEBUG [ool-10-thread-3] software.amazon.jdbc.PluginServiceImpl   [request-id: null] : Releasing resources.
08:30:14.122 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.150 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.150 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.150 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.177 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: false -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.203 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.203 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> (blank)
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.203 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.228 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> false
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.229 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.262 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.290 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.316 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.316 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.027067]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=12, 2024-08-19 12:30:13.839326]
08:30:14.342 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> false
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.342 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> false
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.369 DEBUG [nio-8084-exec-2] s.amazon.jdbc.ConnectionPluginManager    [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.
08:30:14.369 DEBUG [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.
08:30:14.370 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Opening connection to jdbc:aws-wrapper:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example?useSSL=true&verifyServerCertificate=false&wrapperProfileName=SF_D0
08:30:14.370 TRACE [nio-8084-exec-2] software.amazon.jdbc.Driver              [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:14.370 TRACE [nio-8084-exec-2] s.a.j.t.TargetDriverDialectManager       [request-id: agiwvhon3f7rrgfbjint7i477u] : Target driver dialect set to: 'mysql-connector-j', software.amazon.jdbc.targetdriverdialect.MysqlConnectorJTargetDriverDialect@70c13f9a.
08:30:14.370 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:14.370 TRACE [nio-8084-exec-2] s.a.jdbc.ConnectionPluginChainBuilder    [request-id: agiwvhon3f7rrgfbjint7i477u] : Plugins order has been rearranged. The following order is in effect: AuroraInitialConnectionStrategyPluginFactory, AuroraConnectionTrackerPluginFactory, FailoverConnectionPluginFactory
08:30:14.370 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:14.370 TRACE [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Set current host to HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:14.370 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting with properties: 
[verifyServerCertificate] false
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[wrapperProfileName] SF_D0
[useSSL] true
[password] ***
[database] example
[connectTimeout] 10000
[socketTimeout] 5000
[loginTimeout] 10000
[wrapperTargetDriverDialect] mysql-connector-j
[user] example
08:30:14.370 TRACE [nio-8084-exec-2] s.amazon.jdbc.DriverConnectionProvider   [request-id: agiwvhon3f7rrgfbjint7i477u] : Connecting to jdbc:mysql://example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:3306/example
with properties: 
[verifyServerCertificate] false
[password] ***
[wrapperDialect] aurora-mysql
[tcpKeepAlive] false
[connectTimeout] 10000
[socketTimeout] 5000
[user] example
[useSSL] true
08:30:14.639 TRACE [nio-8084-exec-2] s.amazon.jdbc.dialect.DialectManager     [request-id: agiwvhon3f7rrgfbjint7i477u] : Current dialect: aurora-mysql, software.amazon.jdbc.dialect.AuroraMysqlDialect@38175d0d, canUpdate: false
08:30:14.692 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.692 DEBUG [nio-8084-exec-2] s.a.j.p.f.FailoverConnectionPlugin       [request-id: agiwvhon3f7rrgfbjint7i477u] : Node is no longer available in the topology: HostSpec[host=example-dev-v2-cluster.cluster-xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=100, null]
08:30:14.692 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.746 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.773 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.800 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.800 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.800 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.826 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: false -> (blank)
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.852 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: (blank) -> (blank)
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.852 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> (blank)
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.852 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.877 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> false
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.878 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.907 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.935 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.960 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> true
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.960 TRACE [nio-8084-exec-2] s.a.j.h.RdsHostListProvider              [request-id: agiwvhon3f7rrgfbjint7i477u] : [From cache] Topology: 
   HostSpec[host=example-dev-v2-us-east-1a.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, READER, AVAILABLE, weight=1907, 2024-08-19 12:30:14.167986]
   HostSpec[host=example-dev-v2.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com, port=3306, WRITER, AVAILABLE, weight=14, 2024-08-19 12:30:14.664848]
08:30:14.987 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> false
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:14.987 TRACE [nio-8084-exec-2] s.a.jdbc.states.SessionStateServiceImpl  [request-id: agiwvhon3f7rrgfbjint7i477u] : Current session state:
autoCommit: true -> true
readOnly: false -> false
catalog: (blank) -> (blank)
schema: (blank) -> (blank)
holdability: (blank) -> (blank)
networkTimeout: (blank) -> (blank)
transactionIsolation: (blank) -> (blank)
typeMap: (blank) -> (blank)

08:30:15.012 DEBUG [nio-8084-exec-2] s.amazon.jdbc.ConnectionPluginManager    [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.
08:30:15.012 DEBUG [nio-8084-exec-2] software.amazon.jdbc.PluginServiceImpl   [request-id: agiwvhon3f7rrgfbjint7i477u] : Releasing resources.

Answered by karenc-bq

Aug 20, 2024

Hi @efenderbosch-atg, yes you can safely ignore this log message.

When the client application makes the initial connection using a cluster endpoint, the driver will add the provided endpoint to the topology cache in memory. When the failover plugin fetches the actual topology, the cluster endpoint will be replaced by the instance endpoints, hence the logs you are seeing.

These log messages are pretty low level, if you'd like you can increase the log level to see less of these debug messages.
You can use a .properties file to modify the log level:

.level=INFO
handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=ALL
software.amazon.jdbc.Driver.level=FINEST
softwa…

View full answer

karenc-bq · 2024-08-20T16:34:30Z

karenc-bq
Aug 20, 2024
Maintainer

Hi @efenderbosch-atg, yes you can safely ignore this log message.

When the client application makes the initial connection using a cluster endpoint, the driver will add the provided endpoint to the topology cache in memory. When the failover plugin fetches the actual topology, the cluster endpoint will be replaced by the instance endpoints, hence the logs you are seeing.

These log messages are pretty low level, if you'd like you can increase the log level to see less of these debug messages.
You can use a .properties file to modify the log level:

.level=INFO
handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=ALL
software.amazon.jdbc.Driver.level=FINEST
software.amazon.jdbc.plugin.failover.FailoverConnectionPlugin.level=INFO

More details on logging here.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repeated "Node is no longer available in the topology" when the node is up and running #1091

{{title}}

Replies: 1 comment

{{title}}

Select a reply

Repeated "Node is no longer available in the topology" when the node is up and running #1091

efenderbosch-atg Aug 19, 2024

Replies: 1 comment

karenc-bq Aug 20, 2024 Maintainer

efenderbosch-atg
Aug 19, 2024

karenc-bq
Aug 20, 2024
Maintainer