INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) WFLYJCA0001: Bound data source [java:/PostgresXADS] 13:22:01,191 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (External Management Request Threads -- 4) IJ000604: Throwable while attempting to get a new connection: null: jakarta.resource.ResourceException: IJ031084: Unable to create connection at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:532) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:439) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1328) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:505) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:1127) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:94) at org.jboss.as.connector@8.0.8.GA-redhat-00001//org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:254) at org.jboss.as.connector@8.0.8.GA-redhat-00001//org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:99) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:1057) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:778) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:469) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1433) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:448) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.ModelControllerImpl.lambda$executeForResponse$0(ModelControllerImpl.java:259) at org.wildfly.security.elytron-base@2.2.7.Final-redhat-00001//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:304) at org.wildfly.security.elytron-base@2.2.7.Final-redhat-00001//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:270) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.ModelControllerImpl.executeForResponse(ModelControllerImpl.java:259) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.ModelControllerImpl.executeOperation(ModelControllerImpl.java:253) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:236) at org.jboss.as.domain-http-interface@21.0.14.Final-redhat-00001//org.jboss.as.domain.http.server.DomainApiHandler.handleRequest(DomainApiHandler.java:213) at io.undertow.core@2.3.18.SP1-redhat-00001//io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72) at org.jboss.as.domain-http-interface@21.0.14.Final-redhat-00001//org.jboss.as.domain.http.server.DomainApiCheckHandler.handleRequest(DomainApiCheckHandler.java:91) at org.jboss.as.domain-http-interface@21.0.14.Final-redhat-00001//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.lambda$handleRequest$0(ElytronIdentityHandler.java:62) at org.wildfly.security.elytron-base@2.2.7.Final-redhat-00001//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:328) at org.wildfly.security.elytron-base@2.2.7.Final-redhat-00001//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:285) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:254) at org.jboss.as.controller@21.0.14.Final-redhat-00001//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:225) at org.jboss.as.domain-http-interface@21.0.14.Final-redhat-00001//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.handleRequest(ElytronIdentityHandler.java:61) at io.undertow.core@2.3.18.SP1-redhat-00001//io.undertow.server.handlers.BlockingHandler.handleRequest(BlockingHandler.java:56) at io.undertow.core@2.3.18.SP1-redhat-00001//io.undertow.server.Connectors.executeRootHandler(Connectors.java:395) at io.undertow.core@2.3.18.SP1-redhat-00001//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:896) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at java.base/java.lang.Thread.run(Thread.java:829) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513) Caused by: org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:352) at org.postgresql@42.7.4//org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql@42.7.4//org.postgresql.jdbc.PgConnection.(PgConnection.java:273) at org.postgresql@42.7.4//org.postgresql.Driver.makeConnection(Driver.java:446) at org.postgresql@42.7.4//org.postgresql.Driver.connect(Driver.java:298) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.postgresql@42.7.4//org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:104) at org.postgresql@42.7.4//org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:52) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:516) ... 36 more Caused by: java.net.ConnectException: Spojení odmítnuto (Connection refused) at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255) at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.base/java.net.Socket.connect(Socket.java:609) at org.postgresql@42.7.4//org.postgresql.core.PGStream.createSocket(PGStream.java:260) at org.postgresql@42.7.4//org.postgresql.core.PGStream.(PGStream.java:121) at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:140) at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268) ... 45 more 13:22:01,192 ERROR [org.jboss.as.controller.management-operation] (External Management Request Threads -- 4) WFLYCTL0013: Operation ("test-connection-in-pool") failed - address: ([ ("subsystem" => "datasources"), ("xa-data-source" => "PostgresXADS") ]) - failure description: "WFLYJCA0040: failed to invoke operation: java.lang.IllegalStateException: WFLYJCA0047: Connection is not valid Caused by: jakarta.resource.ResourceException: jakarta.resource.ResourceException: IJ031084: Unable to create connection Caused by: jakarta.resource.ResourceException: IJ031084: Unable to create connection Caused by: org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Caused by: java.net.ConnectException: Spojení odmítnuto (Connection refused)" 13:23:41,010 ERROR [org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl] (Periodic Recovery) IJ000906: Error during crash recovery: java:/PostgresXADS (IJ031084: Unable to create connection): jakarta.resource.ResourceException: IJ031084: Unable to create connection at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:532) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:418) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:415) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/javax.security.auth.Subject.doAs(Subject.java:423) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:414) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:411) at java.base/java.security.AccessController.doPrivileged(Native Method) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:410) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.open(XAResourceRecoveryImpl.java:355) at org.jboss.ironjacamar.impl@3.0.8.Final-redhat-00001//org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.getXAResources(XAResourceRecoveryImpl.java:193) at org.jboss.jts.integration@6.0.4.Final-redhat-00001//com.arjuna.ats.internal.jbossatx.jta.XAResourceRecoveryHelperWrapper.getXAResources(XAResourceRecoveryHelperWrapper.java:51) at org.jboss.jts//com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:698) at org.jboss.jts//com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:244) at org.jboss.jts//com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:191) at org.jboss.jts//com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:770) at org.jboss.jts//com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:382) Caused by: org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:352) at org.postgresql@42.7.4//org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql@42.7.4//org.postgresql.jdbc.PgConnection.(PgConnection.java:273) at org.postgresql@42.7.4//org.postgresql.Driver.makeConnection(Driver.java:446) at org.postgresql@42.7.4//org.postgresql.Driver.connect(Driver.java:298) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.postgresql@42.7.4//org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:104) at org.postgresql@42.7.4//org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:52) at org.jboss.ironjacamar.jdbcadapters@3.0.8.Final-redhat-00001//org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:516) ... 16 more Caused by: java.net.ConnectException: Spojení odmítnuto (Connection refused) at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255) at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.base/java.net.Socket.connect(Socket.java:609) at org.postgresql@42.7.4//org.postgresql.core.PGStream.createSocket(PGStream.java:260) at org.postgresql@42.7.4//org.postgresql.core.PGStream.(PGStream.java:121) at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:140) at org.postgresql@42.7.4//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268) ... 25 more