WHOIS server project / mvn clean install -Pintegration

tchizhov.m · 17 June 2023 23:06

Dear All, hi!,
would you kindly advise me on the following issue:
After build is made (mvn clean install), I’m trying to run this set of tests: mvn clean install -Pintegration.
Everything goes fine till whois-query section, it runs first couple of tests then hangs-on, and at least 2 hours of waiting doesn’t make any change.
I have a feeling (may be a wrong one), that it waits for some input, may be test query or whatever…
Would you kindly advise me, how to proceed with/complete these tests?

Here are the steps:

terminal output till the moment where it stops:

image (1)1158×662 128 KB
logs from /whois/whois-query/… :

2023-06-18T00:42:20,496 INFO [DefaultTestContextBootstrapper] Using
TestExecutionListeners:
[org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@77724cbe,
org.springframework.test.context.event.ApplicationEventsTestExecutionListener@27dc627a,
org.springframework.test.context.support.DependencyInjectionTestExecutionListener@570ba13,
org.springframework.test.context.support.DirtiesContextTestExecutionListener@37a9b687,
org.springframework.test.context.event.EventPublishingTestExecutionListener@525b1b70,
org.springframework.test.context.transaction.TransactionalTestExecutionListener@16d07cf3]
2023-06-18T00:42:24,242 INFO [ConfigurationClassParser] Properties
location [file:${whois.config}] not resolvable: Could not resolve
placeholder ‘whois.config’ in value “file:${whois.config}”
2023-06-18T00:42:24,377 INFO [WhoisRipePropertyResolver] Instance name is RIPE
2023-06-18T00:42:24,784 INFO [MLog] MLog clients using slf4j logging.
2023-06-18T00:42:24,834 INFO [C3P0Registry] Initializing c3p0-0.9.5.5
[built 11-December-2019 22:18:33 -0800; debug? true; trace: 10]
2023-06-18T00:42:24,922 INFO [DefaultSourceContext] Delegating source
TEST-GRS to TEST
2023-06-18T00:42:24,923 INFO [DefaultSourceContext] Using sources:
[TEST [MASTER], TEST [SLAVE], TEST-GRS [MASTER], TEST-GRS [SLAVE]]
2023-06-18T00:42:25,238 INFO [IpTreeUpdater] Delegating requests for
TEST-GRS to TEST
2023-06-18T00:42:25,238 INFO [IpTreeUpdater] Delegating requests for
TEST-GRS to TEST
2023-06-18T00:42:25,238 INFO [IpTreeUpdater] Rebuild IpTrees and
scheduled update using sources: [TEST [SLAVE]]
2023-06-18T00:42:25,239 INFO [IpTreeUpdater] Initializing thread pool
with 1 threads
2023-06-18T00:42:25,239 INFO [IpTreeUpdater] Building IP trees
2023-06-18T00:42:25,272 INFO [AbstractPoolBackedDataSource]
Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay
→ 1000, autoCommitOnClose → false, automaticTestTable → null,
breakAfterAcquireFailure → false, checkoutTimeout → 0,
connectionCustomizerClassName →
net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer,
connectionTesterClassName →
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
contextClassLoaderSource → caller, dataSourceName →
z8kfsxaw1kgxz1z1los71a|7c4663ec, debugUnreturnedConnectionStackTraces
→ false, description → null, driverClass → org.mariadb.jdbc.Driver,
extensions → {}, factoryClassLocation → null,
forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins
→ false, forceUseNamedDriverClass → false, identityToken →
z8kfsxaw1kgxz1z1los71a|7c4663ec, idleConnectionTestPeriod → 15,
initialPoolSize → 3, jdbcUrl →
jdbc:mariadb://localhost/test_1687041740769_6cc6903548f7bb4eea70ac990ddb9778_WHOIS,
maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime →
7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100,
maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0,
numHelperThreads → 3, preferredTestQuery → SELECT 1,
privilegeSpawnedThreads → false, properties → {password=,
user=}, propertyCycle → 0,
statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin →
false, testConnectionOnCheckout → false, unreturnedConnectionTimeout
→ 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-18T00:42:25,367 INFO [IpTreeUpdater] Finished building IP
trees in 123.9 ms
2023-06-18T00:42:25,382 INFO [IpRanges] Trusted ranges: [127.0.0.1/32, ::1/128]
2023-06-18T00:42:25,383 INFO [IpRanges] Loadbalancer ranges:
[127.0.0.1/32, ::1/128]
2023-06-18T00:42:25,386 WARN [MaintenanceMode] Access type change:
world FULL → FULL, trusted: FULL → FULL
2023-06-18T00:42:25,429 INFO [AbstractPoolBackedDataSource]
Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay
→ 1000, autoCommitOnClose → false, automaticTestTable → null,
breakAfterAcquireFailure → false, checkoutTimeout → 0,
connectionCustomizerClassName →
net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer,
connectionTesterClassName →
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
contextClassLoaderSource → caller, dataSourceName →
z8kfsxaw1kgxz1z1los71a|7eba962d, debugUnreturnedConnectionStackTraces
→ false, description → null, driverClass →
net.ripe.db.whois.common.jdbc.driver.LoggingDriver, extensions → {},
factoryClassLocation → null, forceIgnoreUnresolvedTransactions →
false, forceSynchronousCheckins → false, forceUseNamedDriverClass →
false, identityToken → z8kfsxaw1kgxz1z1los71a|7eba962d,
idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl →
jdbc:log:mariadb://localhost/test_1687041740769_6cc6903548f7bb4eea70ac990ddb9778_WHOIS;driver=org.mariadb.jdbc.Driver,
maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime →
7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100,
maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0,
numHelperThreads → 3, preferredTestQuery → SELECT 1,
privilegeSpawnedThreads → false, properties → {password=,
user=}, propertyCycle → 0,
statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin →
false, testConnectionOnCheckout → false, unreturnedConnectionTimeout
→ 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-18T00:42:25,466 INFO [AbstractPoolBackedDataSource]
Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay
→ 1000, autoCommitOnClose → false, automaticTestTable → null,
breakAfterAcquireFailure → false, checkoutTimeout → 0,
connectionCustomizerClassName →
net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer,
connectionTesterClassName →
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
contextClassLoaderSource → caller, dataSourceName →
z8kfsxaw1kgxz1z1los71a|5f18a661, debugUnreturnedConnectionStackTraces
→ false, description → null, driverClass → org.mariadb.jdbc.Driver,
extensions → {}, factoryClassLocation → null,
forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins
→ false, forceUseNamedDriverClass → false, identityToken →
z8kfsxaw1kgxz1z1los71a|5f18a661, idleConnectionTestPeriod → 15,
initialPoolSize → 3, jdbcUrl →
jdbc:mariadb://localhost/test_1687041740769_6cc6903548f7bb4eea70ac990ddb9778_INTERNALS,
maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime →
7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100,
maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0,
numHelperThreads → 3, preferredTestQuery → SELECT 1,
privilegeSpawnedThreads → false, properties → {password=,
user=}, propertyCycle → 0,
statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin →
false, testConnectionOnCheckout → false, unreturnedConnectionTimeout
→ 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-18T00:42:25,504 INFO [AuthoritativeResourceImportTask]
Authoritative resource import task is disabled
2023-06-18T00:42:25,512 INFO [AuthoritativeResourceRefreshTask]
Authoritative resource refresh task is disabled
2023-06-18T00:42:25,825 INFO [RipeAuthoritativeResourceImportTask]
Authoritative resource RSNG import task is disabled
2023-06-18T00:42:25,951 INFO [SentryConfigurations] Sentry is not enabled
2023-06-18T00:42:26,084 INFO [AbstractPoolBackedDataSource]
Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay
→ 1000, autoCommitOnClose → false, automaticTestTable → null,
breakAfterAcquireFailure → false, checkoutTimeout → 0,
connectionCustomizerClassName →
net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer,
connectionTesterClassName →
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
contextClassLoaderSource → caller, dataSourceName →
z8kfsxaw1kgxz1z1los71a|2bfe2327, debugUnreturnedConnectionStackTraces
→ false, description → null, driverClass → org.mariadb.jdbc.Driver,
extensions → {}, factoryClassLocation → null,
forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins
→ false, forceUseNamedDriverClass → false, identityToken →
z8kfsxaw1kgxz1z1los71a|2bfe2327, idleConnectionTestPeriod → 15,
initialPoolSize → 3, jdbcUrl →
jdbc:mariadb://localhost/test_1687041740769_6cc6903548f7bb4eea70ac990ddb9778_ACL,
maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime →
7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100,
maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0,
numHelperThreads → 3, preferredTestQuery → SELECT 1,
privilegeSpawnedThreads → false, properties → {password=,
user=}, propertyCycle → 0,
statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin →
false, testConnectionOnCheckout → false, unreturnedConnectionTimeout
→ 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-18T00:42:27,801 INFO [AbstractPoolBackedDataSource]
Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay
→ 1000, autoCommitOnClose → false, automaticTestTable → null,
breakAfterAcquireFailure → false, checkoutTimeout → 0,
connectionCustomizerClassName →
net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer,
connectionTesterClassName →
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
contextClassLoaderSource → caller, dataSourceName →
z8kfsxaw1kgxz1z1los71a|72548e3c, debugUnreturnedConnectionStackTraces
→ false, description → null, driverClass → org.mariadb.jdbc.Driver,
extensions → {}, factoryClassLocation → null,
forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins
→ false, forceUseNamedDriverClass → false, identityToken →
z8kfsxaw1kgxz1z1los71a|72548e3c, idleConnectionTestPeriod → 15,
initialPoolSize → 3, jdbcUrl →
jdbc:mariadb://localhost/test_1687041740769_6cc6903548f7bb4eea70ac990ddb9778_MAILUPDATES,
maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime →
7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100,
maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0,
numHelperThreads → 3, preferredTestQuery → SELECT 1,
privilegeSpawnedThreads → false, properties → {password=,
user=}, propertyCycle → 0,
statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin →
false, testConnectionOnCheckout → false, unreturnedConnectionTimeout
→ 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-18T00:42:27,843 INFO [IpTreeUpdater] Building IP trees
2023-06-18T00:42:27,847 INFO [IpTreeUpdater] Finished building IP
trees in 3.453 ms
2023-06-18T00:42:27,973 INFO [QueryServer] Query server listening on 35135

