Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Pytorch is not installable using sqlmlutils #60

Open
Jeff-Winchell opened this issue Mar 22, 2020 · 1 comment
Open

Pytorch is not installable using sqlmlutils #60

Jeff-Winchell opened this issue Mar 22, 2020 · 1 comment

Comments

@Jeff-Winchell
Copy link

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\PYTHON_SERVICES\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\PYTHON_SERVICES\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'))" bdist_wheel -d C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-wheel-dvpxe0od --python-tag cp37:
running bdist_wheel
running build
running build_deps
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
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant