search

microsoft / sqlmlutils

Utility functions for easier usage of SQL Server Machine Learning Services
Other
32 stars 33 forks source link

Pytorch is not installable using sqlmlutils #60

Open Jeff-Winchell opened 4 years ago

Jeff-Winchell commented 4 years ago

From the PyForMLS subdirectory in a cmd window (Windows 10) I launch python (vs 3.5.2) Then I run these 3 python statements

import sqlmlutils
connection=sqlmlutils.ConnectionInfo(server="localhost",database="mydatabase")
sqlmlutils.SQLPackageManager(connection).install("torch")

The last statement generates this:

STDOUT message(s) from external script: Processing c:\data\sql\mssql15.mssqlserver\mssql\externallibraries\5\2\1_\pyyamltmp\pyyaml-5.3.1-cp37-cp37m-win_amd64.whl Installing collected packages: PyYAML Successfully installed PyYAML-5.3.1 Installed package. Cleaning up temporary directories. Cleaned up temporary directory. Package successfully installed. STDERR message(s) from external script: Failed building wheel for torch Failed cleaning build dir for torch Command ""C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHONSERVICES\python.exe" -u -c "import setuptools, tokenize;file='C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\\pip-req-build-nfi11418\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-record-qwk33zxf\install-record.txt --single-version-externally-managed --compile --home=C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-target-qh7puf9o" failed with error code 1 in C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\\pip-req-build-nfi11418\ STDOUT message(s) from external script: Processing c:\data\sql\mssql15.mssqlserver\mssql\externallibraries\5\2\1\\torchtmp\torch-0.1.2.post2.tar.gz

Building wheels for collected packages: torch Running setup.py bdist_wheel for torch: started Running setup.py bdist_wheel for torch: finished with status 'error' Complete output from command "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHONSERVICES\python.exe" -u -c "import setuptools, tokenize;file='C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\\pip-req-build-nfi11418\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" bdistwheel -d C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\\pip-wheel-dvpxe0od --python-tag cp37: running bdist_wheel running build running builddeps Traceback (most recent call last): File "", line 1, in STDOUT message(s) from external script: File "C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\\pip-req-build-nfi11418\setup.py", line 265, in description="Tensors and Dynamic neural networks in Python with strong GPU acceleration", File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\setuptools__init__.py", line 143, in setup return distutils.core.setup(**attrs) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\core.py", line 148, in setup dist.run_commands() File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\dist.py", line 966, in run_commands self.run_command(cmd) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\dist.py", line 985, in run_command cmd_obj.run()

STDOUT message(s) from external script: File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\wheel\bdist_wheel.py", line 188, in run self.run_command('build') File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\cmd.py", line 313, in run_command self.distribution.run_command(command) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\dist.py", line 985, in run_command cmd_obj.run() File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\command\build.py", line 135, in run self.run_command(cmd_name) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\cmd.py", line 313, in run_command self.distribution.run_command(command) Unable to launch runtime for 'Python' script for request id: FF48E36C-0966-405D-8285-F1D50BA09736. Please check the configuration of the 'Python' runtime. Traceback (most recent call last): File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\sqlqueryexecutor.py", line 58, in execute self._mssqlconn.execute_non_query(builder.base_script, builder.params) File "src_mssql.pyx", line 1033, in _mssql.MSSQLConnection.execute_non_query File "src_mssql.pyx", line 1061, in _mssql.MSSQLConnection.execute_non_query File "src_mssql.pyx", line 1634, in _mssql.check_and_raise File "src_mssql.pyx", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException _mssql.MSSQLDatabaseException: (39021, b"Unable to launch runtime for 'Python' script for request id: FF48E36C-0966-405D-8285-F1D50BA09736. Please check the configuration of the 'Python' runtime.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 185, in _install_many self._install_single(sqlexecutor, target_package_file, scope, True, out_file=out_file) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 202, in _install_single sqlexecutor.execute(builder, out_file=out_file, getResults=False) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\sqlqueryexecutor.py", line 61, in execute raise RuntimeError("Error in SQL Execution") from e RuntimeError: Error in SQL Execution

The above exception was the direct cause of the following exception: Traceback (most recent call last): File "", line 1, in File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 74, in install self._install_from_pypi(package, upgrade, version, install_dependencies, scope, out_file=out_file) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 151, in _install_from_pypi self._install_from_file(target_package_file, scope, upgrade, out_file=out_file) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 174, in _install_from_file self._install_many(target_package_file, dependencies_to_install, scope, out_file=out_file) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 189, in _install_many raise RuntimeError("Package installation failed, installed dependencies were rolled back.") from e RuntimeError: Package installation failed, installed dependencies were rolled back.

Jeff-Winchell commented 4 years ago

I can install some packages. Because I can't install pycld2 either (although its error messages are somewhat different) my guess is the problem is with installing packages that require some sort of building on my computer.