Postgres error maybe related to postgres 17?

General
1

Hi there,

We tried to install Orthanc with a Postgres 17 server,

We have this error :

E0108 10:03:47.062828 DB HOUSEKEEPING postgresql-index:/BaseIndexConnectionsPool.cpp:54] Exception during the database housekeeping: Error with the database engine E0108 10:03:47.844622 SAVE-JOBS postgresql-index:/PostgreSQLStatement.cpp:194] PostgreSQL error: ERROR: relation “serverproperties” does not exist LINE 1: DELETE FROM ServerProperties WHERE server=$1 AND property=$2 ^ E0108 10:03:47.854194 SAVE-JOBS postgresql-index:/DatabaseBackendAdapterV4.cpp:1522] Exception in database back-end: Error with the database engine E0108 10:03:47.854245 SAVE-JOBS postgresql-index:/DatabaseBackendAdapterV4.cpp:1522] Exception in database back-end: Bad sequence of calls E0108 10:03:47.854299 SAVE-JOBS ServerContext.cpp:341] Cannot serialize the jobs engine: Error with the database engine E0108 10:03:48.069493 DB HOUSEKEEPING postgresql-index:/PostgreSQLStatement.cpp:194] PostgreSQL error: ERROR: function updatestatistics() does not exist LINE 1: SELECT * FROM UpdateStatistics() ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Can it be something related to a breaking change in postgres 17 that need an update in Orthanc ? (also can be an error in our side, still investigating).

For notice I have another server running on postgres 16 for 1y, no issue on postgres 16

2

Just hint my mind, we noticed that permission on postgres have changed compared to older version, we might not give enough permission to orthanc to setup its schemas, we are going to investigate but might be a false positive

3

It was a permission issue, new version postgres users of a database needs additional permission to modify the database public schemas.

Sorry for inconveniance