Problem with postgresql with nuxeo lts 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2025 02:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-02-2025 05:33 AM
Hello, are you a customer or are you using a custom Nuxeo build?