eshryane · 19 June 2023 14:22

Hello,

It’s not clear where the integration tests are getting stuck. I expect the integration tests in whois-query to take about 5 minutes.

Can you look for long-running Java processes which may be stuck and then trigger a thread dump with ‘kill -3 ’ and attach the output in a reply? The output will be logged in a file under whois-query/target/.

Regards
Ed Shryane
RIPE NCC

tchizhov.m · 20 June 2023 11:55

Hi Ed, thanks for your response,

here the tests hang:

console output937×824 173 KB
jps monitoring:

jps monitoring563×948 112 KB

and test logs i was able to found (other files contain smt like Test passed ok or empty):

Output #1:

== KeepaliveTest-Integration-output.txt ==========================
2023-06-20T12:49:42,887 INFO [DefaultTestContextBootstrapper] Using TestExecutionListeners: [org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@535a518c, org.springframework.test.context.event.ApplicationEventsTestExecutionListener@38f981b6, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@3a4aadf8, org.springframework.test.context.support.DirtiesContextTestExecutionListener@7bbfc5ff, org.springframework.test.context.event.EventPublishingTestExecutionListener@7a682d35, org.springframework.test.context.transaction.TransactionalTestExecutionListener@ee8e7ff]
2023-06-20T12:49:52,635 INFO [ConfigurationClassParser] Properties location [file:${whois.config}] not resolvable: Could not resolve placeholder ‘whois.config’ in value “file:${whois.config}”
2023-06-20T12:49:53,472 INFO [WhoisRipePropertyResolver] Instance name is RIPE
2023-06-20T12:49:54,910 INFO [MLog] MLog clients using slf4j logging.
2023-06-20T12:49:55,028 INFO [C3P0Registry] Initializing c3p0-0.9.5.5 [built 11-December-2019 22:18:33 -0800; debug? true; trace: 10]
2023-06-20T12:49:55,272 INFO [DefaultSourceContext] Delegating source TEST-GRS to TEST
2023-06-20T12:49:55,272 INFO [DefaultSourceContext] Using sources: [TEST [MASTER], TEST [SLAVE], TEST-GRS [MASTER], TEST-GRS [SLAVE]]
2023-06-20T12:49:56,725 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:49:56,725 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:49:56,726 INFO [IpTreeUpdater] Rebuild IpTrees and scheduled update using sources: [TEST [SLAVE]]
2023-06-20T12:49:56,726 INFO [IpTreeUpdater] Initializing thread pool with 1 threads
2023-06-20T12:49:56,726 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:49:56,855 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|74eebb25, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|74eebb25, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_WHOIS, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:57,016 INFO [IpTreeUpdater] Finished building IP trees in 273.1 ms
2023-06-20T12:49:57,044 INFO [IpRanges] Trusted ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:49:57,072 INFO [IpRanges] Loadbalancer ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:49:57,078 WARN [MaintenanceMode] Access type change: world FULL → FULL, trusted: FULL → FULL
2023-06-20T12:49:57,171 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|4def8aaa, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → net.ripe.db.whois.common.jdbc.driver.LoggingDriver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|4def8aaa, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:log:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_WHOIS;driver=org.mariadb.jdbc.Driver, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:57,371 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|4913465d, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|4913465d, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_INTERNALS, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:57,616 INFO [AuthoritativeResourceImportTask] Authoritative resource import task is disabled
2023-06-20T12:49:57,667 INFO [AuthoritativeResourceRefreshTask] Authoritative resource refresh task is disabled
2023-06-20T12:49:58,306 INFO [RipeAuthoritativeResourceImportTask] Authoritative resource RSNG import task is disabled
2023-06-20T12:49:58,852 INFO [SentryConfigurations] Sentry is not enabled
2023-06-20T12:49:59,412 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|234ad505, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|234ad505, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_ACL, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:50:01,381 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|57fd93f9, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|57fd93f9, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_MAILUPDATES, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:50:01,668 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:01,690 INFO [IpTreeUpdater] Finished building IP trees in 21.13 ms
2023-06-20T12:50:02,212 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:02,231 INFO [IpTreeUpdater] Finished building IP trees in 19.14 ms
2023-06-20T12:50:02,499 INFO [QueryServer] Query server listening on 33511
2023-06-20T12:50:06,572 INFO [ConfigurationClassParser] Properties location [file:${whois.config}] not resolvable: Could not resolve placeholder ‘whois.config’ in value “file:${whois.config}”
2023-06-20T12:50:06,788 INFO [DefaultSourceContext] Delegating source TEST-GRS to TEST
2023-06-20T12:50:06,792 INFO [DefaultSourceContext] Using sources: [TEST [MASTER], TEST [SLAVE], TEST-GRS [MASTER], TEST-GRS [SLAVE]]
2023-06-20T12:50:06,885 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:50:06,886 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:50:06,886 INFO [IpTreeUpdater] Rebuild IpTrees and scheduled update using sources: [TEST [SLAVE]]
2023-06-20T12:50:06,886 INFO [IpTreeUpdater] Initializing thread pool with 1 threads
2023-06-20T12:50:06,886 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:06,919 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|6a74797e, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|6a74797e, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_WHOIS, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:50:06,931 INFO [IpTreeUpdater] Finished building IP trees in 44.55 ms
2023-06-20T12:50:06,936 INFO [IpRanges] Trusted ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:50:06,937 INFO [IpRanges] Loadbalancer ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:50:06,951 WARN [MaintenanceMode] Access type change: world FULL → FULL, trusted: FULL → FULL
2023-06-20T12:50:07,005 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t92ov82p5n|33c0f3d2, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → net.ripe.db.whois.common.jdbc.driver.LoggingDriver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t92ov82p5n|33c0f3d2, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:log:mariadb://localhost/test_1687258183698_77e1b13629fdf7c66c74f689da6b7976_WHOIS;driver=org.mariadb.jdbc.Driver, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
=============================

