duckdb-cli conda package broken for osx with MD aaddon

[geoHeil]

What happens?

The plain duckdb build from the website works fine:
however, when using the one from conda:

https://prefix.dev/channels/conda-forge/packages/duckdb-cli in version 1.4.4 things fail for me:

D load motherduck;
Invalid Input Error:
Initialization function "motherduck_duckdb_cpp_init" from file "~/.duckdb/extensions/v1.4.4/osx_arm64/motherduck.duckdb_extension" threw an exception: "__next_prime overflow"
D

To Reproduce

The plain duckdb build from the website works fine:

 .duckdb/cli/1.4.4/duckdb
DuckDB v1.4.4 (Andium) 6ddac802ff
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D INSTALL motherduck;
D load motherduck;

however, when using the one from conda:

https://prefix.dev/channels/conda-forge/packages/duckdb-cli in version 1.4.4 things fail for me:

rm -r ~/.duckdb
❯ pixi run -e duckdb-shell --frozen duckdb
DuckDB v1.4.4 (Andium) 68d7555
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D INSTALL motherduck;
D load motherduck;
Invalid Input Error:
Initialization function "motherduck_duckdb_cpp_init" from file "~/.duckdb/extensions/v1.4.4/osx_arm64/motherduck.duckdb_extension" threw an exception: "__next_prime overflow"
D

given a pixi snippet of:

duckdb-shell = { features = [
  "duckdb-shell",
], solve-group = "duckdb-shell", no-default-feature = true }

[tool.pixi.feature.duckdb-shell.dependencies]
duckdb-cli = "~=1.4.4"

OS:

OSX

DuckDB Version:

1.4.4

DuckDB Client:

cli

Hardware:

M2 apple silicion

Full Name:

Georg Heiler

Affiliation:

Complexity Science Hub

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• Yes, I have

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant data sets for reproducing the issue?

No - Other reason (please specify in the issue body)

[szarnyasg]

👋 @geoHeil! Thanks reporting this. I moved this to duckdb-python. We'll take a look!

[evertlammerts]

This is a commit hash mismatch. From your output:

# the website distro
DuckDB v1.4.4 (Andium) 6ddac802ff
# vs the conda distro
DuckDB v1.4.4 (Andium) 68d7555

I'm not sure how Conda builds DuckDB, but the extensions are built against a specific DuckDB commit so I expect that this is what's happening here.

Note that this is not the duckdb-cli package that we maintain - in beta - on pypi.

You'll have to open an issue with Conda, @geoHeil .