fivetran-ashokborra commented on code in PR #3566:
URL: https://github.com/apache/polaris/pull/3566#discussion_r2737454271


##########
persistence/relational-jdbc/src/main/java/org/apache/polaris/persistence/relational/jdbc/DatasourceOperations.java:
##########
@@ -312,7 +312,8 @@ private boolean isRetryable(SQLException e) {
 
     // Additionally, one might check for specific error messages or other 
conditions
     return e.getMessage().toLowerCase(Locale.ROOT).contains("connection 
refused")
-        || e.getMessage().toLowerCase(Locale.ROOT).contains("connection 
reset");
+        || e.getMessage().toLowerCase(Locale.ROOT).contains("connection reset")
+        || e.getMessage().toLowerCase(Locale.ROOT).contains("acquisition 
timeout");

Review Comment:
   While I'm aligned with increasing the timeout to a higher value, I think 
that would make sense for deterministic scenarios - like waiting for a specific 
connection. In the case of connection pool, we are not waiting for a specific 
connection pool, but for any of the available connections. Having a retry would 
make it resilient.



##########
persistence/relational-jdbc/src/main/java/org/apache/polaris/persistence/relational/jdbc/DatasourceOperations.java:
##########
@@ -312,7 +312,8 @@ private boolean isRetryable(SQLException e) {
 
     // Additionally, one might check for specific error messages or other 
conditions
     return e.getMessage().toLowerCase(Locale.ROOT).contains("connection 
refused")
-        || e.getMessage().toLowerCase(Locale.ROOT).contains("connection 
reset");
+        || e.getMessage().toLowerCase(Locale.ROOT).contains("connection reset")
+        || e.getMessage().toLowerCase(Locale.ROOT).contains("acquisition 
timeout");

Review Comment:
   While I'm aligned with increasing the timeout to a higher value, I think 
that would make sense for deterministic scenarios - like waiting for a specific 
connection. In the case of connection pool, we are not waiting for a specific 
connection, but for any of the available connections. Having a retry would make 
it resilient.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to