Neuer ioBroker-Blog online: Monatsrückblick März/April 2026

[instalator]

при попвтке обновится до 1.4.0.

В итоге не обновляется

! ````
$ ./iobroker upgrade sql
host.Server-PC Adapter "system.adapter.sql.0" is stopped.
npm install iobroker.sql --production --prefix "C:/ioBroker" (System call)
npm

WARN

deprecated
node-uuid@1.4.7: use uuid module instead
gyp

ERR!

configure error

gyp

ERR!

stack
Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp

ERR!

stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp

ERR!

stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp

ERR!

stack
at FSReqWrap.oncomplete (fs.js:82:15)
gyp

ERR!

System
Windows_NT 6.1.7601
gyp

ERR!

command
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\node_modules\inote-util\node_modules\mmmagic
gyp

ERR!

node -v
v4.6.2
gyp

ERR!

node-gyp -v
v3.4.0
gyp

ERR!

not ok

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-win32-ia32.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.2 (node-v46 ABI) (falling back to source compile with node-gyp)

! gyp

ERR!

configure error

gyp

ERR!

stack
Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp

ERR!

stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp

ERR!

stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp

ERR!

stack
at FSReqWrap.oncomplete (fs.js:82:15)
gyp

ERR!

System
Windows_NT 6.1.7601
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:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32"
gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
gyp

ERR!

node -v
v4.6.2
gyp

ERR!

node-gyp -v
v3.4.0
gyp

ERR!

not ok

node-pre-gyp

ERR!

build error

node-pre-gyp

ERR!

stack
Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32' (1)
node-pre-gyp

ERR!

stack
at ChildProcess. <anonymous>(C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp

ERR!

stack
at emitTwo (events.js:87:13)
node-pre-gyp

ERR!

stack
at ChildProcess.emit (events.js:172:7)
node-pre-gyp

ERR!

stack
at maybeClose (internal/child_process.js:854:16)
node-pre-gyp

ERR!

stack
at Process.ChildProcess._handle.onexit (internal/child_process.js:222:5)
node-pre-gyp

ERR!

System
Windows_NT 6.1.7601
node-pre-gyp

ERR!

command
"C:\Program Files\nodejs\node.exe" "C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
node-pre-gyp

ERR!

node -v
v4.6.2
node-pre-gyp

ERR!

node-pre-gyp -v
v0.6.31
node-pre-gyp

ERR!

not ok

npm

WARN

optional dep failed, continuing
sqlite3@3.1.8
npm

ERR!
Windows_NT 6.1.7601
npm

ERR!

argv
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "iobroker.sql" "--production" "--prefix" "C:/ioBroker"
npm

ERR!

node
v4.6.2
npm

ERR!

npm
v2.15.11
npm

ERR!

code
ELIFECYCLE

! npm

ERR!
mmmagic@0.4.5 install: node-gyp rebuild
npm

ERR!
Exit status 1
npm

ERR!

npm

ERR!
Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npm

ERR!
This is most likely a problem with the mmmagic package,
npm

ERR!
not with npm itself.
npm

ERR!
Tell the author that this fails on your system:
npm

ERR!
node-gyp rebuild
npm

ERR!
You can get information on how to open an issue for this project with:
npm

ERR!
npm bugs mmmagic
npm

ERR!
Or if that isn't available, you can get their info via:
npm

ERR!

npm

ERR!
npm owner ls mmmagic
npm

ERR!
There is likely additional logging output above.

! npm

ERR!
Please include the following file with any support request:
npm

ERR!
C:\ioBroker\node_modules\iobroker\npm-debug.log
ERROR: host.Server-PC Cannot install iobroker.sql: 1
ERROR: process exited with code 25</anonymous>

[sigma]

SQL History 1.5.6. Коннект к внешнему серверу PostgreSQL.

В логе постоянно сыпятся ошибки:

sql.0	2017-10-04 10:41:45.719	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898623, 'Subscribe [Equipment/Relays/R0045]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.499	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898620, 'Subscribe [Equipment/Relays/R0040]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.467	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898619, 'Subscribe [Equipment/Relays/R0037]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.151	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898611, 'Subscribe [Equipment/Relays/R0029]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.149	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898610, 'Subscribe [Equipment/Relays/R0028]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:44.944	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898603, 'Subscribe [Equipment/Buttons/B0017]', true, 1, 0);: error: duplicate key value violates unique constraint "t
sql.0	2017-10-04 10:41:44.890	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898602, 'Subscribe [Equipment/Buttons/B0016]', true, 1, 0);: error: duplicate key value violates unique constraint "t

Каким образом он умудряется выдать две записи в 1 мс?

[Bluefox]

Настрой Минимальный интервал

[ford7]

Периодически слетает настройка истории в sql (активно) только для данной переменной.

Подскажите, что бы это значило?
256_sql1.jpg