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

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]  

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

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

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.

@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?

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

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.

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

2 Likes

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