Error during migration

[dantodor]

I'm getting this:

mix ecto.migrate

21:33:52.458 [info] == Running 20250210142816 Orfeuz.Repo.Migrations.AddPhoenixAnalytics.up/0 forward
Failed to apply migration: Catalog Error: Scalar Function with name "get_current_timestamp" is not in the catalog, but it exists in the core_functions extension.

Please try installing and loading the core_functions extension by running:
INSTALL core_functions;
LOAD core_functions;

Alternatively, consider enabling auto-install and auto-load by running:
SET autoinstall_known_extensions=1;
SET autoload_known_extensions=1;

What am I doing wrong? How can I manually add the recommended functions to the migration?

[Terbium-135]

I am seeing the same error while running in production and had to remove phoenix-analytics for now.

I guess it has something to do with a duckdbex update from a day ago but have to investigate further

https://github.com/AlexR2D2/duckdbex

[Terbium-135]

AlexR2D2/duckdbex#39

[dantodor]

For the record, it comes indeed from the latest duckdbex version. The solution that worked for me was to pin the version to the previous one, 0.3.7
hth

[lalabuy948]

thank you for spotting this! I up for now added exact version to mix. Later on will update properly with newer changes from duckbex.

[Terbium-135]

Good idea to pin version and thx a lot for all your work!
Really appreciate it