# WHOIS server project / mvn clean install -Pintegration

**URL:** <https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534>\
**Category:** Uncategorized\
**Tags:** whois\
**Created:** [17 June 2023 23:06 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534 "2023-06-17T23:06:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![tchizhov.m](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/tchizhov.m/32/284_2.png) [@tchizhov.m](https://forum.ripe.net/u/tchizhov.m)\
**Post date:** [17 June 2023 23:06 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/1 "2023-06-17T23:06:07Z")

</div>

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:

1. terminal output till the moment where it stops:  

2. 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](http://127.0.0.1/32), ::1/128]  
2023-06-18T00:42:25,383 INFO [IpRanges] Loadbalancer ranges:  
[[127.0.0.1/32](http://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

---

<div class="post-metadata">

**Author:** ![eshryane](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/eshryane/32/34_2.png) [@eshryane](https://forum.ripe.net/u/eshryane)\
**Post date:** [19 June 2023 14:22 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/2 "2023-06-19T14:22:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tchizhov.m](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/tchizhov.m/32/284_2.png) [@tchizhov.m](https://forum.ripe.net/u/tchizhov.m)\
**Post date:** [20 June 2023 11:55 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/3 "2023-06-20T11:55:38Z")

</div>

Hi Ed, thanks for your response,

1. here the tests hang:  

2. jps monitoring:  

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

**Output #1:**

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

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

---

<div class="post-metadata">

**Author:** ![tchizhov.m](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/tchizhov.m/32/284_2.png) [@tchizhov.m](https://forum.ripe.net/u/tchizhov.m)\
**Post date:** [20 June 2023 12:03 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/4 "2023-06-20T12:03:03Z")

</div>

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

 ![whois.init start](https://europe1.discourse-cdn.com/flex013/uploads/ripe/original/1X/be89aeaa72448aa3df7a33a076f0226968deef44.png)

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?

---

<div class="post-metadata">

**Author:** ![eshryane](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/eshryane/32/34_2.png) [@eshryane](https://forum.ripe.net/u/eshryane)\
**Post date:** [20 June 2023 13:27 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/5 "2023-06-20T13:27:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tchizhov.m](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/tchizhov.m/32/284_2.png) [@tchizhov.m](https://forum.ripe.net/u/tchizhov.m)\
**Post date:** [20 June 2023 13:49 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/6 "2023-06-20T13:49:19Z")

</div>

Thank you very much!

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

---

<div class="post-metadata">

**Author:** ![eshryane](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/eshryane/32/34_2.png) [@eshryane](https://forum.ripe.net/u/eshryane)\
**Post date:** [20 June 2023 14:18 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/7 "2023-06-20T14:18:23Z")

</div>

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

Regards  
Ed Shryane  
RIPE NCC

---

<div class="post-metadata">

**Author:** ![tchizhov.m](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.ripe.net/tchizhov.m/32/284_2.png) [@tchizhov.m](https://forum.ripe.net/u/tchizhov.m)\
**Post date:** [20 June 2023 14:45 UTC](https://forum.ripe.net/t/whois-server-project-mvn-clean-install-pintegration/534/8 "2023-06-20T14:45:58Z")

</div>

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!