install error: https://github.com/mapbox/node-sqlite3 tag not found

[Antisunny]

Describe the bug

[2/4] Fetching packages...
error Couldn't find match for "918052b538b0effe6c4a44c74a16b2749c08a0d2" in "refs/heads/master,refs/heads/renovate/eslint-8.x,refs/heads/renovate/mocha-9.x,refs/heads/renovate/node-gyp-9.x,refs/heads/ubuntu18,refs/tags/0.0.2,refs/tags/0.0.3,refs/tags/0.0.6,refs/tags/1.0.0,refs/tags/1.0.1,refs/tags/1.0.2,refs/tags/1.0.3,refs/tags/2.0.0,refs/tags/2.0.1,refs/tags/2.0.10,refs/tags/2.0.11,refs/tags/2.0.12,refs/tags/2.0.13,refs/tags/2.0.2,refs/tags/2.0.3,refs/tags/2.0.4,refs/tags/2.0.5,refs/tags/2.0.6,refs/tags/2.0.7,refs/tags/2.0.8,refs/tags/2.0.9,refs/tags/v2.0.14,refs/tags/v2.0.15,refs/tags/v2.0.16,refs/tags/v2.0.17,refs/tags/v2.0.18,refs/tags/v2.1.0,refs/tags/v2.1.1,refs/tags/v2.1.10,refs/tags/v2.1.11,refs/tags/v2.1.12,refs/tags/v2.1.13,refs/tags/v2.1.14,refs/tags/v2.1.15,refs/tags/v2.1.16,refs/tags/v2.1.17,refs/tags/v2.1.18,refs/tags/v2.1.19,refs/tags/v2.1.3,refs/tags/v2.1.4,refs/tags/v2.1.5,refs/tags/v2.1.7,refs/tags/v2.1.7-alpha,refs/tags/v2.1.8,refs/tags/v2.1.9,refs/tags/v2.2.0,refs/tags/v2.2.0-alpha,refs/tags/v2.2.1,refs/tags/v2.2.3,refs/tags/v2.2.4,refs/tags/v2.2.5,refs/tags/v2.2.6,refs/tags/v3.0.0,refs/tags/v3.0.1,refs/tags/v3.0.10,refs/tags/v3.0.2,refs/tags/v3.0.3,refs/tags/v3.0.4,refs/tags/v3.0.5,refs/tags/v3.0.6,refs/tags/v3.0.7,refs/tags/v3.0.8,refs/tags/v3.0.9,refs/tags/v3.1.0,refs/tags/v3.1.1,refs/tags/v3.1.10,refs/tags/v3.1.11,refs/tags/v3.1.12,refs/tags/v3.1.13,refs/tags/v3.1.2,refs/tags/v3.1.3,refs/tags/v3.1.4,refs/tags/v3.1.5,refs/tags/v3.1.6,refs/tags/v3.1.7,refs/tags/v3.1.8,refs/tags/v3.1.9,refs/tags/v4.0.0,refs/tags/v4.0.1,refs/tags/v4.0.2,refs/tags/v4.0.3,refs/tags/v4.0.5,refs/tags/v4.0.6,refs/tags/v4.0.8,refs/tags/v4.0.9,refs/tags/v4.1.0,refs/tags/v4.1.1,refs/tags/v4.2.0,refs/tags/v5.0.0,refs/tags/v5.0.1,refs/tags/v5.0.2,refs/tags/v5.0.3,refs/tags/v5.0.4,refs/tags/v5.0.5" for "https://github.com/mapbox/node-sqlite3".
info Visit https://yarnpkg.com/en/docs/cli/install for documentation about this command.
The command '/bin/sh -c yarn install' returned a non-zero code: 1
ERROR: Service 'server' failed to build : Build failed

To Reproduce
Steps to reproduce the behavior:

1. git clone this repo
2. cd Drift
3. edit docker-compose.yml
4. docker-compose up

Expected behavior
yarn install success

Desktop (please complete the following information):

• OS: Ubuntu 20.04.4 LTS
• Browser None
• Version None

[icepaq]

@MaxLeiter is this related to PR #96?

[Antisunny]

this problem is related to 3269dfc

One way to solve this is to modify two files:

packages.json

"sqlite3": "^5.0.5",

yarn.lock

sqlite3@^5.0.5:
   version "5.0.5"
   resolved "https://registry.npmjs.org/sqlite3/-/sqlite3-5.0.5.tgz#e8768ffcb4800a72216846898cd6c363ba1d83c9"
   integrity: sha512-ZZFOMW31IOMbUeSiL23TuWSjNyS7Z83EDJ80HJxCe78OZ+5BJT6IhAwAUnQgPsUl5z+Er0DGx7VjuTP7PKPNcg==
   dependencies:
     "@mapbox/node-pre-gyp" "^1.0.0"
     node-addon-api "^4.2.0"
     tar "^6.1.11"
   optionalDependencies:
     node-gyp "8.x"

[MaxLeiter]

Yeah, I'll have a fix for this shortly; upstream has resolved the issues afaict.

P.S. @Antisunny: Docker isn't 100% ready yet unless you want to build your own images, so I recommend holding off as some refactors are incoming. You can track #104 or join us in IRC to stay updated.