Works on my windows machine but not on mac: ERR_DLOPEN_FAILED

[cad0p]

Describe the bug

I am using a docker container that has multiple databases, and previously I was only developing with a Windows machine.
Your extension has been great especially for validating queries with IntelliSense! But unfortunately it is crashing with the same settings (literally, thanks to the use of Docker).

I have to add that I am running the extension inside the container.

EDIT: It's actually Linux in both cases as it's running inside a Dev Container. Also this may be worth a try: directus/directus#6071

Here is the log:

node:internal/modules/cjs/loader:1187
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/build/Release/queryparser.node: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (node:internal/modules/cjs/loader:1187:18)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12)
    at Module.require (node:internal/modules/cjs/loader:1005:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at Object.<anonymous> (/home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/index.js:1:17)
    at Module._compile (node:internal/modules/cjs/loader:1103:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12) {
  code: 'ERR_DLOPEN_FAILED'
}
[Info  - 8:58:38 PM] Connection to server got closed. Server will restart.
node:internal/modules/cjs/loader:1187
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/build/Release/queryparser.node: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (node:internal/modules/cjs/loader:1187:18)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12)
    at Module.require (node:internal/modules/cjs/loader:1005:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at Object.<anonymous> (/home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/index.js:1:17)
    at Module._compile (node:internal/modules/cjs/loader:1103:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12) {
  code: 'ERR_DLOPEN_FAILED'
}
[Info  - 8:58:38 PM] Connection to server got closed. Server will restart.
node:internal/modules/cjs/loader:1187
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/build/Release/queryparser.node: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (node:internal/modules/cjs/loader:1187:18)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12)
    at Module.require (node:internal/modules/cjs/loader:1005:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at Object.<anonymous> (/home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/index.js:1:17)
    at Module._compile (node:internal/modules/cjs/loader:1103:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12) {
  code: 'ERR_DLOPEN_FAILED'
}
[Info  - 8:58:38 PM] Connection to server got closed. Server will restart.
node:internal/modules/cjs/loader:1187
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/build/Release/queryparser.node: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (node:internal/modules/cjs/loader:1187:18)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12)
    at Module.require (node:internal/modules/cjs/loader:1005:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at Object.<anonymous> (/home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/index.js:1:17)
    at Module._compile (node:internal/modules/cjs/loader:1103:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12) {
  code: 'ERR_DLOPEN_FAILED'
}
[Info  - 8:58:39 PM] Connection to server got closed. Server will restart.
node:internal/modules/cjs/loader:1187
  return process.dlopen(module, path.toNamespacedPath(filename));
                 ^

Error: /home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/build/Release/queryparser.node: cannot open shared object file: No such file or directory
    at Object.Module._extensions..node (node:internal/modules/cjs/loader:1187:18)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12)
    at Module.require (node:internal/modules/cjs/loader:1005:19)
    at require (node:internal/modules/cjs/helpers:102:18)
    at Object.<anonymous> (/home/node/.vscode-server/extensions/uniquevision.vscode-plpgsql-lsp-1.4.10/server/node_modules/libpg-query/index.js:1:17)
    at Module._compile (node:internal/modules/cjs/loader:1103:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
    at Module.load (node:internal/modules/cjs/loader:981:32)
    at Function.Module._load (node:internal/modules/cjs/loader:822:12) {
  code: 'ERR_DLOPEN_FAILED'
}
[Error - 8:58:39 PM] Connection to server got closed. Server will not be restarted.

Expected Behavior

It should work both on Mac and Windows without any issues, especially with the same setup.

Current Behavior

It only works on Windows

Steps to Reproduce

Not sure yet if being on Mac or Windows is the issue here

Environment

• Windows
• Mac
• Linux
• other (please specify)