Output #2:
2) ==== Test-Integration-output.txt =============================================
2023-06-20T12:49:42,776 INFO [DefaultTestContextBootstrapper] Using TestExecutionListeners: [org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@5921b93c, org.springframework.test.context.event.ApplicationEventsTestExecutionListener@faea4da, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@19b02dfd, org.springframework.test.context.support.DirtiesContextTestExecutionListener@3dce6dd8, org.springframework.test.context.event.EventPublishingTestExecutionListener@69f2cb04, org.springframework.test.context.transaction.TransactionalTestExecutionListener@13803a94]
2023-06-20T12:49:51,895 INFO [ConfigurationClassParser] Properties location [file:${whois.config}] not resolvable: Could not resolve placeholder ‘whois.config’ in value “file:${whois.config}”
2023-06-20T12:49:52,253 INFO [WhoisRipePropertyResolver] Instance name is RIPE
2023-06-20T12:49:54,435 INFO [MLog] MLog clients using slf4j logging.
2023-06-20T12:49:54,571 INFO [C3P0Registry] Initializing c3p0-0.9.5.5 [built 11-December-2019 22:18:33 -0800; debug? true; trace: 10]
2023-06-20T12:49:55,444 INFO [DefaultSourceContext] Delegating source TEST-GRS to TEST
2023-06-20T12:49:55,445 INFO [DefaultSourceContext] Using sources: [TEST [MASTER], TEST [SLAVE], TEST-GRS [MASTER], TEST-GRS [SLAVE]]
2023-06-20T12:49:57,065 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:49:57,082 INFO [IpTreeUpdater] Delegating requests for TEST-GRS to TEST
2023-06-20T12:49:57,085 INFO [IpTreeUpdater] Rebuild IpTrees and scheduled update using sources: [TEST [SLAVE]]
2023-06-20T12:49:57,087 INFO [IpTreeUpdater] Initializing thread pool with 1 threads
2023-06-20T12:49:57,088 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:49:57,257 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t8ph1c2ut7o|6d0e242f, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t8ph1c2ut7o|6d0e242f, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183608_a8ef5a5ffb8fb671d36aab4b5b45ccf0_WHOIS, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:57,585 INFO [IpTreeUpdater] Finished building IP trees in 466.9 ms
2023-06-20T12:49:57,653 INFO [IpRanges] Trusted ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:49:57,667 INFO [IpRanges] Loadbalancer ranges: [127.0.0.1/32, ::1/128]
2023-06-20T12:49:57,673 WARN [MaintenanceMode] Access type change: world FULL → FULL, trusted: FULL → FULL
2023-06-20T12:49:58,087 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t8ph1c2ut7o|10e5471d, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → net.ripe.db.whois.common.jdbc.driver.LoggingDriver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t8ph1c2ut7o|10e5471d, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:log:mariadb://localhost/test_1687258183608_a8ef5a5ffb8fb671d36aab4b5b45ccf0_WHOIS;driver=org.mariadb.jdbc.Driver, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:58,187 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t8ph1c2ut7o|68938ccf, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t8ph1c2ut7o|68938ccf, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183608_a8ef5a5ffb8fb671d36aab4b5b45ccf0_INTERNALS, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:49:58,278 INFO [AuthoritativeResourceImportTask] Authoritative resource import task is disabled
2023-06-20T12:49:58,303 INFO [AuthoritativeResourceRefreshTask] Authoritative resource refresh task is disabled
2023-06-20T12:49:59,001 INFO [RipeAuthoritativeResourceImportTask] Authoritative resource RSNG import task is disabled
2023-06-20T12:49:59,541 INFO [SentryConfigurations] Sentry is not enabled
2023-06-20T12:50:00,064 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t8ph1c2ut7o|19a5cfb8, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t8ph1c2ut7o|19a5cfb8, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183608_a8ef5a5ffb8fb671d36aab4b5b45ccf0_ACL, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:50:02,094 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → false, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → net.ripe.db.whois.common.jdbc.WhoisConnectorCustomizer, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource → caller, dataSourceName → z8kfsxaw1o1t8ph1c2ut7o|1f47e14d, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → org.mariadb.jdbc.Driver, extensions → {}, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, forceSynchronousCheckins → false, forceUseNamedDriverClass → false, identityToken → z8kfsxaw1o1t8ph1c2ut7o|1f47e14d, idleConnectionTestPeriod → 15, initialPoolSize → 3, jdbcUrl → jdbc:mariadb://localhost/test_1687258183608_a8ef5a5ffb8fb671d36aab4b5b45ccf0_MAILUPDATES, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 7200, maxIdleTimeExcessConnections → 0, maxPoolSize → 100, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 0, numHelperThreads → 3, preferredTestQuery → SELECT 1, privilegeSpawnedThreads → false, properties → {password=, user=}, propertyCycle → 0, statementCacheNumDeferredCloseThreads → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, userOverrides → {}, usesTraditionalReflectiveProxies → false ]
2023-06-20T12:50:02,173 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:02,180 INFO [IpTreeUpdater] Finished building IP trees in 6.222 ms
2023-06-20T12:50:02,832 INFO [QueryServer] Query server listening on 42413
2023-06-20T12:50:04,045 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:04,050 INFO [IpTreeUpdater] Finished building IP trees in 4.509 ms
2023-06-20T12:50:04,129 INFO [QueryServer] Query server listening on 40899
2023-06-20T12:50:05,501 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:05,506 INFO [IpTreeUpdater] Finished building IP trees in 4.874 ms
2023-06-20T12:50:05,601 INFO [QueryServer] Query server listening on 39843
2023-06-20T12:50:06,758 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:06,784 INFO [IpTreeUpdater] Finished building IP trees in 21.36 ms
2023-06-20T12:50:06,888 INFO [QueryServer] Query server listening on 45513
2023-06-20T12:50:07,796 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:07,812 INFO [IpTreeUpdater] Finished building IP trees in 16.09 ms
2023-06-20T12:50:08,378 INFO [QueryServer] Query server listening on 37315
2023-06-20T12:50:09,597 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:09,602 INFO [IpTreeUpdater] Finished building IP trees in 4.379 ms
2023-06-20T12:50:09,666 INFO [QueryServer] Query server listening on 33893
% Version 1 (current version) of object “MAINT-ME”
% This version was a UPDATE operation on 2023-06-20T12:50:08Z
% You can use “–list-versions” to get a list of versions for an object.

