Keycloak 13.0.1 with PostgreSQL 42.2.22 driver error

Configuring the server
1

Hi all,
I’m getting an error starting Keycloak 13.0.1. I originally tried to upgrade from 12.0.1 but that failed dramatically so I effectively have a new installation, except for the database. I have a local PostgreSQL 12.7 database and the 42.2.22 JDBC driver. During startup I get:

2021-06-16 15:02:29,783 ERROR [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (default task-1) IJ000316: Handle allocation: org.jboss.jca.adapters.jdbc.jdk8.WrappedConnectionJDK8@8acc3b8: java.lang.Exception
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.listener.AbstractConnectionListener.registerConnection(AbstractConnectionListener.java:315)
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.registerAssociation(AbstractConnectionManager.java:1135)
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:815)
        at org.jboss.ironjacamar.jdbcadapters@1.4.27.Final//org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151)
        at org.jboss.as.connector@23.0.2.Final//org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
        at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)

and:

2021-06-16 15:02:29,785 ERROR [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (default task-1) IJ000317: Transaction boundary: java.lang.Exception
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.afterCompletion(TxConnectionListener.java:1173)
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.transaction.TransactionSynchronizer.invokeAfter(TransactionSynchronizer.java:456)
        at org.jboss.ironjacamar.impl@1.4.27.Final//org.jboss.jca.core.connectionmanager.transaction.TransactionSynchronizer.afterCompletion(TransactionSynchronizer.java:392)
        at org.jboss.as.transactions@23.0.2.Final//org.jboss.as.txn.service.internal.tsr.JCAOrderedLastSynchronizationList.afterCompletion(JCAOrderedLastSynchronizationList.java:160)
        at org.wildfly.transaction.client@1.1.13.Final//org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:223)
        at org.wildfly.transaction.client@1.1.13.Final//org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.afterCompletion(AbstractTransaction.java:306)
        at org.jboss.jts//com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:96)

The server does come up but this error occurs frequently making me think I’m on borrowed time. I didn’t find anything super similar. My datasource looks like:

<datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" tracking="true">
    <connection-url>jdbc:postgresql://localhost:5432/keycloak</connection-url>
    <driver>postgres</driver>
    <new-connection-sql>select now();</new-connection-sql>
    <pool>
        <min-pool-size>4</min-pool-size>
        <initial-pool-size>4</initial-pool-size>
        <max-pool-size>64</max-pool-size>
        <flush-strategy>Gracefully</flush-strategy>
    </pool>
    <security>
        <user-name>user</user-name>
        <password>password</password>
    </security>
</datasource>

and the driver is simply:

<driver name="postgres" module="org.postgres">
    <driver-class>org.postgresql.Driver</driver-class>
</driver>

again, I can access the server and it seems to work but I’m concerned about what isn’t working or what will break in the future. Thanks for any help.