Installing Ape Framework with Recommended Plugins Tries to Install Many Versions of SQLAlchemy [APE-1221]

[arjunaskykok]

Environment information

• OS: linux
• Python Version: 3.10

What went wrong?

I tried to install ape framework on my Ubuntu Linux:

$ python3 -m venv .venv
$ source .venv/bin/activate
(.venv) $ pip install eth-ape'[recommended-plugins]'

But the installation process tried to install many versions of SQLAlchemy!

The full log is here:

Collecting eth-ape[recommended-plugins]
  Using cached eth_ape-0.6.13-py3-none-any.whl (269 kB)
Collecting python-dateutil<3,>=2.8.2
  Using cached python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
Collecting ethpm-types<0.6,>=0.5.3
  Using cached ethpm_types-0.5.3-py3-none-any.whl (29 kB)
Collecting PyYAML<7,>=5.0
  Downloading PyYAML-6.0.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (705 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 705.5/705.5 kB 153.1 kB/s eta 0:00:00
Collecting lazyasd>=0.1.4
  Using cached lazyasd-0.1.4.tar.gz (8.4 kB)
  Preparing metadata (setup.py) ... done
Collecting evm-trace>=0.1.0a21
  Downloading evm_trace-0.1.0a22-py3-none-any.whl (19 kB)
Collecting click<8.1.4,>=8.1.3
  Using cached click-8.1.3-py3-none-any.whl (96 kB)
Collecting packaging<24,>=23.0
  Using cached packaging-23.1-py3-none-any.whl (48 kB)
Collecting hexbytes<1,>=0.2.3
  Using cached hexbytes-0.3.1-py3-none-any.whl (5.9 kB)
Collecting pytest<8.0,>=6.0
  Using cached pytest-7.4.0-py3-none-any.whl (323 kB)
Collecting eth-utils<3,>=2.0.0
  Using cached eth_utils-2.2.0-py3-none-any.whl (23 kB)
Collecting ijson<4,>=3.1.4
  Downloading ijson-3.2.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (111 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 111.8/111.8 kB 68.3 kB/s eta 0:00:00
Collecting pluggy<2,>=0.12
  Using cached pluggy-1.2.0-py3-none-any.whl (17 kB)
Collecting py-geth<4,>=3.13.0
  Using cached py_geth-3.13.0-py3-none-any.whl (24 kB)
Collecting pydantic<2,>=1.10.8
  Using cached pydantic-1.10.11-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.1 MB)
Collecting PyGithub<2,>=1.54
  Using cached PyGithub-1.59.0-py3-none-any.whl (342 kB)
Collecting traitlets>=5.3.0
  Using cached traitlets-5.9.0-py3-none-any.whl (117 kB)
Collecting eth-account<0.9,>=0.8
  Using cached eth_account-0.8.0-py3-none-any.whl (102 kB)
Collecting ipython<9,>=8.5.0
  Using cached ipython-8.14.0-py3-none-any.whl (798 kB)
Collecting pandas<2,>=1.3.0
  Using cached pandas-1.5.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.1 MB)
Collecting eip712<0.3,>=0.2.1
  Using cached eip712-0.2.1-py3-none-any.whl (9.9 kB)
Collecting eth-typing<4,>=3.1
  Using cached eth_typing-3.4.0-py3-none-any.whl (6.0 kB)
Collecting eth-abi<5,>=4.0.0
  Using cached eth_abi-4.1.0-py3-none-any.whl (27 kB)
Collecting requests<3,>=2.28.1
  Using cached requests-2.31.0-py3-none-any.whl (62 kB)
Collecting SQLAlchemy>=1.4.35
  Downloading SQLAlchemy-2.0.19-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 77.5 kB/s eta 0:00:00
Collecting tqdm<5.0,>=4.62.3
  Using cached tqdm-4.65.0-py3-none-any.whl (77 kB)