mntner: MAINT-ME
descr: Testing maintainer
auth: MD5-PW # Filtered
source: RIPE # Filtered

% This query was served by the RIPE Database Query Service version 0.1-TEST (RIPE)

2023-06-20T12:50:10,387 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:10,391 INFO [IpTreeUpdater] Finished building IP trees in 3.894 ms
2023-06-20T12:50:10,452 INFO [QueryServer] Query server listening on 45465
2023-06-20T12:50:11,221 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:11,232 INFO [IpTreeUpdater] Finished building IP trees in 9.685 ms
2023-06-20T12:50:11,358 INFO [QueryServer] Query server listening on 38989
2023-06-20T12:50:12,300 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:12,303 INFO [IpTreeUpdater] Finished building IP trees in 3.430 ms
2023-06-20T12:50:12,367 INFO [QueryServer] Query server listening on 37963
2023-06-20T12:50:13,387 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:13,390 INFO [IpTreeUpdater] Finished building IP trees in 3.478 ms
2023-06-20T12:50:13,465 INFO [QueryServer] Query server listening on 45325
2023-06-20T12:50:14,483 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:14,498 INFO [IpTreeUpdater] Finished building IP trees in 14.87 ms
2023-06-20T12:50:14,572 INFO [QueryServer] Query server listening on 41671
2023-06-20T12:50:15,726 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:15,732 INFO [IpTreeUpdater] Finished building IP trees in 4.880 ms
2023-06-20T12:50:15,784 INFO [QueryServer] Query server listening on 43465
2023-06-20T12:50:16,848 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:16,860 INFO [IpTreeUpdater] Finished building IP trees in 12.41 ms
2023-06-20T12:50:16,989 INFO [QueryServer] Query server listening on 39847
2023-06-20T12:50:17,677 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:17,682 INFO [IpTreeUpdater] Finished building IP trees in 3.953 ms
2023-06-20T12:50:17,739 INFO [QueryServer] Query server listening on 38447
2023-06-20T12:50:18,489 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:18,493 INFO [IpTreeUpdater] Finished building IP trees in 2.992 ms
2023-06-20T12:50:18,561 INFO [QueryServer] Query server listening on 36143
2023-06-20T12:50:19,497 INFO [IpTreeUpdater] Building IP trees
2023-06-20T12:50:19,501 INFO [IpTreeUpdater] Finished building IP trees in 3.332 ms
2023-06-20T12:50:19,580 INFO [QueryServer] Query server listening on 44009

====================================================

tchizhov.m · 20 June 2023 12:03

Another thing, i continued with release,
it was prepared after some struggling, but when i try to launch:

I’m getting this:
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
ERROR StatusLogger Reconfiguration failed: No configuration found for ‘Default’ at ‘null’ in ‘null’
ERROR StatusLogger Reconfiguration failed: No configuration found for ‘251a69d7’ at ‘null’ in ‘null’
Exception in thread “main” org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name ‘aclDataSource’ defined in class path resource [applicationContext-commons.xml>
at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:230)
at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.processProperties(PropertySourcesPlaceholderConfigurer.java:198)
at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.postProcessBeanFactory(PropertySourcesPlaceholderConfigurer.java:173)
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:325)
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:183)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:748)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:564)
at net.ripe.db.whois.common.profiles.WhoisProfile.initContextWithProfile(WhoisProfile.java:19)
at net.ripe.db.whois.db.WhoisServer.main(WhoisServer.java:62)
Caused by: java.lang.IllegalArgumentException: Could not resolve placeholder ‘acl.database.url’ in value “${acl.database.url}”
at org.springframework.util.PropertyPlaceholderHelper.parseStringValue(PropertyPlaceholderHelper.java:180)
at org.springframework.util.PropertyPlaceholderHelper.replacePlaceholders(PropertyPlaceholderHelper.java:126)
at org.springframework.core.env.AbstractPropertyResolver.doResolvePlaceholders(AbstractPropertyResolver.java:239)
at org.springframework.core.env.AbstractPropertyResolver.resolveRequiredPlaceholders(AbstractPropertyResolver.java:210)
at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.lambda$processProperties$0(PropertySourcesPlaceholderConfigurer.java:191)
at org.springframework.beans.factory.config.BeanDefinitionVisitor.resolveStringValue(BeanDefinitionVisitor.java:296)
at org.springframework.beans.factory.config.BeanDefinitionVisitor.resolveValue(BeanDefinitionVisitor.java:217)
at org.springframework.beans.factory.config.BeanDefinitionVisitor.visitPropertyValues(BeanDefinitionVisitor.java:147)
at org.springframework.beans.factory.config.BeanDefinitionVisitor.visitBeanDefinition(BeanDefinitionVisitor.java:85)
at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:227)
… 8 more

