Problem with postgresql with nuxeo lts 2023

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

lzuzanak

Hi, we have a problem using postgresql on nuxeo lts 2023 docker image. On h2 db it works, but as soon as we configure postgre connection in configuration we get error

SQL type mismatch for "task"."id": expected VARCHAR, database has INTEGER / int4(10)
Component service:org.nuxeo.ecm.core.repository.RepositoryServiceComponent notification of application started failed: java.sql.SQLException: Error executing: ALTER TABLE "task" ADD COLUMN "accepted" bool : ERROR: relation "task" does not exist  

It looks as if no migration was performed, this table does not exist in the DB

ttoine

Hello, are you a customer or are you using a custom Nuxeo build?