[keycloak-user] IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK during Custom User Federation

[Marek Posolda]

We have an example for JPA user Provider and also quickstart. I suggest 
to take a look at quickstart or example and compare why it works and 
yours doesn't .

Marek

Dne 5.4.2018 v 18:18 Sachin Rastogi napsal(a):
> Hi all,
>
> We are using Keycloak 3.4.3 and loading users via Custom User Federation
> from the database. We are using Postgres 9.4.12
>
> When we are loading users from the database during
> CustomUserStorageProviderFactory.create(..),
> we are getting the following exception:-
>
> It is throwing the following exception during con.createStatement();
>
> 13:46:43,385 ERROR [stderr] (default task-8) java.sql.SQLException:
> IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK
> 13:46:43,385 ERROR [stderr] (default task-8)    at
> org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:245)
> 13:46:43,386 ERROR [stderr] (default task-8)    at
> org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1928)
> 13:46:43,386 ERROR [stderr] (default task-8)    at
> org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1943)
> 13:46:43,386 ERROR [stderr] (default task-8)    at
> org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1917)
> 13:46:43,387 ERROR [stderr] (default task-8)    at
> org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:340)
> 13:46:43,387 ERROR [stderr] (default task-8)    at
> com.test.service.UserServiceImpl.loadExistingUsers(UserServiceImpl.java:98)
> 13:46:43,387 ERROR [stderr] (default task-8)    at com.test.Custom
> UserStorageProviderFactory.create(CustomUserStorageProviderFactory.java:43)
>
> But if we call loadExistingUsers in init method of
> CustomUserStorageProviderFactory,
> it works fine. Please advise, what are we doing wrong? what is the ideal
> way of loading existing users in Custom User Federation?
>
> Regards,
> SR
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user