sqlite3 CXXABI_1.3.8 not found error

[Chiaki]

sqlite3 CXXABI_1.3.8 not found error

[BobbyWibowo]

You'll have to downgrade sqlite3 to 5.0.2 for the time being
Related issue TryGhost/node-sqlite3#1582

[Chiaki]

I did this at first, but got the same error. Looks like problem in markdown-it.
After I roll back to backup, I've added this dependency and error appears. Sadly, but downgrade even to markdown-it 8.x didn't help. I found that CXXABI 1.3.8 is defined in gcc 4.9, and Centos 7 ships with gcc 4.8.

P.S.
Deleting node_modules folder and running yarn full-upgrade is correct way to workaround?

[BobbyWibowo]

I found that CXXABI 1.3.8 is defined in gcc 4.9, and Centos 7 ships with gcc 4.8.

Correct
They will have to start shipping Linux binaries built on CentOS 7 docker container, if they want to increase their coverage
I believe they will do it eventually, since even sharp did so (lovell/sharp#2119 (comment))

Looks like problem in markdown-it.

That doesn't sound right, imho
markdown-it should not have a native binary, it's a pure JS library

Deleting node_modules folder and running yarn full-upgrade is correct way to workaround?

Actually, no
yarn full-upgrade is more of a "if you know what you're doing" type of thing, as it deletes the yarn.lock file, which specifies exact versions of dependencies last tested by me to be working
It's generally not the end of the world to use it anyway, but it does increase the amount of variables when issues occur

Try to do the following instead

git restore package.json yarn.lock
rm -rf node_modules
env NODE_ENV=production yarn add [email protected]

Remove env NODE_ENV=production if you intend to also install dev dependencies (which you may need if you want to build your own modified client assets, otherwise they're just waste of disk space, roughly 140MB)

[BobbyWibowo]

We switched from sqlite3 to better-sqlite3 by commit afc5850 since it's all around better, and does not require existing installations to manually migrate (Knex.js handles abstraction to the driver)

Unfortunately it does not have prebuilt binaries for CentOS 7 either, but assuming you have Python 3 and GCC 7 (devtoolset-7 or newer), it will build from source just fine during yarn dependencies install