Linux (Ubuntu based) "PG SQL Tools Service component quit unexpectedly. about pgtoolsservice

[TheRealChssAddct]

The above instructions did not work for ubuntu 20.10 (groovy gorilla) even with linking from libffi.so.8.
(it partially worked, getting past this error, but then gave a different error when loading the service.)

The following instructions (originally from this comment here ) did work for me:

• download the 19.10 version of the package from here: libffi6_3.2.1-8_amd64.deb

• install it with:
  sudo apt install ./libffi6_3.2.1-8_amd64.deb

[schoening]

Linking libffi7 as libffi6 solved the problem for now. Not ideal tho...

https://stackoverflow.com/questions/61875869/ubuntu-20-04-upgrade-python-missing-libffi-so-6

[DiomedesDominguez]

Linking libffi7 as libffi6 solved the problem for now. Not ideal tho...

https://stackoverflow.com/questions/61875869/ubuntu-20-04-upgrade-python-missing-libffi-so-6

After listed all possible references with find /usr/lib -name "libffi.so*", I used sudo ln -s /usr/lib/x86_64-linux-gnu/libffi.so.7 /usr/lib/x86_64-linux-gnu/libffi.so.6 to fix the problem.

[sgryphon]

Appears to be a duplicate of #218 and should be closed.

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 as well)

#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

[nasc17]

Issue has been addressed in our unstable release of PostgreSQL extension v0.4.2 using pgtoolsservice v1.8.0. We would appreciate your verification that it has been handled appropriately.