Cannot install python pre version

[darthf1]

Hi!

Because I need a fix made after the release of 0.3.0, I had my version constraint set to duckdb>=0.3.1.dev285. This worked great for me, until today. Today I get:

ERROR: Could not find a version that satisfies the requirement duckdb>=0.3.1.dev285 (from python) (from versions: 0.0.2, 0.0.3, 0.1.0, 0.1.1, 0.1.2, 0.1.3, 0.1.5, 0.1.6, 0.1.7, 0.1.8, 0.1.9, 0.2.0, 0.2.1, 0.2.2, 0.2.3, 0.2
.4, 0.2.5, 0.2.6, 0.2.7, 0.2.8, 0.2.9, 0.3.0)
ERROR: No matching distribution found for duckdb>=0.3.1.dev285

According to https://pypi.org/project/duckdb/#history, 0.3.1.dev501 should be available. Trying with that version I get the same error.

Has something changed?

---

When I run pip install duckdb --pre --upgrade it installs 0.3.0:

Collecting duckdb
  Downloading duckdb-0.3.0-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (11.3 MB)
     |████████████████████████████████| 11.3 MB 4.1 MB/s
Requirement already satisfied: numpy>=1.14 in /opt/venv/lib/python3.9/site-packages (from duckdb) (1.21.3)
Installing collected packages: duckdb
Successfully installed duckdb-0.3.0

---

$ pip3 show duckdb
WARNING: Package(s) not found: duckdb

$ pip3 install duckdb>=0.3.1.dev501 --pre

$ pip3 show duckdb
Name: duckdb
Version: 0.3.0
Summary: DuckDB embedded database
Home-page: https://www.duckdb.org
Author:
Author-email:
License: MIT
Location: /opt/venv/lib/python3.9/site-packages
Requires: numpy
Required-by: python

---

$ pip3 show duckdb
WARNING: Package(s) not found: duckdb

$ pip3 install --upgrade duckdb --pre
Collecting duckdb
  Using cached duckdb-0.3.0-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (11.3 MB)
Requirement already satisfied: numpy>=1.14 in /opt/venv/lib/python3.9/site-packages (from duckdb) (1.21.3)
Installing collected packages: duckdb
Successfully installed duckdb-0.3.0

$ pip3 show duckdb
Name: duckdb
Version: 0.3.0
Summary: DuckDB embedded database
Home-page: https://www.duckdb.org
Author:
Author-email:
License: MIT
Location: /opt/venv/lib/python3.9/site-packages
Requires: numpy
Required-by: python

---

$ pip3 install duckdb==0.3.1.dev501 --pre
ERROR: Could not find a version that satisfies the requirement duckdb==0.3.1.dev501 (from versions: 0.0.2, 0.0.3, 0.1.0, 0.1.1, 0.1.2, 0.1.3, 0.1.5, 0.1.6, 0.1.7, 0.1.8, 0.1.9, 0.2.0, 0.2.1, 0.2.2, 0.2.3, 0.2.4, 0.2.5, 0.2.6, 0.2.7,
 0.2.8, 0.2.9, 0.3.0)
ERROR: No matching distribution found for duckdb==0.3.1.dev501

[Mytherin]

Unfortunately we periodically need to delete older dev versions because of size constraints from pypi. As you mentioned though, the latest dev version should still be there.

[darthf1]

Yeah I tried that, see my initial post.

$ pip3 show duckdb
WARNING: Package(s) not found: duckdb

$ pip3 install --upgrade duckdb --pre
Collecting duckdb
  Using cached duckdb-0.3.0-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (11.3 MB)
Requirement already satisfied: numpy>=1.14 in /opt/venv/lib/python3.9/site-packages (from duckdb) (1.21.3)
Installing collected packages: duckdb
Successfully installed duckdb-0.3.0

$ pip3 show duckdb
Name: duckdb
Version: 0.3.0
Summary: DuckDB embedded database
Home-page: https://www.duckdb.org
Author:
Author-email:
License: MIT
Location: /opt/venv/lib/python3.9/site-packages
Requires: numpy
Required-by: python

[Mytherin]

Ah, I think this is related to the Python builds failing on Linux for the past few days. The Linux packages are likely missing. This is related to #2499.

[darthf1]

Ah ok. Is it possible to build from source in the meantime? Or would I hit the same issues as the CI has?

[lnkuiper]

Building from source should work

[darthf1]

Building from source works! :)

$ pip show duckdb
Name: duckdb
Version: 0.3.1.dev504+g765944adf
Summary: DuckDB embedded database
Home-page: https://www.duckdb.org
Author:
Author-email:
License: MIT
Location: /opt/venv/lib/python3.9/site-packages
Requires: numpy
Required-by:

[darthf1]

Solved by #2539