Error on AzureDataStudio startup after installing PostgreSQL extension on Linux Mint about pgtoolsservice HOT 3 CLOSED

Looks like duplicate of #280
Sorry, closing this one out.

from pgtoolsservice.

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

from pgtoolsservice.

@sgryphon patching libffi.so.6 using .7 is OK on ubuntu, the only problem missing is that it seems only normal query page work, the notebook not as in this image

See that it says 10 rows, but it doesn't show any row at all, only in the query editor

from pgtoolsservice.