Comments (8)
This most defiantly is not fixed yet or the VSCode postgres Extension is pulling an outdated version.
from pgtoolsservice.
There are multiple copies of this same bug, but this issue (#218) is the earliest I can find open.
This bug should be fixed. There is a comment about fixing it on one of the duplicates (#251)
They have the same error, a dialog that pops up on start and says "OSS DB Tools Service component exited unexpectedly. Please restart Azure Data Studio.", then an error reported in the output section:
"It seems the debugger cannot resolve /opt/hostedtoolcache/Python/3.6.12/x64/lib/python3.6/posixpath.py
This may make the debugger miss breakpoints in the standard library.
Related bug: https://bugs.python.org/issue1180193
... a stack trace ...
ImportError: libffi.so.6: cannot open shared object file: No such file or directory
[Error - 12:57:17 PM] Connection to server got closed. Server will not be restarted."
The important bit is the missing "libffi.so.6"
There are many other duplicates (that should probably be closed and directed to here)
#239
#251
#275
#279
#280
#282
#283
Work around:
So far, the workaround for some systems linking libffi.so.6 to version 7 seems to work:
sudo ln -s libffi.so.7 /usr/lib/x86_64-linux-gnu/libffi.so.6
The workaround does not work if you only have version 8, e.g. Ubuntu 20.10 -- it gets past the first error but then just fails. You can check which version you have via:
ls -la /usr/lib/x86_64-linux-gnu/libffi*
The other workaround is to directly install the version 6 libraries directly:
curl -o libffi6_3.2.1-8_amd64.deb http://mirrors.kernel.org/ubuntu/pool/main/libf/libffi/libffi6_3.2.1-8_amd64.deb
sudo apt install ./libffi6_3.2.1-8_amd64.deb
from pgtoolsservice.
ptvsd appears to be dead that is root cause of this issue.
from pgtoolsservice.
I'm getting the same error in openSUSE Leap 15.0 as of 11 November, 2019
$ rpm -qa | grep libffi
libffi7-32bit-3.2.1.git259-lp150.3.3.x86_64
libffi-devel-3.2.1.git259-lp150.3.3.x86_64
libffi7-3.2.1.git259-lp150.3.3.x86_64
Janky, Not at All Recommended Workaround
I created a symlink to /usr/lib64/libffi.so
called /usr/lib64/libffi.so.6
then uninstalled the extension and installed it fresh, the error wasn't reproduced. Now, I'm not entirely certain if there are any breaking changes that would make this crash at runtime, and I AM 100% certain that this is not the right way to fix it, but it seems to have worked for me, for now.
from pgtoolsservice.
Yes, this is a workaround, not a good solution.
I did the same:
[root@nb2 ~]# l /usr/lib64/libffi*
lrwxrwxrwx 1 root root 15 Oct 17 07:24 /usr/lib64/libffi.so -> libffi.so.7.1.0
lrwxrwxrwx 1 root root 11 Oct 16 13:13 /usr/lib64/libffi.so.6 -> libffi.so.7
lrwxrwxrwx 1 root root 15 Oct 17 07:24 /usr/lib64/libffi.so.7 -> libffi.so.7.1.0
-rwxr-xr-x 1 root root 43K Oct 17 07:24 /usr/lib64/libffi.so.7.1.0
[root@nb2 ~]#
from pgtoolsservice.
For those who are coming here for openSUSE Tumbleweed (or others that only offer version 8 of libffi
) see the note above:
The workaround does not work if you only have version 8, e.g. Ubuntu 20.10 -- it gets past the first error but then just fails.
I found that the server:monitoringrepo on OBS still offers
libffi6`, which you can access by adding the following repo:
$ sudo zypper ar https://download.opensuse.org/repositories/server:monitoring/openSUSE_Tumbleweed/server:monitoring.repo
$ sudo zypper ref
$ sudo zypper install libffi6
from pgtoolsservice.
the ptvsd(python tool for vs debugger) module which is being used in ossdbtoolsservice_main.py is no longer active, looks the same old module is being shipped and its creating issues, the ubuntu 20.04 uses newer version which is libffi.so.7.1.0.
from pgtoolsservice.
It's been years, and this has not been fixed. Trying to run ADS on Ubuntu 22.04 (Jammy Jellyfish) to no avail. Anyone successfuly installed and used the extension on 22.04?
Edit: Ok, looking at the issue tracker, lots of people are having this issue for a long time already. Is this product abandoned or what? Nearing one year since the last commit as well.
from pgtoolsservice.
Related Issues (20)
- Error log when connecting to PostgreSQL and MySQL server using ADS
- ObjectExplorer for MySQL views is throwing error HOT 1
- error occurred when I try to install postgreSQL extension HOT 3
- Mysql: Unhandled exception: "unpack requires a buffer of 4 bytes" HOT 3
- Cannot open database list in Azure Data Studio HOT 1
- "OSS DB Tools Service component exited unexpectedly. Please restart Azure Data Studio." on Mac HOT 1
- "OSS DB Tools Service component exited unexpectedly. Please restart Azure Data Studio" on Arch Linux HOT 3
- Bump up Python version to 310 HOT 1
- Enable PR check via Azure DevOps pipeline - Windows
- Enable PR check via Azure DevOps pipeline - Mac
- Resolve Security Components Issue
- Remove MySQL component HOT 1
- Add Postgres14 Executables HOT 1
- PostgreSQL Extension on Azure Data Studio Linux version HOT 1
- Cannot edit more than one data cell in table
- Show query hints if provided in error message
- Quotation marks added in the function/procedure name when trying to drop
- ValueError: dictionary update sequence element #1 has length 1; 2 is required when using username with spaces HOT 1
- Error: "PostgreSQL Tools Service component could not start" HOT 2
- Error in Ubuntu 20.04 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgtoolsservice.