cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with postgresql with nuxeo lts 2023

lzuzanak
Champ in-the-making
Champ in-the-making

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

1 REPLY 1

ttoine
Community Manager Community Manager
Community Manager

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

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.