[bitnami/mlflow] WARNING: database "bitnami_mlflow" has a collation version mismatch

[bhack]

Name and Version

bitnami/mlflow 1.5.7

What architecture are you using?

amd64

What steps will reproduce the bug?

Upgrade to mlflow-1.5.7 app version 2.16.2

What is the expected behavior?

Just working as with other upgrades

What do you see instead?

WARNING:  database "bitnami_mlflow" has a collation version mismatch
DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE bitnami_mlflow REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

[javsalgar]

Hi!

Is this only a warning or this is causing the installation to fail?

[bhack]

The installation doesn't fail but it seems slower and the postgres pod/container is fully spamming these messages.

[bhack]

See also:
https://www.postgresql.org/docs/current/sql-altercollation.html#SQL-ALTERCOLLATION-NOTES

[javsalgar]

From which version of the chart are you updating?

[bhack]

From the previous one.

[javsalgar]

You mean from chart version mlflow-1.5.6 to mlflow-1.5.7?

[bhack]

Yes but I followed all the updates over the time so I cannot be 100% sure that it was exactly introduced in 1.5.6/1.5.7 update as I was not checking the postgres log on each upgrade.

[javsalgar]

Did you change any default values in the postgresql subchart?

[bhack]

No, It is vanilla.

[dgomezleon]

Hi @bhack ,

It seems that the warning could be fixed by executing:

REINDEX DATABASE bitnami_mlflow;
ALTER DATABASE bitnami_mlflow REFRESH COLLATION VERSION;

I'm going to create an internal task to implement this logic for upgrades.