Hi,
When starting a new instance of syncope 4.1.0-M0 based on the Maven
archetype docker. I found those errors on the CORE container.
Something wrong with the PostGreSQL schema ?
2026-03-30 03:26:48.704 INFO [ main]
org.apache.syncope.core.provisioning.api.ConnectorManager : Done
loading 0 connectors
2026-03-30 03:26:59.562 INFO [ main]
rg.apache.syncope.core.persistence.api.content.ContentLoader :
[Master] Empty database found, loading default content
2026-03-30 03:27:00.807 WARN [ main]
core.persistence.common.content.AbstractContentLoaderHandler : No
column type found for USEROWNER_ID
2026-03-30 03:27:00.861 WARN [ main]
core.persistence.common.content.AbstractContentLoaderHandler : No
column type found for USEROWNER_ID
2026-03-30 03:27:00.865 ERROR [ main]
core.persistence.common.content.AbstractContentLoaderHandler : While
trying to perform INSERT INTO
SyncopeGroup(id,name,userOwner_id,realm_id,creator,lastModifier,creationDate,lastChangeDate,plainAttrs)
VALUES (?,?,?,?,?,?,?,?,?) with params
[ebf97068-aa4b-4a85-9f01-680e8c4cf227, director,
823074dc-d280-436d-a7dd-07399fae48ec,
e4c28e7a-9dbf-4ee7-9441-93812a0d4a28, admin, admin, 2010-10-20T11:00Z,
2010-10-20T11:00Z,
[{"values":[{"stringValue":"icon6"}],"schema":"icon"}]]
org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [INSERT INTO
SyncopeGroup(id,name,userOwner_id,realm_id,creator,lastModifier,creationDate,lastChangeDate,plainAttrs)
VALUES (?,?,?,?,?,?,?,?,?)]
at ... [truncated by me...]
Caused by: org.postgresql.util.PSQLException: ERROR: column
"userowner_id" of relation "syncopegroup" does not exist
Position: 34
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875)
at... [truncated by me...]... 50 more
2026-03-30 03:27:00.902 ERROR [ main]
rg.apache.syncope.core.persistence.api.content.ContentLoader :
[Master] While loading default content
org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
bad SQL grammar [SELECT * FROM TypeExtension WHERE 0=1]
at... [truncated by me...]
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"typeextension" does not exist
Position: 15
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875)
at... [truncated by me...]... 49 more
Best regards,
Stéphane POPOFF
