Node-red-node-sqlite won't install on pi zero w

General
1

Hi, installing node-red-node-sqlite on mi pi zero w always throws errors. I tried it out of note red and manually from the command window. Also I tried the solutions given in the other topics.
I'm unsure if the issue is based on the pi zero w I use. Maybe someone can interpret the log better than me (I split the log into two pices cause its to long to post it in once):

2023-04-07T19:29:36.780Z Installieren : node-red-node-sqlite 1.0.3

2023-04-07T19:29:37.289Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@1.0.3
2023-04-07T19:29:50.658Z [err] npm
2023-04-07T19:29:50.672Z [err]  
2023-04-07T19:29:50.675Z [err] WARN
2023-04-07T19:29:50.685Z [err]  config production Use `--omit=dev` instead.
2023-04-07T19:31:06.137Z [err] npm
2023-04-07T19:31:06.140Z [err]  
2023-04-07T19:31:06.142Z [err] WARN
2023-04-07T19:31:06.151Z [err]  deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs
2023-04-07T19:37:44.215Z [err] npm
2023-04-07T19:37:44.225Z [err]  ERR! code 1
2023-04-07T19:37:44.225Z [err] npm ERR! path /home/Admin/.node-red/node_modules/sqlite3
2023-04-07T19:37:44.265Z [err] npm
2023-04-07T19:37:44.271Z [err]  ERR! command failed
2023-04-07T19:37:44.285Z [err] npm ERR! command sh -c -- node-pre-gyp install --fallback-to-build
2023-04-07T19:37:44.285Z [err] npm ERR! make: Entering directory '/home/Admin/.node-red/node_modules/sqlite3/build'
2023-04-07T19:37:44.285Z [err] npm ERR!   CC(target) Release/obj.target/nothing/../node-addon-api/nothing.o
2023-04-07T19:37:44.285Z [err] npm ERR!   AR(target) Release/obj.target/../node-addon-api/nothing.a
2023-04-07T19:37:44.285Z [err] npm ERR!   COPY Release/nothing.a
2023-04-07T19:37:44.285Z [err] npm ERR!   ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c
2023-04-07T19:37:44.285Z [err] npm ERR!   TOUCH Release/obj.target/deps/action_before_build.stamp
2023-04-07T19:37:44.285Z [err] npm 
2023-04-07T19:37:44.288Z [err] ERR!
2023-04-07T19:37:44.289Z [err]    CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3410100/sqlite3.o
2023-04-07T19:37:44.291Z [err] npm
2023-04-07T19:37:44.305Z [err]  ERR! make: Leaving directory '/home/Admin/.node-red/node_modules/sqlite3/build'
2023-04-07T19:37:44.305Z [err] npm ERR! Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
2023-04-07T19:37:44.305Z [err] npm ERR! node-pre-gyp info it worked if it ends with ok
2023-04-07T19:37:44.307Z [err] npm
2023-04-07T19:37:44.309Z [err]  
2023-04-07T19:37:44.310Z [err] ERR!
2023-04-07T19:37:44.346Z [err]  node-pre-gyp info using node-pre-gyp@1.0.10
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp info using node@16.19.0 | linux | arm
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp info check checked for "/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" (not found)
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz 
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp WARN Pre-built binaries not installable for sqlite3@5.1.6 and node@16.19.0 (node-v93 ABI, glibc) (falling back to source compile with node-gyp) 
2023-04-07T19:37:44.346Z [err] npm ERR! node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz 
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info it worked if it ends with ok
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info using node-gyp@9.1.0
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info using node@16.19.0 | linux | arm
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info ok 
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info it worked if it ends with ok
2023-04-07T19:37:44.346Z [err] npm ERR! gyp info using node-gyp@9.1.0
2023-04-07T19:37:44.346Z [err] npm ERR!
2023-04-07T19:37:44.353Z [err]  gyp info using node@16.19.0 | linux | arm
2023-04-07T19:37:44.353Z [err] npm ERR! gyp info find Python using Python version 3.9.2 found at "/usr/bin/python3"
2023-04-07T19:37:44.353Z [err] npm ERR! gyp info spawn /usr/bin/python3
2023-04-07T19:37:44.353Z [err] npm ERR! gyp info spawn args [
2023-04-07T19:37:44.353Z [err] npm ERR!
2023-04-07T19:37:44.354Z [err]  gyp info spawn args   '/usr/lib/node_modules/npm/node_modules/node-gyp/gyp/gyp_main.py',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   'binding.gyp',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '-f',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   'make',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '-I',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '/home/Admin/.node-red/node_modules/sqlite3/build/config.gypi',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '-I',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '/usr/lib/node_modules/npm/node_modules/node-gyp/addon.gypi',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '-I',
2023-04-07T19:37:44.365Z [err] npm ERR! gyp info spawn args   '/home/Admin/.cache/node-gyp/16.19.0/include/node/common.gypi',
2023-04-07T19:37:44.365Z [err] npm 
2023-04-07T19:37:44.368Z [err] ERR!
2023-04-07T19:37:44.370Z [err]  gyp info spawn args   '-Dlibrary=shared_library',
2023-04-07T19:37:44.371Z [err] npm
2023-04-07T19:37:44.386Z [err]  ERR! gyp info spawn args   '-Dvisibility=default',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Dnode_root_dir=/home/Admin/.cache/node-gyp/16.19.0',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Dnode_gyp_dir=/usr/lib/node_modules/npm/node_modules/node-gyp',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Dnode_lib_file=/home/Admin/.cache/node-gyp/16.19.0/<(target_arch)/node.lib',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Dmodule_root_dir=/home/Admin/.node-red/node_modules/sqlite3',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Dnode_engine=v8',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '--depth=.',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '--no-parallel',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '--generator-output',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   'build',
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args   '-Goutput_dir=.'
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info spawn args ]
2023-04-07T19:37:44.386Z [err] npm ERR! gyp info ok 
2023-04-07T19:37:44.388Z [err] npm
2023-04-07T19:37:44.390Z [err]  
2023-04-07T19:37:44.392Z [err] ERR!
2023-04-07T19:37:44.406Z [err]  gyp info it worked if it ends with ok
2023-04-07T19:37:44.406Z [err] npm ERR! gyp info using node-gyp@9.1.0
2023-04-07T19:37:44.406Z [err] npm ERR! gyp info using node@16.19.0 | linux | arm
2023-04-07T19:37:44.406Z [err] npm ERR! gyp info spawn make
2023-04-07T19:37:44.406Z [err] npm ERR! gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
2023-04-07T19:37:44.406Z [err] npm ERR! In file included from Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:37006:
2023-04-07T19:37:44.406Z [err] npm ERR! /usr/include/arm-linux-gnueabihf/sys/ioctl.h:1:1741: error: expected ‘;’ before ‘typedef’
2023-04-07T19:37:44.406Z [err] npm ERR!     1 | ptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRC
2023-04-07T19:37:44.406Z [err] npm ERR!       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ^
2023-04-07T19:37:44.406Z [err] npm ERR!       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ;
2023-04-07T19:37:44.406Z [err] npm ERR! In file included from Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:37013:
2023-04-07T19:37:44.406Z [err] npm ERR! /usr/include/arm-linux-gnueabihf/sys/mman.h:1:1: error: expected ‘;’ before ‘typedef’
2023-04-07T19:37:44.406Z [err] npm ERR!
2023-04-07T19:37:44.413Z [err]      1 | ptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCRCptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptpt
2023-04-07T19:37:44.417Z [err] npm
2023-04-07T19:37:44.425Z [err]  ERR!       | ^
2023-04-07T19:37:44.425Z [err] npm ERR!       | ;
2023-04-07T19:37:44.425Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:37453:42: error: ‘mmap’ undeclared here (not in a function)
2023-04-07T19:37:44.425Z [err] npm ERR! 37453 |   { "mmap",         (sqlite3_syscall_ptr)mmap,            0 },
2023-04-07T19:37:44.425Z [err] npm ERR!       |                                          ^~~~
2023-04-07T19:37:44.425Z [err] npm ERR!
2023-04-07T19:37:44.428Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:37461:42: error: ‘munmap’ undeclared here (not in a function)
2023-04-07T19:37:44.429Z [err] npm
2023-04-07T19:37:44.435Z [err]  ERR! 37461 |   { "munmap",       (sqlite3_syscall_ptr)munmap,          0 },
2023-04-07T19:37:44.435Z [err] npm ERR!       |                                          ^~~~~~
2023-04-07T19:37:44.435Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:37468:42: error: ‘mremap’ undeclared here (not in a function)
2023-04-07T19:37:44.435Z [err] npm ERR! 37468 |   { "mremap",       (sqlite3_syscall_ptr)mremap,          0 },
2023-04-07T19:37:44.435Z [err] npm 
2023-04-07T19:37:44.437Z [err] ERR!
2023-04-07T19:37:44.439Z [err]        |                                          ^~~~~~
2023-04-07T19:37:44.441Z [err] npm
2023-04-07T19:37:44.445Z [err]  ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c: In function ‘unixShmMap’:
2023-04-07T19:37:44.445Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:36: error: ‘PROT_READ’ undeclared (first use in this function)
2023-04-07T19:37:44.445Z [err] npm ERR! 41792 |             pShmNode->isReadonly ? PROT_READ : PROT_READ|PROT_WRITE,
2023-04-07T19:37:44.445Z [err] npm
2023-04-07T19:37:44.447Z [err]  
2023-04-07T19:37:44.449Z [err] ERR!
2023-04-07T19:37:44.453Z [err]        |                                    ^~~~~~~~~
2023-04-07T19:37:44.453Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:36: note: each undeclared identifier is reported only once for each function it appears in
2023-04-07T19:37:44.453Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:58: error: ‘PROT_WRITE’ undeclared (first use in this function)
2023-04-07T19:37:44.454Z [err] npm
2023-04-07T19:37:44.465Z [err]  ERR! 41792 |             pShmNode->isReadonly ? PROT_READ : PROT_READ|PROT_WRITE,
2023-04-07T19:37:44.465Z [err] npm ERR!       |                                                          ^~~~~~~~~~
2023-04-07T19:37:44.465Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:57: error: invalid operands to binary | (have ‘struct unix_syscall *’ and ‘struct unix_syscall *’)
2023-04-07T19:37:44.465Z [err] npm ERR! 41792 |             pShmNode->isReadonly ? PROT_READ : PROT_READ|PROT_WRITE,
2023-04-07T19:37:44.465Z [err] npm ERR!       |                                                ~~~~~~~~~^
2023-04-07T19:37:44.465Z [err] npm ERR!       |                                                |        |
2023-04-07T19:37:44.465Z [err] npm ERR!       |                                                |        struct unix_syscall *
2023-04-07T19:37:44.465Z [err] npm ERR!       |                                                struct unix_syscall *
2023-04-07T19:37:44.465Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41793:13: error: ‘MAP_SHARED’ undeclared (first use in this function)
2023-04-07T19:37:44.465Z [err] npm
2023-04-07T19:37:44.472Z [err]  
2023-04-07T19:37:44.475Z [err] ERR!
2023-04-07T19:37:44.480Z [err]  41793 |             MAP_SHARED, pShmNode->hShm, szRegion*(i64)pShmNode->nRegion
2023-04-07T19:37:44.480Z [err] npm ERR!       |             ^~~~~~~~~~
2023-04-07T19:37:44.480Z [err] npm 
2023-04-07T19:37:44.482Z [err] ERR!
2023-04-07T19:37:44.496Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:46: warning: passing argument 3 of ‘(void * (*)(void *, size_t,  int,  int,  int,  off_t))aSyscall[22].pCurrent’ makes integer from pointer without a cast [-Wint-conversion]
2023-04-07T19:37:44.496Z [err] npm ERR! 41792 |             pShmNode->isReadonly ? PROT_READ : PROT_READ|PROT_WRITE,
2023-04-07T19:37:44.496Z [err] npm ERR!       |             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.496Z [err] npm ERR!       |                                              |
2023-04-07T19:37:44.496Z [err] npm ERR!       |                                              struct unix_syscall *
2023-04-07T19:37:44.496Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41792:46: note: expected ‘int’ but argument is of type ‘struct unix_syscall *’
2023-04-07T19:37:44.496Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41793:13: warning: passing argument 4 of ‘(void * (*)(void *, size_t,  int,  int,  int,  off_t))aSyscall[22].pCurrent’ makes integer from pointer without a cast [-Wint-conversion]
2023-04-07T19:37:44.496Z [err] npm ERR! 41793 |             MAP_SHARED, pShmNode->hShm, szRegion*(i64)pShmNode->nRegion
2023-04-07T19:37:44.496Z [err] npm ERR!       |             ^~~~~~~~~~
2023-04-07T19:37:44.496Z [err] npm ERR!       |             |
2023-04-07T19:37:44.496Z [err] npm ERR!       |             struct unix_syscall *
2023-04-07T19:37:44.496Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41793:13: note: expected ‘int’ but argument is of type ‘struct unix_syscall *’
2023-04-07T19:37:44.496Z [err] npm 
2023-04-07T19:37:44.498Z [err] ERR!
2023-04-07T19:37:44.500Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:41795:19: error: ‘MAP_FAILED’ undeclared (first use in this function)
2023-04-07T19:37:44.501Z [err] npm
2023-04-07T19:37:44.516Z [err]  ERR! 41795 |         if( pMem==MAP_FAILED ){
2023-04-07T19:37:44.516Z [err] npm ERR!       |                   ^~~~~~~~~~
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c: In function ‘unixRemapfile’:
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42114:15: error: ‘PROT_READ’ undeclared (first use in this function)
2023-04-07T19:37:44.516Z [err] npm ERR! 42114 |   int flags = PROT_READ;               /* Flags to pass to mmap() */
2023-04-07T19:37:44.516Z [err] npm ERR!       |               ^~~~~~~~~
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42114:15: warning: initialization of ‘int’ from ‘struct unix_syscall *’ makes integer from pointer without a cast [-Wint-conversion]
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42142:42: error: ‘MREMAP_MAYMOVE’ undeclared (first use in this function)
2023-04-07T19:37:44.516Z [err] npm ERR! 42142 |     pNew = osMremap(pOrig, nReuse, nNew, MREMAP_MAYMOVE);
2023-04-07T19:37:44.516Z [err] npm ERR!       |                                          ^~~~~~~~~~~~~~
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42142:42: warning: passing argument 4 of ‘(void * (*)(void *, size_t,  size_t,  int, ...))aSyscall[24].pCurrent’ makes integer from pointer without a cast [-Wint-conversion]
2023-04-07T19:37:44.516Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42142:42: note: expected ‘int’ but argument is of type ‘struct unix_syscall *’
2023-04-07T19:37:44.516Z [err] npm ERR!
2023-04-07T19:37:44.519Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42157:15: error: ‘MAP_FAILED’ undeclared (first use in this function)
2023-04-07T19:37:44.520Z [err] npm
2023-04-07T19:37:44.522Z [err]  
2023-04-07T19:37:44.530Z [err] ERR! 42157 |     if( pNew==MAP_FAILED || pNew==0 ){
2023-04-07T19:37:44.530Z [err] npm ERR!       |               ^~~~~~~~~~
2023-04-07T19:37:44.530Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42157:13: warning: comparison of distinct pointer types lacks a cast
2023-04-07T19:37:44.530Z [err] npm
2023-04-07T19:37:44.536Z [err]  ERR! 42157 |     if( pNew==MAP_FAILED || pNew==0 ){
2023-04-07T19:37:44.536Z [err] npm ERR!       |             ^~
2023-04-07T19:37:44.536Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42164:35: error: ‘MAP_SHARED’ undeclared (first use in this function)
2023-04-07T19:37:44.536Z [err] npm 
2023-04-07T19:37:44.545Z [err] ERR! 42164 |     pNew = osMmap(0, nNew, flags, MAP_SHARED, h, 0);
2023-04-07T19:37:44.545Z [err] npm ERR!       |                                   ^~~~~~~~~~
2023-04-07T19:37:44.545Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42164:35: warning: passing argument 4 of ‘(void * (*)(void *, size_t,  int,  int,  int,  off_t))aSyscall[22].pCurrent’ makes integer from pointer without a cast [-Wint-conversion]
2023-04-07T19:37:44.545Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42164:35: note: expected ‘int’ but argument is of type ‘struct unix_syscall *’
2023-04-07T19:37:44.545Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:42167:11: warning: comparison of distinct pointer types lacks a cast
2023-04-07T19:37:44.545Z [err] npm ERR! 42167 |   if( pNew==MAP_FAILED ){
2023-04-07T19:37:44.545Z [err] npm ERR!       |           ^~
2023-04-07T19:37:44.545Z [err] npm ERR!
2023-04-07T19:37:44.548Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c: In function ‘cellArea’:
2023-04-07T19:37:44.549Z [err] npm
2023-04-07T19:37:44.551Z [err]
2

Log part two:

2023-04-07T19:37:44.553Z [err] ERR!
2023-04-07T19:37:44.566Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203554:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.566Z [err] npm ERR! 203554 |       case 5:  area  = p->aCoord[9].f - p->aCoord[8].f;
2023-04-07T19:37:44.566Z [err] npm ERR!        |                ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.566Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203555:7: note: here
2023-04-07T19:37:44.566Z [err] npm ERR! 203555 |       case 4:  area *= p->aCoord[7].f - p->aCoord[6].f;
2023-04-07T19:37:44.566Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.566Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203555:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.566Z [err] npm ERR! 203555 |       case 4:  area *= p->aCoord[7].f - p->aCoord[6].f;
2023-04-07T19:37:44.566Z [err] npm ERR!        |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.566Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203556:7: note: here
2023-04-07T19:37:44.566Z [err] npm ERR! 203556 |       case 3:  area *= p->aCoord[5].f - p->aCoord[4].f;
2023-04-07T19:37:44.566Z [err] npm ERR!
2023-04-07T19:37:44.568Z [err]         |       ^~~~
2023-04-07T19:37:44.570Z [err] npm
2023-04-07T19:37:44.572Z [err]  
2023-04-07T19:37:44.575Z [err] ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203556:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.575Z [err] npm ERR! 203556 |       case 3:  area *= p->aCoord[5].f - p->aCoord[4].f;
2023-04-07T19:37:44.575Z [err] npm 
2023-04-07T19:37:44.577Z [err] ERR!
2023-04-07T19:37:44.582Z [err]         |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.582Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203557:7: note: here
2023-04-07T19:37:44.582Z [err] npm ERR! 203557 |       case 2:  area *= p->aCoord[3].f - p->aCoord[2].f;
2023-04-07T19:37:44.582Z [err] npm ERR!
2023-04-07T19:37:44.584Z [err]         |       ^~~~
2023-04-07T19:37:44.593Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203557:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.593Z [err] npm ERR! 203557 |       case 2:  area *= p->aCoord[3].f - p->aCoord[2].f;
2023-04-07T19:37:44.605Z [err] npm ERR!        |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.605Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203558:7: note: here
2023-04-07T19:37:44.605Z [err] npm ERR! 203558 |       default: area *= p->aCoord[1].f - p->aCoord[0].f;
2023-04-07T19:37:44.605Z [err] npm ERR!        |       ^~~~~~~
2023-04-07T19:37:44.605Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203564:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.605Z [err] npm ERR! 203564 |       case 5:  area  = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i;
2023-04-07T19:37:44.605Z [err] npm ERR!        |                ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.605Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203565:7: note: here
2023-04-07T19:37:44.605Z [err] npm ERR! 203565 |       case 4:  area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2023-04-07T19:37:44.605Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.605Z [err] npm 
2023-04-07T19:37:44.608Z [err] ERR!
2023-04-07T19:37:44.610Z [err]  Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203565:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.611Z [err] npm
2023-04-07T19:37:44.626Z [err]  ERR! 203565 |       case 4:  area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2023-04-07T19:37:44.626Z [err] npm ERR!        |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.626Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203566:7: note: here
2023-04-07T19:37:44.626Z [err] npm ERR! 203566 |       case 3:  area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2023-04-07T19:37:44.626Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.626Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203566:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.626Z [err] npm ERR! 203566 |       case 3:  area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2023-04-07T19:37:44.626Z [err] npm ERR!        |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.626Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203567:7: note: here
2023-04-07T19:37:44.626Z [err] npm ERR! 203567 |       case 2:  area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2023-04-07T19:37:44.626Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.626Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203567:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.626Z [err] npm ERR!
2023-04-07T19:37:44.628Z [err]  203567 |       case 2:  area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2023-04-07T19:37:44.630Z [err] npm
2023-04-07T19:37:44.632Z [err]  
2023-04-07T19:37:44.640Z [err] ERR!        |                ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-04-07T19:37:44.640Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:203568:7: note: here
2023-04-07T19:37:44.640Z [err] npm ERR! 203568 |       default: area *= (i64)p->aCoord[1].i - (i64)p->aCoord[0].i;
2023-04-07T19:37:44.640Z [err] npm ERR!        |       ^~~~~~~
2023-04-07T19:37:44.640Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c: In function ‘rtreeCallbackConstraint’:
2023-04-07T19:37:44.640Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202693:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.640Z [err] npm ERR! 202693 |                 readCoord(pCellData+32, &c); aCoord[8] = c.f;
2023-04-07T19:37:44.642Z [err] npm
2023-04-07T19:37:44.654Z [err]  ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.654Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202694:7: note: here
2023-04-07T19:37:44.654Z [err] npm ERR! 202694 |       case 8:   readCoord(pCellData+28, &c); aCoord[7] = c.f;
2023-04-07T19:37:44.654Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.654Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202695:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.654Z [err] npm ERR! 202695 |                 readCoord(pCellData+24, &c); aCoord[6] = c.f;
2023-04-07T19:37:44.654Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.654Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202696:7: note: here
2023-04-07T19:37:44.657Z [err] npm
2023-04-07T19:37:44.659Z [err]  
2023-04-07T19:37:44.661Z [err] ERR!
2023-04-07T19:37:44.676Z [err]  202696 |       case 6:   readCoord(pCellData+20, &c); aCoord[5] = c.f;
2023-04-07T19:37:44.676Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.676Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202697:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.676Z [err] npm ERR! 202697 |                 readCoord(pCellData+16, &c); aCoord[4] = c.f;
2023-04-07T19:37:44.676Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.676Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202698:7: note: here
2023-04-07T19:37:44.676Z [err] npm ERR! 202698 |       case 4:   readCoord(pCellData+12, &c); aCoord[3] = c.f;
2023-04-07T19:37:44.676Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.676Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202699:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.676Z [err] npm ERR! 202699 |                 readCoord(pCellData+8,  &c); aCoord[2] = c.f;
2023-04-07T19:37:44.676Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.676Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202700:7: note: here
2023-04-07T19:37:44.676Z [err] npm ERR!
2023-04-07T19:37:44.678Z [err]  202700 |       default:  readCoord(pCellData+4,  &c); aCoord[1] = c.f;
2023-04-07T19:37:44.680Z [err] npm
2023-04-07T19:37:44.681Z [err]  
2023-04-07T19:37:44.696Z [err] ERR!        |       ^~~~~~~
2023-04-07T19:37:44.696Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202708:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.696Z [err] npm ERR! 202708 |                 readCoord(pCellData+32, &c); aCoord[8] = c.i;
2023-04-07T19:37:44.696Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.696Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202709:7: note: here
2023-04-07T19:37:44.696Z [err] npm ERR! 202709 |       case 8:   readCoord(pCellData+28, &c); aCoord[7] = c.i;
2023-04-07T19:37:44.696Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.696Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202710:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.696Z [err] npm ERR! 202710 |                 readCoord(pCellData+24, &c); aCoord[6] = c.i;
2023-04-07T19:37:44.696Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.696Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202711:7: note: here
2023-04-07T19:37:44.696Z [err] npm ERR! 202711 |       case 6:   readCoord(pCellData+20, &c); aCoord[5] = c.i;
2023-04-07T19:37:44.696Z [err] npm ERR!
2023-04-07T19:37:44.698Z [err]         |       ^~~~
2023-04-07T19:37:44.700Z [err] npm
2023-04-07T19:37:44.701Z [err]  
2023-04-07T19:37:44.716Z [err] ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202712:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.716Z [err] npm ERR! 202712 |                 readCoord(pCellData+16, &c); aCoord[4] = c.i;
2023-04-07T19:37:44.716Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.716Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202713:7: note: here
2023-04-07T19:37:44.716Z [err] npm ERR! 202713 |       case 4:   readCoord(pCellData+12, &c); aCoord[3] = c.i;
2023-04-07T19:37:44.716Z [err] npm ERR!        |       ^~~~
2023-04-07T19:37:44.716Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202714:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2023-04-07T19:37:44.716Z [err] npm ERR! 202714 |                 readCoord(pCellData+8,  &c); aCoord[2] = c.i;
2023-04-07T19:37:44.716Z [err] npm ERR!        |                                              ~~~~~~~~~~^~~~~
2023-04-07T19:37:44.716Z [err] npm ERR! Release/obj/gen/sqlite-autoconf-3410100/sqlite3.c:202715:7: note: here
2023-04-07T19:37:44.716Z [err] npm ERR! 202715 |       default:  readCoord(pCellData+4,  &c); aCoord[1] = c.i;
2023-04-07T19:37:44.716Z [err] npm ERR!        |       ^~~~~~~
2023-04-07T19:37:44.716Z [err] npm ERR!
2023-04-07T19:37:44.721Z [err]  make: *** [deps/sqlite3.target.mk:143: Release/obj.target/sqlite3/gen/sqlite-autoconf-3410100/sqlite3.o] Error 1
2023-04-07T19:37:44.723Z [err] npm
2023-04-07T19:37:44.726Z [err]  ERR!
2023-04-07T19:37:44.735Z [err]  gyp ERR! build error 
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! stack Error: `make` failed with exit code: 2
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! stack     at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:201:23)
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:513:28)
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:293:12)
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! System Linux 5.15.84+
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6"
2023-04-07T19:37:44.735Z [err] npm ERR! gyp ERR! cwd /home/Admin/.node-red/node_modules/sqlite3
2023-04-07T19:37:44.735Z [err] npm 
2023-04-07T19:37:44.737Z [err] ERR!
2023-04-07T19:37:44.739Z [err]  gyp ERR! node -v v16.19.0
2023-04-07T19:37:44.741Z [err] npm
2023-04-07T19:37:44.745Z [err]  ERR! gyp ERR! node-gyp -v v9.1.0
2023-04-07T19:37:44.745Z [err] npm ERR! gyp ERR! not ok 
2023-04-07T19:37:44.745Z [err] npm ERR! node-pre-gyp ERR! build error 
2023-04-07T19:37:44.747Z [err] npm
2023-04-07T19:37:44.749Z [err]  
2023-04-07T19:37:44.753Z [err] ERR! node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/Admin/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
2023-04-07T19:37:44.753Z [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/Admin/.node-red/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
2023-04-07T19:37:44.753Z [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:513:28)
2023-04-07T19:37:44.753Z [err] npm ERR!
2023-04-07T19:37:44.756Z [err]  node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1100:16)
2023-04-07T19:37:44.757Z [err] npm
2023-04-07T19:37:44.766Z [err]  ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:304:5)
2023-04-07T19:37:44.766Z [err] npm ERR! node-pre-gyp ERR! System Linux 5.15.84+
2023-04-07T19:37:44.766Z [err] npm ERR! node-pre-gyp ERR! command "/usr/bin/node" "/home/Admin/.node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
2023-04-07T19:37:44.766Z [err] npm ERR! node-pre-gyp ERR! cwd /home/Admin/.node-red/node_modules/sqlite3
2023-04-07T19:37:44.766Z [err] npm ERR! node-pre-gyp ERR! node -v v16.19.0
2023-04-07T19:37:44.766Z [err] npm ERR! node-pre-gyp ERR! node-pre-gyp -v v1.0.10
2023-04-07T19:37:44.766Z [err] npm ERR!
2023-04-07T19:37:44.768Z [err]  node-pre-gyp ERR! not ok
2023-04-07T19:37:44.832Z [err] 
2023-04-07T19:37:44.837Z [err] npm
2023-04-07T19:37:44.839Z [err]  
2023-04-07T19:37:44.840Z [err] ERR!
2023-04-07T19:37:44.845Z [err]  A complete log of this run can be found in:
2023-04-07T19:37:44.845Z [err] npm ERR!     /home/Admin/.npm/_logs/2023-04-07T19_29_50_048Z-debug-0.log
2023-04-07T19:37:44.929Z rc=1
3

To start I need to ask this, did you install SQL light before you tried to install the node? If not, do a search on RPI sqlite and you should find some sites that will walk you through the install

4

I don't think you need to install sqlite separately, I think it is all included in the node.

Can you have a look at what is in that file? Maybe post the first 50 lines or so.

5

@zenofmud
I installed sqlite3 on a almost fresh system (Node Red with zigbee2mqtt installed) following the given commands and had no error. But installing the node-rednode-sqlite still gives errors.

sudo apt update
sudo apt full-upgrade
sudo apt install sqlite3

@Colin
I opened the file with nano and got the following output.

nano /usr/include/arm-linux-gnueabihf/sys/ioctl.h

ptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptptpt...

Did I open the file with the wrong editor?

6

No you did not. The file is corrupted. I suggest throwing the SD card in the bin and starting again with a known good quality card from a reputable supplier. You could try just erasing the card and starting with that one again, but I would not be surprised if you have further problems with it.

1 Like
7

Is a SD card from sandisk but already a little bit longer in use. The new card should arrive this week. Meanwhile I will try it again with the old one and start from the scratch.

8

Seems as the SD card was the problem. After installing node red sqlite installs without any errors. Thanks @Colin

2 Likes
9

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.