From 312fc70c04b9262a73c75860ece315047fdb6481 Mon Sep 17 00:00:00 2001
From: Valery Kharseko <vharseko@3a-systems.ru>
Date: Thu, 24 Sep 2026 11:59:21 +0000
Subject: [PATCH] [#1076] Walk every link of a connect failure where the verdict decides the retry (#1077)

---
 opendj-server-legacy/src/test/java/org/opends/server/backends/jdbc/CachedConnectionTestCase.java |   28 ++++++++++++++++++++++++++++
 1 files changed, 28 insertions(+), 0 deletions(-)

diff --git a/opendj-server-legacy/src/test/java/org/opends/server/backends/jdbc/CachedConnectionTestCase.java b/opendj-server-legacy/src/test/java/org/opends/server/backends/jdbc/CachedConnectionTestCase.java
index ce3d1d1..ce66a7e 100644
--- a/opendj-server-legacy/src/test/java/org/opends/server/backends/jdbc/CachedConnectionTestCase.java
+++ b/opendj-server-legacy/src/test/java/org/opends/server/backends/jdbc/CachedConnectionTestCase.java
@@ -1122,6 +1122,34 @@
 	}
 
 	/**
+	 * ... and however far down the chain the driver put it. The walk that decides ends where the
+	 * chain ends, not at a count of links: mssql-jdbc chains every error of one message through
+	 * setNextException, and a walk that stopped at 32 of them answered "the caller's to see" for
+	 * the link it never reached - the connect reported as permanent on a database that would have
+	 * taken it a moment later, and a backend that stays locked down for it (issue #1076).
+	 */
+	@Test(timeOut = 120000)
+	public void testARetryableLinkPastTheOldBudgetOfTheWalkIsLookedAt() throws Exception {
+		final String url = StubDriver.PREFIX + "deep-chain";
+		// 32 links that say nothing of the moment in front of the one that says the database is at its limit
+		SQLException chain = tooManyConnections();
+		for (int link = 32; link > 0; link--) {
+			final SQLException inFront = new SQLException("error " + link + " of the same message", "08006", link);
+			inFront.setNextException(chain);
+			chain = inFront;
+		}
+		stub.failWith(chain, 1);
+		System.setProperty(CachedConnection.POOL_TIMEOUT_PROPERTY, "30");
+
+		try {
+			assertNotNull(CachedConnection.getConnection(url));
+		} catch (SQLException reported) {
+			fail("a database at its limit 33 links down the failure must be waited out, not reported: " + reported, reported);
+		}
+		assertEquals(stub.attempts.get(), 2, "the link past the 32nd must be looked at");
+	}
+
+	/**
 	 * The rest of the insufficient_resources class is not worth waiting out: a server out of disk
 	 * is not made whole by a connection of ours coming back to the pool.
 	 */

--
Gitblit v1.10.0