=================

may it be related somehow, some issue with database connection setup, stored in applicationContext-commons.xml or like that?

eshryane · 20 June 2023 13:27

Hello,

(1) I’ve reproduced the hanging integration tests in the whois-query module on OSX. However, the integration tests are passing on Linux (specifically Oracle Linux 8.8). I suggest running the integration tests on a Linux server for the moment as a workaround. I’ve created a bug in the DB team’s backlog to investigate the hanging further.

(2) The error: “Could not resolve placeholder ‘acl.database.url’ in value “${acl.database.url}”” is caused by a missing property. I suggest adding a property to the java command “-Dwhois.config=properties”, copy the example whois.properties from whois-commons/src/test/resources/whois.properties and update for your own environment.

Regards
Ed Shryane
RIPE NCC

tchizhov.m · 20 June 2023 13:49

Thank you very much!

(btw - i experience hanging issue on Ubuntu, 2204)

eshryane · 20 June 2023 14:18

That’s very good to know. I’ll test on Ubuntu.

Regards
Ed Shryane
RIPE NCC

tchizhov.m · 20 June 2023 14:45

Ah, okk, to be more precise then:
Windows11 => Oracle VM VirtualBox => Ubuntu 2204
-Pintegration - always hangs on this point;
-Pall - sometimes works, sometimes hangs on different points;
-Pendtoend - never tried yet;
-Prelease - sometimes works sometimes floating error like -Pall

Thank you very much for your kind help!

Topic		Replies	Views
Maven doesn't detect generateByaccs ripe-database	4	686	30 May 2023
Any workaround to build whois in Windows whois	2	500	7 July 2023
Can't start JMX with Java 17 - any possible workaround? whois , debug	57	2269	9 August 2023
Can't find whois.init file whois	2	660	29 July 2023
RIPE DB structure ripe-database	2	419	8 June 2023

WHOIS server project / mvn clean install -Pintegration

Related Topics