Hi,
This column was dropped in favor of a new table holding multiple uris for a
resource. It seems you are still using old entity format (see
ResourceEntity) which does not have a "uri" field anymore. Although your
database looks correct.
Regards.
Pedro Igor
On Tue, Aug 21, 2018 at 4:40 PM, Gary Schulte <gary.schulte(a)opengov.com>
wrote:
We recently upgraded from 4.1.0.Final to 4.3.0.Final, and have been
getting
this exception in various operations:
... 102 more
Caused by: org.postgresql.util.PSQLException: ERROR: column
resourceen0_.uri does not exist
Position: 336
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:2433)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:2178)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(
PgPreparedStatement.java:155)
at
org.postgresql.jdbc.PgPreparedStatement.executeQuery(
PgPreparedStatement.java:118)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(
WrappedPreparedStatement.java:504)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
extract(ResultSetReturnImpl.java:70)
... 120 more
I first encountered this trying to export the configuration
via `keycloak.migration.action=export` , but am now encountering it in a
number of operations such as impersonating a user from the admin console.
We aborted an upgrade to 4.2.1 due to a failed db migration, but 4.3.0
worked fine. Presumably there is a problem with the ddl migration.
Any speculation on root cause and/or a fix? Is there a DDL published
FYI we have keycloak deployed to k8s using an Amazon RDS postgres instance
for the backing store.
TIA
Gary S
_______________________________________________
keycloak-dev mailing list
keycloak-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-dev