Quarkus build fails because it can't connect to the DB

[David Hoffer]

Using 1.13.7.Final

We get an error with one application when we build on the CI server.  The reason is the CI server does not have the postgres-db DB IP defined in its host file.  Why is the build trying to connect to the DB?  Our other builds don't do this. 

We are using the standard quarkus-maven-plugin in our build with goals configured as:

<goals>
<goal>build</goal>
</goals>

Jul 02, 2021 2:44:35 PM org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator initiateService

WARN: HHH000342: Could not obtain connection to query metadata

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:315)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)

at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223)

at org.postgresql.Driver.makeConnection(Driver.java:465)

at org.postgresql.Driver.connect(Driver.java:264)

at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:204)

at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:490)

at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:472)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:68)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1126)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: java.net.UnknownHostException: postgres-db

at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:220)

at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)

at java.base/java.net.Socket.connect(Socket.java:609)

at org.postgresql.core.PGStream.createSocket(PGStream.java:231)

at org.postgresql.core.PGStream.<init>(PGStream.java:95)

at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:98)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213)

... 12 more

Jul 02, 2021 2:44:37 PM io.quarkus.agroal.runtime.AgroalEventLoggingListener onWarning

WARN: Datasource 'sdlDS': The connection attempt failed.

Jul 02, 2021 2:44:37 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

WARN: SQL Error: 0, SQLState: 08001

Jul 02, 2021 2:44:37 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: The connection attempt failed.

Jul 02, 2021 2:44:37 PM org.hibernate.resource.beans.container.spi.AbstractCdiBeanContainer stop

INFO: HHH10005004: Stopping BeanContainer : io.quarkus.hibernate.orm.runtime.cdi.QuarkusArcBeanContainer@5e04a824

Jul 02, 2021 2:44:37 PM io.quarkus.runtime.ApplicationLifecycleManager run

ERROR: Failed to start application (with profile prod)

java.net.UnknownHostException: postgres-db

at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:220)

at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)

at java.base/java.net.Socket.connect(Socket.java:609)

at org.postgresql.core.PGStream.createSocket(PGStream.java:231)

at org.postgresql.core.PGStream.<init>(PGStream.java:95)

at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:98)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)

at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223)

at org.postgresql.Driver.makeConnection(Driver.java:465)

at org.postgresql.Driver.connect(Driver.java:264)

at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:204)

at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:490)

at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:472)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:68)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1126)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.base/java.lang.Thread.run(Thread.java:834)

[Stuart Douglas]

Can you provide more output? This looks like it is starting the app.

Stuart

--
You received this message because you are subscribed to the Google Groups "Quarkus Development mailing list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to quarkus-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/quarkus-dev/f1a118fb-0e7b-4407-b5a4-6dd44af7a0ean%40googlegroups.com.

[David Hoffer]

Upon further research it was the NiFi nar build step that was causing the problem.  That plugin instantiates the service class(s) as part of its docs generation step.  I had wired the Quarkus integration in that same service class.  Simple fix was to ignore Quarkus startup if it can't resolve the DB host as it means its not in a mode that needs Quarkus.

-Dave