search

TryGhost / node-sqlite3

SQLite3 bindings for Node.js
BSD 3-Clause "New" or "Revised" License
6.23k stars 814 forks source link

Can not install sqlite3 with Node v12.18.3 #1436

Closed EdenRosen closed 3 years ago

EdenRosen commented 3 years ago

i have a problem,

i write this command:

npm install sqlite3

and get this error:

sqlite3@5.0.1 install C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3 node-pre-gyp install --fallback-to-build

node-pre-gyp WARN Using request for node-pre-gyp https download node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-win32-x64.tar.gz node-pre-gyp WARN Pre-built binaries not found for sqlite3@5.0.1 and node@12.18.3 (node-v72 ABI, unknown) (falling back to source compile with node-gyp) gyp ERR! find Python gyp ERR! find Python Python is not set from command line or npm configuration gyp ERR! find Python Python is not set from environment variable PYTHON gyp ERR! find Python checking if "python" can be used gyp ERR! find Python - "python" is not in PATH or produced an error gyp ERR! find Python checking if "python2" can be used gyp ERR! find Python - "python2" is not in PATH or produced an error gyp ERR! find Python checking if "python3" can be used gyp ERR! find Python - "python3" is not in PATH or produced an error gyp ERR! find Python checking if the py launcher can be used to find Python 2 gyp ERR! find Python - "py.exe" is not in PATH or produced an error gyp ERR! find Python checking if Python is C:\Python27\python.exe gyp ERR! find Python - "C:\Python27\python.exe" could not be run gyp ERR! find Python checking if Python is C:\Python37\python.exe gyp ERR! find Python - "C:\Python37\python.exe" could not be run gyp ERR! find Python gyp ERR! find Python ** gyp ERR! find Python You need to install the latest version of Python. gyp ERR! find Python Node-gyp should be able to find and use Python. If not, gyp ERR! find Python you can try one of the following options: gyp ERR! find Python - Use the switch --python="C:\Path\To\python.exe" gyp ERR! find Python (accepted by both node-gyp and npm) gyp ERR! find Python - Set the environment variable PYTHON gyp ERR! find Python - Set the npm configuration variable python: gyp ERR! find Python npm config set python "C:\Path\To\python.exe" gyp ERR! find Python For more information consult the documentation at: gyp ERR! find Python https://github.com/nodejs/node-gyp#installation gyp ERR! find Python ** gyp ERR! find Python gyp ERR! configure error gyp ERR! stack Error: Could not find any Python installation to use gyp ERR! stack at PythonFinder.fail (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-python.js:307:47) gyp ERR! stack at PythonFinder.runChecks (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-python.js:136:21) gyp ERR! stack at PythonFinder. (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-python.js:225:16) gyp ERR! stack at PythonFinder.execFileCallback (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-python.js:271:16) gyp ERR! stack at exithandler (child_process.js:310:5) gyp ERR! stack at ChildProcess.errorhandler (child_process.js:322:5) gyp ERR! stack at ChildProcess.emit (events.js:315:20) gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:273:12) gyp ERR! stack at onErrorNT (internal/child_process.js:469:16) gyp ERR! stack at processTicksAndRejections (internal/process/task_queues.js:84:21) gyp ERR! System Windows_NT 10.0.19041 gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64" "--napi_version=6" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6"
gyp ERR! cwd C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3 gyp ERR! node -v v12.18.3 gyp ERR! node-gyp -v v5.1.0 gyp ERR! not ok node-pre-gyp ERR! build error node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1) node-pre-gyp ERR! stack at ChildProcess. (C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\node-pre-gyp\lib\util\compile.js:83:29) node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20) node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1021:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5) node-pre-gyp ERR! System Windows_NT 10.0.19041 node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build" node-pre-gyp ERR! cwd C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3 node-pre-gyp ERR! node -v v12.18.3 node-pre-gyp ERR! node-pre-gyp -v v0.11.0 node-pre-gyp ERR! not ok Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\OneDrive\Eden\Program\WebDev\ChatExpress\node_modules\sqlite3\lib\binding\napi-v6-win32-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1) npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@2.3.1 (node_modules\fsevents): npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@2.3.1: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})

npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! sqlite3@5.0.1 install: node-pre-gyp install --fallback-to-build npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the sqlite3@5.0.1 install script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\user\AppData\Roaming\npm-cache_logs\2021-01-30T16_24_49_309Z-debug.log

anyone can help me please? Is there a way to install sqlite3 in the vscode terminal?

rifftrader commented 3 years ago

Interested in following the discussion. A mate of mine and I are having a similar issue where neither one of cannot install the module on our machines.

My version of node is v14.15.4.

I'm getting the following:

`npm install --save sqlite3

npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142 npm WARN deprecated har-validator@5.1.5: this library is no longer supported

sqlite3@5.0.1 install /Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3 node-pre-gyp install --fallback-to-build

node-pre-gyp WARN Using request for node-pre-gyp https download node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-darwin-x64.tar.gz node-pre-gyp WARN Pre-built binaries not found for sqlite3@5.0.1 and node@14.15.4 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) CC(target) Release/obj.target/nothing/../node-addon-api/nothing.o LIBTOOL-STATIC Release/nothing.a warning: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/libtool: archive library: Release/nothing.a the table of contents is empty (no object file members in the library define global symbols) ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c /bin/sh: Projects/SqlLite3: No such file or directory TOUCH Release/obj.target/deps/action_before_build.stamp CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3320300/sqlite3.o LIBTOOL-STATIC Release/sqlite3.a CXX(target) Release/obj.target/node_sqlite3/src/backup.o clang: error: no such file or directory: 'Projects/SqlLite3' clang: error: no such file or directory: 'Module' clang: error: no such file or directory: 'Test/node_modules/node-addon-api' make: *** [Release/obj.target/node_sqlite3/src/backup.o] Error 1 gyp ERR! build error gyp ERR! stack Error: make failed with exit code: 2 gyp ERR! stack at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23) gyp ERR! stack at ChildProcess.emit (events.js:315:20) gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12) gyp ERR! System Darwin 20.2.0 gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/Users//Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6" gyp ERR! cwd /Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3 gyp ERR! node -v v14.15.4 gyp ERR! node-gyp -v v5.1.0 gyp ERR! not ok node-pre-gyp ERR! build error node-pre-gyp ERR! stack Error: Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1) node-pre-gyp ERR! stack at ChildProcess. (/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/node-pre-gyp/lib/util/compile.js:83:29) node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20) node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1048:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5) node-pre-gyp ERR! System Darwin 20.2.0 node-pre-gyp ERR! command "/usr/local/bin/node" "/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build" node-pre-gyp ERR! cwd /Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3 node-pre-gyp ERR! node -v v14.15.4 node-pre-gyp ERR! node-pre-gyp -v v0.11.0 node-pre-gyp ERR! not ok Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/Users/Documents/Coding Projects/SqlLite3 Module Test/node_modules/sqlite3/lib/binding/napi-v6-darwin-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)

npm WARN sqlite-test@1.0.0 No repository field.

npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! sqlite3@5.0.1 install: node-pre-gyp install --fallback-to-build npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the sqlite3@5.0.1 install script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! /Users/.npm/_logs/2021-01-31T08_52_48_898Z-debug.log`

saeidfiy commented 3 years ago

