Need help - Cannot install palette SQLITE on v2.2.2 on ARMV6 (RPi)

championc · 29 May 2022 13:40

Hi all,

I urgently need help. I have had Node-Red running perfectly for about a year. I suddenly got an issue with Aedes "Flows Stopped due to missing node types". I couldn't resolve and ended up now doing a full re-install. That was originally on v1.3.4

So I am now on v2.2.2 but every time I try to install node-red-node-sqlite, it eventually fails. Can anyone advise me as to how to get it installed. I managed to install node-red-contrib-sqlitedb, but the node-sqlite just will not install for me

2022-05-28T21:22:47.364Z Install : node-red-node-sqlite 1.0.3

2022-05-28T21:22:46.815Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@1.0.3
2022-05-28T21:25:57.469Z [out] 
2022-05-28T21:25:57.469Z [out] > sqlite3@5.0.8 install /home/pi/.node-red/node_modules/sqlite3
2022-05-28T21:25:57.469Z [out] > node-pre-gyp install --fallback-to-build
2022-05-28T21:25:57.469Z [out] 
2022-05-28T21:26:06.501Z [err] node-pre-gyp
2022-05-28T21:26:06.511Z [err]  ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.0.8/napi-v6-linux-glibc-arm.tar.gz 
2022-05-28T21:26:06.517Z [err] node-pre-gyp
2022-05-28T21:26:06.521Z [err]  
2022-05-28T21:26:06.531Z [err] WARN Pre-built binaries not installable for sqlite3@5.0.8 and node@14.19.1 (node-v83 ABI, glibc) (falling back to source compile with node-gyp) 
2022-05-28T21:26:06.531Z [err] node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.0.8/napi-v6-linux-glibc-arm.tar.gz 
2022-05-28T21:26:39.622Z [out] make: Entering directory '/home/pi/.node-red/node_modules/sqlite3/build'
2022-05-28T21:26:39.643Z [out]   CC(target) Release/obj.target/nothing/../node-addon-api/nothing.o
2022-05-28T21:26:41.268Z [out]   AR(target) Release/obj.target/../node-addon-api/nothing.a
2022-05-28T21:26:41.409Z [out]   COPY Release/nothing.a
2022-05-28T21:26:41.527Z [out]   ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c
2022-05-28T21:26:48.665Z [out]   TOUCH Release/obj.target/deps/action_before_build.stamp
2022-05-28T21:26:48.748Z [out]   CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3380400/sqlite3.o
2022-05-28T21:26:51.606Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3ResultStrAccum’:
2022-05-28T21:26:51.622Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:26:51.622Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:26:51.622Z [err]                            ^
2022-05-28T21:26:51.622Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:30530:51: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:26:51.622Z [err]      sqlite3_result_text(pCtx, p->zText, p->nChar, SQLITE_DYNAMIC);
2022-05-28T21:26:51.622Z [err]                                                    ^~~~~~~~~~~~~~
2022-05-28T21:26:52.715Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3ErrorWithMsg’:
2022-05-28T21:26:52.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:26:52.742Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:26:52.742Z [err]                            ^
2022-05-28T21:26:52.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:32763:54: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:26:52.742Z [err]      sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC);
2022-05-28T21:26:52.742Z [err]                                                       ^~~~~~~~~~~~~~
2022-05-28T21:27:12.458Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3VdbeMemSetStr’:
2022-05-28T21:27:12.529Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:12.529Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:12.529Z [err]                            ^
2022-05-28T21:27:12.529Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79018:15: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:12.529Z [err]      if( xDel==SQLITE_DYNAMIC ){
2022-05-28T21:27:12.529Z [err]                ^~~~~~~~~~~~~~
2022-05-28T21:27:12.816Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘valueFromExpr’:
2022-05-28T21:27:12.887Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:12.887Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:12.887Z [err]                            ^
2022-05-28T21:27:12.887Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79430:55: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:12.887Z [err]        sqlite3ValueSetStr(pVal, -1, zVal, SQLITE_UTF8, SQLITE_DYNAMIC);
2022-05-28T21:27:12.887Z [err]                                                        ^~~~~~~~~~~~~~
2022-05-28T21:27:13.170Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:13.170Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:13.170Z [err]                            ^
2022-05-28T21:27:13.170Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79483:29: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:13.170Z [err]                           0, SQLITE_DYNAMIC);
2022-05-28T21:27:13.170Z [err]                              ^~~~~~~~~~~~~~
2022-05-28T21:28:12.372Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘printfFunc’:
2022-05-28T21:28:12.489Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:12.489Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:12.489Z [err]                            ^
2022-05-28T21:28:12.489Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:121402:25: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:12.489Z [err]                          SQLITE_DYNAMIC);
2022-05-28T21:28:12.489Z [err]                          ^~~~~~~~~~~~~~
2022-05-28T21:28:14.600Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘quoteFunc’:
2022-05-28T21:28:14.716Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:14.716Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:14.716Z [err]                            ^
2022-05-28T21:28:14.716Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:122229:23: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:14.716Z [err]                        SQLITE_DYNAMIC);
2022-05-28T21:28:14.716Z [err]                        ^~~~~~~~~~~~~~
2022-05-28T21:28:36.852Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3GenerateColumnNames’:
2022-05-28T21:28:36.984Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:36.984Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:36.984Z [err]                            ^
2022-05-28T21:28:36.984Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:136299:58: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:36.984Z [err]          sqlite3VdbeSetColName(v, i, COLNAME_NAME, zName, SQLITE_DYNAMIC);
2022-05-28T21:28:36.984Z [err]                                                           ^~~~~~~~~~~~~~
2022-05-28T21:28:37.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:37.119Z [err]  #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:37.119Z [err]                            ^
2022-05-28T21:28:37.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:136306:52: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:37.119Z [err]        sqlite3VdbeSetColName(v, i, COLNAME_NAME, z, SQLITE_DYNAMIC);
2022-05-28T21:28:37.119Z [err]                                                     ^~~~~~~~~~~~~~
2022-05-28T21:32:32.446Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘cellArea’:
2022-05-28T21:32:32.643Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197997:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:32.643Z [err]        case 5:  area  = p->aCoord[9].f - p->aCoord[8].f;
2022-05-28T21:32:32.643Z [err]                 ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:32.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197998:7: note: here
2022-05-28T21:32:32.742Z [err]        case 4:  area *= p->aCoord[7].f - p->aCoord[6].f;
2022-05-28T21:32:32.742Z [err]        ^~~~
2022-05-28T21:32:32.936Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197998:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:32.936Z [err]        case 4:  area *= p->aCoord[7].f - p->aCoord[6].f;
2022-05-28T21:32:32.936Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.036Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197999:7: note: here
2022-05-28T21:32:33.036Z [err]        case 3:  area *= p->aCoord[5].f - p->aCoord[4].f;
2022-05-28T21:32:33.036Z [err]        ^~~~
2022-05-28T21:32:33.229Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197999:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.229Z [err]        case 3:  area *= p->aCoord[5].f - p->aCoord[4].f;
2022-05-28T21:32:33.229Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.328Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198000:7: note: here
2022-05-28T21:32:33.328Z [err]        case 2:  area *= p->aCoord[3].f - p->aCoord[2].f;
2022-05-28T21:32:33.328Z [err]        ^~~~
2022-05-28T21:32:33.524Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198000:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.524Z [err]        case 2:  area *= p->aCoord[3].f - p->aCoord[2].f;
2022-05-28T21:32:33.524Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.624Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198001:7: note: here
2022-05-28T21:32:33.624Z [err]        default: area *= p->aCoord[1].f - p->aCoord[0].f;
2022-05-28T21:32:33.624Z [err]        ^~~~~~~
2022-05-28T21:32:33.727Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198007:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.727Z [err]        case 5:  area  = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i;
2022-05-28T21:32:33.727Z [err]                 ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.826Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198008:7: note: here
2022-05-28T21:32:33.826Z [err]        case 4:  area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2022-05-28T21:32:33.826Z [err]        ^~~~
2022-05-28T21:32:34.019Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198008:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.019Z [err]        case 4:  area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2022-05-28T21:32:34.019Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198009:7: note: here
2022-05-28T21:32:34.119Z [err]        case 3:  area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2022-05-28T21:32:34.119Z [err]        ^~~~
2022-05-28T21:32:34.312Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198009:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.312Z [err]        case 3:  area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2022-05-28T21:32:34.312Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.411Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198010:7: note: here
2022-05-28T21:32:34.411Z [err]        case 2:  area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2022-05-28T21:32:34.411Z [err]        ^~~~
2022-05-28T21:32:34.607Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198010:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.607Z [err]        case 2:  area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2022-05-28T21:32:34.607Z [err]                 ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.706Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198011:7: note: here
2022-05-28T21:32:34.706Z [err]        default: area *= (i64)p->aCoord[1].i - (i64)p->aCoord[0].i;
2022-05-28T21:32:34.706Z [err]        ^~~~~~~
2022-05-28T21:32:34.861Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘rtreeCallbackConstraint’:
2022-05-28T21:32:35.052Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197136:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.052Z [err]                  readCoord(pCellData+32, &c); aCoord[8] = c.f;
2022-05-28T21:32:35.052Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.151Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197137:7: note: here
2022-05-28T21:32:35.151Z [err]        case 8:   readCoord(pCellData+28, &c); aCoord[7] = c.f;
2022-05-28T21:32:35.151Z [err]        ^~~~
2022-05-28T21:32:35.251Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197138:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.251Z [err]                  readCoord(pCellData+24, &c); aCoord[6] = c.f;
2022-05-28T21:32:35.251Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.350Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197139:7: note: here
2022-05-28T21:32:35.350Z [err]        case 6:   readCoord(pCellData+20, &c); aCoord[5] = c.f;
2022-05-28T21:32:35.350Z [err]        ^~~~
2022-05-28T21:32:35.449Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197140:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.449Z [err]                  readCoord(pCellData+16, &c); aCoord[4] = c.f;
2022-05-28T21:32:35.449Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.549Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197141:7: note: here
2022-05-28T21:32:35.549Z [err]        case 4:   readCoord(pCellData+12, &c); aCoord[3] = c.f;
2022-05-28T21:32:35.549Z [err]        ^~~~
2022-05-28T21:32:35.650Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197142:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.650Z [err]                  readCoord(pCellData+8,  &c); aCoord[2] = c.f;
2022-05-28T21:32:35.650Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.749Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197143:7: note: here
2022-05-28T21:32:35.749Z [err]        default:  readCoord(pCellData+4,  &c); aCoord[1] = c.f;
2022-05-28T21:32:35.749Z [err]        ^~~~~~~
2022-05-28T21:32:35.852Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197151:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.852Z [err]                  readCoord(pCellData+32, &c); aCoord[8] = c.i;
2022-05-28T21:32:35.852Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.951Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197152:7: note: here
2022-05-28T21:32:35.951Z [err]        case 8:   readCoord(pCellData+28, &c); aCoord[7] = c.i;
2022-05-28T21:32:35.951Z [err]        ^~~~
2022-05-28T21:32:36.050Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197153:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.050Z [err]                  readCoord(pCellData+24, &c); aCoord[6] = c.i;
2022-05-28T21:32:36.050Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.149Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197154:7: note: here
2022-05-28T21:32:36.149Z [err]        case 6:   readCoord(pCellData+20, &c); aCoord[5] = c.i;
2022-05-28T21:32:36.149Z [err]        ^~~~
2022-05-28T21:32:36.249Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197155:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.249Z [err]                  readCoord(pCellData+16, &c); aCoord[4] = c.i;
2022-05-28T21:32:36.249Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.348Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197156:7: note: here
2022-05-28T21:32:36.348Z [err]        case 4:   readCoord(pCellData+12, &c); aCoord[3] = c.i;
2022-05-28T21:32:36.348Z [err]        ^~~~
2022-05-28T21:32:36.448Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197157:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.448Z [err]                  readCoord(pCellData+8,  &c); aCoord[2] = c.i;
2022-05-28T21:32:36.448Z [err]                                               ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.547Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197158:7: note: here
2022-05-28T21:32:36.547Z [err]        default:  readCoord(pCellData+4,  &c); aCoord[1] = c.i;
2022-05-28T21:32:36.547Z [err]        ^~~~~~~
2022-05-29T05:22:45.788Z [err] cc: fatal error: Killed signal terminated program cc1
2022-05-29T05:22:45.788Z [err] compilation terminated.
2022-05-29T05:22:45.788Z [err] make: *** [deps/sqlite3.target.mk:141: Release/obj.target/sqlite3/gen/sqlite-autoconf-3380400/sqlite3.o] Error 1
2022-05-29T05:22:46.541Z [out] make: Leaving directory '/home/pi/.node-red/node_modules/sqlite3/build'
2022-05-29T05:22:48.240Z [err] gyp
2022-05-29T05:22:48.544Z [err]  
2022-05-29T05:22:48.580Z [err] ERR!
2022-05-29T05:22:48.679Z [err]  build error 
2022-05-29T05:22:48.874Z [err] gyp
2022-05-29T05:22:48.911Z [err]  
2022-05-29T05:22:49.042Z [err] ERR! stack Error: `make` failed with exit code: 2
2022-05-29T05:22:49.042Z [err] gyp ERR! stack     at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23)
2022-05-29T05:22:49.042Z [err] gyp ERR! stack     at ChildProcess.emit (events.js:400:28)
2022-05-29T05:22:49.042Z [err] gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:282:12)
2022-05-29T05:22:49.151Z [err] gyp
2022-05-29T05:22:49.189Z [err]  
2022-05-29T05:22:49.232Z [err] ERR! System Linux 5.10.103+
2022-05-29T05:22:49.232Z [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/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/pi/.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"
2022-05-29T05:22:49.232Z [err] gyp ERR! cwd /home/pi/.node-red/node_modules/sqlite3
2022-05-29T05:22:49.232Z [err] gyp 
2022-05-29T05:22:49.259Z [err] ERR!
2022-05-29T05:22:49.309Z [err]  node -v v14.19.1
2022-05-29T05:22:49.309Z [err] gyp ERR! node-gyp -v v5.1.0
2022-05-29T05:22:49.309Z [err] gyp ERR! not ok 
2022-05-29T05:22:49.892Z [err] node-pre-gyp
2022-05-29T05:22:49.920Z [err]  
2022-05-29T05:22:49.930Z [err] ERR!
2022-05-29T05:22:49.972Z [err]  build error 
2022-05-29T05:22:49.989Z [err] node-pre-gyp
2022-05-29T05:22:50.039Z [err]  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/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.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)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/pi/.node-red/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:400:28)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1058:16)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:293:5)
2022-05-29T05:22:50.079Z [err] node-pre-gyp
2022-05-29T05:22:50.082Z [err]  
2022-05-29T05:22:50.130Z [err] ERR! System Linux 5.10.103+
2022-05-29T05:22:50.130Z [err] node-pre-gyp ERR! command "/usr/bin/node" "/home/pi/.node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
2022-05-29T05:22:50.130Z [err] node-pre-gyp ERR! cwd
2022-05-29T05:22:50.169Z [err]  /home/pi/.node-red/node_modules/sqlite3
2022-05-29T05:22:50.169Z [err] node-pre-gyp ERR! node -v v14.19.1
2022-05-29T05:22:50.198Z [err] node-pre-gyp ERR! node-pre-gyp -v v1.0.9
2022-05-29T05:22:50.198Z [err] node-pre-gyp
2022-05-29T05:22:50.240Z [err]  ERR! not ok 
2022-05-29T05:22:50.329Z [out] 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/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.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)
2022-05-29T05:23:46.711Z [err] npm
2022-05-29T05:23:46.719Z [err]  ERR! code ELIFECYCLE
2022-05-29T05:23:46.719Z [err] npm ERR! errno 1
2022-05-29T05:23:47.189Z [err] npm
2022-05-29T05:23:47.197Z [err]  ERR! sqlite3@5.0.8 install: `node-pre-gyp install --fallback-to-build`
2022-05-29T05:23:47.197Z [err] npm ERR! Exit status 1
2022-05-29T05:23:47.197Z [err] npm ERR! 
2022-05-29T05:23:47.197Z [err] npm ERR!
2022-05-29T05:23:47.201Z [err]  Failed at the sqlite3@5.0.8 install script.
2022-05-29T05:23:47.203Z [err] npm
2022-05-29T05:23:47.209Z [err]  ERR! This is probably not a problem with npm. There is likely additional logging output above.
2022-05-29T05:23:47.620Z [err] 
2022-05-29T05:23:47.624Z [err] npm
2022-05-29T05:23:47.631Z [err]  ERR! A complete log of this run can be found in:
2022-05-29T05:23:47.631Z [err] npm ERR!
2022-05-29T05:23:47.639Z [err]      /home/pi/.npm/_logs/2022-05-29T05_23_47_541Z-debug.log
2022-05-29T05:23:47.739Z rc=1

TotallyInformation · 29 May 2022 13:55

If you get that, you can restart node-red in safe mode and at least remove the offending nodes which will let you start everything else back up.

What version of Node.js are you running?

championc · 29 May 2022 14:00

node.js version 14.19.1

npm version 6.14.16

I have a decent usage of saving data to the database, so I'm not really keen to blow away the stuff [yet] unless it actually led to resolution, which I believe it won't

TotallyInformation · 29 May 2022 14:21

You shouldn't throw away the DB, it is a separate file anyway so you can easily back it up.

My initial thought was that you were on an older version of node.js but clearly not so.

So just installed the node on both my Windows 10 dev pc and my live server (AMD rather than ARM though. I don't currently have a working ARM based server). Probably doesn't prove much I'm afraid since it clearly didn't trigger a build.

There are only 64bit ARM versions of that library unfortunately. Hence the need to compile. Do other npm packages that need compiling install successfully? Do you have build-tools installed?

Steve-Mcl · 29 May 2022 14:37

Try deleting /home/pi/.node-red/node_modules then running

cd /home/pi/.node-red
npm install

UnborN · 29 May 2022 14:58

By the way the node-sqlite3 dependancy that the sqlite node depends on had a few important updates
( fixing issues related to node-gyp and using prebuilt binaries )

We are currently on version 5.0.2

"dependencies": {
        "sqlite3": "^5.0.2"
    },

maybe worth updating to 5.0.8 ?

Steve-Mcl · 29 May 2022 15:02

5.0.8 satisfies constraint ^5.0.2 so if you install node-red-node-sqlite then you will get 5.0.8 (or the latest 5.x.x)

UnborN · 29 May 2022 15:05

I see .. ofcourse .. its even there in the log

2022-05-28T21:25:57.469Z [out] > sqlite3@5.0.8

championc · 29 May 2022 16:12

Currently re-trying the sqlite install, which could take some time (giving much the same output as before. After running the above, I got the following


added 405 packages from 445 contributors and audited 405 packages in 665.649s

64 packages are looking for funding
  run `npm fund` for details

found 1 critical severity vulnerability
  run `npm audit fix` to fix them, or `npm audit` for details

after which I ran npm fund followed by npm audit fix and got

pi@solarpi:~/.node-red $ npm audit fix
up to date in 85.352s

64 packages are looking for funding
  run `npm fund` for details

fixed 0 of 1 vulnerability in 405 scanned packages
  1 vulnerability required manual review and could not be updated
pi@solarpi:~/.node-red $

TotallyInformation · 29 May 2022 19:03

No!

Never a good idea and it is a pain that the npm folk thought that would ever be useful.

Ignore the audit messages unless you want to deliberately break things.

As for the fund messages, by all means do look at those if you are wanting to give some funding to authors

championc · 29 May 2022 20:23

Well the install process is STILL running. I haven't got an RC=0 or RC=1 yet - but I certainly expect RC=1

What can I do next ?

championc · 29 May 2022 22:48

dynamicdave · 30 May 2022 10:33

I had a very similar situation with sqlite a year ago.

I fixed it by doing..cd /home/pi/.node-red or wherever you have node-RED
And then doing... npm rebuild sqlite3
Note: It take ages to rebuild

championc · 30 May 2022 19:44

Unfortunately, since sqlite won't install, then I cannot do a repair

So I then tried

npm install sqlite3
npm install sqlite

And then

pi@solarpi:~/.node-red $ npm install node-red-node-sqlite
+ node-red-node-sqlite@1.0.3
added 1 package from 1 contributor and audited 486 packages in 128.728s

68 packages are looking for funding
  run `npm fund` for details

found 1 critical severity vulnerability
  run `npm audit fix` to fix them, or `npm audit` for details
pi@solarpi:~/.node-red $ node-red-restart
Restarted Node-RED
pi@solarpi:~/.node-red $

And it appears to have done the trick

zenofmud · 30 May 2022 20:26

did you do a deploy and clear your browsers caches?

championc · 30 May 2022 21:04

All sorted

A huge thanks to everyone who made suggestions and took time to contribute to resolve my issues. I hope that this thread may help someone else in a similar situation in the future.

I'd never have resolved this without all of your assistance - so thank you so much to all

system · 13 June 2022 21:05

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

Topic		Replies	Views
Can't instal SQLite on node-red General	8	3277	30 December 2018
Node-Red SQLITE General	6	540	25 June 2019
Help! Broke my installation General	19	215	2 February 2024
Can't get sqlite node installed General	10	3819	24 July 2020
Not able to install SQLite General	13	733	14 October 2021

Need help - Cannot install palette SQLITE on v2.2.2 on ARMV6 (RPi)

Related Topics