Collecting web3[tester]<7,>=6.5.0
  Downloading web3-6.6.1-py3-none-any.whl (1.6 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.6/1.6 MB 87.6 kB/s eta 0:00:00
Collecting rich<13,>=12.5.1
  Using cached rich-12.6.0-py3-none-any.whl (237 kB)
Collecting watchdog<3.0,>=2.1.9
  Using cached watchdog-2.3.1-py3-none-manylinux2014_x86_64.whl (80 kB)
Collecting importlib-metadata
  Using cached importlib_metadata-6.8.0-py3-none-any.whl (22 kB)
Collecting ape-etherscan
  Using cached ape_etherscan-0.6.7-py3-none-any.whl (20 kB)
Collecting ape-vyper
  Using cached ape_vyper-0.6.9-py3-none-any.whl (18 kB)
Collecting ape-hardhat
  Downloading ape_hardhat-0.6.12-py3-none-any.whl (18 kB)
Collecting ape-solidity
  Using cached ape_solidity-0.6.7-py3-none-any.whl (21 kB)
Collecting ape-infura
  Using cached ape_infura-0.6.2-py3-none-any.whl (8.8 kB)
Collecting ape-alchemy
  Using cached ape_alchemy-0.6.2-py3-none-any.whl (10 kB)
Collecting ape-foundry
  Downloading ape_foundry-0.6.14-py3-none-any.whl (19 kB)
Collecting ape-tokens
  Downloading ape_tokens-0.6.2-py3-none-any.whl (9.7 kB)
Collecting ape-template
  Using cached ape_template-0.6.1-py3-none-any.whl (7.4 kB)
Collecting ape-ens
  Using cached ape_ens-0.6.1-py3-none-any.whl (8.4 kB)
Collecting eth-hash[pycryptodome]
  Using cached eth_hash-0.5.2-py3-none-any.whl (8.6 kB)
Collecting dataclassy<1,>=0.8.2
  Using cached dataclassy-0.11.1-py3-none-any.whl (23 kB)
Collecting parsimonious<0.10.0,>=0.9.0
  Using cached parsimonious-0.9.0.tar.gz (48 kB)
  Preparing metadata (setup.py) ... done
Collecting eth-rlp<1,>=0.3.0
  Using cached eth_rlp-0.3.0-py3-none-any.whl (5.0 kB)
Collecting bitarray<3,>=2.4.0
  Downloading bitarray-2.8.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (283 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 283.8/283.8 kB 91.5 kB/s eta 0:00:00
Collecting rlp<4,>=1.0.0
  Using cached rlp-3.0.0-py2.py3-none-any.whl (20 kB)
Collecting eth-keys<0.5,>=0.4.0
  Using cached eth_keys-0.4.0-py3-none-any.whl (21 kB)
Collecting eth-keyfile<0.7.0,>=0.6.0
  Using cached eth_keyfile-0.6.1-py3-none-any.whl (6.5 kB)
Collecting cytoolz>=0.10.1
  Downloading cytoolz-0.12.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.9 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.9/1.9 MB 74.5 kB/s eta 0:00:00
Collecting py-cid<0.4,>=0.3.0
  Using cached py_cid-0.3.0-py2.py3-none-any.whl (7.9 kB)
Collecting py-evm<0.8,>=0.7.0a3
  Downloading py_evm-0.7.0a3-py3-none-any.whl (296 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 296.7/296.7 kB 81.1 kB/s eta 0:00:00
Collecting msgspec>=0.8
  Downloading msgspec-0.17.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (197 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 197.3/197.3 kB 98.3 kB/s eta 0:00:00
Collecting decorator
  Using cached decorator-5.1.1-py3-none-any.whl (9.1 kB)
Collecting backcall
  Using cached backcall-0.2.0-py2.py3-none-any.whl (11 kB)
Collecting stack-data
  Using cached stack_data-0.6.2-py3-none-any.whl (24 kB)
Collecting pexpect>4.3
  Using cached pexpect-4.8.0-py2.py3-none-any.whl (59 kB)
Collecting pygments>=2.4.0
  Using cached Pygments-2.15.1-py3-none-any.whl (1.1 MB)
Collecting pickleshare
  Using cached pickleshare-0.7.5-py2.py3-none-any.whl (6.9 kB)
Collecting matplotlib-inline
  Using cached matplotlib_inline-0.1.6-py3-none-any.whl (9.4 kB)
Collecting jedi>=0.16
  Using cached jedi-0.18.2-py2.py3-none-any.whl (1.6 MB)
Collecting prompt-toolkit!=3.0.37,<3.1.0,>=3.0.30
  Using cached prompt_toolkit-3.0.39-py3-none-any.whl (385 kB)
Collecting pytz>=2020.1
  Using cached pytz-2023.3-py2.py3-none-any.whl (502 kB)
Collecting numpy>=1.21.0
  Using cached numpy-1.25.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (17.6 MB)
Collecting semantic-version>=2.6.0
  Using cached semantic_version-2.10.0-py2.py3-none-any.whl (15 kB)
Collecting typing-extensions>=4.2.0
  Using cached typing_extensions-4.7.1-py3-none-any.whl (33 kB)
Collecting pyjwt[crypto]>=2.4.0
  Downloading PyJWT-2.8.0-py3-none-any.whl (22 kB)
Collecting deprecated
  Using cached Deprecated-1.2.14-py2.py3-none-any.whl (9.6 kB)
Collecting pynacl>=1.4.0
  Using cached PyNaCl-1.5.0-cp36-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.manylinux_2_24_x86_64.whl (856 kB)
Collecting exceptiongroup>=1.0.0rc8
  Using cached exceptiongroup-1.1.2-py3-none-any.whl (14 kB)
Collecting iniconfig
  Using cached iniconfig-2.0.0-py3-none-any.whl (5.9 kB)
Collecting tomli>=1.0.0
  Using cached tomli-2.0.1-py3-none-any.whl (12 kB)
Collecting six>=1.5
  Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting certifi>=2017.4.17
  Using cached certifi-2023.5.7-py3-none-any.whl (156 kB)
Collecting charset-normalizer<4,>=2
  Using cached charset_normalizer-3.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (201 kB)
Collecting urllib3<3,>=1.21.1
  Downloading urllib3-2.0.4-py3-none-any.whl (123 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 123.9/123.9 kB 77.1 kB/s eta 0:00:00
Collecting idna<4,>=2.5
  Using cached idna-3.4-py3-none-any.whl (61 kB)
Collecting commonmark<0.10.0,>=0.9.0
  Using cached commonmark-0.9.1-py2.py3-none-any.whl (51 kB)
Collecting greenlet!=0.4.17
  Using cached greenlet-2.0.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (613 kB)
Collecting aiohttp>=3.7.4.post0
  Downloading aiohttp-3.8.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.0 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.0/1.0 MB 83.5 kB/s eta 0:00:00
Collecting jsonschema>=4.0.0
  Downloading jsonschema-4.18.4-py3-none-any.whl (80 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 81.0/81.0 kB 51.9 kB/s eta 0:00:00
Collecting pyunormalize>=15.0.0
  Downloading pyunormalize-15.0.0.tar.gz (515 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 515.4/515.4 kB 83.4 kB/s eta 0:00:00
  Preparing metadata (setup.py) ... done
Collecting lru-dict>=1.1.6
  Using cached lru_dict-1.2.0-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (28 kB)
Collecting websockets>=10.0.0
  Using cached websockets-11.0.3-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (129 kB)
Collecting protobuf>=4.21.6
  Using cached protobuf-4.23.4-cp37-abi3-manylinux2014_x86_64.whl (304 kB)
Collecting eth-tester[py-evm]==v0.9.0-b.2
  Downloading eth_tester-0.9.0b2-py3-none-any.whl (71 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 71.9/71.9 kB 78.6 kB/s eta 0:00:00
INFO: pip is looking at multiple versions of web3[tester] to determine which version is compatible with other requirements. This could take a while.
Collecting web3[tester]<7,>=6.5.0
  Using cached web3-6.5.0-py3-none-any.whl (579 kB)
Collecting cached-property<2,>=1.5.1
  Using cached cached_property-1.5.2-py2.py3-none-any.whl (7.6 kB)
Collecting trie<3,>=2.0.0
  Using cached trie-2.1.1-py3-none-any.whl (39 kB)
Collecting py-ecc<7.0.0,>=1.4.7
  Using cached py_ecc-6.0.0-py3-none-any.whl (43 kB)
Collecting mypy-extensions<1.0.0,>=0.4.1
  Using cached mypy_extensions-0.4.4.tar.gz (4.2 kB)
  Preparing metadata (setup.py) ... done
Collecting pyethash<1.0.0,>=0.1.27
  Using cached pyethash-0.1.27.tar.gz (38 kB)
  Preparing metadata (setup.py) ... done
Collecting eth-bloom>=1.0.3
  Using cached eth_bloom-2.0.0-py3-none-any.whl (5.2 kB)
Collecting eth-tester[py-evm]==v0.9.0-b.1
  Using cached eth_tester-0.9.0b1-py3-none-any.whl (71 kB)
INFO: pip is looking at multiple versions of py-evm to determine which version is compatible with other requirements. This could take a while.
INFO: pip is looking at multiple versions of watchdog to determine which version is compatible with other requirements. This could take a while.
Collecting watchdog<3.0,>=2.1.9
  Downloading watchdog-2.3.0-py3-none-manylinux2014_x86_64.whl (80 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 80.7/80.7 kB 93.2 kB/s eta 0:00:00
  Downloading watchdog-2.2.1-py3-none-manylinux2014_x86_64.whl (78 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 79.0/79.0 kB 110.9 kB/s eta 0:00:00
  Downloading watchdog-2.2.0-py3-none-manylinux2014_x86_64.whl (78 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 78.7/78.7 kB 106.9 kB/s eta 0:00:00
INFO: pip is looking at multiple versions of web3[tester] to determine which version is compatible with other requirements. This could take a while.
  Using cached watchdog-2.1.9-py3-none-manylinux2014_x86_64.whl (78 kB)
INFO: pip is looking at multiple versions of traitlets to determine which version is compatible with other requirements. This could take a while.
Collecting traitlets>=5.3.0
  Using cached traitlets-5.8.1-py3-none-any.whl (116 kB)
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. See https://pip.pypa.io/warnings/backtracking for guidance. If you want to abort this run, press Ctrl + C.
INFO: pip is looking at multiple versions of watchdog to determine which version is compatible with other requirements. This could take a while.
  Downloading traitlets-5.8.0-py3-none-any.whl (116 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 116.8/116.8 kB 80.1 kB/s eta 0:00:00
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. See https://pip.pypa.io/warnings/backtracking for guidance. If you want to abort this run, press Ctrl + C.
  Downloading traitlets-5.7.1-py3-none-any.whl (109 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 109.9/109.9 kB 71.3 kB/s eta 0:00:00
  Downloading traitlets-5.7.0-py3-none-any.whl (109 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 109.9/109.9 kB 73.9 kB/s eta 0:00:00
  Downloading traitlets-5.6.0-py3-none-any.whl (107 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 107.5/107.5 kB 110.7 kB/s eta 0:00:00
  Using cached traitlets-5.5.0-py3-none-any.whl (107 kB)
  Using cached traitlets-5.4.0-py3-none-any.whl (107 kB)
INFO: pip is looking at multiple versions of traitlets to determine which version is compatible with other requirements. This could take a while.
  Using cached traitlets-5.3.0-py3-none-any.whl (106 kB)
INFO: pip is looking at multiple versions of tqdm to determine which version is compatible with other requirements. This could take a while.
Collecting tqdm<5.0,>=4.62.3
  Using cached tqdm-4.64.1-py2.py3-none-any.whl (78 kB)
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. See https://pip.pypa.io/warnings/backtracking for guidance. If you want to abort this run, press Ctrl + C.
  Using cached tqdm-4.64.0-py2.py3-none-any.whl (78 kB)
  Downloading tqdm-4.63.2-py2.py3-none-any.whl (76 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 76.6/76.6 kB 99.1 kB/s eta 0:00:00
  Downloading tqdm-4.63.1-py2.py3-none-any.whl (76 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 76.6/76.6 kB 91.5 kB/s eta 0:00:00
  Using cached tqdm-4.63.0-py2.py3-none-any.whl (76 kB)
  Using cached tqdm-4.62.3-py2.py3-none-any.whl (76 kB)
INFO: pip is looking at multiple versions of sqlalchemy to determine which version is compatible with other requirements. This could take a while.
Collecting SQLAlchemy>=1.4.35
  Using cached SQLAlchemy-2.0.18-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
INFO: pip is looking at multiple versions of tqdm to determine which version is compatible with other requirements. This could take a while.
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. See https://pip.pypa.io/warnings/backtracking for guidance. If you want to abort this run, press Ctrl + C.
  Downloading SQLAlchemy-2.0.17-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 86.0 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.16-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 80.8 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.15-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 70.7 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.14-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 90.0 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.13-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 71.7 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.12-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 78.2 kB/s eta 0:00:00
INFO: pip is looking at multiple versions of sqlalchemy to determine which version is compatible with other requirements. This could take a while.
  Downloading SQLAlchemy-2.0.11-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.7/2.7 MB 89.0 kB/s eta 0:00:00
  Downloading SQLAlchemy-2.0.10-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.8 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.8/2.8 MB 96.2 kB/s eta 0:00:00
  Using cached SQLAlchemy-2.0.9-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (2.7 MB)
^CERROR: Operation cancelled by user

[notice] A new release of pip available: 22.3.1 -> 23.2
[notice] To update, run: pip install --upgrade pip

How can it be fixed?

Don't know.

[arjunaskykok]

Problem solved after pip install --upgrade pip. Weird it is.

Whether this issue warrants more attention or not, it's up to you. Feel free to close this issue. Perhaps we should put this info in README.md?