error /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3: Command failed. Exit code: 1 Command: node-pre-gyp install --fallback-to-build Arguments: Directory: /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3 Output: node-pre-gyp info it worked if it ends with ok node-pre-gyp info using node-pre-gyp@0.11.0 node-pre-gyp info using node@12.18.4 | linux | x64 node-pre-gyp WARN Using request for node-pre-gyp https download node-pre-gyp info check checked for "/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64/node_sqlite3.node" (not found) node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-linux-x64.tar.gz node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-linux-x64.tar.gz node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-linux-x64.tar.gz node-pre-gyp WARN Pre-built binaries not found for sqlite3@5.0.1 and node@12.18.4 (node-v72 ABI, glibc) (falling back to source compile with node-gyp) node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-linux-x64.tar.gz gyp info it worked if it ends with ok gyp info using node-gyp@3.8.0 gyp info using node@12.18.4 | linux | x64 gyp info ok gyp info it worked if it ends with ok gyp info using node-gyp@3.8.0 gyp info using node@12.18.4 | linux | x64 gyp info spawn /usr/bin/python2 gyp info spawn args [ gyp info spawn args '/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/gyp/gyp_main.py', gyp info spawn args 'binding.gyp', gyp info spawn args '-f', gyp info spawn args 'make', gyp info spawn args '-I', gyp info spawn args '/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/build/config.gypi', gyp info spawn args '-I', gyp info spawn args '/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/addon.gypi', gyp info spawn args '-I', gyp info spawn args '/home/sasa/.node-gyp/12.18.4/include/node/common.gypi', gyp info spawn args '-Dlibrary=shared_library', gyp info spawn args '-Dvisibility=default', gyp info spawn args '-Dnode_root_dir=/home/sasa/.node-gyp/12.18.4', gyp info spawn args '-Dnode_gyp_dir=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp', gyp info spawn args '-Dnode_lib_file=/home/sasa/.node-gyp/12.18.4/<(target_arch)/node.lib', gyp info spawn args '-Dmodule_root_dir=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3', gyp info spawn args '-Dnode_engine=v8', gyp info spawn args '--depth=.', gyp info spawn args '--no-parallel', gyp info spawn args '--generator-output', gyp info spawn args 'build', gyp info spawn args '-Goutput_dir=.' gyp info spawn args ] gyp info ok gyp info it worked if it ends with ok gyp info using node-gyp@3.8.0 gyp info using node@12.18.4 | linux | x64 gyp info spawn make gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ] make: Entering directory '/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/build' CC(target) Release/obj.target/nothing/../node-addon-api/nothing.o AR(target) Release/obj.target/../node-addon-api/nothing.a COPY Release/nothing.a ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c /bin/sh: 1: crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/build/Release/lib.host:/home/sasa/Public/project/data: not found TOUCH Release/obj.target/deps/action_before_build.stamp CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3320300/sqlite3.o Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘strftimeFunc’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:22804:52: note: in expansion of macro ‘SQLITE_DYNAMIC’ 22804 | z==zBuf ? SQLITE_TRANSIENT : SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3ErrorWithMsg’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:31304:54: note: in expansion of macro ‘SQLITE_DYNAMIC’ 31304 | sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3VdbeMemSetStr’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:76767:15: note: in expansion of macro ‘SQLITE_DYNAMIC’ 76767 | if( xDel==SQLITE_DYNAMIC ){ | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘valueFromExpr’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:77179:55: note: in expansion of macro ‘SQLITE_DYNAMIC’ 77179 | sqlite3ValueSetStr(pVal, -1, zVal, SQLITE_UTF8, SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:77231:29: note: in expansion of macro ‘SQLITE_DYNAMIC’ 77231 | 0, SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3VdbeExec’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:92894:38: warning: cast between incompatible function types from ‘int ()(u32, void , void , void )’ {aka ‘int ()(unsigned int, void , void , void )’} to ‘void ()(void , const char )’ [-Wcast-function-type] 92894 | void (x)(void,const char) = (void()(void,const char))db->xTrace; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘printfFunc’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:117034:25: note: in expansion of macro ‘SQLITE_DYNAMIC’ 117034 | SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘generateColumnNames’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:130871:58: note: in expansion of macro ‘SQLITE_DYNAMIC’ 130871 | sqlite3VdbeSetColName(v, i, COLNAME_NAME, zName, SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:14581:27: warning: cast between incompatible function types from ‘int ()(void )’ to ‘void ()(void )’ [-Wcast-function-type] 14581 | #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:130878:52: note: in expansion of macro ‘SQLITE_DYNAMIC’ 130878 | sqlite3VdbeSetColName(v, i, COLNAME_NAME, z, SQLITE_DYNAMIC); | ^~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3_trace’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:162428:16: warning: cast between incompatible function types from ‘void ()(void , const char )’ to ‘int ()(u32, void , void , void )’ {aka ‘int ()(unsigned int, void , void , void )’} [-Wcast-function-type] 162428 | db->xTrace = (int()(u32,void,void,void))xTrace; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3_db_status’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:21627:10: warning: this statement may fall through [-Wimplicit-fallthrough=] 21627 | op = SQLITE_DBSTATUS_CACHE_WRITE+1; | ~^~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:21629:5: note: here 21629 | case SQLITE_DBSTATUS_CACHE_HIT: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3_str_vappendf’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:28505:19: warning: this statement may fall through [-Wimplicit-fallthrough=] 28505 | flag_long = sizeof(char)==sizeof(i64) ? 2 : | ~~^~~~~~~~~~ 28506 | sizeof(char)==sizeof(long int) ? 1 : 0; | ~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:28508:7: note: here 28508 | case etORDINAL: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:28510:19: warning: this statement may fall through [-Wimplicit-fallthrough=] 28510 | cThousand = 0; | ~~^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:28512:7: note: here 28512 | case etDECIMAL: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3GetToken’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:159496:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 159496 | if( !sqlite3Isdigit(z[1]) ) | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:159505:5: note: here 159505 | case CC_DIGIT: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:159595:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 159595 | if( z[1]=='\'' ){ | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:159609:5: note: here 159609 | case CC_ID: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3ExprCodeTarget’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:103317:25: warning: this statement may fall through [-Wimplicit-fallthrough=] 103317 | case TK_AGG_COLUMN: { | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:103342:5: note: here 103342 | case TK_COLUMN: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘exprImpliesNotNull’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:104896:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 104896 | if( exprImpliesNotNull(pParse, p->pRight, pNN, iTab, seenNot) ) return 1; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:104899:5: note: here 104899 | case TK_SPAN: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘impliesNotNullRow’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:105028:17: warning: this statement may fall through [-Wimplicit-fallthrough=] 105028 | case TK_GE: { | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:105047:5: note: here 105047 | default: | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘resolveP2Values’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:78359:13: warning: this statement may fall through [-Wimplicit-fallthrough=] 78359 | if( pOp->p2!=0 ) p->readOnly = 0; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:78362:9: note: here 78362 | case OP_AutoCommit: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:78400:26: warning: this statement may fall through [-Wimplicit-fallthrough=] 78400 | case OP_VFilter: { | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:78409:9: note: here 78409 | default: { | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘resolveExprStep’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:98612:20: warning: this statement may fall through [-Wimplicit-fallthrough=] 98612 | case TK_ISNOT: { | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:98628:5: note: here 98628 | case TK_BETWEEN: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘fkActionTrigger’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:120160:11: warning: this statement may fall through [-Wimplicit-fallthrough=] 120160 | if( !pChanges ){ | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:120164:7: note: here 120164 | default: | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3GenerateConstraintChecks’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122095:17: warning: this statement may fall through [-Wimplicit-fallthrough=] 122095 | onError = OE_Abort; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122098:7: note: here 122098 | case OE_Rollback: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122156:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 122156 | sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, 0, iDataCur); | ^~~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122160:7: note: here 122160 | case OE_Ignore: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122377:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 122377 | sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, pIdx, iIdxCur+ix); | ^~~~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:122381:7: note: here 122381 | case OE_Ignore: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘sqlite3VdbeExec’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:86166:5: warning: this statement may fall through [-Wimplicit-fallthrough=] 86166 | if( (pIn3->flags & MEM_Null)==0 ) break; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:86200:1: note: here 86200 | case OP_Halt: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:86335:15: warning: this statement may fall through [-Wimplicit-fallthrough=] 86335 | pOp->opcode = OP_String; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:86352:1: note: here 86352 | case OP_String: { / out2 / | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:89617:19: warning: this statement may fall through [-Wimplicit-fallthrough=] 89617 | case OP_IfNoHope: { / jump, in3 / | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:89625:1: note: here 89625 | case OP_NoConflict: / jump, in3 / | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:90551:38: warning: this statement may fall through [-Wimplicit-fallthrough=] 90551 | p->aCounter[SQLITE_STMTSTATUS_SORT]++; | ~~~~~~~^~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:90566:1: note: here 90566 | case OP_Rewind: { / jump / | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:91903:15: warning: this statement may fall through [-Wimplicit-fallthrough=] 91903 | pOp->opcode = OP_AggStep1; | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:91906:1: note: here 91906 | case OP_AggStep1: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘jsonRenderNode’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:185188:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 185188 | if( pNode->jnFlags & JNODE_RAW ){ | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:185194:5: note: here 185194 | case JSON_REAL: | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘jsonReturn’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:185333:7: warning: this statement may fall through [-Wimplicit-fallthrough=] 185333 | int_as_real: / fall through to real /; | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:185335:5: note: here 185335 | case JSON_REAL: { | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘jsonEachColumn’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:187027:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 187027 | if( p->bRecursive ){ | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:187037:5: note: here 187037 | default: { | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘cellArea’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189401:22: warning: this statement may fall through [-Wimplicit-fallthrough=] 189401 | case 5: area = p->aCoord[9].f - p->aCoord[8].f; | ~~^~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189402:7: note: here 189402 | case 4: area = p->aCoord[7].f - p->aCoord[6].f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189402:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189402 | case 4: area = p->aCoord[7].f - p->aCoord[6].f; | ~^~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189403:7: note: here 189403 | case 3: area = p->aCoord[5].f - p->aCoord[4].f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189403:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189403 | case 3: area = p->aCoord[5].f - p->aCoord[4].f; | ~^~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189404:7: note: here 189404 | case 2: area = p->aCoord[3].f - p->aCoord[2].f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189404:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189404 | case 2: area = p->aCoord[3].f - p->aCoord[2].f; | ~^~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189405:7: note: here 189405 | default: area = p->aCoord[1].f - p->aCoord[0].f; | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189411:22: warning: this statement may fall through [-Wimplicit-fallthrough=] 189411 | case 5: area = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i; | ~~^~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189412:7: note: here 189412 | case 4: area = (i64)p->aCoord[7].i - (i64)p->aCoord[6].i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189412:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189412 | case 4: area = (i64)p->aCoord[7].i - (i64)p->aCoord[6].i; | ~^~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189413:7: note: here 189413 | case 3: area = (i64)p->aCoord[5].i - (i64)p->aCoord[4].i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189413:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189413 | case 3: area = (i64)p->aCoord[5].i - (i64)p->aCoord[4].i; | ~^~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189414:7: note: here 189414 | case 2: area = (i64)p->aCoord[3].i - (i64)p->aCoord[2].i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189414:21: warning: this statement may fall through [-Wimplicit-fallthrough=] 189414 | case 2: area = (i64)p->aCoord[3].i - (i64)p->aCoord[2].i; | ~^~~~~~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:189415:7: note: here 189415 | default: area = (i64)p->aCoord[1].i - (i64)p->aCoord[0].i; | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘rtreeCallbackConstraint’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188554:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188554 | readCoord(pCellData+32, &c); aCoord[8] = c.f; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188555:7: note: here 188555 | case 8: readCoord(pCellData+28, &c); aCoord[7] = c.f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188556:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188556 | readCoord(pCellData+24, &c); aCoord[6] = c.f; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188557:7: note: here 188557 | case 6: readCoord(pCellData+20, &c); aCoord[5] = c.f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188558:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188558 | readCoord(pCellData+16, &c); aCoord[4] = c.f; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188559:7: note: here 188559 | case 4: readCoord(pCellData+12, &c); aCoord[3] = c.f; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188560:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188560 | readCoord(pCellData+8, &c); aCoord[2] = c.f; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188561:7: note: here 188561 | default: readCoord(pCellData+4, &c); aCoord[1] = c.f; | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188569:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188569 | readCoord(pCellData+32, &c); aCoord[8] = c.i; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188570:7: note: here 188570 | case 8: readCoord(pCellData+28, &c); aCoord[7] = c.i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188571:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188571 | readCoord(pCellData+24, &c); aCoord[6] = c.i; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188572:7: note: here 188572 | case 6: readCoord(pCellData+20, &c); aCoord[5] = c.i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188573:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188573 | readCoord(pCellData+16, &c); aCoord[4] = c.i; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188574:7: note: here 188574 | case 4: readCoord(pCellData+12, &c); aCoord[3] = c.i; | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188575:56: warning: this statement may fall through [-Wimplicit-fallthrough=] 188575 | readCoord(pCellData+8, &c); aCoord[2] = c.i; | ~~^~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188576:7: note: here 188576 | default: readCoord(pCellData+4, &c); aCoord[1] = c.i; | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘rtreeNonleafConstraint’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188631:9: warning: this statement may fall through [-Wimplicit-fallthrough=] 188631 | if( p->op!=RTREE_EQ ) break; / RTREE_LE and RTREE_LT end here / | ^ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:188634:5: note: here 188634 | default: / RTREE_GT or RTREE_GE, or fallthrough of RTREE_EQ / | ^~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘fts3SnippetFunc’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169927:22: warning: this statement may fall through [-Wimplicit-fallthrough=] 169927 | case 6: nToken = sqlite3_value_int(apVal[5]); | ^~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169928:5: note: here 169928 | case 5: iCol = sqlite3_value_int(apVal[4]); | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169928:20: warning: this statement may fall through [-Wimplicit-fallthrough=] 169928 | case 5: iCol = sqlite3_value_int(apVal[4]); | ^~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169929:5: note: here 169929 | case 4: zEllipsis = (const char)sqlite3_value_text(apVal[3]); | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169929:38: warning: this statement may fall through [-Wimplicit-fallthrough=] 169929 | case 4: zEllipsis = (const char)sqlite3_value_text(apVal[3]); | ^~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169930:5: note: here 169930 | case 3: zEnd = (const char)sqlite3_value_text(apVal[2]); | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169930:33: warning: this statement may fall through [-Wimplicit-fallthrough=] 169930 | case 3: zEnd = (const char)sqlite3_value_text(apVal[2]); | ^~~~~~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169931:5: note: here 169931 | case 2: zStart = (const char*)sqlite3_value_text(apVal[1]); | ^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c: In function ‘fts3ColumnMethod’: Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169684:14: warning: this statement may fall through [-Wimplicit-fallthrough=] 169684 | iCol = p->nColumn; | ~^~~~ Release/obj/gen/sqlite-autoconf-3320300/sqlite3.c:169688:5: note: here 169688 | default: | ^~~ AR(target) Release/obj.target/deps/sqlite3.a COPY Release/sqlite3.a CXX(target) Release/obj.target/node_sqlite3/src/backup.o g++: error: crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-addon-api: No such file or directory make: *** [node_sqlite3.target.mk:138: Release/obj.target/node_sqlite3/src/backup.o] Error 1 make: Leaving directory '/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/build' gyp ERR! build error gyp ERR! stack Error: make failed with exit code: 2 gyp ERR! stack at ChildProcess.onExit (/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/lib/build.js:262:23) gyp ERR! stack at ChildProcess.emit (events.js:315:20) gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:275:12) gyp ERR! System Linux 5.8.0-41-generic gyp ERR! command "/home/sasa/.nvm/versions/node/v12.18.4/bin/node" "/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64" "--napi_version=6" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6" gyp ERR! cwd /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3 gyp ERR! node -v v12.18.4 gyp ERR! node-gyp -v v3.8.0 gyp ERR! not ok node-pre-gyp ERR! build error node-pre-gyp ERR! stack Error: Failed to execute '/home/sasa/.nvm/versions/node/v12.18.4/bin/node /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1) node-pre-gyp ERR! stack at ChildProcess. (/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-pre-gyp/lib/util/compile.js:83:29) node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20) node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1021:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5) node-pre-gyp ERR! System Linux 5.8.0-41-generic node-pre-gyp ERR! command "/home/sasa/.nvm/versions/node/v12.18.4/bin/node" "/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build" node-pre-gyp ERR! cwd /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3 node-pre-gyp ERR! node -v v12.18.4 node-pre-gyp ERR! node-pre-gyp -v v0.11.0 node-pre-gyp ERR! not ok Failed to execute '/home/sasa/.nvm/versions/node/v12.18.4/bin/node /home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/sasa/Public/project/data crawler/Pollution-index/ready_to_run/v0.1/node_modules/sqlite3/lib/binding/napi-v6-linux-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1) info Visit https://yarnpkg.com/en/docs/cli/install for documentation about this command.

OliverCordingl1 commented 3 years ago

Getting the same errors on my end.

My workaround was to downgrade a build to @5.0.0 npm i -S sqlite3@5.0.0

Bit annoying that it just happens with the new version.

vorcigernix commented 3 years ago

Same issue here, downgrade helped.

aronreisx commented 3 years ago

Steps below should solve It on windows:

  1. You should install Windows Build Tools globally before install gyp
  1. Install Node Gyp
  1. Clear NPM Cache
  1. Try to install sqlite3 again
aronreisx commented 3 years ago

Same issue here, downgrade helped.

Hi @vorcigernix , follow my steps above and tell me if it work for you.

EdenRosen commented 3 years ago

Steps below should solve It on windows:

  1. You should install Windows Build Tools globally before install gyp
  • [ ] npm i --global --production windows-build-tools
  1. Install Node Gyp
  • [ ] npm i -g node-gyp
  1. Clear NPM Cache
  • [ ] npm cache clean
  1. Try to install sqlite3 again
  • [ ] npm i sqlite3

i can't install windows-build-tools, it gave me an error:

$ npm i --global --production windows-build-tools npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142 npm WARN deprecated har-validator@5.1.5: this library is no longer supported

windows-build-tools@5.2.2 postinstall C:\Users\user\AppData\Roaming\npm\node_modules\windows-build-tools node ./dist/index.js

Downloading python-2.7.15.amd64.msi [> ] 0.0% (0 B/s) Downloaded python-2.7.15.amd64.msi. Saved to C:\Users\user.windows-build-tools\python-2.7.15.amd64.msi. Downloading vs_BuildTools.exe [> ] 0.0% (0 B/s) Downloaded vs_BuildTools.exe. Saved to C:\Users\user.windows-build-tools\vs_BuildTools.exe.

Starting installation... Please restart this script from an administrative PowerShell! The build tools cannot be installed without administrative rights. To fix, right-click on PowerShell and run "as Administrator". npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! windows-build-tools@5.2.2 postinstall: node ./dist/index.js npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the windows-build-tools@5.2.2 postinstall script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\user\AppData\Roaming\npm-cache_logs\2021-02-09T06_26_39_944Z-debug.log

kewde commented 3 years ago

Fixed in 5.0.2

hongquan09dth5 commented 2 years ago

Fixed in 5.0.2

It's interesting because I got this issue in 5.0.2 as below:

`node-pre-gyp WARN Pre-built binaries not installable for sqlite3@5.0.2 and node@14.17.0 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) node-pre-gyp WARN Hit error connect ETIMEDOUT 52.216.92.155:443 gyp ERR! find Python gyp ERR! find Python Python is not set from command line or npm configuration gyp ERR! find Python Python is not set from environment variable PYTHON gyp ERR! find Python checking if "python" can be used gyp ERR! find Python - "python" is not in PATH or produced an error gyp ERR! find Python checking if "python2" can be used gyp ERR! find Python - "python2" is not in PATH or produced an error gyp ERR! find Python checking if "python3" can be used gyp ERR! find Python - "python3" is not in PATH or produced an error gyp ERR! find Python checking if the py launcher can be used to find Python 2 gyp ERR! find Python - "py.exe" is not in PATH or produced an error gyp ERR! find Python checking if Python is C:\Python27\python.exe gyp ERR! find Python - "C:\Python27\python.exe" could not be run gyp ERR! find Python checking if Python is C:\Python37\python.exe gyp ERR! find Python - "C:\Python37\python.exe" could not be run gyp ERR! find Python gyp ERR! find Python ** gyp ERR! find Python You need to install the latest version of Python. gyp ERR! find Python Node-gyp should be able to find and use Python. If not, gyp ERR! find Python you can try one of the following options: gyp ERR! find Python - Use the switch --python="C:\Path\To\python.exe" gyp ERR! find Python (accepted by both node-gyp and npm) gyp ERR! find Python - Set the environment variable PYTHON gyp ERR! find Python - Set the npm configuration variable python: gyp ERR! find Python npm config set python "C:\Path\To\python.exe" gyp ERR! find Python For more information consult the documentation at: gyp ERR! find Python https://github.com/nodejs/node-gyp#installation gyp ERR! find Python ** gyp ERR! find Python gyp ERR! configure error gyp ERR! stack Error: Could not find any Python installation to use gyp ERR! stack at PythonFinder.fail (C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\lib\find-python.js:307:47) gyp ERR! stack at PythonFinder.runChecks (C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\lib\find-python.js:136:21) gyp ERR! stack at PythonFinder. (C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\lib\find-python.js:225:16) gyp ERR! stack at PythonFinder.execFileCallback (C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\lib\find-python.js:271:16) gyp ERR! stack at exithandler (child_process.js:326:5) gyp ERR! stack at ChildProcess.errorhandler (child_process.js:338:5) gyp ERR! stack at ChildProcess.emit (events.js:376:20) gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:275:12) gyp ERR! stack at onErrorNT (internal/child_process.js:467:16) gyp ERR! stack at processTicksAndRejections (internal/process/task_queues.js:82:21) gyp ERR! System Windows_NT 10.0.19042 gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=3" "--node_napi_label=napi-v3" gyp ERR! cwd D:\learning\projects\nestjs\mycv\node_modules\sqlite3 gyp ERR! node -v v14.17.0 gyp ERR! node-gyp -v v5.1.0 gyp ERR! not ok node-pre-gyp ERR! build error node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=3 --node_napi_label=napi-v3' (1) node-pre-gyp ERR! stack at ChildProcess. (D:\learning\projects\nestjs\mycv\node_modules\node-pre-gyp\lib\util\compile.js:83:29) node-pre-gyp ERR! stack at ChildProcess.emit (events.js:376:20) node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1055:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5) node-pre-gyp ERR! System Windows_NT 10.0.19042 node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "D:\learning\projects\nestjs\mycv\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build" node-pre-gyp ERR! cwd D:\learning\projects\nestjs\mycv\node_modules\sqlite3 node-pre-gyp ERR! node -v v14.17.0 node-pre-gyp ERR! node-pre-gyp -v v0.11.0 node-pre-gyp ERR! not ok Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\Admin\AppData\Roaming\nvm\v14.17.0\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=D:\learning\projects\nestjs\mycv\node_modules\sqlite3\lib\binding\napi-v3-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=3 --node_napi_label=napi-v3' (1) npm WARN ajv-keywords@3.5.2 requires a peer of ajv@^6.9.1 but none is installed. You must install peer dependencies yourself. npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@2.3.2 (node_modules\fsevents): npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@2.3.2: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})

npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! sqlite3@5.0.2 install: node-pre-gyp install --fallback-to-build npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the sqlite3@5.0.2 install script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\Admin\AppData\Roaming\npm-cache_logs\2022-02-23T14_16_39_643Z-debug.log`