microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
195 stars 37 forks source link

Postgres exentsion installation fails in ADS with error Related bug: https://bugs.python.org/issue1180193 #367

Open moraja opened 1 year ago

moraja commented 1 year ago

customer is attempting to deploy to add postgres in ADS in a citrix windows desktop environment, but it keeps failing with below error:

It seems the debugger cannot resolve C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\ntpath.py
This may make the debugger miss breakpoints in the standard library.
Related bug: [https://bugs.python.org/issue1180193](https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.python.org%2Fissue1180193&data=05%7C01%7CNathan.Schoenack%40microsoft.com%7C6b44227894bc41e9d16d08db367f8902%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638163693644245167%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=83EkB2sYmU8sT2SqcPlrtMyd8ia4%2FI0YquRrJaQVfYE%3D&reserved=0)
Traceback (most recent call last):
File "C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\site-packages\cx_Freeze\initscripts\__startup__.py", line 40, in run
File "C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\site-packages\cx_Freeze\initscripts\Console.py", line 37, in run
File "ossdbtoolsservice/ossdbtoolsservice_main.py", line 14, in <module>
File "D:\a\1\s\ossdbtoolsservice\capabilities\capabilities_service.py", line 8, in <module>
File "D:\a\1\s\ossdbtoolsservice\capabilities\connection_options\mysql_connection_options.py", line 9, in <module>
File "D:\a\1\s\ossdbtoolsservice\query_execution\__init__.py", line 6, in <module>
File "D:\a\1\s\ossdbtoolsservice\query_execution\query_execution_service.py", line 15, in <module>
File "D:\a\1\s\ossdbtoolsservice\query\__init__.py", line 6, in <module>
File "D:\a\1\s\ossdbtoolsservice\query\batch.py", line 15, in <module>
ModuleNotFoundError: No module named 'ossdbtoolsservice.query.contracts'
[Error - 1:58:03 PM] Connection to server got closed. Server will not be restarted.

However installing the same extension using offline option works fine. This is not a good option for the client since they want to deploy ADS using citrix to their wider audience.