Cannot start pigallery2 after a node upgrade

[sugatam]

I've been running pigallery2 natively on a sbc running debian trixie. A recent upgrade pulled in a new version of node and npm, and now I cannot start the app:

5/4/2024, 10:32:20 AM[WARN_][ConfigDiagnostics] [SQL error] Error: The module '/srv/pigallery2/node_modules/better-sqlite3/build/Release/better_sqlite3.node' was compiled against a different Node.js version using NODE_MODULE_VERSION 108. This version of Node.js requires NODE_MODULE_VERSION 109. Please try re-compiling or re-installing the module (for instance, usingnpm rebuildornpm install).

I wiped node_modules, cleared the npm cache, did a new npm install and an npm rebuild, all to no avail. Finally, I even did a fresh git pull and build, but I'm still getting this. Any ideas?

[bpatrik]

Hi The latest node is not supported yet. Pls use node 18.

…

-- Sorry for being brief, sent from my phone.

On Sat, 4 May 2024, 16:36 sugatam, ***@***.***> wrote: I've been running pigallery2 natively on a sbc running debian trixie. A recent upgrade pulled in a new version of node and npm, and now I cannot start the app: 5/4/2024, 10:32:20 AM[WARN_][ConfigDiagnostics] [SQL error] Error: The module '/srv/pigallery2/node_modules/better-sqlite3/build/Release/better_sqlite3.node' was compiled against a different Node.js version using NODE_MODULE_VERSION 108. This version of Node.js requires NODE_MODULE_VERSION 109. Please try re-compiling or re-installing the module (for instance, usingnpm rebuildornpm install). I wiped node_modules, cleared the npm cache, did a new npm install and an npm rebuild, all to no avail. Finally, I even did a fresh git pull and build, but I'm still getting this. Any ideas? — Reply to this email directly, view it on GitHub <#900>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABZKA5SF7TOZDX6ASU6F7ZTZATXANAVCNFSM6AAAAABHG4FV6CVHI2DSMVQWIX3LMV43ASLTON2WKOZSGI3TSMBSG44TQNI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[sugatam]

Thanks for your reply Patrik. I don't think trixie pulled in a new major version of node, its still node v18.

> process.versions
{ 
  node: '18.20.1',
  modules: '109',

and on another installation where I haven't upgraded:

{ 
  node: '18.19.1',
  modules: '108',
}

I'm not familiar with the node dev/release pipeline, but it appears that despite what I'm trying I can't get that one module - better_sqlite3 - to rebuild in the new pipleline.

[martadinata666]

can you please test using -d, npm -d rebuild likely or what I assume is missing build deps and can't build the module from the source.

[sugatam]

Hi, npm -d rebuild didn't help, nor did clearing out node_modules and running

npm install --build-from-source

How can I get more insight into build deps? You may be right in that I can't build better_sqlite3 from source, just want to know why and address that. Messing around with various revisions of better_sqlite3 (9.x.x) led to npm run build failing, so that was a no go.

[martadinata666]

-d is debug mode, so there should be more insight what wrong? or at least why it don't compile from source. Can you please paste the log, here 🤔

[sugatam]

I was able to fix it by

cd node_modules/better_sqlite3
node-gyp rebuild --release 

[bpatrik]

Happy to hear. Closing this bug.