Guest User

Untitled

a guest
Oct 29th, 2018
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.74 KB | None | 0 0
  1. <datasource jndi-name="java:/PostgresDS" pool-name="PostgresDS">
  2. <connection-url>jdbc:postgresql://10.130.31.43:5432/postgresdb</connection-url>
  3. <driver-class>org.postgresql.Driver</driver-class>
  4. <datasource-class>org.postgresql.ds.PGSimpleDataSource</datasource-class>
  5. <driver>postgresql-42.2.5.jar</driver>
  6. <security>
  7. <user-name>admin</user-name>
  8. <password>admin</password>
  9. </security>
  10. <validation>
  11. <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
  12. <background-validation>true</background-validation>
  13. <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
  14. </validation>
  15. </datasource>
  16.  
  17. 2018-10-30 11:28:46,392 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (External Management Request Threads -- 1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
  18. at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
  19. at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
  20. at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
  21. at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)
  22. at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
  23. at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:1067)
  24. at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:93)
  25. at org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:240)
  26. at org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:97)
  27. at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:999)
  28. at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:743)
  29. at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:467)
  30. at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1411)
  31. at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:423)
  32. at org.jboss.as.controller.ModelControllerImpl.lambda$execute$1(ModelControllerImpl.java:243)
  33. at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:265)
  34. at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:231)
  35. at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:243)
  36. at org.jboss.as.domain.http.server.DomainApiHandler.handleRequest(DomainApiHandler.java:212)
  37. at io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72)
  38. at org.jboss.as.domain.http.server.DomainApiCheckHandler.handleRequest(DomainApiCheckHandler.java:93)
  39. at org.jboss.as.domain.http.server.security.ElytronIdentityHandler.lambda$handleRequest$0(ElytronIdentityHandler.java:62)
  40. at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:289)
  41. at org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:246)
  42. at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:254)
  43. at org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:225)
  44. at org.jboss.as.domain.http.server.security.ElytronIdentityHandler.handleRequest(ElytronIdentityHandler.java:61)
  45. at io.undertow.server.handlers.BlockingHandler.handleRequest(BlockingHandler.java:56)
  46. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:360)
  47. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
  48. at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
  49. at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
  50. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
  51. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
  52. at java.lang.Thread.run(Thread.java:748)
  53. at org.jboss.threads.JBossThread.run(JBossThread.java:485)
  54. Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  55. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:280)
  56. at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
  57. at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
  58. at org.postgresql.Driver.makeConnection(Driver.java:454)
  59. at org.postgresql.Driver.connect(Driver.java:256)
  60. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  61. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  62. at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
  63. at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:314)
  64. ... 35 more
  65. Caused by: java.net.ConnectException: Connection refused (Connection refused)
  66. at java.net.PlainSocketImpl.socketConnect(Native Method)
  67. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  68. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  69. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  70. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  71. at java.net.Socket.connect(Socket.java:589)
  72. at org.postgresql.core.PGStream.<init>(PGStream.java:70)
  73. at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91)
  74. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
  75. ... 43 more
  76.  
  77. 2018-10-30 11:28:46,393 ERROR [org.jboss.as.controller.management-operation] (External Management Request Threads -- 1) WFLYCTL0013: Operation ("test-connection-in-pool") failed - address: ([
  78. ("subsystem" => "datasources"),
  79. ("data-source" => "PostgresDS")
  80. ]) - failure description: "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid"
Add Comment
Please, Sign In to add comment